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_VIEW_ADJ_V

Source

View Text - Preformatted


SELECT flkp.MEANING as adjustment_reason_name, pfpal.adjustment_reason_code as adjustment_reason_code, nvl(preceding_periods_amount,0), nvl(succeeding_periods_amount,0), nvl(pppd.period_amount1,0), nvl(pppd.period_amount2,0), nvl(pppd.period_amount3,0), nvl(pppd.period_amount4,0), nvl(pppd.period_amount5,0), nvl(pppd.period_amount6,0), nvl(pppd.period_amount7,0), nvl(pppd.period_amount8,0), nvl(pppd.period_amount9,0), nvl(pppd.period_amount10,0), nvl(pppd.period_amount11,0), nvl(pppd.period_amount12,0), nvl(pppd.period_amount13,0), (nvl(pppd.period_amount1,0)+ nvl(pppd.period_amount2,0)+ nvl(pppd.period_amount3,0)+ nvl(pppd.period_amount4,0)+ nvl(pppd.period_amount5,0)+ nvl(pppd.period_amount6,0)+ nvl(pppd.period_amount7,0)+ nvl(pppd.period_amount8,0)+ nvl(pppd.period_amount9,0)+ nvl(pppd.period_amount10,0)+ nvl(pppd.period_amount11,0)+ nvl(pppd.period_amount12,0)+ nvl(pppd.period_amount13,0)) as Total_PA, (nvl(pppd.period_amount1,0)+ nvl(pppd.period_amount2,0)+ nvl(pppd.period_amount3,0)+ nvl(pppd.period_amount4,0)+ nvl(pppd.period_amount5,0)+ nvl(pppd.period_amount6,0)) as Total from pa_fp_period_values_v pppd, pa_fp_adj_elements pfpal, pa_amount_types_vl patv, pa_lookups flkp, pa_resource_assignments pra WHERE pfpal.budget_version_id = pa_fin_plan_view_global.Get_Version_ID() and pra.budget_version_id = pa_fin_plan_view_global.Get_Version_ID() and pra.resource_assignment_type='OWN' and pfpal.resource_assignment_id = pra.resource_assignment_id and pppd.budget_version_id = pa_fin_plan_view_global.Get_Version_ID() and pppd.amount_type_code = pa_fin_plan_view_global.Get_Amount_Type_Code() and pppd.object_id = pfpal.ADJ_ELEMENT_ID and pppd.object_type_code = 'ADJ_ELEMENTS' and patv.amount_type_id = pppd.amount_subtype_id and patv.PLAN_ADJ_AMOUNT_FLAG = 'Y' and pfpal.adjustment_reason_code = flkp.LOOKUP_CODE and flkp.LOOKUP_TYPE = 'FIN_PLAN_ADJ_RSN' UNION select palk.meaning as adjustment_reason_Name, null adjustment_reason_code, sum(nvl(pppd.preceding_periods_amount,0)) as preceding_periods_amount, sum(nvl(pppd.succeeding_periods_amount,0)) as succeeding_periods_amount, sum(nvl(pppd.period_amount1,0)) as period1, sum(nvl(pppd.period_amount2,0)) as period2, sum(nvl(pppd.period_amount3,0)) as period3, sum(nvl(pppd.period_amount4,0)) as period4, sum(nvl(pppd.period_amount5,0)) as period5, sum(nvl(pppd.period_amount6,0)) as period6, sum(nvl(pppd.period_amount7,0)) as period7, sum(nvl(pppd.period_amount8,0)) as period8, sum(nvl(pppd.period_amount9,0)) as period9, sum(nvl(pppd.period_amount10,0)) as period10, sum(nvl(pppd.period_amount11,0)) as period11, sum(nvl(pppd.period_amount12,0)) as period12, sum(nvl(pppd.period_amount13,0)) as period13, (sum(nvl(pppd.period_amount1,0))+ sum(nvl(pppd.period_amount2,0))+ sum(nvl(pppd.period_amount3,0))+ sum(nvl(pppd.period_amount4,0))+ sum(nvl(pppd.period_amount5,0))+ sum(nvl(pppd.period_amount6,0))+ sum(nvl(pppd.period_amount7,0))+ sum(nvl(pppd.period_amount8,0))+ sum(nvl(pppd.period_amount9,0))+ sum(nvl(pppd.period_amount10,0))+ sum(nvl(pppd.period_amount11,0))+ sum(nvl(pppd.period_amount12,0))+ sum(nvl(pppd.period_amount13,0))) as Total_PA, (sum(nvl(pppd.period_amount1,0))+ sum(nvl(pppd.period_amount2,0))+ sum(nvl(pppd.period_amount3,0))+ sum(nvl(pppd.period_amount4,0))+ sum(nvl(pppd.period_amount5,0))+ sum(nvl(pppd.period_amount6,0))) as Total from pa_fp_period_values_v pppd, pa_fp_adj_elements pfpal, pa_amount_types_vl patv, pa_lookups palk, pa_resource_assignments pra where pfpal.budget_version_id = pa_fin_plan_view_global.Get_Version_ID() and pra.budget_version_id = pa_fin_plan_view_global.Get_Version_ID() and pra.resource_assignment_type='OWN' and pfpal.resource_assignment_id = pra.resource_assignment_id and pppd.budget_version_id = pa_fin_plan_view_global.Get_Version_ID() and pppd.amount_type_code = pa_fin_plan_view_global.Get_Amount_Type_Code() and pppd.object_id = pfpal.ADJ_ELEMENT_ID and pppd.object_type_code = 'ADJ_ELEMENTS' and patv.amount_type_id = pppd.amount_subtype_id and patv.PLAN_ADJ_AMOUNT_FLAG = 'Y' and palk.LOOKUP_TYPE = 'TRANSLATION_FP' and palk.LOOKUP_CODE = 'TOTAL' group by palk.meaning

