APPS.ENG_DEFAULT_REVISED_ITEM dependencies on BOM_BILL_OF_MATERIALS

Line 58: FROM bom_bill_of_materials

54: BEGIN
55:
56: SELECT bill_sequence_id
57: INTO l_bill_sequence_id
58: FROM bom_bill_of_materials
59: WHERE assembly_item_id = g_rev_item_unexp_rec.revised_item_id
60: AND NVL(alternate_bom_designator, 'NONE') =
61: NVL(g_revised_item_rec.alternate_bom_code, 'NONE')
62: AND organization_id = g_rev_item_unexp_rec.organization_id;

Line 997: FROM BOM_BILL_OF_MATERIALS

993: ) RETURN BOOLEAN
994: IS
995: cursor c_CheckAlternate IS
996: SELECT 1
997: FROM BOM_BILL_OF_MATERIALS
998: WHERE assembly_item_id = p_revised_item_id
999: AND organization_id = p_organization_id
1000: AND ((alternate_bom_designator IS NULL
1001: AND p_alternate_bom_designator IS NULL)

Line 1033: FROM BOM_BILL_OF_MATERIALS

1029: l_assembly_type NUMBER := 0;
1030:
1031: cursor c_CheckBillType IS
1032: SELECT 1
1033: FROM BOM_BILL_OF_MATERIALS
1034: WHERE assembly_item_id = p_revised_item_id
1035: AND organization_id = p_organization_id
1036: AND alternate_bom_designator is null
1037: AND ((assembly_type = 1 and l_assembly_type = 1)

Line 1391: FROM bom_bill_of_materials

1387:
1388: CURSOR c_Get_Bill_Seq
1389: IS
1390: SELECT bill_sequence_id
1391: FROM bom_bill_of_materials
1392: WHERE assembly_item_id = p_rev_item_unexp_rec.revised_item_id
1393: AND organization_id = p_rev_item_unexp_rec.organization_id
1394: AND NVL(alternate_bom_designator, 'none') =
1395: NVL(p_revised_item_rec.alternate_bom_code, 'none');