VIEW: APPS.PA_FP_ENTER_ADJ_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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