eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_FP_OPTIONS_RESLISTS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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