wsh_delivery_details.released_status

SELECT lookup_type,
       lookup_code,
       meaning,
       description,
       decode(view_application_id,
              660,
              'ONT',
              665,
              'WSH',
              201,
              'PO',
              401,
              'INV',
              200,
              'AP',
              222,
              'AR',
              101,
              'GL',
              661,
              'QP',
              0,
              'FND',
              702,
              'BOM',
              140,
              'OFA',
              700,
              'MFG') || '.' || view_application_id application
  FROM apps.fnd_lookup_values lv
 WHERE LANGUAGE = userenv('LANG')
   AND view_application_id = 665
   AND security_group_id = 0
   AND lookup_type = 'PICK_STATUS'
 ORDER BY 1, 5

1	PICK_STATUS	B	Backordered	Line failed to be allocated in Inventory	WSH.665
2	PICK_STATUS	C	Shipped	Line has been shipped	WSH.665
3	PICK_STATUS	D	Cancelled	Line is Cancelled	WSH.665
4	PICK_STATUS	I	Interfaced	Line has been shipped and interfaced to Order Management and Inventory	WSH.665
5	PICK_STATUS	L	Closed	Line has been Received	WSH.665
6	PICK_STATUS	N	Not Ready to Release	Line is not ready to be released	WSH.665
7	PICK_STATUS	P	Purged	Line has been purged from source system	WSH.665
8	PICK_STATUS	R	Ready to Release	Line is ready to be released	WSH.665
9	PICK_STATUS	S	Released to Warehouse	Line has been released to Inventory for processing	WSH.665
10	PICK_STATUS	X	Not Applicable	Line is not applicable for Pick Release	WSH.665