View: WMS_TRX_DETAILS_TMP_V

Product:	WMS - Warehouse Management
Description:	WMS rules execution input baes view
Implementation/DBA Data:	APPS.WMS_TRX_DETAILS_TMP_V

View Text

SELECT WTT.PP_TRANSACTION_TEMP_ID
, WTT.TYPE_CODE
, WTT.LINE_TYPE_CODE
, MTRL.LINE_ID
, WTT.FROM_ORGANIZATION_ID
, WTT.FROM_SUBINVENTORY_CODE
, WTT.FROM_LOCATOR_ID
, MTRL.INVENTORY_ITEM_ID
, WTT.REVISION
, WTT.TRANSACTION_QUANTITY
, WTT.PRIMARY_QUANTITY
, WTT.TO_ORGANIZATION_ID
, WTT.TO_SUBINVENTORY_CODE
, WTT.TO_LOCATOR_ID
, MTRL.HEADER_ID
, MTRL.LINE_NUMBER
, MTRL.TO_ACCOUNT_ID
, WTT.LOT_NUMBER
, WTT.LOT_EXPIRATION_DATE
, WTT.SERIAL_NUMBER
, MTRL.UOM_CODE
, 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
, WTCT.TXN_SOURCE_ID
, WTCT.TXN_SOURCE_LINE_ID
, WTCT.TXN_SOURCE_LINE_DETAIL
, WTCT.TXN_SOURCE_NAME
, WTCT.FREIGHT_CARRIER_CODE
, WTCT.CUSTOMER_ID
, MTRL.TRANSACTION_TYPE_ID
, MTRL.TRANSACTION_SOURCE_TYPE_ID
, MTT.TRANSACTION_ACTION_ID
, MTRL.INSPECTION_STATUS
, WTT.LPN_ID
, WTT.SECONDARY_QUANTITY
FROM MTL_TXN_REQUEST_LINES MTRL
, WMS_TRANSACTIONS_TEMP WTT
, MTL_TRANSACTION_TYPES MTT
, WMS_TXN_CONTEXT_TEMP WTCT
WHERE MTRL.LINE_ID = WTT.TRANSACTION_TEMP_ID
AND WTT.LINE_TYPE_CODE = 1
AND MTRL.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
AND MTRL.LINE_ID = WTCT.LINE_ID

Columns