View: GMF_ORGANIZATION_DEFINITIONS

Product:	GMF - Process Manufacturing Financials
Description:	View of Process Organization Definition Details
Implementation/DBA Data:	APPS.GMF_ORGANIZATION_DEFINITIONS

View Text

SELECT /*+ INDEX(HOI
, HR_ORGANIZATION_INFORMATIO_FK1) */ HAOU.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HAOUT.NAME
, TO_NUMBER(HOI.ORG_INFORMATION1)
, TO_NUMBER(HOI.ORG_INFORMATION2)
, TO_NUMBER(HOI.ORG_INFORMATION3)
, LEDG.CHART_OF_ACCOUNTS_ID
, LEDG.CURRENCY_CODE
FROM HR_ALL_ORGANIZATION_UNITS HAOU
, HR_ALL_ORGANIZATION_UNITS_TL HAOUT
, HR_ORGANIZATION_INFORMATION HOI
, MTL_PARAMETERS MP
, GL_LEDGERS LEDG
WHERE HAOUT.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND HAOUT.LANGUAGE = USERENV('LANG')
AND HAOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION'
AND HOI.ORG_INFORMATION1 = LEDG.LEDGER_ID
AND MP.PROCESS_ENABLED_FLAG = 'Y'

Columns