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.EGO_ITEM_AML_PVT dependencies on MTL_MANUFACTURERS

Line 408: (SELECT 'x' FROM mtl_manufacturers manu

404: AND process_flag = G_PS_IN_PROCESS
405: AND ( (manufacturer_id IS NOT NULL
406: AND
407: NOT EXISTS
408: (SELECT 'x' FROM mtl_manufacturers manu
409: WHERE manu.manufacturer_id = aml_intf.manufacturer_id)
410: )
411: OR
412: (manufacturer_id IS NULL

Line 415: (SELECT 'x' FROM mtl_manufacturers manu

411: OR
412: (manufacturer_id IS NULL
413: AND
414: NOT EXISTS
415: (SELECT 'x' FROM mtl_manufacturers manu
416: WHERE manu.manufacturer_name = aml_intf.manufacturer_name)
417: )
418: );
419:

Line 423: from mtl_manufacturers manu

419:
420: UPDATE ego_aml_intf aml_intf
421: SET manufacturer_id =
422: (Select manufacturer_id
423: from mtl_manufacturers manu
424: where manu.manufacturer_name = aml_intf.manufacturer_name)
425: WHERE data_set_id = p_data_set_id
426: AND process_flag = G_PS_IN_PROCESS
427: AND manufacturer_id IS NULL;

Line 2061: from mtl_manufacturers manu

2057: -- populate the interface table which uses tokens
2058: UPDATE ego_aml_intf aml_intf
2059: SET manufacturer_name =
2060: (Select manufacturer_name
2061: from mtl_manufacturers manu
2062: where manu.manufacturer_id = aml_intf.manufacturer_id)
2063: WHERE data_set_id = p_data_set_id
2064: AND manufacturer_id IS NOT NULL
2065: AND process_flag IN (G_PS_CREATE_REC_EXISTS