Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to find Legal entity infomration at document sequce category tables

in Payables, Payments & Cash Management 1 comment

Summary:

Hi Team,

Any one have sql query on same requirment in your experiance. I used below tables.

FND_DOCUMENT_SEQUENCES
FND_DOC_SEQUENCE_ASSIGNMENTS
FND_DOC_SEQUENCE_USERS
FND_DOC_SEQUENCE_CATEGORIES
HR_LEGAL_ENTITIES

Expected data like below attachment.

Doument Seq Name

Category

LE

CAN_INVOICES

DBM INV

Canada LE

CAN_INVOICES

CRM INV

Canada LE

CAN_INVOICES

STD INV

Canada LE

CAN_INVOICES

Global Intercompany

Canada LE

CAN_INVOICES

Intercompany

Canada LE

CAN_INVOICES

PAY REQ INV

Canada LE

CAN_INVOICES

PREPAY INV

Canada LE

CAN_PAYMENTS

EFT PAY

Canada LE

CAN_PAYMENTS

CLEAR PAY

Canada LE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!