Product: | OE - Order Entry |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSH_PICKING_DETAILS_INTERFACE |
SELECT MTI.PROCESS_FLAG
, MTI.TRANSACTION_HEADER_ID TRANSACTION_ID
, MTI.SOURCE_LINE_ID PICKING_LINE_DETAIL_ID
, MTI.SOURCE_CODE
, MTI.SOURCE_HEADER_ID
, MTI.TRANSACTION_MODE
, MTI.TRANSACTION_TYPE_ID
, MTI.LAST_UPDATE_DATE
, MTI.LAST_UPDATED_BY
, MTI.CREATION_DATE
, MTI.CREATED_BY
, MTI.LAST_UPDATE_LOGIN
, MTI.REQUEST_ID
, MTI.PROGRAM_APPLICATION_ID
, MTI.PROGRAM_ID
, MTI.PROGRAM_UPDATE_DATE
, MTI.ERROR_EXPLANATION
, MTI.ERROR_CODE
, MTI.INVENTORY_ITEM_ID
, MTI.INVENTORY_ITEM
, MTI.ITEM_SEGMENT1
, MTI.ITEM_SEGMENT2
, MTI.ITEM_SEGMENT3
, MTI.ITEM_SEGMENT4
, MTI.ITEM_SEGMENT5
, MTI.ITEM_SEGMENT6
, MTI.ITEM_SEGMENT7
, MTI.ITEM_SEGMENT8
, MTI.ITEM_SEGMENT9
, MTI.ITEM_SEGMENT10
, MTI.ITEM_SEGMENT11
, MTI.ITEM_SEGMENT12
, MTI.ITEM_SEGMENT13
, MTI.ITEM_SEGMENT14
, MTI.ITEM_SEGMENT15
, MTI.ITEM_SEGMENT16
, MTI.ITEM_SEGMENT17
, MTI.ITEM_SEGMENT18
, MTI.ITEM_SEGMENT19
, MTI.ITEM_SEGMENT20
, MTI.ORGANIZATION_ID WAREHOUSE_ID
, MTI.SUBINVENTORY_CODE SUBINVENTORY
, MTI.VENDOR_LOT_NUMBER LOT_NUMBER
, MTI.REVISION
, MTI.LOCATOR_ID
, MTI.LOC_SEGMENT1
, MTI.LOC_SEGMENT2
, MTI.LOC_SEGMENT3
, MTI.LOC_SEGMENT4
, MTI.LOC_SEGMENT5
, MTI.LOC_SEGMENT6
, MTI.LOC_SEGMENT7
, MTI.LOC_SEGMENT8
, MTI.LOC_SEGMENT9
, MTI.LOC_SEGMENT10
, MTI.LOC_SEGMENT11
, MTI.LOC_SEGMENT12
, MTI.LOC_SEGMENT13
, MTI.LOC_SEGMENT14
, MTI.LOC_SEGMENT15
, MTI.LOC_SEGMENT16
, MTI.LOC_SEGMENT17
, MTI.LOC_SEGMENT18
, MTI.LOC_SEGMENT19
, MTI.LOC_SEGMENT20
, MTI.LOCATOR_NAME
, MTI.SHIPMENT_NUMBER SERIAL_NUMBER
, MTI.TRANSACTION_QUANTITY SHIPPED_QUANTITY
, MTI.TRANSACTION_UOM
, MTI.TRANSACTION_DATE
, MTI.TRANSACTION_SOURCE_TYPE_ID CONTAINER_ID
, MTI.TRANSACTION_SEQUENCE_ID CONTAINER_SEQUENCE
, MTI.ATTRIBUTE_CATEGORY
, MTI.ATTRIBUTE1
, MTI.ATTRIBUTE2
, MTI.ATTRIBUTE3
, MTI.ATTRIBUTE4
, MTI.ATTRIBUTE5
, MTI.ATTRIBUTE6
, MTI.ATTRIBUTE7
, MTI.ATTRIBUTE8
, MTI.ATTRIBUTE9
, MTI.ATTRIBUTE10
, MTI.ATTRIBUTE11
, MTI.ATTRIBUTE12
, MTI.ATTRIBUTE13
, MTI.ATTRIBUTE14
, MTI.ATTRIBUTE15
, SH.ORDER_NUMBER ORDER_NUMBER
, SOT.NAME ORDER_TYPE
FROM MTL_TRANSACTIONS_INTERFACE MTI
, SO_PICKING_LINE_DETAILS PLD
, SO_PICKING_LINES_ALL PL
, SO_LINES_ALL SL
, SO_HEADERS_ALL SH
, SO_ORDER_TYPES_ALL SOT
WHERE MTI.PROCESS_FLAG = 9
AND MTI.SOURCE_LINE_ID = PLD.PICKING_LINE_DETAIL_ID
AND PLD.PICKING_LINE_ID = PL.PICKING_LINE_ID
AND PL.ORDER_LINE_ID = SL.LINE_ID
AND SL.HEADER_ID = SH.HEADER_ID
AND SOT.ORDER_TYPE_ID = SH.ORDER_TYPE_ID