View: PA_FP_OPTIONS_RESLISTS_V

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

View Text

SELECT DISTINCT FPO.PROJECT_ID
, FPO.FIN_PLAN_TYPE_ID
, FPO.COST_RESOURCE_LIST_ID
, 'COST RESOURCE LIST' RESLISTTYPE
, FPO.FIN_PLAN_START_DATE
, FPO.FIN_PLAN_END_DATE
FROM PA_PROJ_FP_OPTIONS FPO
WHERE FPO.COST_RESOURCE_LIST_ID IS NOT NULL
AND FPO.PROJECT_ID IS NOT NULL
AND FPO.FIN_PLAN_TYPE_ID IS NOT NULL
AND FPO.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE'
AND FPO.FIN_PLAN_PREFERENCE_CODE IN ('COST_ONLY'
, 'COST_AND_REV_SEP') UNION ALL SELECT FPO.PROJECT_ID
, FPO.FIN_PLAN_TYPE_ID
, FPO.REVENUE_RESOURCE_LIST_ID
, 'REVENUE RESOURCE LIST' RESLISTTYPE
, FPO.FIN_PLAN_START_DATE
, FPO.FIN_PLAN_END_DATE
FROM PA_PROJ_FP_OPTIONS FPO
WHERE FPO.REVENUE_RESOURCE_LIST_ID IS NOT NULL
AND FPO.PROJECT_ID IS NOT NULL
AND FPO.FIN_PLAN_TYPE_ID IS NOT NULL
AND FPO.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE'
AND FPO.FIN_PLAN_PREFERENCE_CODE IN ('REVENUE_ONLY'
, 'COST_AND_REV_SEP') UNION ALL SELECT FPO.PROJECT_ID
, FPO.FIN_PLAN_TYPE_ID
, FPO.ALL_RESOURCE_LIST_ID
, 'COST
AND REVENUE RESOURCE LIST' RESLISTTYPE
, FPO.FIN_PLAN_START_DATE
, FPO.FIN_PLAN_END_DATE
FROM PA_PROJ_FP_OPTIONS FPO
WHERE FPO.ALL_RESOURCE_LIST_ID IS NOT NULL
AND FPO.PROJECT_ID IS NOT NULL
AND FPO.FIN_PLAN_TYPE_ID IS NOT NULL
AND FPO.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE'
AND FPO.FIN_PLAN_PREFERENCE_CODE IN ('COST_AND_REV_SAME') ORDER BY 1
, 2

Columns