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.CSD_SOO_PVT dependencies on MFG_LOOKUPS

Line 170: from mfg_lookups ml

166: and incident_status_id = c_incident_status_id;
167:
168: CURSOR c_wip_status_name(c_job_status_id NUMBER) IS
169: select ml.meaning status_name
170: from mfg_lookups ml
171: where ml.lookup_type = 'WIP_JOB_STATUS'
172: and ml.lookup_code = c_job_status_id
173: and enabled_flag = 'Y'
174: and trunc(sysdate) between nvl(start_date_active, sysdate - 1)