PJS_PROG_PROJECTS_RF_V

Details

• Schema: FUSION

• Object owner: PJS

• Object type: VIEW

Columns

Name
TREE_STRUCTURE_ID ANCESTOR_ID PROJECT_ID ANCESTOR_LEVEL PROJECT_LEVEL PROJECT_PROGRAM_ID

Query

SQL_Statement

select prog_rf.TREE_STRUCTURE_ID , prog_rf.ANCESTOR_PROGRAM_ID ANCESTOR_ID , rel.project_id PROJECT_ID , prog_rf.ANCESTOR_PROGRAM_LEVEL ANCESTOR_LEVEL , prog_rf.PROGRAM_LEVEL+1 PROJECT_LEVEL , rel.program_id PROJECT_PROGRAM_ID from PJS_PROGRAM_DEFN_RF prog_rf , PJS_PROG_PROJ_RELATIONSHIPS rel where prog_rf.TREE_STRUCTURE_ID = rel.TREE_STRUCTURE_ID and prog_rf.PROGRAM_ID = rel.PROGRAM_ID union all select rel.TREE_STRUCTURE_ID , rel.project_id ANCESTOR_ID , rel.project_id PROJECT_ID , prog.PROGRAM_LEVEL+1 ANCESTOR_LEVEL , prog.PROGRAM_LEVEL+1 PROJECT_LEVEL , rel.program_id PROJECT_PROGRAM_ID from PJS_PROGRAM_DEFN_B prog , PJS_PROG_PROJ_RELATIONSHIPS rel where rel.TREE_STRUCTURE_ID = prog.TREE_STRUCTURE_ID and prog.program_id = rel.program_id