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: MSC.MSC_BOM_TEMP#

Source

View Text - Preformatted


select SESSION_ID SESSION_ID, ASSEMBLY_IDENTIFIER ASSEMBLY_IDENTIFIER, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, COMPONENT_IDENTIFIER COMPONENT_IDENTIFIER, COMPONENT_ITEM_ID COMPONENT_ITEM_ID, QUANTITY QUANTITY, FIXED_LT FIXED_LT, VARIABLE_LT VARIABLE_LT, EFFECTIVE_DATE EFFECTIVE_DATE, DISABLE_DATE DISABLE_DATE, ATP_CHECK ATP_CHECK, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, SMC_FLAG SMC_FLAG, PRE_PROCESS_LT PRE_PROCESS_LT, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, ATP_FLAG ATP_FLAG from "MSC"."MSC_BOM_TEMP"

View Text - HTML Formatted

SELECT SESSION_ID SESSION_ID
, ASSEMBLY_IDENTIFIER ASSEMBLY_IDENTIFIER
, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID
, COMPONENT_IDENTIFIER COMPONENT_IDENTIFIER
, COMPONENT_ITEM_ID COMPONENT_ITEM_ID
, QUANTITY QUANTITY
, FIXED_LT FIXED_LT
, VARIABLE_LT VARIABLE_LT
, EFFECTIVE_DATE EFFECTIVE_DATE
, DISABLE_DATE DISABLE_DATE
, ATP_CHECK ATP_CHECK
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, SMC_FLAG SMC_FLAG
, PRE_PROCESS_LT PRE_PROCESS_LT
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, ATP_FLAG ATP_FLAG
FROM "MSC"."MSC_BOM_TEMP"