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 |