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.GMD_QMSMC dependencies on GEM_LOOKUPS

Line 478: FROM gem_lookups

474: and sv.spec_vr_id = X_SPEC_VR_ID;
475:
476: CURSOR sample_plan_freq_per(x_frequency_per varchar2) is
477: SELECT meaning
478: FROM gem_lookups
479: WHERE lookup_type = 'GMD_QC_FREQUENCY_PERIOD'
480: and lookup_code = x_frequency_per;
481:
482: /* Cursors to check if Spec VR has auto enable flag enabled */

Line 2283: FROM gem_lookups

2279: AND sv.spec_vr_id = X_SPEC_VR_ID;
2280:
2281: CURSOR wip_sample_plan_freq_per(x_frequency_per varchar2) IS
2282: SELECT meaning
2283: FROM gem_lookups
2284: WHERE lookup_type = 'GMD_QC_FREQUENCY_PERIOD'
2285: AND lookup_code = x_frequency_per;
2286:
2287: CURSOR get_sampling_plan_id(x_spec_vr_id_in number) IS