DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 1163: bom_substitute_components bsc

1159: BEGIN
1160: SELECT count(*)
1161: INTO l_count
1162: FROM bom_inventory_components bic,
1163: bom_substitute_components bsc
1164: WHERE bic.bill_sequence_id =p_bom_head_unexp_rec.source_bill_sequence_id
1165: AND bic.component_sequence_id = bsc.component_sequence_id
1166: AND bsc.substitute_component_id not in
1167: (select msi1.inventory_item_id