View: WMS_STRATEGY_MAT_TXN_TMP_V

Product:	WMS - Warehouse Management
Description:	WMS strategy search input base view
Implementation/DBA Data:	APPS.WMS_STRATEGY_MAT_TXN_TMP_V

View Text

SELECT 2
, MTRL.LINE_ID
, MTRL.HEADER_ID
, MTRL.LINE_NUMBER
, MTRL.INVENTORY_ITEM_ID
, MTRL.REVISION
, MTRL.ORGANIZATION_ID
, MTRL.FROM_SUBINVENTORY_CODE
, MTRL.FROM_LOCATOR_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 3
, TO_ORGANIZATION_ID
, ORGANIZATION_ID)
, MTRL.TO_SUBINVENTORY_CODE
, MTRL.TO_LOCATOR_ID
, MTRL.TO_ACCOUNT_ID
, MTRL.LOT_NUMBER
, MTRL.UOM_CODE
, MTRL.QUANTITY-NVL(MTRL.QUANTITY_DETAILED
, 0)
, MTRL.DATE_REQUIRED
, MTRL.REASON_ID
, MTRL.REFERENCE
, MTRL.REFERENCE_TYPE_CODE
, MTRL.REFERENCE_ID
, MTRL.PROJECT_ID
, MTRL.TASK_ID
, MTRL.TRANSACTION_HEADER_ID
, MTRL.LINE_STATUS
, MTRL.STATUS_DATE
, MTRL.LAST_UPDATED_BY
, MTRL.LAST_UPDATE_LOGIN
, MTRL.LAST_UPDATE_DATE
, MTRL.CREATED_BY
, MTRL.CREATION_DATE
, MTRL.REQUEST_ID
, MTRL.PROGRAM_APPLICATION_ID
, MTRL.PROGRAM_ID
, MTRL.PROGRAM_UPDATE_DATE
, MTRL.ATTRIBUTE1
, MTRL.ATTRIBUTE2
, MTRL.ATTRIBUTE3
, MTRL.ATTRIBUTE4
, MTRL.ATTRIBUTE5
, MTRL.ATTRIBUTE6
, MTRL.ATTRIBUTE7
, MTRL.ATTRIBUTE8
, MTRL.ATTRIBUTE9
, MTRL.ATTRIBUTE10
, MTRL.ATTRIBUTE11
, MTRL.ATTRIBUTE12
, MTRL.ATTRIBUTE13
, MTRL.ATTRIBUTE14
, MTRL.ATTRIBUTE15
, MTRL.ATTRIBUTE_CATEGORY
, MTRL.PRIMARY_QUANTITY
, MTRL.TRANSACTION_TYPE_ID
, MTRL.TRANSACTION_SOURCE_TYPE_ID
, MTT.TRANSACTION_ACTION_ID
, WTCT.TXN_SOURCE_ID
, WTCT.TXN_SOURCE_LINE_ID
, WTCT.TXN_SOURCE_NAME
, WTCT.TXN_SOURCE_LINE_DETAIL
, WTCT.FREIGHT_CARRIER_CODE
, WTCT.CUSTOMER_ID
FROM MTL_TXN_REQUEST_LINES MTRL
, MTL_TRANSACTION_TYPES MTT
, WMS_TXN_CONTEXT_TEMP WTCT
WHERE MTRL.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
AND MTT.TRANSACTION_ACTION_ID IN (1
, 2
, 3
, 21
, 28
, 34)
AND MTRL.LINE_ID = WTCT.LINE_ID UNION ALL SELECT 1
, MTRL.LINE_ID
, MTRL.HEADER_ID
, MTRL.LINE_NUMBER
, MTRL.INVENTORY_ITEM_ID
, MTRL.REVISION
, DECODE(MTT.TRANSACTION_ACTION_ID
, 3
, MTRL.TO_ORGANIZATION_ID
, MTRL.ORGANIZATION_ID)
, MTRL.FROM_SUBINVENTORY_CODE
, MTRL.FROM_LOCATOR_ID
, MTRL.ORGANIZATION_ID
, MTRL.TO_SUBINVENTORY_CODE
, MTRL.TO_LOCATOR_ID
, MTRL.TO_ACCOUNT_ID
, MTRL.LOT_NUMBER
, MTRL.UOM_CODE
, MTRL.QUANTITY-NVL(MTRL.QUANTITY_DETAILED
, 0)
, MTRL.DATE_REQUIRED
, MTRL.REASON_ID
, MTRL.REFERENCE
, MTRL.REFERENCE_TYPE_CODE
, MTRL.REFERENCE_ID
, MTRL.PROJECT_ID
, MTRL.TASK_ID
, MTRL.TRANSACTION_HEADER_ID
, MTRL.LINE_STATUS
, MTRL.STATUS_DATE
, MTRL.LAST_UPDATED_BY
, MTRL.LAST_UPDATE_LOGIN
, MTRL.LAST_UPDATE_DATE
, MTRL.CREATED_BY
, MTRL.CREATION_DATE
, MTRL.REQUEST_ID
, MTRL.PROGRAM_APPLICATION_ID
, MTRL.PROGRAM_ID
, MTRL.PROGRAM_UPDATE_DATE
, MTRL.ATTRIBUTE1
, MTRL.ATTRIBUTE2
, MTRL.ATTRIBUTE3
, MTRL.ATTRIBUTE4
, MTRL.ATTRIBUTE5
, MTRL.ATTRIBUTE6
, MTRL.ATTRIBUTE7
, MTRL.ATTRIBUTE8
, MTRL.ATTRIBUTE9
, MTRL.ATTRIBUTE10
, MTRL.ATTRIBUTE11
, MTRL.ATTRIBUTE12
, MTRL.ATTRIBUTE13
, MTRL.ATTRIBUTE14
, MTRL.ATTRIBUTE15
, MTRL.ATTRIBUTE_CATEGORY
, MTRL.PRIMARY_QUANTITY
, MTRL.TRANSACTION_TYPE_ID
, MTRL.TRANSACTION_SOURCE_TYPE_ID
, MTT.TRANSACTION_ACTION_ID
, WTCT.TXN_SOURCE_ID
, WTCT.TXN_SOURCE_LINE_ID
, WTCT.TXN_SOURCE_NAME
, WTCT.TXN_SOURCE_LINE_DETAIL
, WTCT.FREIGHT_CARRIER_CODE
, WTCT.CUSTOMER_ID
FROM MTL_TXN_REQUEST_LINES MTRL
, MTL_TRANSACTION_TYPES MTT
, WMS_TXN_CONTEXT_TEMP WTCT
WHERE MTRL.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
AND MTT.TRANSACTION_ACTION_ID IN (2
, 3
, 12
, 27
, 28
, 31
, 33)
AND MTRL.LINE_ID = WTCT.LINE_ID

Columns