eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WMS_TRX_DETAILS_TMP_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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