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'
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'
|
|
|