View: PA_PROJ_FINPLAN_TYPES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJ_FINPLAN_TYPES_V

View Text

SELECT LK.MEANING AS FIN_PLAN_PREFERENCE
, -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
, -1 AS PROJ_FP_OPTION_ID
FROM PA_BUDGET_TYPES C
, PA_LOOKUPS LK
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 LK.LOOKUP_TYPE = 'BUDGET AMOUNT'
AND LK.LOOKUP_CODE = C.BUDGET_AMOUNT_CODE
AND NOT EXISTS (SELECT 1
FROM PA_FIN_PLAN_TYPES_B A
, PA_PROJ_FP_OPTIONS B
WHERE 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 LK.MEANING AS FIN_PLAN_PREFERENCE
, 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
, PO.PROJ_FP_OPTIONS_ID AS PROJ_FP_OPTION_ID
FROM PA_FIN_PLAN_TYPES_VL PT
, PA_PROJ_FP_OPTIONS PO
, PA_LOOKUPS LK
WHERE 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'
AND LK.LOOKUP_TYPE = 'FIN_PLAN_PREFERENCE'
AND LK.LOOKUP_CODE = PO.FIN_PLAN_PREFERENCE_CODE

Columns