View: PA_FINPLAN_TYPES_V

Product:	PA - Projects
Description:	This view displays all the valid budget types and plan types which are used for different business purposes of a project.
Implementation/DBA Data:	APPS.PA_FINPLAN_TYPES_V

View Text

SELECT -1 AS FIN_PLAN_TYPE_ID
, C.BUDGET_TYPE AS NAME
, C.DESCRIPTION AS DESCRIPTION
, C.PREDEFINED_FLAG AS PRE_DEFINED_FLAG
, C.ENABLE_WF_FLAG AS ENABLE_WF_FLAG
, NULL AS PLAN_CLASS_CODE
, NULL AS MIGRATED_FRM_BDGT_TYP_CODE
, NULL AS APPROVED_COST_PLAN_TYPE_FLAG
, NULL AS APPROVED_REV_PLAN_TYPE_FLAG
, 'BUDGET_TYPE' AS FP_TYPE_CODE
, C.BUDGET_TYPE_CODE AS BUDGET_TYPE_CODE
, C.BUDGET_AMOUNT_CODE AS BUDGET_AMOUNT_CODE
, NULL AS PRIMARY_COST_FORECAST_FLAG
, NULL AS PRIMARY_REV_FORECAST_FLAG
, NULL AS USE_FOR_WORKPLAN_FLAG
FROM PA_BUDGET_TYPES C
WHERE C.BUDGET_TYPE_CODE <> 'FORECASTING_BUDGET_TYPE'
AND TRUNC(SYSDATE) BETWEEN C.START_DATE_ACTIVE
AND NVL(C.END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NOT EXISTS (SELECT 1
FROM PA_FIN_PLAN_TYPES_B A
, PA_PROJ_FP_OPTIONS B
WHERE B.PROJECT_ID = PA_BUDGET_PUB.GET_PROJECT_ID
AND B.FIN_PLAN_OPTION_LEVEL_CODE='PLAN_TYPE'
AND A.FIN_PLAN_TYPE_ID = B.FIN_PLAN_TYPE_ID
AND A.MIGRATED_FRM_BDGT_TYP_CODE = C.BUDGET_TYPE_CODE ) UNION SELECT PT.FIN_PLAN_TYPE_ID AS FIN_PLAN_TYPE_ID
, PT.NAME AS NAME
, PT.DESCRIPTION AS DESCRIPTION
, PT.PRE_DEFINED_FLAG AS PRE_DEFINED_FLAG
, PT.ENABLE_WF_FLAG AS ENABLE_WF_FLAG
, PT.PLAN_CLASS_CODE AS PLAN_CLASS_CODE
, PT.MIGRATED_FRM_BDGT_TYP_CODE AS MIGRATED_FRM_BDGT_TYP_CODE
, PT.APPROVED_COST_PLAN_TYPE_FLAG AS APPROVED_COST_PLAN_TYPE_FLAG
, PT.APPROVED_REV_PLAN_TYPE_FLAG AS APPROVED_REV_PLAN_TYPE_FLAG
, 'PLAN_TYPE' AS FP_TYPE_CODE
, NULL AS BUDGET_TYPE_CODE
, PO.FIN_PLAN_PREFERENCE_CODE AS BUDGET_AMOUNT_CODE
, PT.PRIMARY_COST_FORECAST_FLAG AS PRIMARY_COST_FORECAST_FLAG
, PT.PRIMARY_REV_FORECAST_FLAG AS PRIMARY_REV_FORECAST_FLAG
, PT.USE_FOR_WORKPLAN_FLAG AS USE_FOR_WORKPLAN_FLAG
FROM PA_FIN_PLAN_TYPES_VL PT
, PA_PROJ_FP_OPTIONS PO
WHERE PO.PROJECT_ID = PA_BUDGET_PUB.GET_PROJECT_ID
AND PO.FIN_PLAN_OPTION_LEVEL_CODE='PLAN_TYPE'
AND PT.FIN_PLAN_TYPE_ID = PO.FIN_PLAN_TYPE_ID
AND TRUNC(SYSDATE) BETWEEN PT.START_DATE_ACTIVE
AND NVL(PT.END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(PT.FIN_PLAN_TYPE_CODE
, '-99 ') <> 'ORG_FORECAST'

Columns