1. Tables and Views for SCM
  2. INV_RESERVATIONS_INTERFACE

INV_RESERVATIONS_INTERFACE

This table stores reservations requests. The Reservation Interface manager processes reservation requests from this table into INV_RESERVATIONS.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

INV_RSV_INTRFC_PK

RESERVATION_BATCH_ID, RESERVATION_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
RESERVATION_INTERFACE_ID NUMBER 18 Yes Identifies a unique reservation request Active
LOAD_REQUEST_ID NUMBER 18 Used by Enterprise Service Scheduler. Indicates the request ID of the interface job that created the row.
TO_SUPPLY_SOURCE_LINE_NUMBER VARCHAR2 150 This is the supply source line number to transfer to.
SUPPLY_SOURCE_LINE_NUMBER VARCHAR2 150 This is the supply source line number.
SUPPLY_SOURCE_HEADER_NUMBER VARCHAR2 150 This is the supply source header number.
TO_SUPPLY_SOURCE_HDR_NUMBER VARCHAR2 150 This is the supply source header number to transfer to.
RESERVATION_BATCH_ID NUMBER 18 Yes Identifies a group of reservation requests Active
REQUIREMENT_DATE DATE Yes This is the required reservation date. Active
ORGANIZATION_CODE VARCHAR2 18 Identifies organization code in which reservation function is performed Active
ORGANIZATION_ID NUMBER 18 Identifies organization in which reservation function is performed Active
ORGANIZATION_NAME VARCHAR2 240 Organization Name. The value is based on Organization Name from INV_ORGANIZATION_DEFINITIONS_V.
TO_ORGANIZATION_ID NUMBER 18 For transfer and update reservations, the destination organization in which the reservation function is performed Active
TO_ORGANIZATION_NAME VARCHAR2 240 To Organization Name. The value is based on Organization Name from INV_ORGANIZATION_DEFINITIONS_V.
INVENTORY_ITEM_ID NUMBER 18 This identifies the reserved inventory item. Active
ITEM_NUMBER VARCHAR2 300 Item Number. The value is based on Item Number from EGP_SYSTEM_ITEMS_VL.
ITEM_SEGMENT1 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT2 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT3 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT4 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT5 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT6 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT7 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT8 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT9 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT10 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT11 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT12 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT13 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT14 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT15 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT16 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT17 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT18 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT19 VARCHAR2 40 This is an item flexfield segment. Active
ITEM_SEGMENT20 VARCHAR2 40 This is an item flexfield segment. Active
DEMAND_SOURCE_TYPE_ID NUMBER 18 Identifies demand source - Sales Order, Account, Account Alias, Inventory Active
DEMAND_SOURCE_TYPE_NAME VARCHAR2 80 Demand Source Type Name. The value is based on the FND_LOOKUP type INV_RESERVATION_SOURCE_TYPE.
DEMAND_SOURCE_NAME VARCHAR2 30 Identifier for inventory or user defined demand Active
DEMAND_SOURCE_HEADER_ID NUMBER 18 Header identifier for source of demand. For Sales Order: OE_ORDER_HEADERS.HEADER_ID. For Account: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. For Account Alias: INV_GENERIC_DISPOSITIONS.DISPOSITION_ID Active
DEMAND_SOURCE_HEADER_NUMBER VARCHAR2 150 Demand Source Header Number. The value is based on Source Order Number from INV_SALES_ORDERS.
DEMAND_SOURCE_LINE_ID NUMBER 18 Line identifier for demand source. For Sales Order: OE_ORDER_LINES.LINE_ID Active
DEMAND_SOURCE_LINE_NUMBER VARCHAR2 150 When demand source is not within the same pillar (e.g. DOO) then this column stores the demand source line number Active
TO_DEMAND_SOURCE_TYPE_ID NUMBER 18 For update and transfer reservation, identifies destination demand source - Sales Order, Account, Account Alias, Inventory. Active
TO_DEMAND_SOURCE_TYPE_NAME VARCHAR2 80 Demand Source Type Name. The value is based on the FND_LOOKUP type INV_RESERVATION_SOURCE_TYPE.
TO_DEMAND_SOURCE_NAME VARCHAR2 30 For update and transfer reservation, identifier for inventory or user defined destination demand source. Active
TO_DEMAND_SOURCE_HEADER_ID NUMBER 18 For update and transfer reservation, Header identifier fordestination source of demand. For Sales Order: OE_ORDER_HEADERS.HEADER_ID. For Account: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. For Account Alias: INV_GENERIC_DISPOSITIONS.DISPOSITION_ID Active
TO_DEMAND_SOURCE_HDR_NUMBER VARCHAR2 150 Demand Source Header Number. The value is based on Source Order Number from INV_SALES_ORDERS.
TO_DEMAND_SOURCE_LINE_ID NUMBER 18 For update and transfer reservation, Line identifier for destination demand source. For Sales Order: OE_ORDER_LINES.LINE_ID Active
TO_DEMAND_SOURCE_LINE_NUMBER VARCHAR2 150 For update and transfer reservation, line number for destination demand source. Active
PRIMARY_UOM_CODE VARCHAR2 3 Primary unit of measure code of reserved item Active
PRIMARY_UNIT_OF_MEASURE VARCHAR2 25 Primary unit of measure of reserved item
RESERVATION_UOM_CODE VARCHAR2 3 Unit of measure code in which reservation is made. Active
RESERVATION_UNIT_OF_MEASURE VARCHAR2 25 Unit of measure in which reservation is made.
RESERVATION_QUANTITY NUMBER Yes Quantity reserved in RESERVATION_UOM_CODE Active
PRIMARY_RESERVATION_QUANTITY NUMBER Quantity reserved in PRIMARY_UOM_CODE Active
SUPPLY_SOURCE_TYPE_ID NUMBER 18 Indicates supply source of reservation. Active
SUPPLY_SOURCE_TYPE_NAME VARCHAR2 80 Supply Source Type Name. The value is based on the FND_LOOKUP type INV_RESERVATION_SUPPLY_SRC_TYP.
SUPPLY_SOURCE_HEADER_ID NUMBER 18 Header identifier of Supply Source Active
SUPPLY_SOURCE_LINE_ID NUMBER 18 Indicates line identifier of Supply Source Active
SUPPLY_SOURCE_LINE_DETAIL NUMBER 18 Indicates line detail identifier of supply source Active
SUPPLY_SOURCE_NAME VARCHAR2 30 Indicates name of Supply Source Active
TO_SUPPLY_SOURCE_TYPE_ID NUMBER 18 For update and transfer of reservation, indicates destination supply source of reservation. Active
TO_SUPPLY_SOURCE_TYPE_NAME VARCHAR2 80 Supply Source Type Name. The value is based on the FND_LOOKUP type INV_RESERVATION_SUPPLY_SRC_TYP.
TO_SUPPLY_SOURCE_HEADER_ID NUMBER 18 For update and transfer of reservations, header identifier of destination supply source. Active
TO_SUPPLY_SOURCE_LINE_ID NUMBER 18 For transfer and update of reservations, indicates line identifier of destination supply source. Active
TO_SUPPLY_SOURCE_LINE_DETAIL NUMBER 18 For transfer and update of reservations, indicates line detail identifier of destination supply source. Active
TO_SUPPLY_SOURCE_NAME VARCHAR2 30 For transfer and update of reservations, indicates name of destination Supply Source. Active
ERROR_CODE NUMBER Error code returned by Reservations Interface Manager Active
ERROR_EXPLANATION_CODE VARCHAR2 240 Error explanation code returned by Reservations Interface Manager.
ERROR_EXPLANATION VARCHAR2 240 This is the error explanation text. Active
REVISION VARCHAR2 18 Revision of revision controlled reserved item Active
SUBINVENTORY_CODE VARCHAR2 10 Subinventory in which reservation is made Active
LOCATOR_ID NUMBER 18 Identifies locator in which reservation is made. Active
LOC_SEGMENT1 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT2 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT3 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT4 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT5 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT6 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT7 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT8 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT9 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT10 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT11 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT12 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT13 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT14 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT15 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT16 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT17 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT18 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT19 VARCHAR2 40 Locator flexfield segment column Active
LOC_SEGMENT20 VARCHAR2 40 Locator flexfield segment column Active
LOT_NUMBER VARCHAR2 80 Lot number of lot controlled reserved item. Active
TO_REVISION VARCHAR2 18 For update and transfer reservation, destination revision of revision controlled reserved item Active
TO_SUBINVENTORY_CODE VARCHAR2 10 For update and transfer reservation, destination subinventory in which reservation is made. Active
TO_LOCATOR_ID NUMBER 18 For update and transfer reservation, identifies locator in which reservation is made. Active
TO_LOC_SEGMENT1 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT2 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT3 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT4 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT5 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT6 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT7 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT8 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT9 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT10 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT11 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT12 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT13 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT14 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT15 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT16 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT17 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT18 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT19 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOC_SEGMENT20 VARCHAR2 40 For transfer and update reservation, destination locator flexfield segment column Active
TO_LOT_NUMBER VARCHAR2 80 For update and transfer reservation, destination lot number of lot controlled reserved item. Active
ROW_STATUS_CODE VARCHAR2 30 Yes Indicates status of request - Active, Inactive, Error Active
LOCK_FLAG VARCHAR2 30 Indicates request is locked. This is to prevent the request from being picked by another manager. Active
RESERVATION_ACTION_CODE VARCHAR2 30 Yes Indicates reservation function requested Active
TRANSACTION_MODE VARCHAR2 30 Yes Fflag to indicate processing mode: 1 - Online; 2 - Immediate Concurrent; 3 - Batch Active
VALIDATION_FLAG VARCHAR2 30 Flag to indicate if row needs to be validated before being processed. Active
PARTIAL_QUANTITIES_ALLOWED VARCHAR2 30 Flag to indicate if partial reservations are permitted Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
SHIP_READY_FLAG VARCHAR2 30 Flag to indicate if reservation has to be updated to ready to be shipped. Active
LPN_ID NUMBER 18 This identifies the packing unit. Active
TO_LPN_ID NUMBER 18 Identifies the packing unit to transfer to. Active
SECONDARY_RESERVATION_QUANTITY NUMBER Reservation Quantity Recorded in the Secondary Unit Of Measure Active
SECONDARY_UOM_CODE VARCHAR2 3 Items Secondary Unit Of Measure Code Active
SECONDARY_UNIT_OF_MEASURE VARCHAR2 25 Items Secondary Unit Of Measure
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SOURCE_ORDER_NUMBER VARCHAR2 150 Identifies the order from the order capture system.
SOURCE_SYSTEM_ID NUMBER 18 Identifies an instance of the source system (e.g. DOO).
SOURCE_ORDER_TYPE_ID VARCHAR2 30 Indicates the type of demand source for which reservation is made.
SALES_ORDER_NUMBER VARCHAR2 150 Sales Order identifier for the fulfillment system.
SALES_ORDER_SYSTEM_ID NUMBER 18 Identifies Order Capture system
SOLD_TO_PARTY_ID NUMBER 18 Numeric ID to identify the Customer of the Sales Order.
OUTSOURCER_PARTY_ID NUMBER 18 Identifies the outsourcer for the sales order.
SOURCE_FULFILLMENT_LINE_ID NUMBER 18 Points to source_fulfillment_line_id (e.g. DOO fulfillment line id)
SUPPLY_PROJECT_ID NUMBER 18 Indetifier of the project used to stripe Inventory transactions
SUPPLY_PROJECT_NUMBER VARCHAR2 25 Name of the project used to stripe Inventory transactions
SUPPLY_TASK_ID NUMBER 18 Indetifier of the task used to stripe Inventory transactions
SUPPLY_TASK_NUMBER VARCHAR2 100 Name of the task used to stripe Inventory transactions
TO_SUPPLY_PROJECT_ID NUMBER 18 Identifier of the destination project used to update and trnasfer reservations.
TO_SUPPLY_PROJECT_NUMBER VARCHAR2 25 Name of the destination project used to update and transfer reservation.
TO_SUPPLY_TASK_ID NUMBER 18 Identifier of the destination task number used to update and transfer reservation.
TO_SUPPLY_TASK_NUMBER VARCHAR2 100 Name of the destination task used to update and transfer reservation
INV_STRIPING_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for inventory striping attributes
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of manufacture used to stripe inventory transactions
COUNTRY_OF_ORIGIN_NAME VARCHAR2 80 Name for the country of manufacture used to stripe inventory transactions
INV_RESERVED_ATTRIBUTE1 VARCHAR2 150 Reserved for future Inventory striping related functionality
INV_RESERVED_ATTRIBUTE2 VARCHAR2 150 Reserved for future Inventory striping related functionality
INV_USER_DEF_ATTRIBUTE1 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE2 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE3 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE4 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE5 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE6 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE7 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE8 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE9 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE10 VARCHAR2 150 Reserved for user-definable Inventory striping information

