Product: | PA - Projects |
---|---|
Description: | This view shall contain the details of all control orders having a financial impact |
Implementation/DBA Data: | APPS.PA_FP_ELIGIBLE_CI_V |
SELECT PBV.PROJECT_ID
, PCIM.IMPACTED_TASK_ID
, PPC.FIN_PLAN_TYPE_ID
, PBV.BUDGET_VERSION_ID
, PBV.VERSION_TYPE
, PPC.VERSION_TYPE
, PCI.CI_ID
, PCI.CI_NUMBER
, PCI.CI_TYPE_ID
, PCTV.NAME
, PCI.SUMMARY
, DECODE(PT.TASK_NAME
, NULL
, ''
, PT.TASK_NAME || ' (' || PT.TASK_NUMBER || ')')
, PCS.PROJECT_STATUS_NAME
, PCS.PROJECT_SYSTEM_STATUS_CODE
, PBV.LABOR_QUANTITY
, PBV.EQUIPMENT_QUANTITY
, PBV.TOTAL_PROJECT_RAW_COST
, PBV.TOTAL_PROJECT_BURDENED_COST
, PBV.TOTAL_PROJECT_REVENUE
, PBV.RAW_COST
, PBV.BURDENED_COST
, PBV.REVENUE
, PBV.REV_PARTIALLY_IMPL_FLAG
, PCI.OWNER_ID
, HZPA.PARTY_NAME
, PCI.DATE_REQUIRED
, PCI.PRIORITY_CODE
, PAL1.MEANING
, PCTV.CI_TYPE_CLASS_CODE AS CI_TYPE_CLASS_CODE
FROM PA_PT_CO_IMPL_STATUSES PPC
, PA_BUDGET_VERSIONS PBV
, PA_CONTROL_ITEMS PCI
, PA_PROJECT_STATUSES PCS
, PA_CI_IMPACTS PCIM
, PA_TASKS PT
, HZ_PARTIES HZPA
, PA_LOOKUPS PAL1
, PA_CI_TYPES_VL PCTV
WHERE PBV.CI_ID = PCI.CI_ID
AND PBV.PROJECT_ID = PCI.PROJECT_ID
AND PCTV.CI_TYPE_ID = PCI.CI_TYPE_ID
AND PCI.CI_TYPE_ID = PPC.CI_TYPE_ID
AND PCI.STATUS_CODE = PPC.STATUS_CODE
AND PPC.STATUS_CODE = PCS.PROJECT_STATUS_CODE
AND DECODE (PBV.VERSION_TYPE
, 'ALL'
, PPC.VERSION_TYPE
, PBV.VERSION_TYPE) = PPC.VERSION_TYPE
AND PCI.CI_ID = PCIM.CI_ID
AND PCIM.IMPACT_TYPE_CODE = 'FINPLAN'
AND PT.TASK_ID(+) = PCIM.IMPACTED_TASK_ID
AND PCI.OWNER_ID = HZPA.PARTY_ID
AND PAL1.LOOKUP_TYPE(+) = 'PA_TASK_PRIORITY_CODE'
AND PAL1.LOOKUP_CODE(+) = PCI.PRIORITY_CODE