[Home] [Help] [Dependency Information]
Object Name: | MSD_SPF_MODEL_BOM_COMPONENTS |
---|---|
Object Type: | TABLE |
Owner: | MSD |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSD_SPF_MODEL_BOM_COMPS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
EBS_BASE_MODEL_SR_PK
DM_ITEM_SR_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INSTANCE_ID | NUMBER | |||
EBS_BASE_MODEL_SR_PK | NUMBER | |||
DM_ITEM_SR_PK | NUMBER | |||
LATEST_REV | NUMBER | |||
CHAIN_ID | NUMBER | |||
EFFECTIVE_DATE | DATE | |||
DISABLE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT SR_INSTANCE_ID
, EBS_BASE_MODEL_SR_PK
, DM_ITEM_SR_PK
, LATEST_REV
, CHAIN_ID
, EFFECTIVE_DATE
, DISABLE_DATE
FROM MSD.MSD_SPF_MODEL_BOM_COMPONENTS;
MSD.MSD_SPF_MODEL_BOM_COMPONENTS does not reference any database object
MSD.MSD_SPF_MODEL_BOM_COMPONENTS is referenced by following:
|
|
|