View: MTL_TXN_REQUEST_LINES_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_TXN_REQUEST_LINES_V

View Text

SELECT MTRL.LINE_ID LINE_ID
, MTRH.REQUEST_NUMBER REQUEST_NUMBER
, MTRH.MOVE_ORDER_TYPE MOVE_ORDER_TYPE
, MFG2.MEANING MOVE_ORDER_TYPE_NAME
, MTRH.DESCRIPTION DESCRIPTION
, MTRL.HEADER_ID HEADER_ID
, MTT.TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, MTRL.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME
, MTT.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, MTRL.LINE_NUMBER LINE_NUMBER
, MTRL.ORGANIZATION_ID ORGANIZATION_ID
, MTRL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MTRL.REVISION REVISION
, MTRL.FROM_SUBINVENTORY_ID FROM_SUBINVENTORY_ID
, MTRL.FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MSS.LOCATOR_TYPE FROM_SUB_LOCATOR_TYPE
, MSS.ASSET_INVENTORY FROM_SUB_ASSET
, MSS.QUANTITY_TRACKED FROM_SUB_QUANTITY_TRACKED
, MSS.MATERIAL_ACCOUNT FROM_SUB_MATERIAL_ACCOUNT
, MTRL.FROM_LOCATOR_ID FROM_LOCATOR_ID
, MTRL.TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE
, MSS1.LOCATOR_TYPE TO_SUB_LOCATOR_TYPE
, MSS1.ASSET_INVENTORY TO_SUB_ASSET
, MSS1.QUANTITY_TRACKED TO_SUB_QUANTITY_TRACKED
, MSS1.MATERIAL_ACCOUNT TO_SUB_MATERIAL_ACCOUNT
, MTRL.TO_SUBINVENTORY_ID TO_SUBINVENTORY_ID
, MTRL.TO_LOCATOR_ID TO_LOCATOR_ID
, MTRL.TO_ACCOUNT_ID TO_ACCOUNT_ID
, MTRL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, MTRL.LOT_NUMBER LOT_NUMBER
, MTRL.SERIAL_NUMBER_START SERIAL_NUMBER_START
, MTRL.SERIAL_NUMBER_END SERIAL_NUMBER_END
, MTRL.UOM_CODE UOM_CODE
, MTRL.QUANTITY QUANTITY
, MTRL.REQUIRED_QUANTITY REQUIRED_QUANTITY
, MTRL.QUANTITY_DELIVERED QUANTITY_DELIVERED
, MTRL.QUANTITY_DETAILED QUANTITY_DETAILED
, MTRL.DATE_REQUIRED DATE_REQUIRED
, MTRL.REASON_ID REASON_ID
, MTRL.REFERENCE REFERENCE
, MTRL.REFERENCE_TYPE_CODE REFERENCE_TYPE_CODE
, MTRL.REFERENCE_ID REFERENCE_ID
, MTRL.PROJECT_ID PROJECT_ID
, MTRL.TASK_ID TASK_ID
, MTRL.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, MTRL.LINE_STATUS LINE_STATUS
, MTRL.STATUS_DATE STATUS_DATE
, MTRL.LAST_UPDATED_BY LAST_UPDATED_BY
, MTRL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MTRL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MTRL.CREATED_BY CREATED_BY
, MTRL.CREATION_DATE CREATION_DATE
, MTRL.REQUEST_ID REQUEST_ID
, MTRL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MTRL.PROGRAM_ID PROGRAM_ID
, MTRL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MTRL.ATTRIBUTE1 ATTRIBUTE1
, MTRL.ATTRIBUTE2 ATTRIBUTE2
, MTRL.ATTRIBUTE3 ATTRIBUTE3
, MTRL.ATTRIBUTE4 ATTRIBUTE4
, MTRL.ATTRIBUTE5 ATTRIBUTE5
, MTRL.ATTRIBUTE6 ATTRIBUTE6
, MTRL.ATTRIBUTE7 ATTRIBUTE7
, MTRL.ATTRIBUTE8 ATTRIBUTE8
, MTRL.ATTRIBUTE9 ATTRIBUTE9
, MTRL.ATTRIBUTE10 ATTRIBUTE10
, MTRL.ATTRIBUTE11 ATTRIBUTE11
, MTRL.ATTRIBUTE12 ATTRIBUTE12
, MTRL.ATTRIBUTE13 ATTRIBUTE13
, MTRL.ATTRIBUTE14 ATTRIBUTE14
, MTRL.ATTRIBUTE15 ATTRIBUTE15
, MTRL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, MTRL.TXN_SOURCE_ID TXN_SOURCE_ID
, MTRL.TXN_SOURCE_LINE_ID TXN_SOURCE_LINE_ID
, MTRL.TXN_SOURCE_LINE_DETAIL_ID TXN_SOURCE_LINE_DETAIL_ID
, MTRL.PRIMARY_QUANTITY PRIMARY_QUANTITY
, MTRL.TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, MTRL.PICK_STRATEGY_ID PICK_STRATEGY_ID
, MTRL.PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID
, MTRL.UNIT_NUMBER UNIT_NUMBER
, MTRL.FROM_COST_GROUP_ID FROM_COST_GROUP_ID
, CST.COST_GROUP FROM_COST_GROUP_NAME
, MTRL.TO_COST_GROUP_ID TO_COST_GROUP_ID
, CST2.COST_GROUP TO_COST_GROUP_NAME
, MTRL.LPN_ID LPN_ID
, MTRL.TO_LPN_ID TO_LPN_ID
, MTRL.REFERENCE_DETAIL_ID REFERENCE_DETAIL_ID
, MTRL.ASSIGNMENT_ID ASSIGNMENT_ID
, FROM_WLPN.LICENSE_PLATE_NUMBER LPN_NUMBER
, TO_WLPN.LICENSE_PLATE_NUMBER TO_LPN_NUMBER
, MTRL.GRADE_CODE
, MTRL.SECONDARY_QUANTITY
, MTRL.SECONDARY_QUANTITY_DETAILED
, MTRL.SECONDARY_QUANTITY_DELIVERED
, MTRL.SECONDARY_REQUIRED_QUANTITY
, MTRL.SECONDARY_UOM_CODE
, MTT.LOCATION_REQUIRED_FLAG
FROM MTL_TXN_REQUEST_LINES MTRL
, MTL_TXN_REQUEST_HEADERS MTRH
, MTL_TRANSACTION_TYPES MTT
, MTL_SECONDARY_INVENTORIES MSS
, MTL_SECONDARY_INVENTORIES MSS1
, MFG_LOOKUPS MFG
, MFG_LOOKUPS MFG2
, CST_COST_GROUPS CST
, CST_COST_GROUPS CST2
, WMS_LICENSE_PLATE_NUMBERS FROM_WLPN
, WMS_LICENSE_PLATE_NUMBERS TO_WLPN
WHERE MTRH.HEADER_ID = MTRL.HEADER_ID
AND MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
AND MSS.SECONDARY_INVENTORY_NAME(+) = MTRL.FROM_SUBINVENTORY_CODE
AND MSS.ORGANIZATION_ID(+) = MTRL.ORGANIZATION_ID
AND MSS1.SECONDARY_INVENTORY_NAME(+) = MTRL.TO_SUBINVENTORY_CODE
AND MSS1.ORGANIZATION_ID(+) = MTRL.ORGANIZATION_ID
AND MFG.LOOKUP_TYPE = 'MTL_TXN_REQUEST_STATUS'
AND MFG.LOOKUP_CODE = TO_CHAR(MTRL.LINE_STATUS)
AND MFG2.LOOKUP_TYPE = 'MOVE_ORDER_TYPE'
AND MFG2.LOOKUP_CODE = TO_CHAR(MTRH.MOVE_ORDER_TYPE)
AND CST.COST_GROUP_ID(+) = MTRL.FROM_COST_GROUP_ID
AND CST2.COST_GROUP_ID(+) = MTRL.TO_COST_GROUP_ID
AND MTRL.LPN_ID = FROM_WLPN.LPN_ID(+)
AND MTRL.TO_LPN_ID = TO_WLPN.LPN_ID(+)

Columns