eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: WSH_OE_LINES_V2

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

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
, TO_NUMBER(NULL) DELIVERY_ID
, TO_CHAR(NULL) DELIVERY_NAME
, OE.ORDERED_QUANTITY_UOM2
, OE.SHIPPED_QUANTITY2
, OE.ORDERED_QUANTITY2
FROM OE_ORDER_LINES_ALL OE
, OE_ORDER_HEADERS_ALL OH
WHERE OH.HEADER_ID = OE.HEADER_ID

Columns

Name
ORDER_NUMBER
HEADER_ID
LINE_ID
ORG_ID
LINE_TYPE_ID
LINE_NUMBER
ORDERED_ITEM
REQUEST_DATE
ORDER_QUANTITY_UOM
SHIPPED_QUANTITY
ORDERED_QUANTITY
SHIP_FROM_ORG_ID
SHIP_TO_ORG_ID
INVOICE_TO_ORG_ID
DELIVER_TO_ORG_ID
INTMED_SHIP_TO_ORG_ID
SOLD_FROM_ORG_ID
SOLD_TO_ORG_ID
INVENTORY_ITEM_ID
SHIPMENT_NUMBER
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
OPTION_NUMBER
COMPONENT_NUMBER
ORDERED_ITEM_ID
ITEM_IDENTIFIER_TYPE
SERVICE_NUMBER
DELIVERY_ID
DELIVERY_NAME
ORDERED_QUANTITY_UOM2
SHIPPED_QUANTITY2
ORDERED_QUANTITY2