[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_CROSS_REFERENCES_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_CROSS_REFERENCES_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
MTL_CROSS_REFERENCES_INTERFACE temporarily stores cross reference type
codes assigned to inventory items before loading this information into
Oracle Inventory. The cross reference type code provides cross
referencing from the item to any other identification system that is
relevant. This can include references to old item identification
schemes, to vendor item identification, etc. Each inventory item can
be assigned any number of cross reference type codes.
.
Additionally, each cross reference is designated as multi-org or not.
If the cross reference is multi-org, then the cross reference is
valid across the organization hierarchy. Otherwise, the cross
reference holds only for the organization specified.
.
This table contains user friendly columns which allow you to easily
enter your data as well as their corresponding foreign keys. Oracle
Inventory will default column values you do not enter, after
performing the proper validation. For example, you enter the
ITEM_NUMBER, and Oracle Inventory will fill in the corresponding
INVENTORY_ITEM_ID for you.
This table is currently not used.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| CROSS_REFERENCE_TYPE | VARCHAR2 | (25) | Cross reference type | |
| CROSS_REFERENCE | VARCHAR2 | (25) | Cross reference designator | |
| 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 | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| DESCRIPTION | VARCHAR2 | (240) | Cross reference description | |
| ORG_INDEPENDENT_FLAG | VARCHAR2 | (1) | Flag indicating organization independence | |
| REQUEST_ID | NUMBER | Concurrent who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent who column | ||
| PROGRAM_ID | NUMBER | Concurrent who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
| TRANSACTION_ID | NUMBER | Row identifier | ||
| PROCESS_FLAG | NUMBER | Row status | ||
| ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
| ITEM_NUMBER | VARCHAR2 | (81) | Concatenated item segments | |
| 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 | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
| UOM_CODE | VARCHAR2 | (3) | ucc/ean-128 CHANGES FOR 11.5.10 | |
| REVISION_ID | NUMBER | UCC/EAn-128 changes for 11.5.10 | ||
| UNIT_OF_MEASURE_TL | VARCHAR2 | (25) | UCC/EAN-128 changes for 11.5.10 | |
| UOM_LANGUAGE | VARCHAR2 | (4) | UCC/EAN-128 changes for 11.5.10 | |
| REVISION | VARCHAR2 | (3) | UCC/EAN-128 changes for 11.5.10 |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, CROSS_REFERENCE_TYPE
, CROSS_REFERENCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTION
, ORG_INDEPENDENT_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TRANSACTION_ID
, PROCESS_FLAG
, ORGANIZATION_CODE
, ITEM_NUMBER
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, UOM_CODE
, REVISION_ID
, UNIT_OF_MEASURE_TL
, UOM_LANGUAGE
, REVISION
FROM INV.MTL_CROSS_REFERENCES_INTERFACE;
INV.MTL_CROSS_REFERENCES_INTERFACE does not reference any database object
INV.MTL_CROSS_REFERENCES_INTERFACE is referenced by following:
APPS
MTL_CROSS_REFERENCES_INTERFACE
|
|
|
|