APPS.BOM_DEFAULT_BOM_COMPONENT dependencies on ENG_REVISED_ITEMS

Line 272: FROM eng_revised_items

268: RETURN DATE
269: IS
270: CURSOR c_EffectiveDate IS
271: SELECT scheduled_date
272: FROM eng_revised_items
273: WHERE revised_item_sequence_id =
274: g_Rev_Comp_Unexp_Rec.revised_item_sequence_id;
275: BEGIN
276:

Line 481: FROM eng_revised_items

477: NVL(g_rev_component_rec.alternate_bom_code, 'NONE');
478:
479: CURSOR c_CheckBillInRevisedItem IS
480: SELECT bill_sequence_id
481: FROM eng_revised_items
482: WHERE revised_item_sequence_id =
483: g_rev_comp_unexp_rec.revised_item_sequence_id;
484:
485: l_bill_sequence_id NUMBER;

Line 497: -- If bill sequence id is not found in Eng_Revised_Items

493: END IF;
494: END LOOP;
495:
496: --
497: -- If bill sequence id is not found in Eng_Revised_Items
498: -- Only then go to the Bom Table to look for Bill_Sequence_Id
499: --
500: OPEN c_CheckForNew;
501: FETCH c_CheckForNew INTO l_bill_sequence_id;