| 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 |
|