eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: MSD.MSD_DEM_CTO_BOM#

Source

View Text - Preformatted


select BASE_MODEL_ID BASE_MODEL_ID, TOP_ATO_MODEL_ID TOP_ATO_MODEL_ID, PARENT_ITEM_ID PARENT_ITEM_ID, OPTION_ID OPTION_ID, BASE_MODEL_SR_ID BASE_MODEL_SR_ID, PARENT_ITEM_SR_ID PARENT_ITEM_SR_ID, OPTION_SR_ID OPTION_SR_ID, BASE_MODEL_CODE BASE_MODEL_CODE, PARENT_ITEM_CODE PARENT_ITEM_CODE, OPTION_CODE OPTION_CODE, ORG_CODE ORG_CODE, EFFECTIVITY_DATE EFFECTIVITY_DATE, DISABLE_DATE DISABLE_DATE, PLNG_PCT_EXISTING PLNG_PCT_EXISTING, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL, CTO_TYPE CTO_TYPE, COMPONENT_QTY COMPONENT_QTY, OPTIONAL_FLAG OPTIONAL_FLAG, CTO_START_DATE CTO_START_DATE, CTO_END_DATE CTO_END_DATE, CTO_CODE CTO_CODE, CTO_CHILD_CODE CTO_CHILD_CODE, CTO_PARENT_CODE CTO_PARENT_CODE from "MSD"."MSD_DEM_CTO_BOM"

View Text - HTML Formatted

SELECT BASE_MODEL_ID BASE_MODEL_ID
, TOP_ATO_MODEL_ID TOP_ATO_MODEL_ID
, PARENT_ITEM_ID PARENT_ITEM_ID
, OPTION_ID OPTION_ID
, BASE_MODEL_SR_ID BASE_MODEL_SR_ID
, PARENT_ITEM_SR_ID PARENT_ITEM_SR_ID
, OPTION_SR_ID OPTION_SR_ID
, BASE_MODEL_CODE BASE_MODEL_CODE
, PARENT_ITEM_CODE PARENT_ITEM_CODE
, OPTION_CODE OPTION_CODE
, ORG_CODE ORG_CODE
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, DISABLE_DATE DISABLE_DATE
, PLNG_PCT_EXISTING PLNG_PCT_EXISTING
, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL
, CTO_TYPE CTO_TYPE
, COMPONENT_QTY COMPONENT_QTY
, OPTIONAL_FLAG OPTIONAL_FLAG
, CTO_START_DATE CTO_START_DATE
, CTO_END_DATE CTO_END_DATE
, CTO_CODE CTO_CODE
, CTO_CHILD_CODE CTO_CHILD_CODE
, CTO_PARENT_CODE CTO_PARENT_CODE
FROM "MSD"."MSD_DEM_CTO_BOM"