View: OE_DELIVERY_LINES_V

Product:	ONT - Order Management
Description:	This view is for interfacing the lines to shipping, for departure planning.
Implementation/DBA Data:	APPS.OE_DELIVERY_LINES_V

View Text

SELECT OOL.HEADER_ID
, OOH.ORDER_NUMBER
, OOH.ORDER_TYPE_ID
, OTT.NAME
, OOL.LINE_ID
, OOL.LINE_NUMBER||'.'||OOL.SHIPMENT_NUMBER||DECODE(OOL.SERVICE_NUMBER
, ''
, DECODE(OOL.COMPONENT_NUMBER
, ''
, DECODE(OOL.OPTION_NUMBER
, ''
, ''
, '.')
, '.')
, '.')||OOL.OPTION_NUMBER||DECODE(OOL.SERVICE_NUMBER
, ''
, DECODE(OOL.COMPONENT_NUMBER
, ''
, ''
, '.')
, '.')||OOL.COMPONENT_NUMBER||DECODE(OOL.SERVICE_NUMBER
, ''
, ''
, '.')||OOL.SERVICE_NUMBER LINE_NUMBER
, OOL.ORG_ID
, OOL.SOLD_TO_ORG_ID
, OOL.INVENTORY_ITEM_ID
, MSI.DESCRIPTION
, OOL.SHIP_FROM_ORG_ID
, OOL.SUBINVENTORY
, OOL.SHIP_TO_ORG_ID
, OOL.DELIVER_TO_ORG_ID
, OOL.SHIP_TO_CONTACT_ID
, OOL.DELIVER_TO_CONTACT_ID
, OOL.INTMED_SHIP_TO_ORG_ID
, OOL.INTMED_SHIP_TO_CONTACT_ID
, OOL.SHIP_TOLERANCE_ABOVE
, OOL.SHIP_TOLERANCE_BELOW
, OOL.ORDERED_QUANTITY
, OOL.SHIPPED_QUANTITY
, OOL.FULFILLED_QUANTITY
, OOL.ORDER_QUANTITY_UOM
, OOL.SHIPPING_QUANTITY_UOM
, OOL.SHIPPING_QUANTITY
, OOL.SCHEDULE_SHIP_DATE
, OOL.SHIPPING_METHOD_CODE
, OOL.FREIGHT_CARRIER_CODE
, OOL.FREIGHT_TERMS_CODE
, OOL.SHIPMENT_PRIORITY_CODE
, OOL.FOB_POINT_CODE
, OOL.ITEM_IDENTIFIER_TYPE
, OOL.ORDERED_ITEM_ID
, OOL.REQUEST_DATE
, OOL.DEP_PLAN_REQUIRED_FLAG
, OOL.CUST_PRODUCTION_SEQ_NUM
, OOL.CUSTOMER_DOCK_CODE
, OOL.SHIPPING_INTERFACED_FLAG
, OOL.SHIP_SET_ID
, OOL.ATO_LINE_ID
, OOL.SHIP_MODEL_COMPLETE_FLAG
, OOL.TOP_MODEL_LINE_ID
, OOL.ITEM_TYPE_CODE
, OOL.CUST_PO_NUMBER
, OOL.ARRIVAL_SET_ID
, OOL.LINE_CATEGORY_CODE
, OOL.SOURCE_TYPE_CODE
, OOL.LINE_TYPE_ID
, OOL.PROJECT_ID
, OOL.TASK_ID
, OOL.SHIPPING_INSTRUCTIONS
, OOL.PACKING_INSTRUCTIONS
, MCI.MASTER_CONTAINER_ITEM_ID
, MCI.DETAIL_CONTAINER_ITEM_ID
, OOL.PREFERRED_GRADE
, OOL.ORDERED_QUANTITY2
, OOL.ORDERED_QUANTITY_UOM2
, OOL.UNIT_LIST_PRICE
, OOH.TRANSACTIONAL_CURR_CODE
, OOL.END_ITEM_UNIT_NUMBER
, OOL.TP_CONTEXT
, OOL.TP_ATTRIBUTE1
, OOL.TP_ATTRIBUTE2
, OOL.TP_ATTRIBUTE3
, OOL.TP_ATTRIBUTE4
, OOL.TP_ATTRIBUTE5
, OOL.TP_ATTRIBUTE6
, OOL.TP_ATTRIBUTE7
, OOL.TP_ATTRIBUTE8
, OOL.TP_ATTRIBUTE9
, OOL.TP_ATTRIBUTE10
, OOL.TP_ATTRIBUTE11
, OOL.TP_ATTRIBUTE12
, OOL.TP_ATTRIBUTE13
, OOL.TP_ATTRIBUTE14
, OOL.TP_ATTRIBUTE15
, OOH.SOLD_TO_CONTACT_ID
, OOL.CUSTOMER_JOB
, OOL.CUSTOMER_PRODUCTION_LINE
, OOL.CUST_MODEL_SERIAL_NUMBER
, OOL.LINE_SET_ID
, OOL.SOURCE_DOCUMENT_TYPE_ID
, OOH.ORDER_DATE_TYPE_CODE
, OOL.SCHEDULE_ARRIVAL_DATE
, OOL.PROMISE_DATE
, OOL.EARLIEST_ACCEPTABLE_DATE
, OOL.LATEST_ACCEPTABLE_DATE
, OOL.EARLIEST_SHIP_DATE
FROM OE_ORDER_LINES_ALL OOL
, OE_TRANSACTION_TYPES_TL OTT
, MTL_SYSTEM_ITEMS MSI
, MTL_CUSTOMER_ITEMS MCI
, OE_ORDER_HEADERS_ALL OOH
WHERE OOL.HEADER_ID = OOH.HEADER_ID
AND OTT.TRANSACTION_TYPE_ID = OOH.ORDER_TYPE_ID AND OTT.LANGUAGE = USERENV('LANG') AND OOL.OPEN_FLAG = 'Y' AND NVL(OOL.SHIPPING_INTERFACED_FLAG
, 'N') = 'N' AND OOL.SHIPPABLE_FLAG = 'Y' AND NVL(OOL.BOOKED_FLAG
, 'N') = 'Y' AND NVL(OOL.CANCELLED_FLAG
, 'N') = 'N' AND NVL(OOL.AUTHORIZED_TO_SHIP_FLAG
, 'Y') = 'Y' AND MSI.ORGANIZATION_ID = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
, OOL.ORG_ID) AND MSI.INVENTORY_ITEM_ID = OOL.INVENTORY_ITEM_ID AND MCI.CUSTOMER_ITEM_ID(+) = OOL.ORDERED_ITEM_ID AND OOL.SOURCE_TYPE_CODE <> 'EXTERNAL' AND OOL.LINE_CATEGORY_CODE = 'ORDER'

Columns