Foreign Keys

Table Foreign Table Foreign Key Column
INV_RESERVATIONS_INTERFACE inv_org_parameters ORGANIZATION_ID
INV_RESERVATIONS_INTERFACE inv_lot_numbers INVENTORY_ITEM_ID, ORGANIZATION_ID, LOT_NUMBER
INV_RESERVATIONS_INTERFACE inv_lot_numbers INVENTORY_ITEM_ID, ORGANIZATION_ID, TO_LOT_NUMBER
INV_RESERVATIONS_INTERFACE inv_secondary_inventories SUBINVENTORY_CODE, ORGANIZATION_ID
INV_RESERVATIONS_INTERFACE inv_secondary_inventories TO_SUBINVENTORY_CODE, ORGANIZATION_ID
INV_RESERVATIONS_INTERFACE inv_item_locations LOCATOR_ID
INV_RESERVATIONS_INTERFACE inv_item_locations TO_LOCATOR_ID
INV_RESERVATIONS_INTERFACE inv_org_parameters TO_ORGANIZATION_ID
INV_RESERVATIONS_INTERFACE egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
INV_RESERVATIONS_INTERFACE inv_txn_source_types_b DEMAND_SOURCE_TYPE_ID
INV_RESERVATIONS_INTERFACE inv_txn_source_types_b TO_DEMAND_SOURCE_TYPE_ID
INV_RESERVATIONS_INTERFACE inv_txn_source_types_b SUPPLY_SOURCE_TYPE_ID
INV_RESERVATIONS_INTERFACE inv_txn_source_types_b TO_SUPPLY_SOURCE_TYPE_ID

