APPS.ENG_VAL_TO_ID dependencies on BOM_BILL_OF_MATERIALS

Line 1475: FROM bom_bill_of_materials

1471: BEGIN
1472:
1473: SELECT bill_sequence_id
1474: INTO l_id
1475: FROM bom_bill_of_materials
1476: WHERE assembly_item_id = p_assembly_item_id
1477: AND NVL(alternate_bom_designator, 'NONE') =
1478: NVL(p_alternate_bom_designator, 'NONE')
1479: AND organization_id = p_organization_id;

Line 2156: select bill_sequence_id into l_bill_seq_id from bom_bill_of_materials

2152: from mtl_item_revisions
2153: where inventory_item_id =l_rev_item_unexp_rec.from_end_item_id
2154: and organization_id =l_rev_item_unexp_rec.organization_id;
2155:
2156: select bill_sequence_id into l_bill_seq_id from bom_bill_of_materials
2157: where
2158: ASSEMBLY_ITEM_ID = l_rev_item_unexp_rec.from_end_item_id
2159: and ORGANIZATION_ID = l_rev_item_unexp_rec.organization_id
2160: and ALTERNATE_BOM_DESIGNATOR = p_revised_item_rec.from_end_item_alternate;

Line 3278: alt_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE) is

3274: l_Bill_Seq1 NUMBER := NULL; -- Bug 2429272 Change2 Begin
3275:
3276: cursor c1 (rev_item_id eng_revised_items.revised_item_id%TYPE,
3277: org_id eng_revised_items.organization_id%TYPE,
3278: alt_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE) is
3279: select bill_sequence_id
3280: from bom_bill_of_materials
3281: where assembly_item_id = rev_item_id and
3282: organization_id = org_id and

Line 3280: from bom_bill_of_materials

3276: cursor c1 (rev_item_id eng_revised_items.revised_item_id%TYPE,
3277: org_id eng_revised_items.organization_id%TYPE,
3278: alt_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE) is
3279: select bill_sequence_id
3280: from bom_bill_of_materials
3281: where assembly_item_id = rev_item_id and
3282: organization_id = org_id and
3283: nvl(effectivity_control, 1) <> 4 AND -- Bug 4210718
3284: nvl(alternate_bom_designator,'NULL') = nvl(alt_bom_code,'NULL');