View: ORG_ORGANIZATION_DEF_MRC_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.ORG_ORGANIZATION_DEF_MRC_V

View Text

SELECT HOU.ORGANIZATION_ID ORGANIZATION_ID
, HOU.BUSINESS_GROUP_ID
, HOU.DATE_FROM USER_DEFINITION_ENABLE_DATE
, HOU.DATE_TO DISABLE_DATE
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, HOU.NAME ORGANIZATION_NAME
, NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99) SET_OF_BOOKS_ID
, LGR.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, HOI1.ORG_INFORMATION2 INVENTORY_ENABLED_FLAG
, TO_NUMBER(HOI2.ORG_INFORMATION3) OPERATING_UNIT
, TO_NUMBER(HOI2.ORG_INFORMATION2) LEGAL_ENTITY
FROM HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
, MTL_PARAMETERS MP
, GL_LEDGERS LGR
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
AND HOU.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'
AND TO_NUMBER(DECODE(RTRIM(TRANSLATE(HOI2.ORG_INFORMATION1
, '0123456789'
, ' '))
, NULL
, HOI2.ORG_INFORMATION1
, -99999)) = LGR.LEDGER_ID
AND LGR.OBJECT_TYPE_CODE = 'L'
AND NVL(COMPLETE_FLAG
, 'Y') = 'Y'

Columns