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 2566: FROM ENG_REVISED_ITEMS eri

2562: )
2563: IS
2564:
2565: SELECT 'Rev Item is only Eco for altenate routing'
2566: FROM ENG_REVISED_ITEMS eri
2567: , BOM_OPERATIONAL_ROUTINGS bor
2568: WHERE bor.alternate_routing_designator IS NOT NULL
2569: AND eri.routing_sequence_id = bor.routing_sequence_id(+)
2570: AND eri.routing_sequence_id IS NOT NULL

Line 3059: FROM eng_revised_items

3055: p_rev_comp_unexp_rec.component_sequence_id;
3056:
3057: CURSOR c_NewBill IS
3058: SELECT revised_item_id, change_notice, organization_id
3059: FROM eng_revised_items
3060: WHERE revised_item_sequence_id =
3061: p_rev_comp_Unexp_rec.revised_item_sequence_id;
3062:
3063: CURSOR CheckForNew IS

Line 3065: FROM eng_revised_items eri

3061: p_rev_comp_Unexp_rec.revised_item_sequence_id;
3062:
3063: CURSOR CheckForNew IS
3064: SELECT 'Valid'
3065: FROM eng_revised_items eri
3066: WHERE eri.revised_item_sequence_id =
3067: p_rev_comp_Unexp_rec.revised_item_sequence_id
3068: AND eri.bill_sequence_id IS NULL
3069: AND NOT EXISTS (SELECT 1