View: PA_ADW_OPER_UNITS_B_V

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PA_ADW_OPER_UNITS_B_V

View Text

SELECT OU.ORGANIZATION_ID
, OU.NAME
, LE.NAME
, SOB.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HR_ORGANIZATION_UNITS OU
, HR_ORGANIZATION_UNITS LE
, HR_ORGANIZATION_INFORMATION OUI
, HR_ORGANIZATION_INFORMATION LEI
, PA_IMPLEMENTATIONS PI
, GL_SETS_OF_BOOKS SOB
WHERE PI.ORG_ID = OU.ORGANIZATION_ID
AND OU.ORGANIZATION_ID = OUI.ORGANIZATION_ID
AND OUI.ORG_INFORMATION_CONTEXT = 'OPERATING UNIT INFORMATION'
AND OUI.ORG_INFORMATION2 = LE.ORGANIZATION_ID
AND LE.ORGANIZATION_ID = LEI.ORGANIZATION_ID
AND LEI.ORG_INFORMATION_CONTEXT = 'LEGAL ENTITY ACCOUNTING'
AND LEI.ORG_INFORMATION1 = SOB.SET_OF_BOOKS_ID UNION SELECT -1
, PLU.MEANING
, PLU.MEANING
, PLU.MEANING
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM PA_LOOKUPS PLU
WHERE PLU.LOOKUP_TYPE = 'ADW RESOURCE NAME'
AND PLU.LOOKUP_CODE = 'UNKNOWN'
AND NOT EXISTS ( SELECT 'YES'
FROM HR_ORGANIZATION_UNITS HRORG
, PA_IMPLEMENTATIONS PI
WHERE PI.ORG_ID = HRORG.ORGANIZATION_ID )

Columns