DBA Data[Home] [Help] [Dependency Information]


TABLE: INV.MTL_RESERVATIONS_INTERFACE

Object Details
Object Name: MTL_RESERVATIONS_INTERFACE
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_RESERVATIONS_INTERFACE
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_RESERVATIONS_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnRESERVATION_BATCH_ID
ColumnRESERVATION_INTERFACE_ID
MTL_RESERVATIONS_INTERFACE_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnLOCK_FLAG
MTL_RESERVATIONS_INTERFACE_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRESERVATION_ACTION_CODE
MTL_RESERVATIONS_INTERFACE_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRANSACTION_MODE
MTL_RESERVATIONS_INTERFACE_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnVALIDATION_FLAG
MTL_RESERVATIONS_INTERFACE_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARTIAL_QUANTITIES_ALLOWED
MTL_RESERVATIONS_INTERFACE_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSHIP_READY_FLAG
MTL_RESERVATIONS_INTERFACE_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRESERVATION_INTERFACE_ID
MTL_RESERVATIONS_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnREQUIREMENT_DATE
MTL_RESERVATIONS_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnDEMAND_SOURCE_TYPE_ID
ColumnDEMAND_SOURCE_NAME
ColumnDEMAND_SOURCE_HEADER_ID
ColumnDEMAND_SOURCE_LINE_ID
MTL_RESERVATIONS_INTERFACE_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTO_DEMAND_SOURCE_TYPE_ID
ColumnTO_DEMAND_SOURCE_NAME
ColumnTO_DEMAND_SOURCE_HEADER_ID
ColumnTO_DEMAND_SOURCE_LINE_ID
MTL_RESERVATIONS_INTERFACE_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSUPPLY_SOURCE_TYPE_ID
ColumnSUPPLY_SOURCE_HEADER_ID
ColumnSUPPLY_SOURCE_LINE_ID
ColumnSUPPLY_SOURCE_LINE_DETAIL
ColumnSUPPLY_SOURCE_NAME
MTL_RESERVATIONS_INTERFACE_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTO_SUPPLY_SOURCE_TYPE_ID
ColumnTO_SUPPLY_SOURCE_HEADER_ID
ColumnTO_SUPPLY_SOURCE_LINE_ID
ColumnTO_SUPPLY_SOURCE_LINE_DETAIL
ColumnTO_SUPPLY_SOURCE_NAME
MTL_RESERVATIONS_INTERFACE_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREVISION
ColumnLOT_NUMBER
ColumnSUBINVENTORY_CODE
ColumnLOCATOR_ID
MTL_RESERVATIONS_INTERFACE_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTO_REVISION
ColumnTO_LOT_NUMBER
ColumnTO_SUBINVENTORY_CODE
ColumnTO_LOCATOR_ID
MTL_RESERVATIONS_INTERFACE_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnROW_STATUS_CODE
Columns
Name Datatype Length Mandatory Comments
RESERVATION_INTERFACE_ID NUMBER
Yes Identifies a unique reservation request
RESERVATION_BATCH_ID NUMBER
Yes Identifies a group of reservation requests
REQUIREMENT_DATE DATE
Yes Required reservation date
ORGANIZATION_ID NUMBER
Yes Identifies organization in which reservation function is performed
TO_ORGANIZATION_ID NUMBER

For transfer and update reservations, the destination organization in which the reservation function is performed
INVENTORY_ITEM_ID NUMBER
Yes Identifies item reserved
ITEM_SEGMENT1 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT2 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT3 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT4 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT5 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT6 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT7 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT8 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT9 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT10 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT11 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT12 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT13 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT14 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT15 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT16 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT17 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT18 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT19 VARCHAR2 (40)
Item flexfield segment column
ITEM_SEGMENT20 VARCHAR2 (40)
Item flexfield segment column
DEMAND_SOURCE_TYPE_ID NUMBER
Yes Identifies demand source - Sales Order, Account, Account Alias, Inventory
DEMAND_SOURCE_NAME VARCHAR2 (30)
Identifier for inventory or user defined demand
DEMAND_SOURCE_HEADER_ID NUMBER

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: MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
DEMAND_SOURCE_LINE_ID NUMBER

Line identifier for demand source. For Sales Order: OE_ORDER_LINES.LINE_ID
TO_DEMAND_SOURCE_TYPE_ID NUMBER

For update and transfer reservation, identifies destination demand source - Sales Order, Account, Account Alias, Inventory.
TO_DEMAND_SOURCE_NAME VARCHAR2 (30)
For update and transfer reservation, identifier for inventory or user defined destination demand source.
TO_DEMAND_SOURCE_HEADER_ID NUMBER

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: MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
TO_DEMAND_SOURCE_LINE_ID NUMBER

For update and transfer reservation, Line identifier for destination demand source. For Sales Order: OE_ORDER_LINES.LINE_ID
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure of reserved item
PRIMARY_UOM_ID NUMBER

Not currently used
RESERVATION_UOM_CODE VARCHAR2 (3) Yes Unit of measure in which reservation is made.
RESERVATION_UOM_ID NUMBER

Not currently used
RESERVATION_QUANTITY NUMBER
Yes Quantity reserved in RESERVATION_UOM_CODE
PRIMARY_RESERVATION_QUANTITY NUMBER

