VIEW: APPS.WSH_PICKING_DETAILS_INTERFACE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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