[Home] [Help] [Dependency Information]
Object Name: | MSD_DEM_CTO_BOM# |
---|---|
Object Type: | VIEW |
Owner: | MSD |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BASE_MODEL_ID | NUMBER | |||
TOP_ATO_MODEL_ID | NUMBER | |||
PARENT_ITEM_ID | NUMBER | |||
OPTION_ID | NUMBER | |||
BASE_MODEL_SR_ID | NUMBER | |||
PARENT_ITEM_SR_ID | NUMBER | |||
OPTION_SR_ID | NUMBER | |||
BASE_MODEL_CODE | VARCHAR2 | (250) | ||
PARENT_ITEM_CODE | VARCHAR2 | (250) | ||
OPTION_CODE | VARCHAR2 | (250) | ||
ORG_CODE | VARCHAR2 | (7) | ||
EFFECTIVITY_DATE | DATE | |||
DISABLE_DATE | DATE | |||
PLNG_PCT_EXISTING | NUMBER | |||
ATO_FORECAST_CONTROL | NUMBER | |||
CTO_TYPE | VARCHAR2 | (120) | ||
COMPONENT_QTY | NUMBER | |||
OPTIONAL_FLAG | NUMBER | |||
CTO_START_DATE | DATE | |||
CTO_END_DATE | DATE | |||
CTO_CODE | VARCHAR2 | (2000) | ||
CTO_CHILD_CODE | VARCHAR2 | (2000) | ||
CTO_PARENT_CODE | VARCHAR2 | (2000) |
Cut, paste (and edit) the following text to query this object:
SELECT BASE_MODEL_ID
, TOP_ATO_MODEL_ID
, PARENT_ITEM_ID
, OPTION_ID
, BASE_MODEL_SR_ID
, PARENT_ITEM_SR_ID
, OPTION_SR_ID
, BASE_MODEL_CODE
, PARENT_ITEM_CODE
, OPTION_CODE
, ORG_CODE
, EFFECTIVITY_DATE
, DISABLE_DATE
, PLNG_PCT_EXISTING
, ATO_FORECAST_CONTROL
, CTO_TYPE
, COMPONENT_QTY
, OPTIONAL_FLAG
, CTO_START_DATE
, CTO_END_DATE
, CTO_CODE
, CTO_CHILD_CODE
, CTO_PARENT_CODE
FROM MSD.MSD_DEM_CTO_BOM#;
|
|
|