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

Line 2034: from gem_lookups l,

2030: l_sample_id NUMBER;
2031: l_sample_source varchar2(30);
2032: Cursor get_sample_disposition(p_sample_id NUMBER) is
2033: select l.meaning
2034: from gem_lookups l,
2035: gmd_sample_spec_disp ssd,
2036: gmd_event_spec_disp esd,
2037: gmd_sampling_events se
2038: where l.lookup_code = ssd.disposition

Line 2047: From gem_lookups

2043: and se.sampling_Event_id = esd.sampling_event_id;
2044:
2045: Cursor get_source_meaning IS
2046: Select meaning
2047: From gem_lookups
2048: Where lookup_type = 'GMD_QC_SOURCE'
2049: And lookup_code = l_sample_source;
2050:
2051: