View: PA_FP_VIEW_ADJ_V

Product:	PA - Projects
Description:	The pa_fp_view_adj_v view store the adjusted amounts by period for all adjustment reasons.
Implementation/DBA Data:	APPS.PA_FP_VIEW_ADJ_V

View Text

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

Columns