VIEW: APPS.CSP_PACK_LIST_NAV

Source

View Text - Preformatted

SELECT ph.packlist_number , nt.node_type , ph.packlist_header_id , nt.icon_name , 'N' , 'PLIST_STATUS' , ph.packlist_status from csp_nav_node_types nt, csp_packlist_headers ph where nt.root_key = 'CSP_PACKLIST' and nt.node_type = 'PACK_LIST' and ph.organization_id = csp_pick_utils.csp_global_org_id order by 1 DESC

View Text - HTML Formatted

SELECT PH.PACKLIST_NUMBER
, NT.NODE_TYPE
, PH.PACKLIST_HEADER_ID
, NT.ICON_NAME
, 'N'
, 'PLIST_STATUS'
, PH.PACKLIST_STATUS
FROM CSP_NAV_NODE_TYPES NT
, CSP_PACKLIST_HEADERS PH
WHERE NT.ROOT_KEY = 'CSP_PACKLIST'
AND NT.NODE_TYPE = 'PACK_LIST'
AND PH.ORGANIZATION_ID = CSP_PICK_UTILS.CSP_GLOBAL_ORG_ID ORDER BY 1 DESC