VIEW: APPS.PQH_ENTITY_ELEMENT_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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