[Home] [Help] [Dependency Information]
Object Name: | MRP_COMPONENT_SUBSTITUTES |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_COMPONENT_SUBSTITUTES |
Subobject Name: | |
Status: | VALID |
MRP_COMPONENT_SUBSTITUTES stores items that can be used in place of a
primary component on a bill of material. INVENTORY_ITEM_ID is the
primary component identifier and SUBSTITUTE_ITEM_ID is the substitute
component identifier. This information is for reporting purposes
only, and does not affect the plan. This table is populated during
the Snapshot, and is derived from BOM_SUBSTITUTE_COMPONENTS.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_COMPONENT_SUBSTITUTES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
COMPILE_DESIGNATOR INVENTORY_ITEM_ID USING_ASSEMBLY_ITEM_ID SUBSTITUTE_ITEM_ID OPERATION_SEQ_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | MPS, MRP or DRP plan identifier |
USING_ASSEMBLY_ITEM_ID | NUMBER | Yes | Using assembly item identifier | |
SUBSTITUTE_ITEM_ID | NUMBER | Yes | Substitute inventory item identifier | |
OPERATION_SEQ_NUM | NUMBER | Yes | Manufacturing operation sequence number | |
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 | ||
ITEM_QUANTITY | NUMBER | Component substitute part quantity | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
, USING_ASSEMBLY_ITEM_ID
, SUBSTITUTE_ITEM_ID
, OPERATION_SEQ_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ITEM_QUANTITY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM MRP.MRP_COMPONENT_SUBSTITUTES;
MRP.MRP_COMPONENT_SUBSTITUTES does not reference any database object
MRP.MRP_COMPONENT_SUBSTITUTES is referenced by following:
|
|
|