DBA Data[Home] [Help]

VIEW: APPS.CST_ACCT_INFO_V

Source

View Text - Preformatted

SELECT ORGANIZATION_ID, TO_NUMBER(ORG_INFORMATION1) LEDGER_ID, TO_NUMBER(ORG_INFORMATION2) LEGAL_ENTITY, TO_NUMBER(ORG_INFORMATION3) OPERATING_UNIT FROM HR_ORGANIZATION_INFORMATION WHERE ORG_INFORMATION_CONTEXT = 'Accounting Information'
View Text - HTML Formatted

SELECT ORGANIZATION_ID
, TO_NUMBER(ORG_INFORMATION1) LEDGER_ID
, TO_NUMBER(ORG_INFORMATION2) LEGAL_ENTITY
, TO_NUMBER(ORG_INFORMATION3) OPERATING_UNIT
FROM HR_ORGANIZATION_INFORMATION
WHERE ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION'