eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on ENG_REVISED_ITEMS

Line 2574: FROM ENG_REVISED_ITEMS eri

2570: )
2571: IS
2572:
2573: SELECT 'Rev Item is only Eco for altenate routing'
2574: FROM ENG_REVISED_ITEMS eri
2575: , BOM_OPERATIONAL_ROUTINGS bor
2576: WHERE bor.alternate_routing_designator IS NOT NULL
2577: AND eri.routing_sequence_id = bor.routing_sequence_id(+)
2578: AND eri.routing_sequence_id IS NOT NULL

Line 3094: FROM eng_revised_items

3090: p_rev_comp_unexp_rec.component_sequence_id;
3091:
3092: CURSOR c_NewBill IS
3093: SELECT revised_item_id, change_notice, organization_id
3094: FROM eng_revised_items
3095: WHERE revised_item_sequence_id =
3096: p_rev_comp_Unexp_rec.revised_item_sequence_id;
3097:
3098: CURSOR CheckForNew IS

Line 3100: FROM eng_revised_items eri

3096: p_rev_comp_Unexp_rec.revised_item_sequence_id;
3097:
3098: CURSOR CheckForNew IS
3099: SELECT 'Valid'
3100: FROM eng_revised_items eri
3101: WHERE eri.revised_item_sequence_id =
3102: p_rev_comp_Unexp_rec.revised_item_sequence_id
3103: AND eri.bill_sequence_id IS NULL
3104: AND NOT EXISTS (SELECT 1