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.GL_GLXUSA_XMLP_PKG dependencies on GL_CONSOLIDATION_HISTORY

Line 170: P3 := ' gl_consolidation_history GLH ';

166:
167:
168: P1 := ' EXISTS ( SELECT sysdate ' ;
169: P2 := ' FROM gl_consolidation_accounts CONS_ACCT, ';
170: P3 := ' gl_consolidation_history GLH ';
171: P4 := ' WHERE GLH.consolidation_id = :P_CONSOLIDATION_ID ' ;
172: P5 := ' AND GLH.from_period_name = :P_PERIOD_NAME ';
173: P6 := ' AND GLH.average_consolidation_flag = :P_N ';
174: P7 := ' AND GLH.actual_flag = :P_A ';

Line 179: P10_3:=' FROM GL_CONSOLIDATION_HISTORY GLH2 ';

175: P8 := ' AND GLH.amount_type = :P_PERIOD_TYPE ';
176: P9 := ' AND GLH.consolidation_run_id = CONS_ACCT.consolidation_run_id ';
177: P10_1:=' AND GLH.consolidation_run_id = ';
178: P10_2:=' (SELECT MAX(glh2.consolidation_run_id) ';
179: P10_3:=' FROM GL_CONSOLIDATION_HISTORY GLH2 ';
180: P10_4:=' WHERE glh2.consolidation_id = GLH.consolidation_id ';
181: P10_5:=' AND glh2.from_period_name = GLH.from_period_name ';
182: P10_6:=' AND glh2.actual_flag = GLH.actual_flag ';
183: P10_7:=' AND glh2.amount_type = GLH.amount_type) ';

Line 346: FROM GL_CONSOLIDATION_HISTORY CH

342: FROM GL_CONSOLIDATION_ACCOUNTS CA
343: WHERE CA.consolidation_id = cons_id
344: AND CA.consolidation_run_id =
345: ( SELECT max(CH.consolidation_run_id)
346: FROM GL_CONSOLIDATION_HISTORY CH
347: WHERE CH.consolidation_id = cons_id
348: AND CH.average_consolidation_flag = avg_flag
349: AND CH.actual_flag = actual_flag
350: AND CH.amount_type = amount_type )