View: MTL_RESERVATIONS_INTERFACE_V

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

View Text

SELECT MRI.ROWID
, MRI.RESERVATION_INTERFACE_ID
, MRI.RESERVATION_BATCH_ID
, MRI.REQUIREMENT_DATE
, MRI.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MRI.TO_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MRI.INVENTORY_ITEM_ID
, MSI.DESCRIPTION
, MRI.ITEM_SEGMENT1
, MRI.ITEM_SEGMENT2
, MRI.ITEM_SEGMENT3
, MRI.ITEM_SEGMENT4
, MRI.ITEM_SEGMENT5
, MRI.ITEM_SEGMENT6
, MRI.ITEM_SEGMENT7
, MRI.ITEM_SEGMENT8
, MRI.ITEM_SEGMENT9
, MRI.ITEM_SEGMENT10
, MRI.ITEM_SEGMENT11
, MRI.ITEM_SEGMENT12
, MRI.ITEM_SEGMENT13
, MRI.ITEM_SEGMENT14
, MRI.ITEM_SEGMENT15
, MRI.ITEM_SEGMENT16
, MRI.ITEM_SEGMENT17
, MRI.ITEM_SEGMENT18
, MRI.ITEM_SEGMENT19
, MRI.ITEM_SEGMENT20
, MRI.DEMAND_SOURCE_TYPE_ID
, ML1.TRANSACTION_SOURCE_TYPE_NAME
, MRI.DEMAND_SOURCE_NAME
, MRI.DEMAND_SOURCE_HEADER_ID
, MRI.DEMAND_SOURCE_LINE_ID
, TO_DEMAND_SOURCE_TYPE_ID
, ML2.TRANSACTION_SOURCE_TYPE_NAME
, MRI.TO_DEMAND_SOURCE_NAME
, MRI.TO_DEMAND_SOURCE_HEADER_ID
, MRI.TO_DEMAND_SOURCE_LINE_ID
, MRI.PRIMARY_UOM_CODE
, MRI.PRIMARY_UOM_ID
, MRI.RESERVATION_UOM_CODE
, MRI.RESERVATION_UOM_ID
, MRI.RESERVATION_QUANTITY
, MRI.PRIMARY_RESERVATION_QUANTITY
, MRI.SECONDARY_UOM_CODE
, MRI.SECONDARY_UOM_ID
, MRI.SECONDARY_RESERVATION_QUANTITY
, MRI.EXTERNAL_SOURCE_CODE
, MRI.EXTERNAL_SOURCE_LINE_ID
, MRI.SUPPLY_SOURCE_TYPE_ID
, ML3.TRANSACTION_SOURCE_TYPE_NAME
, MRI.SUPPLY_SOURCE_HEADER_ID
, MRI.SUPPLY_SOURCE_LINE_ID
, MRI.SUPPLY_SOURCE_LINE_DETAIL
, MRI.SUPPLY_SOURCE_NAME
, MRI.TO_SUPPLY_SOURCE_TYPE_ID
, ML4.TRANSACTION_SOURCE_TYPE_NAME
, MRI.TO_SUPPLY_SOURCE_HEADER_ID
, MRI.TO_SUPPLY_SOURCE_LINE_ID
, MRI.TO_SUPPLY_SOURCE_LINE_DETAIL
, MRI.TO_SUPPLY_SOURCE_NAME
, MRI.ERROR_CODE
, MRI.ERROR_EXPLANATION
, MRI.REVISION
, MRI.SUBINVENTORY_CODE
, MRI.SUBINVENTORY_ID
, MRI.LOCATOR_ID
, MRI.LOC_SEGMENT1
, MRI.LOC_SEGMENT2
, MRI.LOC_SEGMENT3
, MRI.LOC_SEGMENT4
, MRI.LOC_SEGMENT5
, MRI.LOC_SEGMENT6
, MRI.LOC_SEGMENT7
, MRI.LOC_SEGMENT8
, MRI.LOC_SEGMENT9
, MRI.LOC_SEGMENT10
, MRI.LOC_SEGMENT11
, MRI.LOC_SEGMENT12
, MRI.LOC_SEGMENT13
, MRI.LOC_SEGMENT14
, MRI.LOC_SEGMENT15
, MRI.LOC_SEGMENT16
, MRI.LOC_SEGMENT17
, MRI.LOC_SEGMENT18
, MRI.LOC_SEGMENT19
, MRI.LOC_SEGMENT20
, MRI.LOT_NUMBER
, MRI.LOT_NUMBER_ID
, MRI.SERIAL_NUMBER
, MRI.SERIAL_NUMBER_ID
, MRI.TO_REVISION
, MRI.TO_SUBINVENTORY_CODE
, MRI.TO_SUBINVENTORY_ID
, MRI.TO_LOCATOR_ID
, MRI.TO_LOC_SEGMENT1
, MRI.TO_LOC_SEGMENT2
, MRI.TO_LOC_SEGMENT3
, MRI.TO_LOC_SEGMENT4
, MRI.TO_LOC_SEGMENT5
, MRI.TO_LOC_SEGMENT6
, MRI.TO_LOC_SEGMENT7
, MRI.TO_LOC_SEGMENT8
, MRI.TO_LOC_SEGMENT9
, MRI.TO_LOC_SEGMENT10
, MRI.TO_LOC_SEGMENT11
, MRI.TO_LOC_SEGMENT12
, MRI.TO_LOC_SEGMENT13
, MRI.TO_LOC_SEGMENT14
, MRI.TO_LOC_SEGMENT15
, MRI.TO_LOC_SEGMENT16
, MRI.TO_LOC_SEGMENT17
, MRI.TO_LOC_SEGMENT18
, MRI.TO_LOC_SEGMENT19
, MRI.TO_LOC_SEGMENT20
, MRI.TO_LOT_NUMBER
, MRI.TO_LOT_NUMBER_ID
, MRI.TO_SERIAL_NUMBER
, MRI.TO_SERIAL_NUMBER_ID
, MRI.ROW_STATUS_CODE
, ML7.MEANING
, MRI.LOCK_FLAG
, MRI.RESERVATION_ACTION_CODE
, ML5.MEANING
, MRI.TRANSACTION_MODE
, ML6.MEANING
, MRI.VALIDATION_FLAG
, MRI.PARTIAL_QUANTITIES_ALLOWED
, MRI.LAST_UPDATE_DATE
, MRI.LAST_UPDATED_BY
, MRI.CREATION_DATE
, MRI.CREATED_BY
, MRI.LAST_UPDATE_LOGIN
, MRI.REQUEST_ID
, MRI.PROGRAM_APPLICATION_ID
, MRI.PROGRAM_ID
, MRI.PROGRAM_UPDATE_DATE
, MRI.PROJECT_ID
, MRI.TASK_ID
, MRI.PROJECT_PLANNING_GROUP
, MRI.ATTRIBUTE_CATEGORY
, MRI.ATTRIBUTE1
, MRI.ATTRIBUTE2
, MRI.ATTRIBUTE3
, MRI.ATTRIBUTE4
, MRI.ATTRIBUTE5
, MRI.ATTRIBUTE6
, MRI.ATTRIBUTE7
, MRI.ATTRIBUTE8
, MRI.ATTRIBUTE9
, MRI.ATTRIBUTE10
, MRI.ATTRIBUTE11
, MRI.ATTRIBUTE12
, MRI.ATTRIBUTE13
, MRI.ATTRIBUTE14
, MRI.ATTRIBUTE15
, MRI.SHIP_READY_FLAG
, MRI.LPN_ID
, MRI.TO_LPN_ID
FROM MTL_SYSTEM_ITEMS MSI
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, MTL_TXN_SOURCE_TYPES ML1
, MTL_TXN_SOURCE_TYPES ML2
, MTL_TXN_SOURCE_TYPES ML3
, MTL_TXN_SOURCE_TYPES ML4
, MFG_LOOKUPS ML5
, MFG_LOOKUPS ML6
, MFG_LOOKUPS ML7
, MTL_RESERVATIONS_INTERFACE MRI
WHERE MSI.INVENTORY_ITEM_ID = MRI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MRI.ORGANIZATION_ID
AND MP1.ORGANIZATION_ID = MRI.ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MRI.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID (+)= MRI.TO_ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID (+)= MRI.TO_ORGANIZATION_ID
AND ML1.TRANSACTION_SOURCE_TYPE_ID(+)= MRI.DEMAND_SOURCE_TYPE_ID
AND ML2.TRANSACTION_SOURCE_TYPE_ID(+)= MRI.TO_DEMAND_SOURCE_TYPE_ID
AND ML3.TRANSACTION_SOURCE_TYPE_ID(+)= MRI.SUPPLY_SOURCE_TYPE_ID
AND ML4.TRANSACTION_SOURCE_TYPE_ID(+)= MRI.TO_SUPPLY_SOURCE_TYPE_ID
AND ML5.LOOKUP_TYPE = 'MTL_RESERVATION_ACTION_CODE'
AND ML5.LOOKUP_CODE = MRI.RESERVATION_ACTION_CODE
AND ML6.LOOKUP_TYPE = 'MTL_TRANSACTION_MODE'
AND ML6.LOOKUP_CODE = MRI.TRANSACTION_MODE
AND ML7.LOOKUP_TYPE = 'INV_YES_NO_ERROR'
AND ML7.LOOKUP_CODE = MRI.ROW_STATUS_CODE

Columns