View: PA_FP_ENTER_ADJ_LINES_V

Product:	PA - Projects
Description:	The pa_fp_enter_adj_lines_v view store the adjusted amounts by period for one adjustment reason.
Implementation/DBA Data:	APPS.PA_FP_ENTER_ADJ_LINES_V

View Text

SELECT B.AMOUNT_TYPE_ID
, B.AMOUNT_TYPE_NAME
, B.AMOUNT_TYPE_CODE
, B.AMOUNT_TYPE_CODE||'_ADJUSTMENTS' AS AMOUNT_SUBTYPE_CODE
, A.PRECEDING_PERIODS_AMOUNT
, A.SUCCEEDING_PERIODS_AMOUNT
, A.PERIOD_AMOUNT1
, A.PERIOD_AMOUNT2
, A.PERIOD_AMOUNT3
, A.PERIOD_AMOUNT4
, A.PERIOD_AMOUNT5
, A.PERIOD_AMOUNT6
, A.PERIOD_AMOUNT7
, A.PERIOD_AMOUNT8
, A.PERIOD_AMOUNT9
, A.PERIOD_AMOUNT10
, A.PERIOD_AMOUNT11
, A.PERIOD_AMOUNT12
, A.PERIOD_AMOUNT13
FROM PA_FP_PERIOD_VALUES_V A
, PA_AMOUNT_TYPES_VL B
, PA_FP_ADJ_ELEMENTS C
, PA_AMOUNT_TYPES_VL D
, PA_RESOURCE_ASSIGNMENTS PRA
WHERE C.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 C.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND C.ADJUSTMENT_REASON_CODE = PA_FIN_PLAN_VIEW_GLOBAL.GET_ADJ_REASON_CODE()
AND A.OBJECT_ID = C.ADJ_ELEMENT_ID
AND A.OBJECT_TYPE_CODE ='ADJ_ELEMENTS'
AND A.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND B.AMOUNT_TYPE_CODE = A.AMOUNT_TYPE_CODE
AND B.PLAN_ADJUSTABLE_FLAG = 'Y'
AND D.AMOUNT_TYPE_CODE = A.AMOUNT_SUBTYPE_CODE
AND D.PLAN_ADJ_AMOUNT_FLAG = 'Y' UNION SELECT B.AMOUNT_TYPE_ID
, B.AMOUNT_TYPE_NAME
, B.AMOUNT_TYPE_CODE
, B.AMOUNT_TYPE_CODE||'_ADJUSTMENTS' AS AMOUNT_SUBTYPE_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM PA_AMOUNT_TYPES_VL B
WHERE B.PLAN_ADJUSTABLE_FLAG = 'Y'
AND NOT EXISTS (SELECT 'X'
FROM PA_FP_PERIOD_VALUES_V A
, PA_FP_ADJ_ELEMENTS C
, PA_AMOUNT_TYPES_VL D
, PA_RESOURCE_ASSIGNMENTS PRA WHERE B.AMOUNT_TYPE_CODE = A.AMOUNT_TYPE_CODE
AND D.AMOUNT_TYPE_CODE = A.AMOUNT_SUBTYPE_CODE
AND D.PLAN_ADJ_AMOUNT_FLAG = 'Y'
AND A.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND C.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 C.ADJUSTMENT_REASON_CODE = PA_FIN_PLAN_VIEW_GLOBAL.GET_ADJ_REASON_CODE()
AND C.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND A.OBJECT_ID = C.ADJ_ELEMENT_ID
AND A.OBJECT_TYPE_CODE ='ADJ_ELEMENTS') ORDER BY 1

Columns