[Home] [Help]
[Dependency Information]
VIEW: MSD.MSD_SPF_MODEL_BOM_COMPONENTS#
Object Details
Object Name: | MSD_SPF_MODEL_BOM_COMPONENTS# |
Object Type: | VIEW |
Owner: | MSD |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
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 |
|
|
|
Query Text
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#;
Dependencies
[top of page]
MSD.MSD_SPF_MODEL_BOM_COMPONENTS# references the following:
-
MSD
-
MSD_SPF_MODEL_BOM_COMPONENTS
MSD.MSD_SPF_MODEL_BOM_COMPONENTS# is referenced by following:
-
APPS
-
MSD_SPF_MODEL_BOM_COMPONENTS