VIEW: APPS.PA_FP_ELIGIBLE_CI_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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