[Home] [Help] [Dependency Information]
Object Name: | MRP_AD_ITEM_RELATIONSHIPS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Id of substituted Item | ||
RELATED_ITEM_ID | NUMBER | Id of substitutuing Item | ||
ORGANIZATION_ID | NUMBER | |||
RELATIONSHIP_TYPE_ID | NUMBER | relationship type2-substitution,5-Sevice,8- supersession,18- repair to | ||
RN | NUMBER | Refresh Number | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, RELATED_ITEM_ID
, ORGANIZATION_ID
, RELATIONSHIP_TYPE_ID
, RN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
FROM MRP.MRP_AD_ITEM_RELATIONSHIPS;
MRP.MRP_AD_ITEM_RELATIONSHIPS does not reference any database object
MRP.MRP_AD_ITEM_RELATIONSHIPS is referenced by following:
|
|
|