Indexes

Index Uniqueness Tablespace Columns Status
INV_RESV_INTERFACE_U1 Unique FUSION_TS_INTERFACE RESERVATION_BATCH_ID, RESERVATION_INTERFACE_ID
INV_RSV_INTRFC_N1 Non Unique FUSION_TS_INTERFACE ORGANIZATION_ID, INVENTORY_ITEM_ID Obsolete
INV_RSV_INTRFC_N10 Non Unique FUSION_TS_INTERFACE LOCK_FLAG
INV_RSV_INTRFC_N11 Non Unique FUSION_TS_INTERFACE RESERVATION_ACTION_CODE
INV_RSV_INTRFC_N12 Non Unique FUSION_TS_INTERFACE TRANSACTION_MODE
INV_RSV_INTRFC_N13 Non Unique FUSION_TS_INTERFACE VALIDATION_FLAG
INV_RSV_INTRFC_N14 Non Unique FUSION_TS_INTERFACE PARTIAL_QUANTITIES_ALLOWED
INV_RSV_INTRFC_N15 Non Unique FUSION_TS_INTERFACE SHIP_READY_FLAG
INV_RSV_INTRFC_N16 Non Unique FUSION_TS_INTERFACE RESERVATION_INTERFACE_ID
INV_RSV_INTRFC_N2 Non Unique FUSION_TS_INTERFACE ORGANIZATION_ID, INVENTORY_ITEM_ID, REQUIREMENT_DATE
INV_RSV_INTRFC_N3 Non Unique FUSION_TS_INTERFACE DEMAND_SOURCE_TYPE_ID, DEMAND_SOURCE_NAME, DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE_ID
INV_RSV_INTRFC_N4 Non Unique FUSION_TS_INTERFACE TO_DEMAND_SOURCE_TYPE_ID, TO_DEMAND_SOURCE_NAME, TO_DEMAND_SOURCE_HEADER_ID, TO_DEMAND_SOURCE_LINE_ID
INV_RSV_INTRFC_N9 Non Unique FUSION_TS_INTERFACE ROW_STATUS_CODE