Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 1 
/* Get all locations of a pkg_name, within a BOM */
2 
SELECT :PROD_ID ||'_'|| os.os_id ||'_'|| pv.pv_id AS PROD_AT_OS,
3 
	   pkg.pkg_name AS PROD_NAME,
4 
	   pv.PKG_VERSION AS PROD_VERSION,
5 
	   nn.NODE_NAME,
6 
	   os.OS_NAME,
7 
	   os.OS_ID,
8 
	   pv.pv_id AS PROD_ID,
9 
	   DECODE( pv.pv_id,
10 
	   		   :PROD_ID, 0,
11 
			   1 ) AS IS_DIFFERENT,
12 
	   nt.NODE_ICON,
13 
	   osc.PRODUCT_COMMENTS
14 
  FROM BOM_CONTENTS bc,
15 
	   OPERATING_SYSTEMS os,
16 
	   NETWORK_NODES nn,
17 
	   NODE_TYPES nt,
18 
	   OS_CONTENTS osc,
19 
	   PACKAGE_VERSIONS pv,
20 
	   PACKAGES pkg
21 
 WHERE bc.NODE_ID = nn.NODE_ID
22 
   AND os.NODE_ID = nn.NODE_ID
23 
   AND nn.NODE_TYPE_ID = nt.NODE_TYPE_ID
24 
   AND osc.OS_ID = os.OS_ID
25 
   AND osc.PROD_ID = pv.pv_id
26 
   AND pv.pkg_id = pkg.pkg_id
27 
   AND bc.BOM_ID = :BOM_ID
28 
   AND pv.pkg_id IN ( SELECT pv.pkg_id
29 
   	   			 	  FROM PACKAGE_VERSIONS pv
30 
					  WHERE pv.pv_id = :PROD_ID )