View: CST_ORGANIZATION_DEFINITIONS

Product:	BOM - Bills of Material
Description:	Inventory organizations
Implementation/DBA Data:	APPS.CST_ORGANIZATION_DEFINITIONS

View Text

SELECT HAOU.ORGANIZATION_ID
, HAOU.BUSINESS_GROUP_ID
, HAOU.DATE_FROM
, HAOU.DATE_TO
, MP.ORGANIZATION_CODE
, HAOUT.NAME
, GL.LEDGER_ID
, GL.CHART_OF_ACCOUNTS_ID
, GL.CURRENCY_CODE
, TO_NUMBER(HOI.ORG_INFORMATION3)
, TO_NUMBER(HOI.ORG_INFORMATION2)
FROM HR_ALL_ORGANIZATION_UNITS HAOU
, HR_ORGANIZATION_INFORMATION HOI
, HR_ALL_ORGANIZATION_UNITS_TL HAOUT
, MTL_PARAMETERS MP
, GL_LEDGERS GL
WHERE HAOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT ='ACCOUNTING INFORMATION'
AND GL.LEDGER_ID = TO_NUMBER(DECODE(RTRIM(TRANSLATE(HOI.ORG_INFORMATION1
, '0123456789'
, ' '))
, NULL
, HOI.ORG_INFORMATION1
, -99999))
AND HAOUT.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND HAOUT.LANGUAGE = USERENV('LANG')

Columns