VIEW: APPS.PA_ADJUST_TYPE_V

Source

View Text - Preformatted

SELECT c.fin_plan_preference_code, a.burden_rate_flag, a.cost_rate_flag, a.bill_rate_flag, a.revenue_qty_flag, a.all_qty_flag, a.cost_qty_flag, b.budget_version_id, c.track_workplan_costs_flag, c.project_id, a.RAW_COST_FLAG, a.BURDENED_COST_FLAG FROM PA_FIN_PLAN_AMOUNT_SETS A, PA_BUDGET_VERSIONS B, PA_PROJ_FP_OPTIONS C WHERE B.PROJECT_ID = C.PROJECT_ID AND B.FIN_PLAN_TYPE_ID = C.FIN_PLAN_TYPE_ID AND B.BUDGET_VERSION_ID = C.FIN_PLAN_VERSION_ID AND C.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION' AND A.FIN_PLAN_AMOUNT_SET_ID = nvl (C.ALL_AMOUNT_SET_ID, nvl (C.COST_AMOUNT_SET_ID, C.REVENUE_AMOUNT_SET_ID))

View Text - HTML Formatted

SELECT C.FIN_PLAN_PREFERENCE_CODE
, A.BURDEN_RATE_FLAG
, A.COST_RATE_FLAG
, A.BILL_RATE_FLAG
, A.REVENUE_QTY_FLAG
, A.ALL_QTY_FLAG
, A.COST_QTY_FLAG
, B.BUDGET_VERSION_ID
, C.TRACK_WORKPLAN_COSTS_FLAG
, C.PROJECT_ID
, A.RAW_COST_FLAG
, A.BURDENED_COST_FLAG
FROM PA_FIN_PLAN_AMOUNT_SETS A
, PA_BUDGET_VERSIONS B
, PA_PROJ_FP_OPTIONS C
WHERE B.PROJECT_ID = C.PROJECT_ID
AND B.FIN_PLAN_TYPE_ID = C.FIN_PLAN_TYPE_ID
AND B.BUDGET_VERSION_ID = C.FIN_PLAN_VERSION_ID
AND C.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION'
AND A.FIN_PLAN_AMOUNT_SET_ID = NVL (C.ALL_AMOUNT_SET_ID
, NVL (C.COST_AMOUNT_SET_ID
, C.REVENUE_AMOUNT_SET_ID))