INV_TRX_DETAILS_TMP_V

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name

PP_TRANSACTION_TEMP_ID TYPE_CODE LINE_TYPE_CODE LINE_ID FROM_ORGANIZATION_ID FROM_SUBINVENTORY_CODE FROM_LOCATOR_ID INVENTORY_ITEM_ID REVISION TRANSACTION_QUANTITY PRIMARY_QUANTITY TO_ORGANIZATION_ID TO_SUBINVENTORY_CODE TO_LOCATOR_ID HEADER_ID LINE_NUMBER TO_ACCOUNT_ID LOT_NUMBER LOT_EXPIRATION_DATE SERIAL_NUMBER UOM_CODE DATE_REQUIRED REASON_ID REFERENCE_NAME REFERENCE_TYPE_CODE REFERENCE_ID TRANSACTION_HEADER_ID LINE_STATUS STATUS_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE CREATED_BY CREATION_DATE REQUEST_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY TXN_SOURCE_ID TXN_SOURCE_LINE_ID TXN_SOURCE_LINE_DETAIL TXN_SOURCE_NAME FREIGHT_CARRIER_CODE CUSTOMER_ID TRANSACTION_TYPE_ID TRANSACTION_SOURCE_TYPE_ID TRANSACTION_ACTION_ID INSPECTION_STATUS LPN_ID

Query

SQL_Statement

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_NAME ,mtrl.REFERENCE_TYPE_CODE ,mtrl.REFERENCE_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.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 FROM INV_TXN_REQUEST_LINES mtrl ,INV_TRANSACTIONS_GT wtt ,INV_TRANSACTION_TYPES mtt ,INV_TXN_CONTEXT_GT 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