APPS.BOM_VAL_TO_ID dependencies on BOM_BILL_OF_MATERIALS

Line 40: bom_bill_of_materials WHERE

36: FUNCTION Get_BOM_Implementation_Date(p_bill_seq_id IN NUMBER)
37: RETURN DATE
38: IS
39: CURSOR c1 IS SELECT implementation_date FROM
40: bom_bill_of_materials WHERE
41: bill_sequence_id = p_bill_seq_id;
42: BEGIN
43: FOR r1 IN c1
44: LOOP

Line 320: FROM bom_bill_of_materials

316: BEGIN
317:
318: SELECT bill_sequence_id
319: INTO l_id
320: FROM bom_bill_of_materials
321: WHERE assembly_item_id = p_assembly_item_id
322: AND NVL(alternate_bom_designator, 'NONE') =
323: -- NVL(p_alternate_bom_designator, 'NONE')
324: decode(p_alternate_bom_designator,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_designator) --2783251

Line 2421: FROM bom_bill_of_materials

2417:
2418: BEGIN
2419: SELECT 1
2420: INTO l_dummy
2421: FROM bom_bill_of_materials
2422: WHERE bill_sequence_id = source_bill_sequence_id
2423: AND bill_sequence_id = l_sub_comp_unexp_rec.bill_Sequence_id;
2424: EXCEPTION
2425: WHEN NO_DATA_FOUND THEN

Line 3036: FROM bom_bill_of_materials

3032:
3033: BEGIN
3034: SELECT 1
3035: INTO l_dummy
3036: FROM bom_bill_of_materials
3037: WHERE bill_sequence_id = source_bill_sequence_id
3038: AND bill_sequence_id = l_ref_desg_unexp_rec.bill_sequence_id;
3039: EXCEPTION
3040: WHEN NO_DATA_FOUND THEN

Line 3691: FROM bom_bill_of_materials

3687:
3688: BEGIN
3689: SELECT 1
3690: INTO l_dummy
3691: FROM bom_bill_of_materials
3692: WHERE bill_sequence_id = source_bill_sequence_id
3693: AND bill_sequence_id = l_bom_comp_ops_unexp_rec.bill_Sequence_id;
3694: EXCEPTION
3695: WHEN NO_DATA_FOUND THEN