Quantity reserved in PRIMARY_UOM_CODE
EXTERNAL_SOURCE_CODE VARCHAR2 (30)
Not currently used
EXTERNAL_SOURCE_LINE_ID NUMBER

Not currently used
SUPPLY_SOURCE_TYPE_ID NUMBER
Yes Indicates supply source of reservation.
SUPPLY_SOURCE_HEADER_ID NUMBER

Header identifier of Supply Source
SUPPLY_SOURCE_LINE_ID NUMBER

Indicates line identifier of Supply Source
SUPPLY_SOURCE_LINE_DETAIL NUMBER

Indicates line detail identifier of supply source
SUPPLY_SOURCE_NAME VARCHAR2 (30)
Indicates name of Supply Source
TO_SUPPLY_SOURCE_TYPE_ID NUMBER

For update and transfer of reservation, indicates destination supply source of reservation.
TO_SUPPLY_SOURCE_HEADER_ID NUMBER

For update and transfer of reservations, header identifier of destination supply source.
TO_SUPPLY_SOURCE_LINE_ID NUMBER

For transfer and update of reservations, indicates line identifier of destination supply source.
TO_SUPPLY_SOURCE_LINE_DETAIL NUMBER

For transfer and update of reservations, indicates line detail identifier of destination supply source.
TO_SUPPLY_SOURCE_NAME VARCHAR2 (30)
For transfer and update of reservations, indicates name of destination Supply Source.
ERROR_CODE NUMBER

Error code returned by Reservations Interface Manager
ERROR_EXPLANATION VARCHAR2 (240)
Error explanation text
REVISION VARCHAR2 (3)
Revision of revision controlled reserved item
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory in which reservation is made
SUBINVENTORY_ID NUMBER

Not currently used
LOCATOR_ID NUMBER

Identifies locator in which reservation is made.
LOC_SEGMENT1 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT2 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT3 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT4 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT5 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT6 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT7 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT8 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT9 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT10 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT11 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT12 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT13 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT14 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT15 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT16 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT17 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT18 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT19 VARCHAR2 (40)
Locator flexfield segment column
LOC_SEGMENT20 VARCHAR2 (40)
Locator flexfield segment column
LOT_NUMBER VARCHAR2 (80)
Lot number of lot controlled reserved item.
LOT_NUMBER_ID NUMBER

Not currently used
SERIAL_NUMBER VARCHAR2 (30)
Not used
SERIAL_NUMBER_ID NUMBER

Not currently used
TO_REVISION VARCHAR2 (3)
For update and transfer reservation, destination revision of revision controlled reserved item
TO_SUBINVENTORY_CODE VARCHAR2 (10)
For update and transfer reservation, destination subinventory in which reservation is made.
TO_SUBINVENTORY_ID NUMBER

Not currently used
TO_LOCATOR_ID NUMBER

For update and transfer reservation, identifies locator in which reservation is made.
TO_LOC_SEGMENT1 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT2 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT3 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT4 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT5 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT6 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT7 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT8 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT9 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT10 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT11 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT12 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT13 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT14 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT15 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT16 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT17 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT18 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT19 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOC_SEGMENT20 VARCHAR2 (40)
For transfer and update reservation, destination locator flexfield segment column
TO_LOT_NUMBER VARCHAR2 (80)
For update and transfer reservation, destination lot number of lot controlled reserved item.
TO_LOT_NUMBER_ID NUMBER

Not currently used
TO_SERIAL_NUMBER VARCHAR2 (30)
Not currently used
TO_SERIAL_NUMBER_ID NUMBER

Not currently used
ROW_STATUS_CODE NUMBER
Yes Indicates status of request - Active, Inactive, Error
LOCK_FLAG NUMBER

Indicates request is locked. This is to prevent the request from being picked by another manager.
RESERVATION_ACTION_CODE NUMBER
Yes Indicates reservation function requested
TRANSACTION_MODE NUMBER
Yes Fflag to indicate processing mode: 1 - Online; 2 - Immediate Concurrent; 3 - Batch
VALIDATION_FLAG NUMBER

Flag to indicate if row needs to be validated before being processed.
PARTIAL_QUANTITIES_ALLOWED NUMBER

Flag to indicate if partial reservations are permitted
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
PROJECT_ID NUMBER

Not currently used
TASK_ID NUMBER

Not currently used
PROJECT_PLANNING_GROUP NUMBER

Not currently used
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
SHIP_READY_FLAG NUMBER

Flag to indicate if reservation has to be updated to ready to be shipped.
LPN_ID NUMBER

LPN Identifier
TO_LPN_ID NUMBER

TO_LPN Identifier
SECONDARY_RESERVATION_QUANTITY NUMBER

Reservation Quantity Recorded in the Secondary Unit Of Measure
SECONDARY_UOM_CODE VARCHAR2 (3)
Items Secondary Unit Of Measure Code
SECONDARY_UOM_ID NUMBER

Not Currently Used
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

INV.MTL_RESERVATIONS_INTERFACE does not reference any database object

INV.MTL_RESERVATIONS_INTERFACE is referenced by following:

SchemaINV
ViewMTL_RESERVATIONS_INTERFACE#