View: PA_ADW_ORGS_B_V

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

View Text

SELECT HRORG.ORGANIZATION_ID
, HRORG.NAME
, HRBG.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HR_ORGANIZATION_UNITS HRORG
, HR_ORGANIZATION_UNITS HRBG
, PA_IMPLEMENTATIONS PI
WHERE HRORG.BUSINESS_GROUP_ID = HRBG.ORGANIZATION_ID
AND PI.PROJECT_ORGANIZATION_TYPE = HRORG.TYPE UNION SELECT -1
, 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'

Columns