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


VIEW: INV.MTL_RESERVATIONS_INTERFACE#

Object Details
Object Name: MTL_RESERVATIONS_INTERFACE#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESERVATION_INTERFACE_ID NUMBER
Yes
RESERVATION_BATCH_ID NUMBER
Yes
REQUIREMENT_DATE DATE
Yes
ORGANIZATION_ID NUMBER
Yes
TO_ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER
Yes
ITEM_SEGMENT1 VARCHAR2 (40)
ITEM_SEGMENT2 VARCHAR2 (40)
ITEM_SEGMENT3 VARCHAR2 (40)
ITEM_SEGMENT4 VARCHAR2 (40)
ITEM_SEGMENT5 VARCHAR2 (40)
ITEM_SEGMENT6 VARCHAR2 (40)
ITEM_SEGMENT7 VARCHAR2 (40)
ITEM_SEGMENT8 VARCHAR2 (40)
ITEM_SEGMENT9 VARCHAR2 (40)
ITEM_SEGMENT10 VARCHAR2 (40)
ITEM_SEGMENT11 VARCHAR2 (40)
ITEM_SEGMENT12 VARCHAR2 (40)
ITEM_SEGMENT13 VARCHAR2 (40)
ITEM_SEGMENT14 VARCHAR2 (40)
ITEM_SEGMENT15 VARCHAR2 (40)
ITEM_SEGMENT16 VARCHAR2 (40)
ITEM_SEGMENT17 VARCHAR2 (40)
ITEM_SEGMENT18 VARCHAR2 (40)
ITEM_SEGMENT19 VARCHAR2 (40)
ITEM_SEGMENT20 VARCHAR2 (40)
DEMAND_SOURCE_TYPE_ID NUMBER
Yes
DEMAND_SOURCE_NAME VARCHAR2 (30)
DEMAND_SOURCE_HEADER_ID NUMBER

DEMAND_SOURCE_LINE_ID NUMBER

TO_DEMAND_SOURCE_TYPE_ID NUMBER

TO_DEMAND_SOURCE_NAME VARCHAR2 (30)
TO_DEMAND_SOURCE_HEADER_ID NUMBER

TO_DEMAND_SOURCE_LINE_ID NUMBER

PRIMARY_UOM_CODE VARCHAR2 (3)
PRIMARY_UOM_ID NUMBER

RESERVATION_UOM_CODE VARCHAR2 (3) Yes
RESERVATION_UOM_ID NUMBER

RESERVATION_QUANTITY NUMBER
Yes
PRIMARY_RESERVATION_QUANTITY NUMBER

EXTERNAL_SOURCE_CODE VARCHAR2 (30)
EXTERNAL_SOURCE_LINE_ID NUMBER

SUPPLY_SOURCE_TYPE_ID NUMBER
Yes
SUPPLY_SOURCE_HEADER_ID NUMBER

SUPPLY_SOURCE_LINE_ID NUMBER

SUPPLY_SOURCE_LINE_DETAIL NUMBER

SUPPLY_SOURCE_NAME VARCHAR2 (30)
TO_SUPPLY_SOURCE_TYPE_ID NUMBER

TO_SUPPLY_SOURCE_HEADER_ID NUMBER

TO_SUPPLY_SOURCE_LINE_ID NUMBER

TO_SUPPLY_SOURCE_LINE_DETAIL NUMBER

TO_SUPPLY_SOURCE_NAME VARCHAR2 (30)
ERROR_CODE NUMBER

ERROR_EXPLANATION VARCHAR2 (240)
REVISION VARCHAR2 (3)
SUBINVENTORY_CODE VARCHAR2 (10)
SUBINVENTORY_ID NUMBER

LOCATOR_ID NUMBER

