APPS.PQH_CMMTMNT_ENTITIES_V
[Home] [Help]
| Product: | PQH - Public Sector HR |
|---|---|
| Description: | View for Commitment Entities |
| Implementation/DBA Data: |
APPS.PQH_CMMTMNT_ENTITIES_V
|
SELECT BGT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BGT.BUDGET_ID BUDGET_ID
, BGT.BUDGET_START_DATE BUDGET_DATE_FROM
, BGT.BUDGET_END_DATE BUDGET_DATE_TO
, BVR.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BVR.DATE_FROM VERSION_FROM_DATE
, BVR.DATE_TO VERSION_TO_DATE
, BDT.BUDGET_DETAIL_ID BUDGET_DETAIL_ID
, BGT.BUDGET_UNIT1_ID BUDGET_UNIT1_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT1_ID) BUDGET_UNIT1_NAME
, BGT.BUDGET_UNIT2_ID BUDGET_UNIT2_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT2_ID) BUDGET_UNIT2_NAME
, BGT.BUDGET_UNIT3_ID BUDGET_UNIT3_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT3_ID) BUDGET_UNIT3_NAME
, BGT.BUDGETED_ENTITY_CD BUDGETED_ENTITY_CD
, HR_GENERAL.DECODE_LOOKUP('PQH_BUDGET_ENTITY'
, BGT.BUDGETED_ENTITY_CD) BUDGETED_ENTITY_NAME
, BDT.ORGANIZATION_ID ENTITY_ID
, HR_GENERAL.DECODE_ORGANIZATION(BDT.ORGANIZATION_ID) ENTITY_NAME
FROM PQH_BUDGETS BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BGT.BUDGETED_ENTITY_CD = 'ORGANIZATION' UNION SELECT BGT.BUSINESS_GROUP_ID
, BGT.BUDGET_ID
, BGT.BUDGET_START_DATE
, BGT.BUDGET_END_DATE
, BVR.BUDGET_VERSION_ID
, BVR.DATE_FROM
, BVR.DATE_TO
, BDT.BUDGET_DETAIL_ID
, BGT.BUDGET_UNIT1_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT1_ID)
, BGT.BUDGET_UNIT2_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT2_ID)
, BGT.BUDGET_UNIT3_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT3_ID)
, BGT.BUDGETED_ENTITY_CD
, HR_GENERAL.DECODE_LOOKUP('PQH_BUDGET_ENTITY'
, BGT.BUDGETED_ENTITY_CD)
, BDT.POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID) ENTITY_NAME
FROM PQH_BUDGETS BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BGT.BUDGETED_ENTITY_CD = 'POSITION' UNION SELECT BGT.BUSINESS_GROUP_ID
, BGT.BUDGET_ID
, BGT.BUDGET_START_DATE
, BGT.BUDGET_END_DATE
, BVR.BUDGET_VERSION_ID
, BVR.DATE_FROM
, BVR.DATE_TO
, BDT.BUDGET_DETAIL_ID
, BGT.BUDGET_UNIT1_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT1_ID)
, BGT.BUDGET_UNIT2_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT2_ID)
, BGT.BUDGET_UNIT3_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT3_ID)
, BGT.BUDGETED_ENTITY_CD
, HR_GENERAL.DECODE_LOOKUP('PQH_BUDGET_ENTITY'
, BGT.BUDGETED_ENTITY_CD)
, BDT.JOB_ID
, HR_GENERAL.DECODE_JOB(BDT.JOB_ID)
FROM PQH_BUDGETS BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BGT.BUDGETED_ENTITY_CD = 'JOB' UNION SELECT BGT.BUSINESS_GROUP_ID
, BGT.BUDGET_ID
, BGT.BUDGET_START_DATE
, BGT.BUDGET_END_DATE
, BVR.BUDGET_VERSION_ID
, BVR.DATE_FROM
, BVR.DATE_TO
, BDT.BUDGET_DETAIL_ID
, BGT.BUDGET_UNIT1_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT1_ID)
, BGT.BUDGET_UNIT2_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT2_ID)
, BGT.BUDGET_UNIT3_ID
, HR_GENERAL.DECODE_SHARED_TYPE(BGT.BUDGET_UNIT3_ID)
, BGT.BUDGETED_ENTITY_CD
, HR_GENERAL.DECODE_LOOKUP('PQH_BUDGET_ENTITY'
, BGT.BUDGETED_ENTITY_CD)
, BDT.GRADE_ID
, HR_GENERAL.DECODE_GRADE(BDT.GRADE_ID)
FROM PQH_BUDGETS BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BGT.BUDGETED_ENTITY_CD = 'GRADE'