[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_RESERVATIONS_INTERFACE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  INV.MTL_RESERVATIONS_INTERFACE_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, RESERVATION_INTERFACE_ID
, RESERVATION_BATCH_ID
, REQUIREMENT_DATE
, ORGANIZATION_ID
, ORGANIZATION_CODE
, ORGANIZATION_NAME
, TO_ORGANIZATION_ID
, TO_ORGANIZATION_CODE
, TO_ORGANIZATION_NAME
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_DESCRIPTION
, 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_TYPE_DESCRIPTION
, DEMAND_SOURCE_NAME
, DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE_ID
, TO_DEMAND_SOURCE_TYPE_ID
, TO_DEMAND_SOURCE_TYPE_DESC
, 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
, SECONDARY_UOM_CODE
, SECONDARY_UOM_ID
, SECONDARY_RESERVATION_QUANTITY
, EXTERNAL_SOURCE_CODE
, EXTERNAL_SOURCE_LINE_ID
, SUPPLY_SOURCE_TYPE_ID
, SUPPLY_SOURCE_TYPE_DESCRIPTION
, SUPPLY_SOURCE_HEADER_ID
, SUPPLY_SOURCE_LINE_ID
, SUPPLY_SOURCE_LINE_DETAIL
, SUPPLY_SOURCE_NAME
, TO_SUPPLY_SOURCE_TYPE_ID
, TO_SUPPLY_SOURCE_TYPE_DESC
, 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
, ROW_STATUS_DESCRIPTION
, LOCK_FLAG
, RESERVATION_ACTION_CODE
, RESERVATION_ACTION_DESCRIPTION
, TRANSACTION_MODE
, TRANSACTION_MODE_DESCRIPTION
, 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
FROM APPS.MTL_RESERVATIONS_INTERFACE_V;
APPS
HR_ALL_ORGANIZATION_UNITS
MFG_LOOKUPS
MTL_PARAMETERS
MTL_RESERVATIONS_INTERFACE
MTL_SYSTEM_ITEMS
MTL_TXN_SOURCE_TYPES
APPS.MTL_RESERVATIONS_INTERFACE_V is not referenced by any database object
|
|
|
|