View: PA_FP_WEBADI_NON_PERIODIC_V

Product:	PA - Projects
Description:	This view is used in Financial Planning to download non-periodic budget/forecast data into Excel Spreadsheet.
Implementation/DBA Data:	APPS.PA_FP_WEBADI_NON_PERIODIC_V

View Text

SELECT PRA.BUDGET_VERSION_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, P.NAME
, P.SEGMENT1
, PRA.RESOURCE_ASSIGNMENT_ID
, NVL(PE.NAME
, P.LONG_NAME) TASK_NAME
, NVL(PE.ELEMENT_NUMBER
, P.SEGMENT1) TASK_NUMBER
, NVL(PEV.DISPLAY_SEQUENCE
, -1) AS TASK_DISPLAY_SEQUENCE
, PRLM.ALIAS RESOURCE_NAME
, PRA.RESOURCE_LIST_MEMBER_ID
, PRA.PLANNING_START_DATE
, PRA.PLANNING_END_DATE
, NVL(RAC.TXN_CURRENCY_CODE
, DECODE(PBV.CI_ID
, NULL
, DECODE(PBV.APPROVED_REV_PLAN_TYPE_FLAG
, 'Y'
, P.PROJFUNC_CURRENCY_CODE
, P.PROJECT_CURRENCY_CODE)
, DECODE(PBV.VERSION_TYPE
, 'ALL'
, PA_FIN_PLAN_UTILS2.GET_AGREEMENT_CURRENCY(PRA.BUDGET_VERSION_ID)
, 'REVENUE'
, PA_FIN_PLAN_UTILS2.GET_AGREEMENT_CURRENCY(PRA.BUDGET_VERSION_ID)
, DECODE(PBV.APPROVED_REV_PLAN_TYPE_FLAG
, 'Y'
, P.PROJFUNC_CURRENCY_CODE
, P.PROJECT_CURRENCY_CODE)))) AS CURRENCY
, UOM.MEANING
, DECODE(NVL(NVL(PPFO.COST_TIME_PHASED_CODE
, PPFO.REVENUE_TIME_PHASED_CODE)
, PPFO.ALL_TIME_PHASED_CODE)
, 'N'
, PA_FIN_PLAN_UTILS.GET_NP_RA_DESCRIPTION(PRA.RESOURCE_ASSIGNMENT_ID
, RAC.TXN_CURRENCY_CODE)
, NULL) DESCRIPTION
, PRA.SPREAD_CURVE_ID SPREAD_CURVE_ID
, PSC.NAME SPREAD_CURVE
, PRA.MFC_COST_TYPE_ID MFC_COST_TYPE_ID
, CCT.COST_TYPE MFC_COST_TYPE
, PRA.ETC_METHOD_CODE ETC_METHOD_CODE
, ETC.MEANING ETC_METHOD
, NULL DELETE_FLAG
, RAC.TOTAL_DISPLAY_QUANTITY
, RAC.TOTAL_INIT_QUANTITY
, RAC.TOTAL_DISPLAY_QUANTITY-NVL(RAC.TOTAL_INIT_QUANTITY
, 0)
, PA_FP_WEBADI_UTILS.GET_CURRENT_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'QUANTITY') CURRENT_QUANTITY
, PA_FP_WEBADI_UTILS.GET_ORIGINAL_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'QUANTITY')ORIGINAL_QUANTITY
, PA_FP_WEBADI_UTILS.GET_PRIOR_FORECAST_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'QUANTITY') PRIOR_FORECAST_QUANTITY
, RAC.TOTAL_TXN_RAW_COST
, RAC.TOTAL_TXN_INIT_RAW_COST
, RAC.TOTAL_TXN_RAW_COST-NVL(RAC.TOTAL_TXN_INIT_RAW_COST
, 0)
, PA_FP_WEBADI_UTILS.GET_CURRENT_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'RAW_COST') CURRENT_RAW_COST
, PA_FP_WEBADI_UTILS.GET_ORIGINAL_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'RAW_COST') ORIGINAL_RAW_COST
, PA_FP_WEBADI_UTILS.GET_PRIOR_FORECAST_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'RAW_COST') PRIOR_FORECAST_RAW_COST
, RAC.TOTAL_TXN_BURDENED_COST
, RAC.TOTAL_TXN_INIT_BURDENED_COST
, RAC.TOTAL_TXN_BURDENED_COST-NVL(RAC.TOTAL_TXN_INIT_BURDENED_COST
, 0)
, PA_FP_WEBADI_UTILS.GET_CURRENT_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'BURDENED_COST') CURRENT_BURDENED_COST
, PA_FP_WEBADI_UTILS.GET_ORIGINAL_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'BURDENED_COST') ORIGINAL_BURDENED_COST
, PA_FP_WEBADI_UTILS.GET_PRIOR_FORECAST_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'BURDENED_COST') PRIOR_FORECAST_BURDENED_COST
, RAC.TOTAL_TXN_REVENUE
, RAC.TOTAL_TXN_INIT_REVENUE
, RAC.TOTAL_TXN_REVENUE-NVL(RAC.TOTAL_TXN_INIT_REVENUE
, 0)
, PA_FP_WEBADI_UTILS.GET_CURRENT_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'REVENUE') CURRENT_REVENUE
, PA_FP_WEBADI_UTILS.GET_ORIGINAL_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'REVENUE') ORIGINAL_REVENUE
, PA_FP_WEBADI_UTILS.GET_PRIOR_FORECAST_AMOUNT(PPFO.FIN_PLAN_TYPE_ID
, PT.PLAN_CLASS_CODE
, P.PROJECT_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PRA.TASK_ID
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')
, RAC.TXN_CURRENCY_CODE
, 'REVENUE') PRIOR_FORECAST_REVENUE
, DECODE(PRA.RATE_BASED_FLAG
, 'Y'
, RAC.TXN_RAW_COST_RATE_OVERRIDE
, NULL)
, DECODE(PRA.RATE_BASED_FLAG
, 'Y'
, RAC.TXN_BURDEN_COST_RATE_OVERRIDE
, NULL)
, DECODE(PRA.RATE_BASED_FLAG
, 'Y'
, RAC.TXN_BILL_RATE_OVERRIDE
, NULL)
, DECODE(PRA.RATE_BASED_FLAG
, 'Y'
, RAC.TXN_AVERAGE_RAW_COST_RATE
, NULL)
, DECODE(PRA.RATE_BASED_FLAG
, 'Y'
, RAC.TXN_AVERAGE_BURDEN_COST_RATE
, NULL)
, DECODE(PRA.RATE_BASED_FLAG
, 'Y'
, RAC.TXN_AVERAGE_BILL_RATE
, NULL)
, DECODE(PRA.RATE_BASED_FLAG
, 'Y'
, RAC.TXN_ETC_RAW_COST_RATE
, NULL)
, DECODE(PRA.RATE_BASED_FLAG
, 'Y'
, RAC.TXN_ETC_BURDEN_COST_RATE
, NULL)
, DECODE(PRA.RATE_BASED_FLAG
, 'Y'
, RAC.TXN_ETC_BILL_RATE
, NULL)
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, NULL
, NULL
, (SELECT PCTV1.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV1
WHERE PCTV1.CONVERSION_TYPE=NVL(PPFO.PROJFUNC_COST_RATE_TYPE
, 'CORPORATE')))
, DECODE(DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, NULL
, NULL
, (SELECT PLK_D1.MEANING
FROM PA_LOOKUPS PLK_D1
WHERE PLK_D1.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D1.LOOKUP_CODE=NVL(DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, 'FIXED_DATE')))
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, NULL
, NULL
, (SELECT PCTV2.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV2
WHERE PCTV2.CONVERSION_TYPE=NVL(PPFO.PROJECT_COST_RATE_TYPE
, 'CORPORATE')))
, DECODE(DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, NULL
, NULL
, (SELECT PLK_D2.MEANING
FROM PA_LOOKUPS PLK_D2
WHERE PLK_D2.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D2.LOOKUP_CODE=NVL(DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, 'FIXED_DATE')))
, DECODE(PPFO.PROJFUNC_REV_RATE_TYPE
, NULL
, NULL
, (SELECT PCTV3.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV3
WHERE PCTV3.CONVERSION_TYPE=NVL(PPFO.PROJFUNC_REV_RATE_TYPE
, 'CORPORATE')))
, DECODE(DECODE(PPFO.PROJFUNC_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_REV_RATE_DATE_TYPE)
, NULL
, NULL
, (SELECT PLK_D3.MEANING
FROM PA_LOOKUPS PLK_D3
WHERE PLK_D3.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D3.LOOKUP_CODE=NVL(DECODE(PPFO.PROJFUNC_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_REV_RATE_DATE_TYPE)
, 'FIXED_DATE')))
, DECODE(PPFO.PROJECT_REV_RATE_TYPE
, NULL
, NULL
, (SELECT PCTV4.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV4
WHERE PCTV4.CONVERSION_TYPE=NVL(PPFO.PROJECT_REV_RATE_TYPE
, 'CORPORATE')))
, DECODE(DECODE(PPFO.PROJECT_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_REV_RATE_DATE_TYPE)
, NULL
, NULL
, (SELECT PLK_D4.MEANING
FROM PA_LOOKUPS PLK_D4
WHERE PLK_D4.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D4.LOOKUP_CODE=NVL(DECODE(PPFO.PROJECT_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_REV_RATE_DATE_TYPE)
, 'FIXED_DATE')))
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, PFTC.PROJFUNC_COST_EXCHANGE_RATE
, TO_NUMBER(NULL))
, DECODE(PPFO.PROJFUNC_COST_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJFUNC_COST_RATE_DATE
, TO_DATE(NULL))
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, PFTC.PROJECT_COST_EXCHANGE_RATE
, TO_NUMBER(NULL))
, DECODE(PPFO.PROJECT_COST_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJECT_COST_RATE_DATE
, TO_DATE(NULL))
, DECODE(PPFO.PROJFUNC_REV_RATE_TYPE
, 'USER'
, PFTC.PROJFUNC_REV_EXCHANGE_RATE
, TO_NUMBER(NULL))
, DECODE(PPFO.PROJFUNC_REV_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJFUNC_REV_RATE_DATE
, TO_DATE(NULL))
, DECODE(PPFO.PROJECT_REV_RATE_TYPE
, 'USER'
, PFTC.PROJECT_REV_EXCHANGE_RATE
, TO_NUMBER(NULL))
, DECODE(PPFO.PROJECT_REV_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJECT_REV_RATE_DATE
, TO_DATE(NULL))
, PA_PLANNING_ELEMENT_UTILS.GET_TASK_PERCENT_COMPLETE(P.PROJECT_ID
, PRA.BUDGET_VERSION_ID
, PEV.PROJ_ELEMENT_ID
, 'FINANCIAL_PLANNING') PHYSICAL_PERCENT_COMPLETE
, DECODE(PRA.TRANSACTION_SOURCE_CODE
, NULL
, NULL
, (SELECT MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE='PA_FP_FCST_GEN_SRC_ALL'
AND LOOKUP_CODE= NVL(PRA.TRANSACTION_SOURCE_CODE
, ( SELECT LOOKUP_CODE
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE='PA_FP_FCST_GEN_SRC_ALL'
AND ROWNUM=1)))) ETC_SOURCE
, PA_FIN_PLAN_UTILS.GET_CHANGE_REASON(PRA.RESOURCE_ASSIGNMENT_ID
, RAC.TXN_CURRENCY_CODE
, NVL(NVL(PPFO.COST_TIME_PHASED_CODE
, PPFO.REVENUE_TIME_PHASED_CODE)
, PPFO.ALL_TIME_PHASED_CODE)) CHANGE_REASON
, PBV.RECORD_VERSION_NUMBER
FROM PA_PROJECTS_ALL P
, PA_RESOURCE_ASGN_CURR RAC
, PA_FIN_PLAN_TYPES_B PT
, PA_RESOURCE_ASSIGNMENTS PRA
, PA_PROJ_ELEMENTS PE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_PROJ_ELEM_VER_STRUCTURE PEVS
, PA_RESOURCE_LISTS PRL
, PA_BUDGET_VERSIONS PBV
, PA_FP_TXN_CURRENCIES PFTC
, PA_PROJ_FP_OPTIONS PPFO
, PA_RESOURCE_LIST_MEMBERS PRLM
, PA_LOOKUPS UOM
, PA_SPREAD_CURVES_TL PSC
, CST_COST_TYPES_V CCT
, PA_LOOKUPS ETC
WHERE P.PROJECT_ID = PRA.PROJECT_ID
AND RAC.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND RAC.BUDGET_VERSION_ID = PRA.BUDGET_VERSION_ID
AND RAC.BUDGET_VERSION_ID = PBV.BUDGET_VERSION_ID
AND RAC.TXN_CURRENCY_CODE = PFTC.TXN_CURRENCY_CODE
AND PRA.TASK_ID=PEV.PROJ_ELEMENT_ID (+)
AND PEV.PARENT_STRUCTURE_VERSION_ID(+)=PA_PLANNING_ELEMENT_UTILS.GET_FIN_STRUCT_ID(PRA.PROJECT_ID
, PRA.BUDGET_VERSION_ID)
AND PEV.PROJ_ELEMENT_ID = PE.PROJ_ELEMENT_ID (+)
AND PEV.PARENT_STRUCTURE_VERSION_ID = PEVS.ELEMENT_VERSION_ID (+)
AND PEV.PROJECT_ID = PEVS.PROJECT_ID (+)
AND PRLM.RESOURCE_LIST_MEMBER_ID=PRA.RESOURCE_LIST_MEMBER_ID
AND PPFO.PROJECT_ID = PRA.PROJECT_ID
AND PT.FIN_PLAN_TYPE_ID = PBV.FIN_PLAN_TYPE_ID
AND PPFO.FIN_PLAN_TYPE_ID = PBV.FIN_PLAN_TYPE_ID
AND PPFO.FIN_PLAN_VERSION_ID = PRA.BUDGET_VERSION_ID
AND PPFO.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION'
AND PPFO.PROJ_FP_OPTIONS_ID=PFTC.PROJ_FP_OPTIONS_ID
AND PBV.BUDGET_VERSION_ID = PRA.BUDGET_VERSION_ID
AND PRL.RESOURCE_LIST_ID = PBV.RESOURCE_LIST_ID
AND UOM.LOOKUP_TYPE = 'UNIT'
AND UOM.LOOKUP_CODE = NVL(PRLM.UNIT_OF_MEASURE
, 'HOURS')
AND NVL(PRA.SPREAD_CURVE_ID
, 1)=PSC.SPREAD_CURVE_ID
AND ETC.LOOKUP_TYPE='PA_FP_ETC_METHOD'
AND ETC.LOOKUP_CODE(+)=PRA.ETC_METHOD_CODE
AND CCT.COST_TYPE_ID(+) = PRA.MFC_COST_TYPE_ID
AND PSC.LANGUAGE = USERENV('LANG') UNION ALL SELECT PBV.BUDGET_VERSION_ID
, NULL FIN_PLAN_PREFERENCE_CODE
, NULL PLAN_CLASS_CODE
, P.PROJECT_ID
, P.NAME
, P.SEGMENT1
, NULL RESOURCE_ASSIGNMENT_ID
, NULL TASK_NAME
, NULL TASK_NUMBER
, NULL TASK_DISPLAY_SEQUENCE
, NULL RESOURCE_NAME
, NULL RESOURCE_LIST_MEMBER_ID
, NULL START_DATE
, NULL END_DATE
, NULL CURRENCY
, NULL UOM
, NULL DESCRIPTION
, NULL SPREAD_CURVE_ID
, NULL SPREAD_CURVE
, NULL MFC_COST_TYPE_ID
, NULL MFC_COST_TYPE
, NULL ETC_METHOD_CODE
, NULL ETC_METHOD
, NULL DELETE_FLAG
, NULL QUANTITY
, NULL ACTUAL_QUANTITY
, NULL ETC_QUANTITY
, NULL CURRENT_QUANTITY
, NULL ORIGINAL_QUANTITY
, NULL PRIOR_FORECAST_QUANTITY
, NULL RAW_COST
, NULL ACTUAL_RAW_COST
, NULL ETC_RAW_COST
, NULL CURRENT_RAW_COST
, NULL ORIGINAL_RAW_COST
, NULL PRIOR_FORECAST_RAW_COST
, NULL BURDENED_COST
, NULL ACTUAL_BURDENED_COST
, NULL ETC_BURDENED_COST
, NULL CURRENT_BURDENED_COST
, NULL ORIGINAL_BURDENED_COST
, NULL PRIOR_FORECAST_BURDENED_COST
, NULL REVENUE
, NULL ACTUAL_REVENUE
, NULL ETC_REVENUE
, NULL CURRENT_REVENUE
, NULL ORIGINAL_REVENUE
, NULL PRIOR_FORECAST_REVENUE
, NULL RAW_COST_OVER_RATE
, NULL BURDENED_COST_OVER_RATE
, NULL BILL_OVER_RATE
, NULL RAW_COST_RATE
, NULL BURDENED_COST_RATE
, NULL BILL_RATE
, NULL ETC_RAW_COST_RATE
, NULL ETC_BURDENED_COST_RATE
, NULL ETC_BILL_RATE
, NULL PROJFUNC_COST_RATE_TYPE
, NULL PROJFUNC_COST_RATE_DATE_TYPE
, NULL PROJECT_COST_RATE_TYPE
, NULL PROJECT_COST_RATE_DATE_TYPE
, NULL PROJFUNC_REV_RATE_TYPE
, NULL PROJFUNC_REV_RATE_DATE_TYPE
, NULL PROJECT_REV_RATE_TYPE
, NULL PROJECT_REV_RATE_DATE_TYPE
, NULL PROJFUNC_COST_RATE
, NULL PROJFUNC_COST_RATE_DATE
, NULL PROJECT_COST_RATE
, NULL PROJECT_COST_RATE_DATE
, NULL PROJFUNC_REV_RATE
, NULL PROJFUNC_REV_RATE_DATE
, NULL PROJECT_REV_RATE
, NULL PROJECT_REV_RATE_DATE
, NULL PHYSICAL_PERCENT_COMPLETE
, NULL ETC_SOURCE
, NULL CHANGE_REASON
, PBV.RECORD_VERSION_NUMBER
FROM PA_PROJECTS_ALL P
, PA_BUDGET_VERSIONS PBV
WHERE P.PROJECT_ID = PBV.PROJECT_ID
AND NOT EXISTS (SELECT 1
FROM PA_RESOURCE_ASSIGNMENTS RA
WHERE PBV.BUDGET_VERSION_ID = RA.BUDGET_VERSION_ID)

Columns