[Home] [Help] [Dependency Information]
Object Name: | MTL_RTG_ITEM_REVS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_RTG_ITEM_REVS_INTERFACE |
Subobject Name: | |
Status: | VALID |
MTL_RTG_ITEM_REVS_INTERFACE temporarily stores routing revisions
before loading this information into Oracle Inventory. This table
contains user friendly columns which allow you to easily enter your
data as well as the corresponding foreign keys. Oracle Inventory
will derive column values you do not enter, after performing the
proper validation. For example, if you enter the ORGANIZATION_CODE,
Oracle Inventory will fill in the corresponding ORGANIZATION_ID for
you.
.
This is used by the BOM product.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_RTG_ITEM_REVS_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | TRANSACTION_ID |
MTL_RTG_ITEM_REVS_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ORGANIZATION_ID
INVENTORY_ITEM_ID PROCESS_REVISION |
MTL_RTG_ITEM_REVS_INTERFACE_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
PROCESS_REVISION | VARCHAR2 | (3) | Routing revision code | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
CHANGE_NOTICE | VARCHAR2 | (10) | Engineering change order number | |
ECN_INITIATION_DATE | DATE | ECO initiation date | ||
IMPLEMENTATION_DATE | DATE | ECO implementation date | ||
IMPLEMENTED_SERIAL_NUMBER | VARCHAR2 | (30) | (no longer used) | |
EFFECTIVITY_DATE | DATE | Revision effectivity date | ||
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 | |
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 | ||
INVENTORY_ITEM_NUMBER | VARCHAR2 | (81) | Concatenated item segments | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Abbreviated organization name | |
TRANSACTION_ID | NUMBER | Interface record identifier | ||
PROCESS_FLAG | NUMBER | Interface record processing status | ||
TRANSACTION_TYPE | VARCHAR2 | (10) | Specifies a type of transaction to be performed on the interface record (e.g. CREATE) | |
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original System Reference | |
BATCH_ID | NUMBER | BATCH_ID |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, PROCESS_REVISION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CHANGE_NOTICE
, ECN_INITIATION_DATE
, IMPLEMENTATION_DATE
, IMPLEMENTED_SERIAL_NUMBER
, EFFECTIVITY_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INVENTORY_ITEM_NUMBER
, ORGANIZATION_CODE
, TRANSACTION_ID
, PROCESS_FLAG
, TRANSACTION_TYPE
, ORIGINAL_SYSTEM_REFERENCE
, BATCH_ID
FROM INV.MTL_RTG_ITEM_REVS_INTERFACE;
INV.MTL_RTG_ITEM_REVS_INTERFACE does not reference any database object
INV.MTL_RTG_ITEM_REVS_INTERFACE is referenced by following:
|
|
|