View Text - HTML Formatted

SELECT FLKP.MEANING AS ADJUSTMENT_REASON_NAME
, PFPAL.ADJUSTMENT_REASON_CODE AS ADJUSTMENT_REASON_CODE
, NVL(PRECEDING_PERIODS_AMOUNT
, 0)
, NVL(SUCCEEDING_PERIODS_AMOUNT
, 0)
, NVL(PPPD.PERIOD_AMOUNT1
, 0)
, NVL(PPPD.PERIOD_AMOUNT2
, 0)
, NVL(PPPD.PERIOD_AMOUNT3
, 0)
, NVL(PPPD.PERIOD_AMOUNT4
, 0)
, NVL(PPPD.PERIOD_AMOUNT5
, 0)
, NVL(PPPD.PERIOD_AMOUNT6
, 0)
, NVL(PPPD.PERIOD_AMOUNT7
, 0)
, NVL(PPPD.PERIOD_AMOUNT8
, 0)
, NVL(PPPD.PERIOD_AMOUNT9
, 0)
, NVL(PPPD.PERIOD_AMOUNT10
, 0)
, NVL(PPPD.PERIOD_AMOUNT11
, 0)
, NVL(PPPD.PERIOD_AMOUNT12
, 0)
, NVL(PPPD.PERIOD_AMOUNT13
, 0)
, (NVL(PPPD.PERIOD_AMOUNT1
, 0)+ NVL(PPPD.PERIOD_AMOUNT2
, 0)+ NVL(PPPD.PERIOD_AMOUNT3
, 0)+ NVL(PPPD.PERIOD_AMOUNT4
, 0)+ NVL(PPPD.PERIOD_AMOUNT5
, 0)+ NVL(PPPD.PERIOD_AMOUNT6
, 0)+ NVL(PPPD.PERIOD_AMOUNT7
, 0)+ NVL(PPPD.PERIOD_AMOUNT8
, 0)+ NVL(PPPD.PERIOD_AMOUNT9
, 0)+ NVL(PPPD.PERIOD_AMOUNT10
, 0)+ NVL(PPPD.PERIOD_AMOUNT11
, 0)+ NVL(PPPD.PERIOD_AMOUNT12
, 0)+ NVL(PPPD.PERIOD_AMOUNT13
, 0)) AS TOTAL_PA
, (NVL(PPPD.PERIOD_AMOUNT1
, 0)+ NVL(PPPD.PERIOD_AMOUNT2
, 0)+ NVL(PPPD.PERIOD_AMOUNT3
, 0)+ NVL(PPPD.PERIOD_AMOUNT4
, 0)+ NVL(PPPD.PERIOD_AMOUNT5
, 0)+ NVL(PPPD.PERIOD_AMOUNT6
, 0)) AS TOTAL
FROM PA_FP_PERIOD_VALUES_V PPPD
, PA_FP_ADJ_ELEMENTS PFPAL
, PA_AMOUNT_TYPES_VL PATV
, PA_LOOKUPS FLKP
, PA_RESOURCE_ASSIGNMENTS PRA
WHERE PFPAL.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PRA.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PRA.RESOURCE_ASSIGNMENT_TYPE='OWN'
AND PFPAL.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PPPD.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PPPD.AMOUNT_TYPE_CODE = PA_FIN_PLAN_VIEW_GLOBAL.GET_AMOUNT_TYPE_CODE()
AND PPPD.OBJECT_ID = PFPAL.ADJ_ELEMENT_ID
AND PPPD.OBJECT_TYPE_CODE = 'ADJ_ELEMENTS'
AND PATV.AMOUNT_TYPE_ID = PPPD.AMOUNT_SUBTYPE_ID
AND PATV.PLAN_ADJ_AMOUNT_FLAG = 'Y'
AND PFPAL.ADJUSTMENT_REASON_CODE = FLKP.LOOKUP_CODE
AND FLKP.LOOKUP_TYPE = 'FIN_PLAN_ADJ_RSN' UNION SELECT PALK.MEANING AS ADJUSTMENT_REASON_NAME
, NULL ADJUSTMENT_REASON_CODE
, SUM(NVL(PPPD.PRECEDING_PERIODS_AMOUNT
, 0)) AS PRECEDING_PERIODS_AMOUNT
, SUM(NVL(PPPD.SUCCEEDING_PERIODS_AMOUNT
, 0)) AS SUCCEEDING_PERIODS_AMOUNT
, SUM(NVL(PPPD.PERIOD_AMOUNT1
, 0)) AS PERIOD1
, SUM(NVL(PPPD.PERIOD_AMOUNT2
, 0)) AS PERIOD2
, SUM(NVL(PPPD.PERIOD_AMOUNT3
, 0)) AS PERIOD3
, SUM(NVL(PPPD.PERIOD_AMOUNT4
, 0)) AS PERIOD4
, SUM(NVL(PPPD.PERIOD_AMOUNT5
, 0)) AS PERIOD5
, SUM(NVL(PPPD.PERIOD_AMOUNT6
, 0)) AS PERIOD6
, SUM(NVL(PPPD.PERIOD_AMOUNT7
, 0)) AS PERIOD7
, SUM(NVL(PPPD.PERIOD_AMOUNT8
, 0)) AS PERIOD8
, SUM(NVL(PPPD.PERIOD_AMOUNT9
, 0)) AS PERIOD9
, SUM(NVL(PPPD.PERIOD_AMOUNT10
, 0)) AS PERIOD10
, SUM(NVL(PPPD.PERIOD_AMOUNT11
, 0)) AS PERIOD11
, SUM(NVL(PPPD.PERIOD_AMOUNT12
, 0)) AS PERIOD12
, SUM(NVL(PPPD.PERIOD_AMOUNT13
, 0)) AS PERIOD13
, (SUM(NVL(PPPD.PERIOD_AMOUNT1
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT2
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT3
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT4
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT5
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT6
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT7
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT8
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT9
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT10
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT11
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT12
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT13
, 0))) AS TOTAL_PA
, (SUM(NVL(PPPD.PERIOD_AMOUNT1
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT2
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT3
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT4
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT5
, 0))+ SUM(NVL(PPPD.PERIOD_AMOUNT6
, 0))) AS TOTAL
FROM PA_FP_PERIOD_VALUES_V PPPD
, PA_FP_ADJ_ELEMENTS PFPAL
, PA_AMOUNT_TYPES_VL PATV
, PA_LOOKUPS PALK
, PA_RESOURCE_ASSIGNMENTS PRA
WHERE PFPAL.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PRA.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PRA.RESOURCE_ASSIGNMENT_TYPE='OWN'
AND PFPAL.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PPPD.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PPPD.AMOUNT_TYPE_CODE = PA_FIN_PLAN_VIEW_GLOBAL.GET_AMOUNT_TYPE_CODE()
AND PPPD.OBJECT_ID = PFPAL.ADJ_ELEMENT_ID
AND PPPD.OBJECT_TYPE_CODE = 'ADJ_ELEMENTS'
AND PATV.AMOUNT_TYPE_ID = PPPD.AMOUNT_SUBTYPE_ID
AND PATV.PLAN_ADJ_AMOUNT_FLAG = 'Y'
AND PALK.LOOKUP_TYPE = 'TRANSLATION_FP'
AND PALK.LOOKUP_CODE = 'TOTAL' GROUP BY PALK.MEANING