DBA Data[Home] [Help]

VIEW: APPS.MTL_RESERVATIONS_INTERFACE_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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