SELECT prj.PROJ_NAME, nn.NODE_NAME, nn.NODE_VERSION, 
br.BRANCH_NAME, br.BRANCH_ID, b.BOM_ID, bc.NODE_ID,
os.OS_ID, osc.PROD_ID, pv.PV_ID, p.PKG_NAME, pv.PKG_VERSION
FROM NETWORK_NODES nn, PROJECTS prj, BRANCHES br, 
BOMS b, BOM_CONTENTS bc, OPERATING_SYSTEMS os,
OS_CONTENTS osc, PACKAGE_VERSIONS pv, PACKAGES p
WHERE nn.NODE_NAME = :NODE_NAME
AND prj.PROJ_NAME = :PROJ_NAME
AND prj.PROJ_ID = br.PROJ_ID
AND br.BRANCH_NAME = :BRANCH_NAME
AND b.BOM_VERSION = :BOM_VERSION
AND b.BOM_LIFECYCLE = :BOM_LIFECYCLE
AND bc.BOM_ID = b.BOM_ID
AND nn.NODE_ID = bc.NODE_ID
AND os.OS_NAME = :OS_NAME
AND os.NODE_ID = nn.NODE_ID
AND os.OS_ID = osc.OS_ID
AND pv.PV_ID = osc.PROD_ID
AND pv.IS_PATCH = 'Y'
AND p.PKG_ID = pv.PKG_ID
ORDER BY osc.SEQ_NUM