DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 1228: bom_substitute_components bsc

1224: BEGIN
1225: SELECT count(*)
1226: INTO l_count
1227: FROM bom_inventory_components bic,
1228: bom_substitute_components bsc
1229: WHERE bic.bill_sequence_id =p_bom_head_unexp_rec.source_bill_sequence_id
1230: AND bic.component_sequence_id = bsc.component_sequence_id
1231: AND bsc.substitute_component_id not in
1232: (select msi1.inventory_item_id

Line 1428: bom_substitute_components bsc

1424: BEGIN
1425: SELECT count(*)
1426: INTO l_count
1427: FROM bom_inventory_components bic,
1428: bom_substitute_components bsc
1429: WHERE bic.bill_sequence_id =p_bom_head_unexp_rec.source_bill_sequence_id
1430: AND bic.component_sequence_id = bsc.component_sequence_id
1431: AND bsc.substitute_component_id not in
1432: (select msi1.inventory_item_id