[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_MFG_PART_NUMBERS |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_MFG_PART_NUMBERS
|
| Subobject Name: | |
| Status: | VALID |
MTL_MFG_PART_NUMBERS stores the cross reference between an item
defined in Oracle Inventory and the part number used by its
manufacturer. This information can be used to perform item searches
by manufacturer part number.
.
Manufacturer part number references are defined for an item in the
item master organization.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_MFG_PART_NUMBERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ORGANIZATION_ID
MANUFACTURER_ID
INVENTORY_ITEM_ID
MFG_PART_NUM
|
| MTL_MFG_PART_NUMBERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MANUFACTURER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MANUFACTURER_ID | NUMBER | Yes | Manufacturer identifier | |
| MFG_PART_NUM | VARCHAR2 | (150) | Yes | Manufacturer's part number |
| INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
| 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 | ||
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| MRP_PLANNING_CODE | NUMBER | (not currently used) | ||
| DESCRIPTION | VARCHAR2 | (240) | (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 | |
| 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 | ||
| START_DATE | DATE | 11.5.10 PLM requirement | ||
| END_DATE | DATE | 11.5.10 PLM requirement | ||
| FIRST_ARTICLE_STATUS | VARCHAR2 | (30) | 11.5.10 PLM requirement | |
| APPROVAL_STATUS | VARCHAR2 | (30) | 11.5.10 PLM requirement |
Cut, paste (and edit) the following text to query this object:
SELECT MANUFACTURER_ID
, MFG_PART_NUM
, INVENTORY_ITEM_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, MRP_PLANNING_CODE
, DESCRIPTION
, 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
, START_DATE
, END_DATE
, FIRST_ARTICLE_STATUS
, APPROVAL_STATUS
FROM INV.MTL_MFG_PART_NUMBERS;
INV.MTL_MFG_PART_NUMBERS does not reference any database object
INV.MTL_MFG_PART_NUMBERS is referenced by following:
APPS
EGO_MTL_MFG_PART_NUMBERS_TR1
MTL_MFG_PART_NUMBERS
|
|
|
|