eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_FP_OF_WEBADI_V

Source

View Text - Preformatted


SELECT ppdm.amount_subtype_id, pmvl.AMOUNT_TYPE_NAME, ofe.org_id, hrorg1.name, ofe.Organization_Id, hrorg2.name, ofe.other_org_id, hrorg3.name, ofe.other_organization_id, hrorg4.name, pp.name, decode(ofe.resource_id,-1,ppa.assignment_name,pr.name), ppdm.period_amount1, ppdm.period_amount2, ppdm.period_amount3, ppdm.period_amount4, ppdm.period_amount5, ppdm.period_amount6, ppdm.period_amount7, ppdm.period_amount8, ppdm.period_amount9, ppdm.period_amount10, ppdm.period_amount11, ppdm.period_amount12, ppdm.period_amount13, ppdm.period_amount14, ppdm.period_amount15, ppdm.period_amount16, ppdm.period_amount17, ppdm.period_amount18, ppdm.period_amount19, ppdm.period_amount20, ppdm.period_amount21, ppdm.period_amount22, ppdm.period_amount23, ppdm.period_amount24, ppdm.period_amount25, ppdm.period_amount26, ppdm.period_amount27, ppdm.period_amount28, ppdm.period_amount29, ppdm.period_amount30, ppdm.period_amount31, ppdm.period_amount32, ppdm.period_amount33, ppdm.period_amount34, ppdm.period_amount35, ppdm.period_amount36, ppdm.period_amount37, ppdm.period_amount38, ppdm.period_amount39, ppdm.period_amount40, ppdm.period_amount41, ppdm.period_amount42, ppdm.period_amount43, ppdm.period_amount44, ppdm.period_amount45, ppdm.period_amount46, ppdm.period_amount47, ppdm.period_amount48, ppdm.period_amount49, ppdm.period_amount50, ppdm.period_amount51, ppdm.period_amount52 From pa_proj_periods_denorm ppdm, hr_all_organization_units hrorg1, hr_all_organization_units hrorg2, hr_all_organization_units hrorg3, hr_all_organization_units hrorg4, pa_org_fcst_elements ofe, pa_projects_all pp, pa_work_types_b pwtb, pa_project_assignments ppa, pa_resources pr, pa_amount_types_vl pmvl WHERE ofe.budget_version_id= pa_fin_plan_view_global.Get_Version_ID() and ofe.provider_receiver_code= decode(ppdm.amount_subtype_code,'OWN_REVENUE','P', 'BORROWED_REVENUE','R', 'TP_REVENUE_IN','P', 'TP_REVENUE_OUT','R', 'OWN_PROJECT_COST','P', 'TP_COST_IN','R', 'TP_COST_OUT','P', 'LENT_RESOURCE_COST','P', 'UNASSIGNED_TIME_COST','P', ofe.provider_receiver_code) and ofe.organization_id= decode(ppdm.amount_subtype_code,'OWN_REVENUE',ofe.other_organization_id, 'OWN_PROJECT_COST',ofe.other_organization_id, ofe.organization_id) and NVL(pwtb.unassigned_flag,'N')= decode(ppdm.amount_subtype_code, 'UNASSIGNED_TIME_COST', 'Y',NVL(pwtb.unassigned_flag,'N')) and NVL(pwtb.unassigned_flag,'N')<> decode(ppdm.amount_subtype_code,'UNASSIGNED_TIME_COST','N','Y') and ofe.organization_id<> decode(ppdm.amount_subtype_code,'TP_REVENUE_IN',ofe.other_organization_id, 'TP_COST_OUT',ofe.other_organization_id, 'LENT_RESOURCE_COST',ofe.other_organization_id,-99) and ppdm.amount_type_code= pa_fin_plan_view_global.Get_Amount_Type_code() and pmvl.AMOUNT_TYPE_ID = ppdm.amount_subtype_id and pp.project_id= ofe.txn_project_id and pp.work_type_id = pwtb.work_type_id(+) and nvl(hrorg1.organization_id,-99) = nvl(ofe.org_id,-99) and nvl(hrorg2.organization_id,-99) = nvl(ofe.organization_id,-99) and nvl(hrorg3.organization_id,-99) = nvl(ofe.other_org_id,-99) and nvl(hrorg4.organization_id,-99) = nvl(ofe.other_organization_id,-99) and ppa.assignment_id(+)=ofe.assignment_id and pr.resource_id(+)=ofe.resource_id and ppdm.budget_version_id = pa_fin_plan_view_global.Get_Version_ID() and ppdm.object_id = ofe.forecast_element_id and ppdm.object_type_code = 'FCST_ELEMENTS' and ppdm.currency_type = 'PROJ_FUNCTIONAL' union Select ppdm.amount_subtype_id, pmvl.AMOUNT_TYPE_NAME, to_number(null), null, to_number(null), null, pp.org_id, hrorg1.name, pp.carrying_out_organization_id, hrorg.name, null, null, ppdm.period_amount1, ppdm.period_amount2, ppdm.period_amount3, ppdm.period_amount4, ppdm.period_amount5, ppdm.period_amount6, ppdm.period_amount7, ppdm.period_amount8, ppdm.period_amount9, ppdm.period_amount10, ppdm.period_amount11, ppdm.period_amount12, ppdm.period_amount13, ppdm.period_amount14, ppdm.period_amount15, ppdm.period_amount16, ppdm.period_amount17, ppdm.period_amount18, ppdm.period_amount19, ppdm.period_amount20, ppdm.period_amount21, ppdm.period_amount22, ppdm.period_amount23, ppdm.period_amount24, ppdm.period_amount25, ppdm.period_amount26, ppdm.period_amount27, ppdm.period_amount28, ppdm.period_amount29, ppdm.period_amount30, ppdm.period_amount31, ppdm.period_amount32, ppdm.period_amount33, ppdm.period_amount34, ppdm.period_amount35, ppdm.period_amount36, ppdm.period_amount37, ppdm.period_amount38, ppdm.period_amount39, ppdm.period_amount40, ppdm.period_amount41, ppdm.period_amount42, ppdm.period_amount43, ppdm.period_amount44, ppdm.period_amount45, ppdm.period_amount46, ppdm.period_amount47, ppdm.period_amount48, ppdm.period_amount49, ppdm.period_amount50, ppdm.period_amount51, ppdm.period_amount52 From pa_proj_periods_denorm ppdm, hr_all_organization_units hrorg1, hr_all_organization_units hrorg, pa_resource_assignments pra, pa_projects_all pp, pa_budget_versions pbv, pa_amount_types_vl pmvl where pra.budget_version_id= pa_fin_plan_view_global.Get_Version_ID() and pbv.budget_version_id= pa_fin_plan_view_global.Get_Version_ID() and pra.project_id = pbv.project_id and pra.task_id=0 and ppdm.amount_type_code= pa_fin_plan_view_global.Get_Amount_Type_code() and ppdm.amount_subtype_code like '%ADJUSTMENTS%' and pmvl.AMOUNT_TYPE_ID = ppdm.amount_subtype_id and pp.project_id= pbv.project_id and nvl(hrorg.organization_id,-99) = nvl(pp.carrying_out_organization_id,-99) and nvl(hrorg1.organization_id,-99) = nvl(pp.org_id,-99) and ppdm.budget_version_id = pa_fin_plan_view_global.Get_Version_ID() and ppdm.object_id = pra.resource_assignment_id and ppdm.object_type_code = 'RES_ASSIGNMENT' and ppdm.resource_assignment_id = pra.resource_assignment_id and ppdm.currency_type = 'PROJ_FUNCTIONAL' order by 1,9

