VIEW: INV.MTL_RESERVATIONS_INTERFACE#

Source

View Text - Preformatted

select RESERVATION_INTERFACE_ID RESERVATION_INTERFACE_ID, RESERVATION_BATCH_ID RESERVATION_BATCH_ID, REQUIREMENT_DATE REQUIREMENT_DATE, ORGANIZATION_ID ORGANIZATION_ID, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_SEGMENT1 ITEM_SEGMENT1, ITEM_SEGMENT2 ITEM_SEGMENT2, ITEM_SEGMENT3 ITEM_SEGMENT3, ITEM_SEGMENT4 ITEM_SEGMENT4, ITEM_SEGMENT5 ITEM_SEGMENT5, ITEM_SEGMENT6 ITEM_SEGMENT6, ITEM_SEGMENT7 ITEM_SEGMENT7, ITEM_SEGMENT8 ITEM_SEGMENT8, ITEM_SEGMENT9 ITEM_SEGMENT9, ITEM_SEGMENT10 ITEM_SEGMENT10, ITEM_SEGMENT11 ITEM_SEGMENT11, ITEM_SEGMENT12 ITEM_SEGMENT12, ITEM_SEGMENT13 ITEM_SEGMENT13, ITEM_SEGMENT14 ITEM_SEGMENT14, ITEM_SEGMENT15 ITEM_SEGMENT15, ITEM_SEGMENT16 ITEM_SEGMENT16, ITEM_SEGMENT17 ITEM_SEGMENT17, ITEM_SEGMENT18 ITEM_SEGMENT18, ITEM_SEGMENT19 ITEM_SEGMENT19, ITEM_SEGMENT20 ITEM_SEGMENT20, DEMAND_SOURCE_TYPE_ID DEMAND_SOURCE_TYPE_ID, DEMAND_SOURCE_NAME DEMAND_SOURCE_NAME, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE_ID DEMAND_SOURCE_LINE_ID, TO_DEMAND_SOURCE_TYPE_ID TO_DEMAND_SOURCE_TYPE_ID, TO_DEMAND_SOURCE_NAME TO_DEMAND_SOURCE_NAME, TO_DEMAND_SOURCE_HEADER_ID TO_DEMAND_SOURCE_HEADER_ID, TO_DEMAND_SOURCE_LINE_ID TO_DEMAND_SOURCE_LINE_ID, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, PRIMARY_UOM_ID PRIMARY_UOM_ID, RESERVATION_UOM_CODE RESERVATION_UOM_CODE, RESERVATION_UOM_ID RESERVATION_UOM_ID, RESERVATION_QUANTITY RESERVATION_QUANTITY, PRIMARY_RESERVATION_QUANTITY PRIMARY_RESERVATION_QUANTITY, EXTERNAL_SOURCE_CODE EXTERNAL_SOURCE_CODE, EXTERNAL_SOURCE_LINE_ID EXTERNAL_SOURCE_LINE_ID, SUPPLY_SOURCE_TYPE_ID SUPPLY_SOURCE_TYPE_ID, SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_HEADER_ID, SUPPLY_SOURCE_LINE_ID SUPPLY_SOURCE_LINE_ID, SUPPLY_SOURCE_LINE_DETAIL SUPPLY_SOURCE_LINE_DETAIL, SUPPLY_SOURCE_NAME SUPPLY_SOURCE_NAME, TO_SUPPLY_SOURCE_TYPE_ID TO_SUPPLY_SOURCE_TYPE_ID, TO_SUPPLY_SOURCE_HEADER_ID TO_SUPPLY_SOURCE_HEADER_ID, TO_SUPPLY_SOURCE_LINE_ID TO_SUPPLY_SOURCE_LINE_ID, TO_SUPPLY_SOURCE_LINE_DETAIL TO_SUPPLY_SOURCE_LINE_DETAIL, TO_SUPPLY_SOURCE_NAME TO_SUPPLY_SOURCE_NAME, ERROR_CODE ERROR_CODE, ERROR_EXPLANATION ERROR_EXPLANATION, REVISION REVISION, SUBINVENTORY_CODE SUBINVENTORY_CODE, SUBINVENTORY_ID SUBINVENTORY_ID, LOCATOR_ID LOCATOR_ID, LOC_SEGMENT1 LOC_SEGMENT1, LOC_SEGMENT2 LOC_SEGMENT2, LOC_SEGMENT3 LOC_SEGMENT3, LOC_SEGMENT4 LOC_SEGMENT4, LOC_SEGMENT5 LOC_SEGMENT5, LOC_SEGMENT6 LOC_SEGMENT6, LOC_SEGMENT7 LOC_SEGMENT7, LOC_SEGMENT8 LOC_SEGMENT8, LOC_SEGMENT9 LOC_SEGMENT9, LOC_SEGMENT10 LOC_SEGMENT10, LOC_SEGMENT11 LOC_SEGMENT11, LOC_SEGMENT12 LOC_SEGMENT12, LOC_SEGMENT13 LOC_SEGMENT13, LOC_SEGMENT14 LOC_SEGMENT14, LOC_SEGMENT15 LOC_SEGMENT15, LOC_SEGMENT16 LOC_SEGMENT16, LOC_SEGMENT17 LOC_SEGMENT17, LOC_SEGMENT18 LOC_SEGMENT18, LOC_SEGMENT19 LOC_SEGMENT19, LOC_SEGMENT20 LOC_SEGMENT20, LOT_NUMBER LOT_NUMBER, LOT_NUMBER_ID LOT_NUMBER_ID, SERIAL_NUMBER SERIAL_NUMBER, SERIAL_NUMBER_ID SERIAL_NUMBER_ID, TO_REVISION TO_REVISION, TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE, TO_SUBINVENTORY_ID TO_SUBINVENTORY_ID, TO_LOCATOR_ID TO_LOCATOR_ID, TO_LOC_SEGMENT1 TO_LOC_SEGMENT1, TO_LOC_SEGMENT2 TO_LOC_SEGMENT2, TO_LOC_SEGMENT3 TO_LOC_SEGMENT3, TO_LOC_SEGMENT4 TO_LOC_SEGMENT4, TO_LOC_SEGMENT5 TO_LOC_SEGMENT5, TO_LOC_SEGMENT6 TO_LOC_SEGMENT6, TO_LOC_SEGMENT7 TO_LOC_SEGMENT7, TO_LOC_SEGMENT8 TO_LOC_SEGMENT8, TO_LOC_SEGMENT9 TO_LOC_SEGMENT9, TO_LOC_SEGMENT10 TO_LOC_SEGMENT10, TO_LOC_SEGMENT11 TO_LOC_SEGMENT11, TO_LOC_SEGMENT12 TO_LOC_SEGMENT12, TO_LOC_SEGMENT13 TO_LOC_SEGMENT13, TO_LOC_SEGMENT14 TO_LOC_SEGMENT14, TO_LOC_SEGMENT15 TO_LOC_SEGMENT15, TO_LOC_SEGMENT16 TO_LOC_SEGMENT16, TO_LOC_SEGMENT17 TO_LOC_SEGMENT17, TO_LOC_SEGMENT18 TO_LOC_SEGMENT18, TO_LOC_SEGMENT19 TO_LOC_SEGMENT19, TO_LOC_SEGMENT20 TO_LOC_SEGMENT20, TO_LOT_NUMBER TO_LOT_NUMBER, TO_LOT_NUMBER_ID TO_LOT_NUMBER_ID, TO_SERIAL_NUMBER TO_SERIAL_NUMBER, TO_SERIAL_NUMBER_ID TO_SERIAL_NUMBER_ID, ROW_STATUS_CODE ROW_STATUS_CODE, LOCK_FLAG LOCK_FLAG, RESERVATION_ACTION_CODE RESERVATION_ACTION_CODE, TRANSACTION_MODE TRANSACTION_MODE, VALIDATION_FLAG VALIDATION_FLAG, PARTIAL_QUANTITIES_ALLOWED PARTIAL_QUANTITIES_ALLOWED, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PROJECT_PLANNING_GROUP PROJECT_PLANNING_GROUP, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SHIP_READY_FLAG SHIP_READY_FLAG, LPN_ID LPN_ID, TO_LPN_ID TO_LPN_ID, SECONDARY_RESERVATION_QUANTITY SECONDARY_RESERVATION_QUANTITY, SECONDARY_UOM_CODE SECONDARY_UOM_CODE, SECONDARY_UOM_ID SECONDARY_UOM_ID from "INV"."MTL_RESERVATIONS_INTERFACE"

