VIEW: APPS.WSH_OE_LINES_V1

Source

View Text - Preformatted

SELECT oh.order_number, oe.HEADER_ID, oe.LINE_ID, oe.ORG_ID, oe.LINE_TYPE_ID, oe.LINE_NUMBER, oe.ORDERED_ITEM, oe.REQUEST_DATE, oe.ORDER_QUANTITY_UOM, oe.SHIPPED_QUANTITY, oe.ORDERED_QUANTITY, oe.SHIP_FROM_ORG_ID, oe.SHIP_TO_ORG_ID, oe.INVOICE_TO_ORG_ID, oe.DELIVER_TO_ORG_ID, oe.INTMED_SHIP_TO_ORG_ID, oe.SOLD_FROM_ORG_ID, oe.SOLD_TO_ORG_ID, oe.inventory_item_id, oe.SHIPMENT_NUMBER, oe.CREATION_DATE, oe.CREATED_BY, oe.LAST_UPDATE_DATE, oe.LAST_UPDATED_BY, oe.LAST_UPDATE_LOGIN, oe.OPTION_NUMBER, oe.COMPONENT_NUMBER, oe.ORDERED_ITEM_ID, oe.ITEM_IDENTIFIER_TYPE, oe.SERVICE_NUMBER, wda.DELIVERY_ID, wnd.NAME DELIVERY_NAME, oe.ordered_quantity_uom2, oe.shipped_quantity2, oe.ordered_quantity2 FROM oe_order_lines_all oe, oe_order_headers_all oh, wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd WHERE oe.header_id = wdd.source_header_id AND oe.line_id = wdd.source_line_id AND oh.header_id = oe.header_id AND wdd.delivery_detail_id = wda.delivery_detail_id AND wdd.source_code = 'OE' AND wda.delivery_id IS NOT NULL AND wnd.delivery_id = wda.delivery_id AND wnd.delivery_type = 'STANDARD' GROUP BY oh.order_number, oe.HEADER_ID, oe.LINE_ID, oe.ORG_ID, oe.LINE_TYPE_ID, oe.LINE_NUMBER, oe.ORDERED_ITEM, oe.REQUEST_DATE, oe.ORDER_QUANTITY_UOM, oe.SHIPPED_QUANTITY, oe.ORDERED_QUANTITY, oe.SHIP_FROM_ORG_ID, oe.SHIP_TO_ORG_ID, oe.INVOICE_TO_ORG_ID, oe.DELIVER_TO_ORG_ID, oe.INTMED_SHIP_TO_ORG_ID, oe.SOLD_FROM_ORG_ID, oe.SOLD_TO_ORG_ID, oe.inventory_item_id, oe.SHIPMENT_NUMBER, oe.CREATION_DATE, oe.CREATED_BY, oe.LAST_UPDATE_DATE, oe.LAST_UPDATED_BY, oe.LAST_UPDATE_LOGIN, oe.OPTION_NUMBER, oe.COMPONENT_NUMBER, oe.ORDERED_ITEM_ID, oe.ITEM_IDENTIFIER_TYPE, oe.SERVICE_NUMBER, wda.DELIVERY_ID, wnd.NAME, oe.ordered_quantity_uom2, oe.shipped_quantity2, oe.ordered_quantity2

View Text - HTML Formatted

SELECT OH.ORDER_NUMBER
, OE.HEADER_ID
, OE.LINE_ID
, OE.ORG_ID
, OE.LINE_TYPE_ID
, OE.LINE_NUMBER
, OE.ORDERED_ITEM
, OE.REQUEST_DATE
, OE.ORDER_QUANTITY_UOM
, OE.SHIPPED_QUANTITY
, OE.ORDERED_QUANTITY
, OE.SHIP_FROM_ORG_ID
, OE.SHIP_TO_ORG_ID
, OE.INVOICE_TO_ORG_ID
, OE.DELIVER_TO_ORG_ID
, OE.INTMED_SHIP_TO_ORG_ID
, OE.SOLD_FROM_ORG_ID
, OE.SOLD_TO_ORG_ID
, OE.INVENTORY_ITEM_ID
, OE.SHIPMENT_NUMBER
, OE.CREATION_DATE
, OE.CREATED_BY
, OE.LAST_UPDATE_DATE
, OE.LAST_UPDATED_BY
, OE.LAST_UPDATE_LOGIN
, OE.OPTION_NUMBER
, OE.COMPONENT_NUMBER
, OE.ORDERED_ITEM_ID
, OE.ITEM_IDENTIFIER_TYPE
, OE.SERVICE_NUMBER
, WDA.DELIVERY_ID
, WND.NAME DELIVERY_NAME
, OE.ORDERED_QUANTITY_UOM2
, OE.SHIPPED_QUANTITY2
, OE.ORDERED_QUANTITY2
FROM OE_ORDER_LINES_ALL OE
, OE_ORDER_HEADERS_ALL OH
, WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES WND
WHERE OE.HEADER_ID = WDD.SOURCE_HEADER_ID
AND OE.LINE_ID = WDD.SOURCE_LINE_ID
AND OH.HEADER_ID = OE.HEADER_ID
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDD.SOURCE_CODE = 'OE'
AND WDA.DELIVERY_ID IS NOT NULL
AND WND.DELIVERY_ID = WDA.DELIVERY_ID
AND WND.DELIVERY_TYPE = 'STANDARD' GROUP BY OH.ORDER_NUMBER
, OE.HEADER_ID
, OE.LINE_ID
, OE.ORG_ID
, OE.LINE_TYPE_ID
, OE.LINE_NUMBER
, OE.ORDERED_ITEM
, OE.REQUEST_DATE
, OE.ORDER_QUANTITY_UOM
, OE.SHIPPED_QUANTITY
, OE.ORDERED_QUANTITY
, OE.SHIP_FROM_ORG_ID
, OE.SHIP_TO_ORG_ID
, OE.INVOICE_TO_ORG_ID
, OE.DELIVER_TO_ORG_ID
, OE.INTMED_SHIP_TO_ORG_ID
, OE.SOLD_FROM_ORG_ID
, OE.SOLD_TO_ORG_ID
, OE.INVENTORY_ITEM_ID
, OE.SHIPMENT_NUMBER
, OE.CREATION_DATE
, OE.CREATED_BY
, OE.LAST_UPDATE_DATE
, OE.LAST_UPDATED_BY
, OE.LAST_UPDATE_LOGIN
, OE.OPTION_NUMBER
, OE.COMPONENT_NUMBER
, OE.ORDERED_ITEM_ID
, OE.ITEM_IDENTIFIER_TYPE
, OE.SERVICE_NUMBER
, WDA.DELIVERY_ID
, WND.NAME
, OE.ORDERED_QUANTITY_UOM2
, OE.SHIPPED_QUANTITY2
, OE.ORDERED_QUANTITY2