VIEW: APPS.AHL_OSP_SHIPMENT_LINES_V

Source

View Text - Preformatted

SELECT SHIPMENTLINEEO.LINE_ID, SHIPMENTLINEEO.CREATION_DATE, SHIPMENTLINEEO.CREATED_BY, SHIPMENTLINEEO.LAST_UPDATE_DATE, SHIPMENTLINEEO.LAST_UPDATED_BY, SHIPMENTLINEEO.LAST_UPDATE_LOGIN, SHIPMENTLINEEO.ORG_ID, SHIPMENTLINEEO.HEADER_ID, SHIPMENTLINEEO.LINE_NUMBER, SHIPMENTLINEEO.LINE_TYPE_ID, SHIPMENTLINEEO.INVENTORY_ITEM_ID, SHIPMENTLINEEO.ORDERED_QUANTITY, SHIPMENTLINEEO.ORDER_QUANTITY_UOM, SHIPMENTLINEEO.SCHEDULE_SHIP_DATE, SHIPMENTLINEEO.PROJECT_ID, SHIPMENTLINEEO.TASK_ID, SHIPMENTLINEEO.SHIP_FROM_ORG_ID, SHIPMENTLINEEO.SHIP_TO_ORG_ID, SHIPMENTLINEEO.SUBINVENTORY, SHIPMENTLINEEO.SHIPMENT_PRIORITY_CODE, SHIPMENTLINEEO.SHIPPING_METHOD_CODE, SHIPMENTLINEEO.FOB_POINT_CODE, SHIPMENTLINEEO.FREIGHT_TERMS_CODE, SHIPMENTLINEEO.FREIGHT_CARRIER_CODE, SHIPMENTLINEEO.RETURN_REASON_CODE, SHIPMENTLINEEO.PACKING_INSTRUCTIONS, SHIPMENTLINEEO.SOURCE_DOCUMENT_ID, SHIPMENTLINEEO.SOURCE_DOCUMENT_LINE_ID, OSPL.OSP_LINE_NUMBER, SHIPMENTLINEEO.SOURCE_DOCUMENT_TYPE_ID, MTLI.CONCATENATED_SEGMENTS PART_NUMBER, MTLI.DESCRIPTION ITEM_DESC, AHL_OSP_UTIL_PKG.GET_SHIP_LINE_SERIAL_NUMBER(shipmentlineeo.line_id, shipmentlineeo.source_document_line_id), AHL_OSP_UTIL_PKG.GET_SHIP_LINE_LOT_NUMBER(shipmentlineeo.line_id, shipmentlineeo.source_document_line_id), DECODE(shipmentlineEO.source_document_line_id, NULL, 'N', 'Y') FROM OE_ORDER_LINES_ALL SHIPMENTLINEEO, AHL_OSP_ORDER_LINES OSPL, MTL_SYSTEM_ITEMS_KFV MTLI, ahl_osp_orders_b oso WHERE SHIPMENTLINEEO.SOURCE_DOCUMENT_LINE_ID = OSPL.OSP_ORDER_LINE_ID (+) AND SHIPMENTLINEEO.SOURCE_DOCUMENT_ID = OSPL.OSP_ORDER_ID (+) AND SHIPMENTLINEEO.SOURCE_DOCUMENT_TYPE_ID = 21 AND SHIPMENTLINEEO.SHIP_FROM_ORG_ID = MTLI.ORGANIZATION_ID AND SHIPMENTLINEEO.INVENTORY_ITEM_ID = MTLI.INVENTORY_ITEM_ID and ospl.osp_order_id = oso.osp_order_id (+)

View Text - HTML Formatted

SELECT SHIPMENTLINEEO.LINE_ID
, SHIPMENTLINEEO.CREATION_DATE
, SHIPMENTLINEEO.CREATED_BY
, SHIPMENTLINEEO.LAST_UPDATE_DATE
, SHIPMENTLINEEO.LAST_UPDATED_BY
, SHIPMENTLINEEO.LAST_UPDATE_LOGIN
, SHIPMENTLINEEO.ORG_ID
, SHIPMENTLINEEO.HEADER_ID
, SHIPMENTLINEEO.LINE_NUMBER
, SHIPMENTLINEEO.LINE_TYPE_ID
, SHIPMENTLINEEO.INVENTORY_ITEM_ID
, SHIPMENTLINEEO.ORDERED_QUANTITY
, SHIPMENTLINEEO.ORDER_QUANTITY_UOM
, SHIPMENTLINEEO.SCHEDULE_SHIP_DATE
, SHIPMENTLINEEO.PROJECT_ID
, SHIPMENTLINEEO.TASK_ID
, SHIPMENTLINEEO.SHIP_FROM_ORG_ID
, SHIPMENTLINEEO.SHIP_TO_ORG_ID
, SHIPMENTLINEEO.SUBINVENTORY
, SHIPMENTLINEEO.SHIPMENT_PRIORITY_CODE
, SHIPMENTLINEEO.SHIPPING_METHOD_CODE
, SHIPMENTLINEEO.FOB_POINT_CODE
, SHIPMENTLINEEO.FREIGHT_TERMS_CODE
, SHIPMENTLINEEO.FREIGHT_CARRIER_CODE
, SHIPMENTLINEEO.RETURN_REASON_CODE
, SHIPMENTLINEEO.PACKING_INSTRUCTIONS
, SHIPMENTLINEEO.SOURCE_DOCUMENT_ID
, SHIPMENTLINEEO.SOURCE_DOCUMENT_LINE_ID
, OSPL.OSP_LINE_NUMBER
, SHIPMENTLINEEO.SOURCE_DOCUMENT_TYPE_ID
, MTLI.CONCATENATED_SEGMENTS PART_NUMBER
, MTLI.DESCRIPTION ITEM_DESC
, AHL_OSP_UTIL_PKG.GET_SHIP_LINE_SERIAL_NUMBER(SHIPMENTLINEEO.LINE_ID
, SHIPMENTLINEEO.SOURCE_DOCUMENT_LINE_ID)
, AHL_OSP_UTIL_PKG.GET_SHIP_LINE_LOT_NUMBER(SHIPMENTLINEEO.LINE_ID
, SHIPMENTLINEEO.SOURCE_DOCUMENT_LINE_ID)
, DECODE(SHIPMENTLINEEO.SOURCE_DOCUMENT_LINE_ID
, NULL
, 'N'
, 'Y')
FROM OE_ORDER_LINES_ALL SHIPMENTLINEEO
, AHL_OSP_ORDER_LINES OSPL
, MTL_SYSTEM_ITEMS_KFV MTLI
, AHL_OSP_ORDERS_B OSO
WHERE SHIPMENTLINEEO.SOURCE_DOCUMENT_LINE_ID = OSPL.OSP_ORDER_LINE_ID (+)
AND SHIPMENTLINEEO.SOURCE_DOCUMENT_ID = OSPL.OSP_ORDER_ID (+)
AND SHIPMENTLINEEO.SOURCE_DOCUMENT_TYPE_ID = 21
AND SHIPMENTLINEEO.SHIP_FROM_ORG_ID = MTLI.ORGANIZATION_ID
AND SHIPMENTLINEEO.INVENTORY_ITEM_ID = MTLI.INVENTORY_ITEM_ID
AND OSPL.OSP_ORDER_ID = OSO.OSP_ORDER_ID (+)