[Home] [Help]
View: CST_ACCT_INFO_V
Product: | BOM - Bills of Material |
Description: | Accounting Information for an Inventory Organization |
Implementation/DBA Data: |
APPS.CST_ACCT_INFO_V
|
View Text
SELECT ORGANIZATION_ID
, DECODE(ORG_INFORMATION_CONTEXT
, 'ACCOUNTING INFORMATION'
, TO_NUMBER(ORG_INFORMATION1)
, TO_NUMBER(NULL)) LEDGER_ID
, DECODE(ORG_INFORMATION_CONTEXT
, 'ACCOUNTING INFORMATION'
, TO_NUMBER(ORG_INFORMATION2)
, TO_NUMBER(NULL))LEGAL_ENTITY
, DECODE(ORG_INFORMATION_CONTEXT
, 'ACCOUNTING INFORMATION'
, TO_NUMBER(ORG_INFORMATION3)
, TO_NUMBER(NULL)) OPERATING_UNIT
FROM HR_ORGANIZATION_INFORMATION
WHERE ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION'
Columns
Name |
ORGANIZATION_ID |
LEDGER_ID |
LEGAL_ENTITY |
OPERATING_UNIT |