VIEW: APPS.MTL_TXN_REQUEST_LINES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)