APPS.ENG_VAL_TO_ID dependencies on BOM_BILL_OF_MATERIALS

Line 1469: FROM bom_bill_of_materials

1465: BEGIN
1466:
1467: SELECT bill_sequence_id
1468: INTO l_id
1469: FROM bom_bill_of_materials
1470: WHERE assembly_item_id = p_assembly_item_id
1471: AND NVL(alternate_bom_designator, 'NONE') =
1472: NVL(p_alternate_bom_designator, 'NONE')
1473: AND organization_id = p_organization_id;

Line 2150: select bill_sequence_id into l_bill_seq_id from bom_bill_of_materials

2146: from mtl_item_revisions
2147: where inventory_item_id =l_rev_item_unexp_rec.from_end_item_id
2148: and organization_id =l_rev_item_unexp_rec.organization_id;
2149:
2150: select bill_sequence_id into l_bill_seq_id from bom_bill_of_materials
2151: where
2152: ASSEMBLY_ITEM_ID = l_rev_item_unexp_rec.from_end_item_id
2153: and ORGANIZATION_ID = l_rev_item_unexp_rec.organization_id
2154: and ALTERNATE_BOM_DESIGNATOR = p_revised_item_rec.from_end_item_alternate;

Line 3272: alt_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE) is

3268: l_Bill_Seq1 NUMBER := NULL; -- Bug 2429272 Change2 Begin
3269:
3270: cursor c1 (rev_item_id eng_revised_items.revised_item_id%TYPE,
3271: org_id eng_revised_items.organization_id%TYPE,
3272: alt_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE) is
3273: select bill_sequence_id
3274: from bom_bill_of_materials
3275: where assembly_item_id = rev_item_id and
3276: organization_id = org_id and

Line 3274: from bom_bill_of_materials

3270: cursor c1 (rev_item_id eng_revised_items.revised_item_id%TYPE,
3271: org_id eng_revised_items.organization_id%TYPE,
3272: alt_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE) is
3273: select bill_sequence_id
3274: from bom_bill_of_materials
3275: where assembly_item_id = rev_item_id and
3276: organization_id = org_id and
3277: nvl(effectivity_control, 1) <> 4 AND -- Bug 4210718
3278: nvl(alternate_bom_designator,'NULL') = nvl(alt_bom_code,'NULL');