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.

VIEW: APPS.BOM_SUB_COMPS_QF_V

Source

View Text - Preformatted


SELECT BSC.SUBSTITUTE_COMPONENT_ID , BSC.COMPONENT_SEQUENCE_ID , BSC.ACD_TYPE , MIF.ITEM_NUMBER , MIF.DESCRIPTION FROM BOM_SUBSTITUTE_COMPONENTS BSC , BOM_INVENTORY_COMPONENTS BIC , BOM_BILL_OF_MATERIALS BOM , MTL_ITEM_FLEXFIELDS MIF WHERE BSC.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID AND BIC.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID AND BOM.ORGANIZATION_ID = MIF.ORGANIZATION_ID AND BSC.SUBSTITUTE_COMPONENT_ID = MIF.INVENTORY_ITEM_ID AND NVL(BSC.ACD_TYPE, 1) <> 3

View Text - HTML Formatted

SELECT BSC.SUBSTITUTE_COMPONENT_ID
, BSC.COMPONENT_SEQUENCE_ID
, BSC.ACD_TYPE
, MIF.ITEM_NUMBER
, MIF.DESCRIPTION
FROM BOM_SUBSTITUTE_COMPONENTS BSC
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BOM
, MTL_ITEM_FLEXFIELDS MIF
WHERE BSC.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
AND BIC.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID
AND BOM.ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND BSC.SUBSTITUTE_COMPONENT_ID = MIF.INVENTORY_ITEM_ID
AND NVL(BSC.ACD_TYPE
, 1) <> 3