VIEW: APPS.CSD_WSH_LINE_STATUS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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