[Home] [Help]
View: INV_ORGANIZATION_INFO_V
View Text
SELECT MP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, DECODE((SELECT FPG.MULTI_ORG_FLAG
FROM FND_PRODUCT_GROUPS FPG)
, 'Y'
, TO_NUMBER(HOI2.ORG_INFORMATION3)
, TO_NUMBER(NULL)) OPERATING_UNIT
, TO_NUMBER(HOI2.ORG_INFORMATION2) LEGAL_ENTITY
, TO_NUMBER(HOI2.ORG_INFORMATION1) SET_OF_BOOKS_ID
FROM HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
, MTL_PARAMETERS MP
WHERE HOI1.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
AND HOI1.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1 = 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND HOI1.ORG_INFORMATION_CONTEXT = 'CLASS'
AND HOI2.ORG_INFORMATION_CONTEXT ='ACCOUNTING INFORMATION'
Columns
Name |
ORGANIZATION_ID |
ORGANIZATION_CODE |
OPERATING_UNIT |
LEGAL_ENTITY |
SET_OF_BOOKS_ID |