APPS.GMF_SUBLEDGER_REPORT dependencies on GL_SUBR_TST_VW

Line 168: CURSOR c_gl_subr_tst_vw IS

164: trans_qty_usage_um,
165: reference_no;
166:
167: /* Cursor for running report on test subledger table */
168: CURSOR c_gl_subr_tst_vw IS
169: SELECT
170: co_code,
171: fiscal_year,
172: period,

Line 206: FROM gl_subr_tst_vw

202: whse_code,
203: trans_qty_usage,
204: trans_qty_usage_um,
205: reference_no
206: FROM gl_subr_tst_vw
207: WHERE
208: reference_no = nvl(preference_no,reference_no) and --bug# 1801491
209: co_code = pco_code and
210: fiscal_year = to_number(pfiscal_year) and

Line 581: OPEN c_gl_subr_tst_vw;

577: /* Open the right cursor based upon the user specified parameter */
578: IF report_on = 1 THEN
579: OPEN c_gl_subr_led_vw;
580: ELSE
581: OPEN c_gl_subr_tst_vw;
582: END IF;
583:
584: /* Start the report processing */
585: WHILE TRUE

Line 595: FETCH c_gl_subr_tst_vw INTO r;

591: IF report_on = 1 THEN
592: FETCH c_gl_subr_led_vw INTO r;
593: EXIT WHEN c_gl_subr_led_vw%NOTFOUND;
594: ELSE
595: FETCH c_gl_subr_tst_vw INTO r;
596: EXIT WHEN c_gl_subr_tst_vw%NOTFOUND;
597: END IF;
598: /* Begin Bug#2424449 Piyush K. Mishra
599: Incorporated B#2255269 */

Line 596: EXIT WHEN c_gl_subr_tst_vw%NOTFOUND;

592: FETCH c_gl_subr_led_vw INTO r;
593: EXIT WHEN c_gl_subr_led_vw%NOTFOUND;
594: ELSE
595: FETCH c_gl_subr_tst_vw INTO r;
596: EXIT WHEN c_gl_subr_tst_vw%NOTFOUND;
597: END IF;
598: /* Begin Bug#2424449 Piyush K. Mishra
599: Incorporated B#2255269 */
600: if (r.doc_date <= min_date) then

Line 1139: CLOSE c_gl_subr_tst_vw;

1135: /* Close the te right cursor base upon user specified parameter */
1136: IF report_on = 1 THEN
1137: CLOSE c_gl_subr_led_vw;
1138: ELSE
1139: CLOSE c_gl_subr_tst_vw;
1140: END IF;
1141:
1142: /* Print the totals for the very last line */
1143: PRINT_TOTALS (-888,'-888','-888',-888 , rep_mode, ppage_size); -- Bug 2804810