DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MSD_DEM_MODEL_BOM_COMPONENTS_V

Object Details
Object Name: MSD_DEM_MODEL_BOM_COMPONENTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.MSD_DEM_MODEL_BOM_COMPONENTS_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMSC_SYSTEM_ITEMS
SynonymMSC_TRADING_PARTNERS
PL/SQL PackageMSD_DEM_COMMON_UTILITIES - show dependent code
SynonymMSD_DEM_MODEL_BOM_COMPONENTS
SchemaPUBLIC
SynonymDUAL
APPS.MSD_DEM_MODEL_BOM_COMPONENTS_V is referenced by following:

SchemaAPPS
Package BodyMSD_DEM_CTO - show dependent code