VIEW: APPS.PQH_CMMTMNT_ENTITIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'