View Text - HTML Formatted

SELECT RESERVATION_INTERFACE_ID RESERVATION_INTERFACE_ID
, RESERVATION_BATCH_ID RESERVATION_BATCH_ID
, REQUIREMENT_DATE REQUIREMENT_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_SEGMENT1 ITEM_SEGMENT1
, ITEM_SEGMENT2 ITEM_SEGMENT2
, ITEM_SEGMENT3 ITEM_SEGMENT3
, ITEM_SEGMENT4 ITEM_SEGMENT4
, ITEM_SEGMENT5 ITEM_SEGMENT5
, ITEM_SEGMENT6 ITEM_SEGMENT6
, ITEM_SEGMENT7 ITEM_SEGMENT7
, ITEM_SEGMENT8 ITEM_SEGMENT8
, ITEM_SEGMENT9 ITEM_SEGMENT9
, ITEM_SEGMENT10 ITEM_SEGMENT10
, ITEM_SEGMENT11 ITEM_SEGMENT11
, ITEM_SEGMENT12 ITEM_SEGMENT12
, ITEM_SEGMENT13 ITEM_SEGMENT13
, ITEM_SEGMENT14 ITEM_SEGMENT14
, ITEM_SEGMENT15 ITEM_SEGMENT15
, ITEM_SEGMENT16 ITEM_SEGMENT16
, ITEM_SEGMENT17 ITEM_SEGMENT17
, ITEM_SEGMENT18 ITEM_SEGMENT18
, ITEM_SEGMENT19 ITEM_SEGMENT19
, ITEM_SEGMENT20 ITEM_SEGMENT20
, DEMAND_SOURCE_TYPE_ID DEMAND_SOURCE_TYPE_ID
, DEMAND_SOURCE_NAME DEMAND_SOURCE_NAME
, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE_ID DEMAND_SOURCE_LINE_ID
, TO_DEMAND_SOURCE_TYPE_ID TO_DEMAND_SOURCE_TYPE_ID
, TO_DEMAND_SOURCE_NAME TO_DEMAND_SOURCE_NAME
, TO_DEMAND_SOURCE_HEADER_ID TO_DEMAND_SOURCE_HEADER_ID
, TO_DEMAND_SOURCE_LINE_ID TO_DEMAND_SOURCE_LINE_ID
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, PRIMARY_UOM_ID PRIMARY_UOM_ID
, RESERVATION_UOM_CODE RESERVATION_UOM_CODE
, RESERVATION_UOM_ID RESERVATION_UOM_ID
, RESERVATION_QUANTITY RESERVATION_QUANTITY
, PRIMARY_RESERVATION_QUANTITY PRIMARY_RESERVATION_QUANTITY
, EXTERNAL_SOURCE_CODE EXTERNAL_SOURCE_CODE
, EXTERNAL_SOURCE_LINE_ID EXTERNAL_SOURCE_LINE_ID
, SUPPLY_SOURCE_TYPE_ID SUPPLY_SOURCE_TYPE_ID
, SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_HEADER_ID
, SUPPLY_SOURCE_LINE_ID SUPPLY_SOURCE_LINE_ID
, SUPPLY_SOURCE_LINE_DETAIL SUPPLY_SOURCE_LINE_DETAIL
, SUPPLY_SOURCE_NAME SUPPLY_SOURCE_NAME
, TO_SUPPLY_SOURCE_TYPE_ID TO_SUPPLY_SOURCE_TYPE_ID
, TO_SUPPLY_SOURCE_HEADER_ID TO_SUPPLY_SOURCE_HEADER_ID
, TO_SUPPLY_SOURCE_LINE_ID TO_SUPPLY_SOURCE_LINE_ID
, TO_SUPPLY_SOURCE_LINE_DETAIL TO_SUPPLY_SOURCE_LINE_DETAIL
, TO_SUPPLY_SOURCE_NAME TO_SUPPLY_SOURCE_NAME
, ERROR_CODE ERROR_CODE
, ERROR_EXPLANATION ERROR_EXPLANATION
, REVISION REVISION
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, SUBINVENTORY_ID SUBINVENTORY_ID
, LOCATOR_ID LOCATOR_ID
, LOC_SEGMENT1 LOC_SEGMENT1
, LOC_SEGMENT2 LOC_SEGMENT2
, LOC_SEGMENT3 LOC_SEGMENT3
, LOC_SEGMENT4 LOC_SEGMENT4
, LOC_SEGMENT5 LOC_SEGMENT5
, LOC_SEGMENT6 LOC_SEGMENT6
, LOC_SEGMENT7 LOC_SEGMENT7
, LOC_SEGMENT8 LOC_SEGMENT8
, LOC_SEGMENT9 LOC_SEGMENT9
, LOC_SEGMENT10 LOC_SEGMENT10
, LOC_SEGMENT11 LOC_SEGMENT11
, LOC_SEGMENT12 LOC_SEGMENT12
, LOC_SEGMENT13 LOC_SEGMENT13
, LOC_SEGMENT14 LOC_SEGMENT14
, LOC_SEGMENT15 LOC_SEGMENT15
, LOC_SEGMENT16 LOC_SEGMENT16
, LOC_SEGMENT17 LOC_SEGMENT17
, LOC_SEGMENT18 LOC_SEGMENT18
, LOC_SEGMENT19 LOC_SEGMENT19
, LOC_SEGMENT20 LOC_SEGMENT20
, LOT_NUMBER LOT_NUMBER
, LOT_NUMBER_ID LOT_NUMBER_ID
, SERIAL_NUMBER SERIAL_NUMBER
, SERIAL_NUMBER_ID SERIAL_NUMBER_ID
, TO_REVISION TO_REVISION
, TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE
, TO_SUBINVENTORY_ID TO_SUBINVENTORY_ID
, TO_LOCATOR_ID TO_LOCATOR_ID
, TO_LOC_SEGMENT1 TO_LOC_SEGMENT1
, TO_LOC_SEGMENT2 TO_LOC_SEGMENT2
, TO_LOC_SEGMENT3 TO_LOC_SEGMENT3
, TO_LOC_SEGMENT4 TO_LOC_SEGMENT4
, TO_LOC_SEGMENT5 TO_LOC_SEGMENT5
, TO_LOC_SEGMENT6 TO_LOC_SEGMENT6
, TO_LOC_SEGMENT7 TO_LOC_SEGMENT7
, TO_LOC_SEGMENT8 TO_LOC_SEGMENT8
, TO_LOC_SEGMENT9 TO_LOC_SEGMENT9
, TO_LOC_SEGMENT10 TO_LOC_SEGMENT10
, TO_LOC_SEGMENT11 TO_LOC_SEGMENT11
, TO_LOC_SEGMENT12 TO_LOC_SEGMENT12
, TO_LOC_SEGMENT13 TO_LOC_SEGMENT13
, TO_LOC_SEGMENT14 TO_LOC_SEGMENT14
, TO_LOC_SEGMENT15 TO_LOC_SEGMENT15
, TO_LOC_SEGMENT16 TO_LOC_SEGMENT16
, TO_LOC_SEGMENT17 TO_LOC_SEGMENT17
, TO_LOC_SEGMENT18 TO_LOC_SEGMENT18
, TO_LOC_SEGMENT19 TO_LOC_SEGMENT19
, TO_LOC_SEGMENT20 TO_LOC_SEGMENT20
, TO_LOT_NUMBER TO_LOT_NUMBER
, TO_LOT_NUMBER_ID TO_LOT_NUMBER_ID
, TO_SERIAL_NUMBER TO_SERIAL_NUMBER
, TO_SERIAL_NUMBER_ID TO_SERIAL_NUMBER_ID
, ROW_STATUS_CODE ROW_STATUS_CODE
, LOCK_FLAG LOCK_FLAG
, RESERVATION_ACTION_CODE RESERVATION_ACTION_CODE
, TRANSACTION_MODE TRANSACTION_MODE
, VALIDATION_FLAG VALIDATION_FLAG
, PARTIAL_QUANTITIES_ALLOWED PARTIAL_QUANTITIES_ALLOWED
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PROJECT_PLANNING_GROUP PROJECT_PLANNING_GROUP
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SHIP_READY_FLAG SHIP_READY_FLAG
, LPN_ID LPN_ID
, TO_LPN_ID TO_LPN_ID
, SECONDARY_RESERVATION_QUANTITY SECONDARY_RESERVATION_QUANTITY
, SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, SECONDARY_UOM_ID SECONDARY_UOM_ID
FROM "INV"."MTL_RESERVATIONS_INTERFACE"