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.ENG_VALIDATE_ECO dependencies on ENG_ENGINEERING_CHANGES

Line 307: FROM ENG_ENGINEERING_CHANGES eec1

303: IS
304: SELECT 'Rev Comp referencing Seq Num exists'
305: FROM SYS.DUAL
306: WHERE EXISTS (SELECT NULL
307: FROM ENG_ENGINEERING_CHANGES eec1
308: , ENG_REVISED_ITEMS eri1
309: , ENG_REVISED_ITEMS eri2
310: WHERE eri1.revised_item_id = eri2.revised_item_id
311: AND eri1.organization_id = eec1.organization_id

Line 425: FROM eng_engineering_changes

421: BEGIN
422:
423: SELECT change_id
424: INTO l_id
425: FROM eng_engineering_changes
426: WHERE change_notice = p_change_notice
427: AND organization_id = p_org_id;
428:
429: RETURN l_id;

Line 2262: FROM eng_engineering_changes

2258:
2259: ---While bulkloading PLM records we will have to look at route_id
2260: CURSOR c_CheckProcess_PLM(p_change_id NUMBER) IS
2261: SELECT route_id
2262: FROM eng_engineering_changes
2263: WHERE change_id = p_change_id ;
2264:
2265: l_route_id NUMBER;
2266:

Line 2328: FROM eng_engineering_changes

2324: CURSOR c_CheckECO IS
2325: SELECT status_type, priority_code, change_order_type_id,status_code --bug no 3591968 by Rashmi
2326: ,approval_status_type,assignee_id ,change_id --PLM records we will only have to look for processes based on change_type_id
2327: , nvl(plm_or_erp_change, 'PLM') plm_or_erp_change
2328: FROM eng_engineering_changes
2329: WHERE change_notice = p_change_notice
2330: AND organization_id = p_organization_id;
2331: --bug no 3591968 by Rashmi
2332: /*CURSOR c_CheckProcessInProgress(cp_change_id NUMBER,cp_status_code NUMBER) IS