Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_ADJUST_TYPE_V |
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))