View Text - HTML Formatted

SELECT PPDM.AMOUNT_SUBTYPE_ID
, PMVL.AMOUNT_TYPE_NAME
, OFE.ORG_ID
, HRORG1.NAME
, OFE.ORGANIZATION_ID
, HRORG2.NAME
, OFE.OTHER_ORG_ID
, HRORG3.NAME
, OFE.OTHER_ORGANIZATION_ID
, HRORG4.NAME
, PP.NAME
, DECODE(OFE.RESOURCE_ID
, -1
, PPA.ASSIGNMENT_NAME
, PR.NAME)
, PPDM.PERIOD_AMOUNT1
, PPDM.PERIOD_AMOUNT2
, PPDM.PERIOD_AMOUNT3
, PPDM.PERIOD_AMOUNT4
, PPDM.PERIOD_AMOUNT5
, PPDM.PERIOD_AMOUNT6
, PPDM.PERIOD_AMOUNT7
, PPDM.PERIOD_AMOUNT8
, PPDM.PERIOD_AMOUNT9
, PPDM.PERIOD_AMOUNT10
, PPDM.PERIOD_AMOUNT11
, PPDM.PERIOD_AMOUNT12
, PPDM.PERIOD_AMOUNT13
, PPDM.PERIOD_AMOUNT14
, PPDM.PERIOD_AMOUNT15
, PPDM.PERIOD_AMOUNT16
, PPDM.PERIOD_AMOUNT17
, PPDM.PERIOD_AMOUNT18
, PPDM.PERIOD_AMOUNT19
, PPDM.PERIOD_AMOUNT20
, PPDM.PERIOD_AMOUNT21
, PPDM.PERIOD_AMOUNT22
, PPDM.PERIOD_AMOUNT23
, PPDM.PERIOD_AMOUNT24
, PPDM.PERIOD_AMOUNT25
, PPDM.PERIOD_AMOUNT26
, PPDM.PERIOD_AMOUNT27
, PPDM.PERIOD_AMOUNT28
, PPDM.PERIOD_AMOUNT29
, PPDM.PERIOD_AMOUNT30
, PPDM.PERIOD_AMOUNT31
, PPDM.PERIOD_AMOUNT32
, PPDM.PERIOD_AMOUNT33
, PPDM.PERIOD_AMOUNT34
, PPDM.PERIOD_AMOUNT35
, PPDM.PERIOD_AMOUNT36
, PPDM.PERIOD_AMOUNT37
, PPDM.PERIOD_AMOUNT38
, PPDM.PERIOD_AMOUNT39
, PPDM.PERIOD_AMOUNT40
, PPDM.PERIOD_AMOUNT41
, PPDM.PERIOD_AMOUNT42
, PPDM.PERIOD_AMOUNT43
, PPDM.PERIOD_AMOUNT44
, PPDM.PERIOD_AMOUNT45
, PPDM.PERIOD_AMOUNT46
, PPDM.PERIOD_AMOUNT47
, PPDM.PERIOD_AMOUNT48
, PPDM.PERIOD_AMOUNT49
, PPDM.PERIOD_AMOUNT50
, PPDM.PERIOD_AMOUNT51
, PPDM.PERIOD_AMOUNT52
FROM PA_PROJ_PERIODS_DENORM PPDM
, HR_ALL_ORGANIZATION_UNITS HRORG1
, HR_ALL_ORGANIZATION_UNITS HRORG2
, HR_ALL_ORGANIZATION_UNITS HRORG3
, HR_ALL_ORGANIZATION_UNITS HRORG4
, PA_ORG_FCST_ELEMENTS OFE
, PA_PROJECTS_ALL PP
, PA_WORK_TYPES_B PWTB
, PA_PROJECT_ASSIGNMENTS PPA
, PA_RESOURCES PR
, PA_AMOUNT_TYPES_VL PMVL
WHERE OFE.BUDGET_VERSION_ID= PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND OFE.PROVIDER_RECEIVER_CODE= DECODE(PPDM.AMOUNT_SUBTYPE_CODE
, 'OWN_REVENUE'
, 'P'
, 'BORROWED_REVENUE'
, 'R'
, 'TP_REVENUE_IN'
, 'P'
, 'TP_REVENUE_OUT'
, 'R'
, 'OWN_PROJECT_COST'
, 'P'
, 'TP_COST_IN'
, 'R'
, 'TP_COST_OUT'
, 'P'
, 'LENT_RESOURCE_COST'
, 'P'
, 'UNASSIGNED_TIME_COST'
, 'P'
, OFE.PROVIDER_RECEIVER_CODE)
AND OFE.ORGANIZATION_ID= DECODE(PPDM.AMOUNT_SUBTYPE_CODE
, 'OWN_REVENUE'
, OFE.OTHER_ORGANIZATION_ID
, 'OWN_PROJECT_COST'
, OFE.OTHER_ORGANIZATION_ID
, OFE.ORGANIZATION_ID)
AND NVL(PWTB.UNASSIGNED_FLAG
, 'N')= DECODE(PPDM.AMOUNT_SUBTYPE_CODE
, 'UNASSIGNED_TIME_COST'
, 'Y'
, NVL(PWTB.UNASSIGNED_FLAG
, 'N'))
AND NVL(PWTB.UNASSIGNED_FLAG
, 'N')<> DECODE(PPDM.AMOUNT_SUBTYPE_CODE
, 'UNASSIGNED_TIME_COST'
, 'N'
, 'Y')
AND OFE.ORGANIZATION_ID<> DECODE(PPDM.AMOUNT_SUBTYPE_CODE
, 'TP_REVENUE_IN'
, OFE.OTHER_ORGANIZATION_ID
, 'TP_COST_OUT'
, OFE.OTHER_ORGANIZATION_ID
, 'LENT_RESOURCE_COST'
, OFE.OTHER_ORGANIZATION_ID
, -99)
AND PPDM.AMOUNT_TYPE_CODE= PA_FIN_PLAN_VIEW_GLOBAL.GET_AMOUNT_TYPE_CODE()
AND PMVL.AMOUNT_TYPE_ID = PPDM.AMOUNT_SUBTYPE_ID
AND PP.PROJECT_ID= OFE.TXN_PROJECT_ID
AND PP.WORK_TYPE_ID = PWTB.WORK_TYPE_ID(+)
AND NVL(HRORG1.ORGANIZATION_ID
, -99) = NVL(OFE.ORG_ID
, -99)
AND NVL(HRORG2.ORGANIZATION_ID
, -99) = NVL(OFE.ORGANIZATION_ID
, -99)
AND NVL(HRORG3.ORGANIZATION_ID
, -99) = NVL(OFE.OTHER_ORG_ID
, -99)
AND NVL(HRORG4.ORGANIZATION_ID
, -99) = NVL(OFE.OTHER_ORGANIZATION_ID
, -99)
AND PPA.ASSIGNMENT_ID(+)=OFE.ASSIGNMENT_ID
AND PR.RESOURCE_ID(+)=OFE.RESOURCE_ID
AND PPDM.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PPDM.OBJECT_ID = OFE.FORECAST_ELEMENT_ID
AND PPDM.OBJECT_TYPE_CODE = 'FCST_ELEMENTS'
AND PPDM.CURRENCY_TYPE = 'PROJ_FUNCTIONAL' UNION SELECT PPDM.AMOUNT_SUBTYPE_ID
, PMVL.AMOUNT_TYPE_NAME
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, PP.ORG_ID
, HRORG1.NAME
, PP.CARRYING_OUT_ORGANIZATION_ID
, HRORG.NAME
, NULL
, NULL
, PPDM.PERIOD_AMOUNT1
, PPDM.PERIOD_AMOUNT2
, PPDM.PERIOD_AMOUNT3
, PPDM.PERIOD_AMOUNT4
, PPDM.PERIOD_AMOUNT5
, PPDM.PERIOD_AMOUNT6
, PPDM.PERIOD_AMOUNT7
, PPDM.PERIOD_AMOUNT8
, PPDM.PERIOD_AMOUNT9
, PPDM.PERIOD_AMOUNT10
, PPDM.PERIOD_AMOUNT11
, PPDM.PERIOD_AMOUNT12
, PPDM.PERIOD_AMOUNT13
, PPDM.PERIOD_AMOUNT14
, PPDM.PERIOD_AMOUNT15
, PPDM.PERIOD_AMOUNT16
, PPDM.PERIOD_AMOUNT17
, PPDM.PERIOD_AMOUNT18
, PPDM.PERIOD_AMOUNT19
, PPDM.PERIOD_AMOUNT20
, PPDM.PERIOD_AMOUNT21
, PPDM.PERIOD_AMOUNT22
, PPDM.PERIOD_AMOUNT23
, PPDM.PERIOD_AMOUNT24
, PPDM.PERIOD_AMOUNT25
, PPDM.PERIOD_AMOUNT26
, PPDM.PERIOD_AMOUNT27
, PPDM.PERIOD_AMOUNT28
, PPDM.PERIOD_AMOUNT29
, PPDM.PERIOD_AMOUNT30
, PPDM.PERIOD_AMOUNT31
, PPDM.PERIOD_AMOUNT32
, PPDM.PERIOD_AMOUNT33
, PPDM.PERIOD_AMOUNT34
, PPDM.PERIOD_AMOUNT35
, PPDM.PERIOD_AMOUNT36
, PPDM.PERIOD_AMOUNT37
, PPDM.PERIOD_AMOUNT38
, PPDM.PERIOD_AMOUNT39
, PPDM.PERIOD_AMOUNT40
, PPDM.PERIOD_AMOUNT41
, PPDM.PERIOD_AMOUNT42
, PPDM.PERIOD_AMOUNT43
, PPDM.PERIOD_AMOUNT44
, PPDM.PERIOD_AMOUNT45
, PPDM.PERIOD_AMOUNT46
, PPDM.PERIOD_AMOUNT47
, PPDM.PERIOD_AMOUNT48
, PPDM.PERIOD_AMOUNT49
, PPDM.PERIOD_AMOUNT50
, PPDM.PERIOD_AMOUNT51
, PPDM.PERIOD_AMOUNT52
FROM PA_PROJ_PERIODS_DENORM PPDM
, HR_ALL_ORGANIZATION_UNITS HRORG1
, HR_ALL_ORGANIZATION_UNITS HRORG
, PA_RESOURCE_ASSIGNMENTS PRA
, PA_PROJECTS_ALL PP
, PA_BUDGET_VERSIONS PBV
, PA_AMOUNT_TYPES_VL PMVL
WHERE PRA.BUDGET_VERSION_ID= PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PBV.BUDGET_VERSION_ID= PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PRA.PROJECT_ID = PBV.PROJECT_ID
AND PRA.TASK_ID=0
AND PPDM.AMOUNT_TYPE_CODE= PA_FIN_PLAN_VIEW_GLOBAL.GET_AMOUNT_TYPE_CODE()
AND PPDM.AMOUNT_SUBTYPE_CODE LIKE '%ADJUSTMENTS%'
AND PMVL.AMOUNT_TYPE_ID = PPDM.AMOUNT_SUBTYPE_ID
AND PP.PROJECT_ID= PBV.PROJECT_ID
AND NVL(HRORG.ORGANIZATION_ID
, -99) = NVL(PP.CARRYING_OUT_ORGANIZATION_ID
, -99)
AND NVL(HRORG1.ORGANIZATION_ID
, -99) = NVL(PP.ORG_ID
, -99)
AND PPDM.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PPDM.OBJECT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PPDM.OBJECT_TYPE_CODE = 'RES_ASSIGNMENT'
AND PPDM.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PPDM.CURRENCY_TYPE = 'PROJ_FUNCTIONAL' ORDER BY 1
, 9