APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 3090: FROM BOM_SUBSTITUTE_COMPONENTS BSCI2

3086: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
3087: OR ( p_batch_id = BSCI.batch_id )
3088: )
3089: AND exists (SELECT 'x'
3090: FROM BOM_SUBSTITUTE_COMPONENTS BSCI2
3091: WHERE BSCI2.COMPONENT_SEQUENCE_ID = BSCI.COMPONENT_SEQUENCE_ID
3092: AND NVL(BSCI2.ACD_TYPE, 1) = NVL(BSCI.ACD_TYPE, 1) );
3093:
3094: /*Update the transaction_types */