Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
13 rsolanki 1 
/* Crumbs */
2 
SELECT qry.*
3 
  FROM (
4 
 
5 
		/* LEVEL 1 */
6 
		SELECT 1 AS CRUMB_LEVEL,
7 
			   'Default.asp?' || 'proj_id=' || :PROJ_ID AS CRUMB_LINK,
8 
			   proj.proj_name AS CRUMB_NAME
9 
		  FROM DM_PROJECTS proj
10 
		 WHERE proj.proj_id = :PROJ_ID
11 
 
12 
 
13 
		UNION
14 
 
15 
		/* LEVEL 2 */
16 
		SELECT 2 AS CRUMB_LEVEL,
17 
			   'BomStates.asp?' || 'proj_id=' || :PROJ_ID || '&branch_id=' || :BRANCH_ID AS CRUMB_LINK,
18 
			   br.branch_name AS CRUMB_NAME
19 
		  FROM BRANCHES br
20 
		 WHERE br.branch_id = :BRANCH_ID
21 
 
22 
 
23 
		UNION
24 
 
25 
		/* LEVEL 3 */
26 
		SELECT 3 AS CRUMB_LEVEL,
27 
			   'BomDefault.asp?' || 'bom_id=' || :BOM_ID AS CRUMB_LINK,
28 
			   bn.BOM_NAME ||' '|| bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS CRUMB_NAME
29 
		  FROM BOMS bo,
30 
			   BOM_NAMES bn
31 
		 WHERE bo.BOM_NAME_ID = bn.bom_name_id
32 
		   AND bo.bom_id = :BOM_ID
33 
 
34 
 
35 
        UNION
36 
 
37 
		/* LEVEL 4 */
38 
		SELECT 4 AS CRUMB_LEVEL,
39 
			   'NodeDefault.asp?' || 'bom_id=' || :BOM_ID || '&node_id=' || :NODE_ID AS CRUMB_LINK,
40 
			   nn.NODE_NAME AS CRUMB_NAME
41 
		  FROM NETWORK_NODES nn
42 
		 WHERE nn.NODE_ID = :NODE_ID
43 
 
44 
 
45 
        UNION
46 
 
47 
		/* LEVEL 5 */
48 
		SELECT 5 AS CRUMB_LEVEL,
49 
			   'OsDefault.asp?' || 'bom_id=' || :BOM_ID || '&os_id=' || :OS_ID AS CRUMB_LINK,
50 
			   os.OS_NAME AS CRUMB_NAME
51 
		  FROM OPERATING_SYSTEMS os
52 
		 WHERE os.OS_ID = :OS_ID
53 
 
54 
 
55 
        UNION
56 
 
57 
		/* LEVEL 6 */
58 
		SELECT 6 AS CRUMB_LEVEL,
59 
			   'ProdDefault.asp?' || 'bom_id=' || :BOM_ID || '&os_id=' || :OS_ID || '&prod_id=' || :PROD_ID AS CRUMB_LINK,
60 
			   pkg.PKG_NAME ||' '|| pv.PKG_VERSION AS CRUMB_NAME
61 
		  FROM PACKAGES pkg,
62 
          	   PACKAGE_VERSIONS pv
63 
		 WHERE pv.PKG_ID = pkg.PKG_ID
64 
           AND pv.PV_ID = :PROD_ID
65 
 
66 
       ) qry
67 
 ORDER BY qry.CRUMB_LEVEL
68