DBA Data[Home] [Help]

VIEW: APPS.CSP_PLIST_BOXES_NAV

Source

View Text - Preformatted

SELECT pb.box_name , nt.node_type , pb.box_id , nt.icon_name , 'N' , 'PACK_LIST' , pb.packlist_header_id from csp_nav_node_types nt, csp_packlist_boxes pb where nt.root_key = 'CSP_PACKLIST' and nt.node_type = 'PLIST_BOX' order by 1
View Text - HTML Formatted

SELECT PB.BOX_NAME
, NT.NODE_TYPE
, PB.BOX_ID
, NT.ICON_NAME
, 'N'
, 'PACK_LIST'
, PB.PACKLIST_HEADER_ID
FROM CSP_NAV_NODE_TYPES NT
, CSP_PACKLIST_BOXES PB
WHERE NT.ROOT_KEY = 'CSP_PACKLIST'
AND NT.NODE_TYPE = 'PLIST_BOX' ORDER BY 1