RCS_PROJ_COST_COLL_STATUS_V

Details

• Schema: FUSION

• Object owner: RCS

• Object type: VIEW

Columns

Name
PROJECT_TYPE_ID PROJECT_ID COST_COLL_EXCLUDED

Query

SQL_Statement
SELECT prj.project_type_id, prj.project_id, decode(exc.project_type_id,null,'N','Y') as cost_coll_excluded FROM PJF_PROJECTS_ALL_B prj,RCS_PROJ_COST_COLL_EXCLUSIONS exc WHERE prj.project_type_id = exc.project_type_id(+)