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.GML_AUDIT_REPORTS dependencies on CPG_ORAGEMS_MAPPING

Line 132: FROM cpg_oragems_mapping f

128: CURSOR lcnt_cur IS
129: SELECT count(*)
130: FROM po_ordr_dtl
131: WHERE po_id IN (SELECT po_id
132: FROM cpg_oragems_mapping f
133: WHERE f.po_header_id = p_hid
134: AND nvl(po_release_id,0)>0);
135:
136: BEGIN

Line 180: FROM cpg_oragems_mapping f

176: CURSOR cost_cur IS
177: SELECT SUM(order_qty1*net_price)
178: FROM po_ordr_dtl
179: WHERE po_id IN (SELECT po_id
180: FROM cpg_oragems_mapping f
181: WHERE f.po_header_id = p_hid
182: AND nvl(po_release_id,0)>0);
183:
184: BEGIN

Line 206: FROM cpg_oragems_mapping a

202: l_ret VARCHAR2(1);
203:
204: CURSOR ofi_gms_mch_cur IS
205: SELECT 'Y'
206: FROM cpg_oragems_mapping a
207: WHERE a.po_header_id=p_ohid
208: AND a.po_line_id = p_olid
209: AND a.po_line_location_id=p_ollid
210: AND a.po_id=p_gid