View: BOM_SUB_COMPS_QF_V

Product:	BOM - Bills of Material
Description:	View for substitute components list of values
Implementation/DBA Data:	APPS.BOM_SUB_COMPS_QF_V

View Text

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

Columns