APPS.ENG_VALIDATE_REV_COMPONENT dependencies on ENG_REVISED_ITEMS

Line 1452: FROM eng_revised_items

1448: CURSOR c_NewBill IS
1449: SELECT revised_item_id,
1450: change_notice,
1451: organization_id
1452: FROM eng_revised_items
1453: WHERE revised_item_sequence_id =
1454: p_rev_comp_Unexp_rec.revised_item_sequence_id;
1455:
1456: CURSOR CheckForNew IS

Line 1458: FROM eng_revised_items eri

1454: p_rev_comp_Unexp_rec.revised_item_sequence_id;
1455:
1456: CURSOR CheckForNew IS
1457: SELECT 'Valid'
1458: FROM eng_revised_items eri
1459: WHERE eri.revised_item_sequence_id =
1460: p_rev_comp_Unexp_rec.revised_item_sequence_id
1461: AND eri.bill_sequence_id IS NULL
1462: AND NOT EXISTS (SELECT 1

Line 1498: FROM mtl_system_items mi, eng_revised_items eri

1494: Is_Item_PTO VARCHAR2(1) := 'N';
1495:
1496: CURSOR c_ATO_PTO IS
1497: SELECT mi.replenish_to_order_flag, mi.pick_components_flag
1498: FROM mtl_system_items mi, eng_revised_items eri
1499: WHERE mi.inventory_item_id = eri.revised_item_id
1500: AND mi.organization_id = eri.organization_id
1501: AND eri.revised_item_sequence_id =
1502: p_rev_comp_Unexp_rec.revised_item_sequence_id;

Line 1792: FROM eng_revised_items eri,

1788: -- bill as common
1789: BEGIN
1790: SELECT 'Valid'
1791: INTO l_dummy
1792: FROM eng_revised_items eri,
1793: bom_bill_of_materials bom
1794: WHERE eri.revised_item_sequence_id =
1795: p_Rev_Comp_Unexp_Rec.revised_item_sequence_id
1796: AND bom.bill_sequence_id = eri.bill_sequence_id