[Home] [Help] [Dependency Information]
Object Name: | MSD_DEM_MODEL_BOM_COMPONENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CTO_CODE | VARCHAR2 | (2084) | ||
CTO_CHILD_CODE | VARCHAR2 | (2041) | ||
CTO_PARENT_CODE | VARCHAR2 | (2000) | ||
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 | |||
CTO_TYPE | VARCHAR2 | (4000) | ||
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 | |||
COMPONENT_QTY | NUMBER | |||
OPTIONAL_FLAG | NUMBER | |||
ATO_FORECAST_CONTROL | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CTO_CODE
, CTO_CHILD_CODE
, CTO_PARENT_CODE
, BASE_MODEL_CODE
, PARENT_ITEM_CODE
, OPTION_CODE
, ORG_CODE
, EFFECTIVITY_DATE
, DISABLE_DATE
, PLNG_PCT_EXISTING
, CTO_TYPE
, BASE_MODEL_ID
, TOP_ATO_MODEL_ID
, PARENT_ITEM_ID
, OPTION_ID
, BASE_MODEL_SR_ID
, PARENT_ITEM_SR_ID
, OPTION_SR_ID
, COMPONENT_QTY
, OPTIONAL_FLAG
, ATO_FORECAST_CONTROL
FROM APPS.MSD_DEM_MODEL_BOM_COMPONENTS_V;
|
|
|