DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_INVENTORY_COMPONENTS

Line 1091: FROM bom_inventory_components bic

1087: WHERE bill_sequence_id = p_bom_head_unexp_rec.source_bill_sequence_id;
1088:
1089: SELECT count(*)
1090: INTO l_count
1091: FROM bom_inventory_components bic
1092: WHERE bic.bill_sequence_id = p_bom_head_unexp_rec.source_bill_sequence_id
1093: AND nvl(bic.disable_date, sysdate + 1) >= sysdate --- Bug: 3448641
1094: AND not exists
1095: (SELECT 'x'

Line 1227: FROM bom_inventory_components bic,

1223: --
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

Line 1355: FROM bom_inventory_components bic

1351: WHERE bill_sequence_id = p_bom_head_unexp_rec.source_bill_sequence_id;
1352:
1353: SELECT count(*)
1354: INTO l_count
1355: FROM bom_inventory_components bic
1356: WHERE bic.bill_sequence_id = p_bom_head_unexp_rec.source_bill_sequence_id
1357: AND nvl(bic.disable_date, sysdate + 1) >= sysdate
1358: AND not exists
1359: (SELECT 'x'

Line 1427: FROM bom_inventory_components bic,

1423: --
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