DBA Data[Home] [Help]

VIEW: APPS.CSP_PARTS_LOOPS_NAV

Source

View Text - Preformatted

SELECT pl.parts_loop_name , nt.node_type , pl.parts_loop_id , nt.icon_name , 'N' , 'ROOT' , nt.root_key from csp_nav_node_types nt, csp_parts_loops_b pl where nt.root_key = 'CSP_PARTS_LOOPS' and nt.node_type = 'PARTS_LOOPS' order by 1
View Text - HTML Formatted

SELECT PL.PARTS_LOOP_NAME
, NT.NODE_TYPE
, PL.PARTS_LOOP_ID
, NT.ICON_NAME
, 'N'
, 'ROOT'
, NT.ROOT_KEY
FROM CSP_NAV_NODE_TYPES NT
, CSP_PARTS_LOOPS_B PL
WHERE NT.ROOT_KEY = 'CSP_PARTS_LOOPS'
AND NT.NODE_TYPE = 'PARTS_LOOPS' ORDER BY 1