View: WSH_OE_LINES_V1

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_OE_LINES_V1

View Text

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 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 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

Columns