View: PQH_ENTITY_ELEMENT_TYPES_V

Product:	PQH - Public Sector HR
Description:	Entity Element Types View
Implementation/DBA Data:	APPS.PQH_ENTITY_ELEMENT_TYPES_V

View Text

SELECT PET.ELEMENT_NAME ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PCE.ENTITY_NAME ENTITY_NAME
, PCE.ENTITY_ID ENTITY_ID
, PCE.BUDGETED_ENTITY_CD BUDGETED_ENTITY_CD
, PCE.BUDGETED_ENTITY_NAME BUDGETED_ENTITY_NAME
, PCE.BUDGET_UNIT1_NAME BUDGET_MEASUREMENT_TYPE
, PCE.BUDGET_UNIT1_ID BUDGET_UNIT_ID
FROM PQH_CMMTMNT_ENTITIES_V PCE
, PQH_BUDGET_PERIODS BPR
, PQH_BUDGET_SETS BST
, PQH_BUDGET_ELEMENTS BEL
, PAY_ELEMENT_TYPES PET
WHERE PCE.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, PCE.BUSINESS_GROUP_ID )
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN PCE.VERSION_FROM_DATE
AND PCE.VERSION_TO_DATE
AND PCE.BUDGET_DETAIL_ID = BPR.BUDGET_DETAIL_ID
AND BPR.BUDGET_PERIOD_ID = BST.BUDGET_PERIOD_ID
AND BST.BUDGET_SET_ID = BEL.BUDGET_SET_ID
AND BEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND BPR.BUDGET_UNIT1_VALUE IS NOT NULL GROUP BY PET.ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID
, PCE.ENTITY_NAME
, PCE.ENTITY_ID
, PCE.BUDGETED_ENTITY_CD
, PCE.BUDGETED_ENTITY_NAME
, PCE.BUDGET_UNIT1_NAME
, PCE.BUDGET_UNIT1_ID UNION SELECT PET.ELEMENT_NAME ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PCE.ENTITY_NAME ENTITY_NAME
, PCE.ENTITY_ID ENTITY_ID
, PCE.BUDGETED_ENTITY_CD BUDGETED_ENTITY_CD
, PCE.BUDGETED_ENTITY_NAME BUDGETED_ENTITY_NAME
, PCE.BUDGET_UNIT2_NAME BUDGET_MEASUREMENT_TYPE
, PCE.BUDGET_UNIT2_ID BUDGET_UNIT_ID
FROM PQH_CMMTMNT_ENTITIES_V PCE
, PQH_BUDGET_PERIODS BPR
, PQH_BUDGET_SETS BST
, PQH_BUDGET_ELEMENTS BEL
, PAY_ELEMENT_TYPES PET
WHERE PCE.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, PCE.BUSINESS_GROUP_ID )
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN PCE.VERSION_FROM_DATE
AND PCE.VERSION_TO_DATE
AND PCE.BUDGET_DETAIL_ID = BPR.BUDGET_DETAIL_ID
AND BPR.BUDGET_PERIOD_ID = BST.BUDGET_PERIOD_ID
AND BST.BUDGET_SET_ID = BEL.BUDGET_SET_ID
AND BEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND BPR.BUDGET_UNIT2_VALUE IS NOT NULL GROUP BY PET.ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID
, PCE.ENTITY_NAME
, PCE.ENTITY_ID
, PCE.BUDGETED_ENTITY_CD
, PCE.BUDGETED_ENTITY_NAME
, PCE.BUDGET_UNIT2_NAME
, PCE.BUDGET_UNIT2_ID UNION SELECT PET.ELEMENT_NAME ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PCE.ENTITY_NAME ENTITY_NAME
, PCE.ENTITY_ID ENTITY_ID
, PCE.BUDGETED_ENTITY_CD BUDGETED_ENTITY_CD
, PCE.BUDGETED_ENTITY_NAME BUDGETED_ENTITY_NAME
, PCE.BUDGET_UNIT3_NAME BUDGET_MEASUREMENT_TYPE
, PCE.BUDGET_UNIT3_ID BUDGET_UNIT_ID
FROM PQH_CMMTMNT_ENTITIES_V PCE
, PQH_BUDGET_PERIODS BPR
, PQH_BUDGET_SETS BST
, PQH_BUDGET_ELEMENTS BEL
, PAY_ELEMENT_TYPES PET
WHERE PCE.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, PCE.BUSINESS_GROUP_ID )
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN PCE.VERSION_FROM_DATE
AND PCE.VERSION_TO_DATE
AND PCE.BUDGET_DETAIL_ID = BPR.BUDGET_DETAIL_ID
AND BPR.BUDGET_PERIOD_ID = BST.BUDGET_PERIOD_ID
AND BST.BUDGET_SET_ID = BEL.BUDGET_SET_ID
AND BEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND BPR.BUDGET_UNIT3_VALUE IS NOT NULL GROUP BY PET.ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID
, PCE.ENTITY_NAME
, PCE.ENTITY_ID
, PCE.BUDGETED_ENTITY_CD
, PCE.BUDGETED_ENTITY_NAME
, PCE.BUDGET_UNIT3_NAME
, PCE.BUDGET_UNIT3_ID

Columns