APPS.BOM_DEFAULT_BOM_COMPONENT dependencies on ENG_REVISED_ITEMS

Line 200: FROM eng_revised_items

196: RETURN DATE
197: IS
198: CURSOR c_EffectiveDate IS
199: SELECT scheduled_date
200: FROM eng_revised_items
201: WHERE revised_item_sequence_id =
202: g_Rev_Comp_Unexp_Rec.revised_item_sequence_id;
203: BEGIN
204:

Line 406: FROM eng_revised_items

402: NVL(g_rev_component_rec.alternate_bom_code, 'NONE');
403:
404: CURSOR c_CheckBillInRevisedItem IS
405: SELECT bill_sequence_id
406: FROM eng_revised_items
407: WHERE revised_item_sequence_id =
408: g_rev_comp_unexp_rec.revised_item_sequence_id;
409:
410: l_bill_sequence_id NUMBER;

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

418: END IF;
419: END LOOP;
420:
421: --
422: -- If bill sequence id is not found in Eng_Revised_Items
423: -- Only then go to the Bom Table to look for Bill_Sequence_Id
424: --
425: OPEN c_CheckForNew;
426: FETCH c_CheckForNew INTO l_bill_sequence_id;