LOC_SEGMENT1 VARCHAR2 (40)
LOC_SEGMENT2 VARCHAR2 (40)
LOC_SEGMENT3 VARCHAR2 (40)
LOC_SEGMENT4 VARCHAR2 (40)
LOC_SEGMENT5 VARCHAR2 (40)
LOC_SEGMENT6 VARCHAR2 (40)
LOC_SEGMENT7 VARCHAR2 (40)
LOC_SEGMENT8 VARCHAR2 (40)
LOC_SEGMENT9 VARCHAR2 (40)
LOC_SEGMENT10 VARCHAR2 (40)
LOC_SEGMENT11 VARCHAR2 (40)
LOC_SEGMENT12 VARCHAR2 (40)
LOC_SEGMENT13 VARCHAR2 (40)
LOC_SEGMENT14 VARCHAR2 (40)
LOC_SEGMENT15 VARCHAR2 (40)
LOC_SEGMENT16 VARCHAR2 (40)
LOC_SEGMENT17 VARCHAR2 (40)
LOC_SEGMENT18 VARCHAR2 (40)
LOC_SEGMENT19 VARCHAR2 (40)
LOC_SEGMENT20 VARCHAR2 (40)
LOT_NUMBER VARCHAR2 (80)
LOT_NUMBER_ID NUMBER

SERIAL_NUMBER VARCHAR2 (30)
SERIAL_NUMBER_ID NUMBER

TO_REVISION VARCHAR2 (3)
TO_SUBINVENTORY_CODE VARCHAR2 (10)
TO_SUBINVENTORY_ID NUMBER

TO_LOCATOR_ID NUMBER

TO_LOC_SEGMENT1 VARCHAR2 (40)
TO_LOC_SEGMENT2 VARCHAR2 (40)
TO_LOC_SEGMENT3 VARCHAR2 (40)
TO_LOC_SEGMENT4 VARCHAR2 (40)
TO_LOC_SEGMENT5 VARCHAR2 (40)
TO_LOC_SEGMENT6 VARCHAR2 (40)
TO_LOC_SEGMENT7 VARCHAR2 (40)
TO_LOC_SEGMENT8 VARCHAR2 (40)
TO_LOC_SEGMENT9 VARCHAR2 (40)
TO_LOC_SEGMENT10 VARCHAR2 (40)
TO_LOC_SEGMENT11 VARCHAR2 (40)
TO_LOC_SEGMENT12 VARCHAR2 (40)
TO_LOC_SEGMENT13 VARCHAR2 (40)
TO_LOC_SEGMENT14 VARCHAR2 (40)
TO_LOC_SEGMENT15 VARCHAR2 (40)
TO_LOC_SEGMENT16 VARCHAR2 (40)
TO_LOC_SEGMENT17 VARCHAR2 (40)
TO_LOC_SEGMENT18 VARCHAR2 (40)
TO_LOC_SEGMENT19 VARCHAR2 (40)
TO_LOC_SEGMENT20 VARCHAR2 (40)
TO_LOT_NUMBER VARCHAR2 (80)
TO_LOT_NUMBER_ID NUMBER

TO_SERIAL_NUMBER VARCHAR2 (30)
TO_SERIAL_NUMBER_ID NUMBER

ROW_STATUS_CODE NUMBER
Yes
LOCK_FLAG NUMBER

RESERVATION_ACTION_CODE NUMBER
Yes
TRANSACTION_MODE NUMBER
Yes
VALIDATION_FLAG NUMBER

PARTIAL_QUANTITIES_ALLOWED NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PROJECT_ID NUMBER

TASK_ID NUMBER

PROJECT_PLANNING_GROUP NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SHIP_READY_FLAG NUMBER

LPN_ID NUMBER

TO_LPN_ID NUMBER

SECONDARY_RESERVATION_QUANTITY NUMBER

SECONDARY_UOM_CODE VARCHAR2 (3)
SECONDARY_UOM_ID NUMBER

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# references the following:

SchemaINV
TableMTL_RESERVATIONS_INTERFACE
INV.MTL_RESERVATIONS_INTERFACE# is referenced by following:

SchemaAPPS
SynonymMTL_RESERVATIONS_INTERFACE