[Home] [Help]
View: PA_ADJUST_TYPE_V
View Text
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
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))
Columns
Name |
FIN_PLAN_PREFERENCE_CODE |
BURDEN_RATE_FLAG |
COST_RATE_FLAG |
BILL_RATE_FLAG |
REVENUE_QTY_FLAG |
ALL_QTY_FLAG |
COST_QTY_FLAG |
BUDGET_VERSION_ID |
TRACK_WORKPLAN_COSTS_FLAG |
PROJECT_ID |