View: CSD_WSH_LINE_STATUS_V

Product:	CSD - Depot Repair
Description:	View for shipping line status on status details tab
Implementation/DBA Data:	APPS.CSD_WSH_LINE_STATUS_V

View Text

SELECT WDD.SOURCE_HEADER_ID SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID SOURCE_LINE_ID
, TO_CHAR(OE.LINE_NUMBER) || '.' || TO_CHAR(OE.SHIPMENT_NUMBER) LINE_NUMBER
, WDD.REQUESTED_QUANTITY
, LK.MEANING ORIGINAL_LINE_STATUS
FROM OE_ORDER_LINES_ALL OE
, WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES WND
, WSH_LOOKUPS LK
WHERE OE.HEADER_ID = WDD.SOURCE_HEADER_ID
AND OE.LINE_ID = WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDD.SOURCE_CODE = 'OE'
AND WND.DELIVERY_ID = WDA.DELIVERY_ID
AND LK.LOOKUP_TYPE = 'PICK_STATUS'
AND LK.LOOKUP_CODE = WDD.RELEASED_STATUS
AND WND.DELIVERY_TYPE = 'STANDARD' ORDER BY OE.LINE_NUMBER
, OE.SHIPMENT_NUMBER

Columns