VIEW: APPS.WSH_OE_LINES_V2

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

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