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