Subversion Repositories DevTools

Rev

Rev 27 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
27 rsolanki 1 
/* Project List */
2 
SELECT dmp.PROJ_ID,
3 
	   dmp.PROJ_NAME,
4 
	   dmp.RM_PROJECTS_FK,
5 
	   proj.PROJ_NAME AS RM_PROJECT_NAME,
6 
	   dmp.IS_HIDDEN,
7 
	   dmp.IS_DOWNLOAD,
8 
           pbom.BOM_ID,
9 
           bn.BOM_NAME,
10 
           bms.RTAG_ID_FK,
11 
           br.BRANCH_NAME,
12 
           pbom.STATE_ID,
13 
           st.STATE_NAME,
14 
           bms.BOM_VERSION ||'.'|| bms.BOM_LIFECYCLE AS VERSION
15 
  FROM DM_PROJECTS dmp,
16 
  	   PROJECTS proj,
17 
           PRODUCTION_BOM pbom,
18 
           BOMS bms,
19 
           BOM_NAMES bn,
20 
           BRANCHES br,
21 
           STATES st
22 
 WHERE dmp.RM_PROJECTS_FK = proj.PROJ_ID (+)
23 
       AND dmp.PROJ_NAME LIKE ('%PRODUCTION%')
24 
       AND pbom.PROJ_ID = dmp.PROJ_ID
25 
       AND bms.BOM_ID = pbom.BOM_ID
26 
       AND bn.BOM_NAME_ID = bms.BOM_NAME_ID
27 
       AND br.BRANCH_ID = bms.RTAG_ID_FK
28 
       AND st.STATE_ID = pbom.STATE_ID
29 
       AND dmp.PROJ_ID = :PROJ_ID
30 
 ORDER BY UPPER(dmp.PROJ_NAME)
31