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 295: FROM bom_bill_of_materials

291: BEGIN
292:
293: SELECT bill_sequence_id
294: INTO l_id
295: FROM bom_bill_of_materials
296: WHERE assembly_item_id = p_assembly_item_id
297: AND NVL(alternate_bom_designator, 'NONE') =
298: -- NVL(p_alternate_bom_designator, 'NONE')
299: decode(p_alternate_bom_designator,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_designator) --2783251

Line 2396: FROM bom_bill_of_materials

2392:
2393: BEGIN
2394: SELECT 1
2395: INTO l_dummy
2396: FROM bom_bill_of_materials
2397: WHERE bill_sequence_id = source_bill_sequence_id
2398: AND bill_sequence_id = l_sub_comp_unexp_rec.bill_Sequence_id;
2399: EXCEPTION
2400: WHEN NO_DATA_FOUND THEN

Line 2993: FROM bom_bill_of_materials

2989:
2990: BEGIN
2991: SELECT 1
2992: INTO l_dummy
2993: FROM bom_bill_of_materials
2994: WHERE bill_sequence_id = source_bill_sequence_id
2995: AND bill_sequence_id = l_ref_desg_unexp_rec.bill_sequence_id;
2996: EXCEPTION
2997: WHEN NO_DATA_FOUND THEN

Line 3648: FROM bom_bill_of_materials

3644:
3645: BEGIN
3646: SELECT 1
3647: INTO l_dummy
3648: FROM bom_bill_of_materials
3649: WHERE bill_sequence_id = source_bill_sequence_id
3650: AND bill_sequence_id = l_bom_comp_ops_unexp_rec.bill_Sequence_id;
3651: EXCEPTION
3652: WHEN NO_DATA_FOUND THEN