VIEW: APPS.CSP_REP_HIER_SECINV_NAV

Source

View Text - Preformatted

SELECT mp.organization_code||'.'||si.secondary_inventory_name , nt.node_type , si.secondary_inventory_id , decode(si.condition_type,'G','ECGRNFLG','B','ECRDFLG','ECGRNFLG') , 'Y' , 'REP_HIERARCHY' , rh.hierarchy_node_id from csp_nav_node_types nt, csp_rep_hierarchies rh, csp_sec_inventories si, mtl_parameters mp where nt.root_key = 'CSP_HIERARCHY' and nt.node_type = 'SEC_INV' and rh.hierarchy_node_id = si.hierarchy_node_id and si.organization_id = mp.organization_id union all select rh.node_name , nt.node_type , rh.hierarchy_node_id , nt.icon_name , 'N' , nt.node_type , rh.parent_node_id from csp_nav_node_types nt, csp_rep_hierarchies rh where nt.root_key = 'CSP_HIERARCHY' and nt.node_type = 'REP_HIERARCHY' and rh.hierarchy_node_id <> rh.top_node_id order by 1

View Text - HTML Formatted

SELECT MP.ORGANIZATION_CODE||'.'||SI.SECONDARY_INVENTORY_NAME
, NT.NODE_TYPE
, SI.SECONDARY_INVENTORY_ID
, DECODE(SI.CONDITION_TYPE
, 'G'
, 'ECGRNFLG'
, 'B'
, 'ECRDFLG'
, 'ECGRNFLG')
, 'Y'
, 'REP_HIERARCHY'
, RH.HIERARCHY_NODE_ID
FROM CSP_NAV_NODE_TYPES NT
, CSP_REP_HIERARCHIES RH
, CSP_SEC_INVENTORIES SI
, MTL_PARAMETERS MP
WHERE NT.ROOT_KEY = 'CSP_HIERARCHY'
AND NT.NODE_TYPE = 'SEC_INV'
AND RH.HIERARCHY_NODE_ID = SI.HIERARCHY_NODE_ID
AND SI.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION ALL SELECT RH.NODE_NAME
, NT.NODE_TYPE
, RH.HIERARCHY_NODE_ID
, NT.ICON_NAME
, 'N'
, NT.NODE_TYPE
, RH.PARENT_NODE_ID
FROM CSP_NAV_NODE_TYPES NT
, CSP_REP_HIERARCHIES RH
WHERE NT.ROOT_KEY = 'CSP_HIERARCHY'
AND NT.NODE_TYPE = 'REP_HIERARCHY'
AND RH.HIERARCHY_NODE_ID <> RH.TOP_NODE_ID ORDER BY 1