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.GMF_SUBLEDGER_REPORT dependencies on FM_ROUT_HDR

Line 356: CURSOR c_fm_rout_hdr(v_routing_id NUMBER) IS

352: AND to_char(b.batch_status) = t.lookup_code
353: AND t.lookup_type = upper('batch_status');
354: c_pm_btch c_pm_btch_hdr%ROWTYPE;
355:
356: CURSOR c_fm_rout_hdr(v_routing_id NUMBER) IS
357: SELECT
358: r.routing_no,
359: r.routing_vers
360: FROM

Line 361: fm_rout_hdr r

357: SELECT
358: r.routing_no,
359: r.routing_vers
360: FROM
361: fm_rout_hdr r
362: WHERE
363: r.routing_id = v_routing_id;
364: c_fm_rout c_fm_rout_hdr%ROWTYPE;
365:

Line 364: c_fm_rout c_fm_rout_hdr%ROWTYPE;

360: FROM
361: fm_rout_hdr r
362: WHERE
363: r.routing_id = v_routing_id;
364: c_fm_rout c_fm_rout_hdr%ROWTYPE;
365:
366: /* Begin Bug#2088655 P.Raghu - Detail info on Document Type 'PROC' */
367: CURSOR c_pur_ship_dtl(v_doc_id NUMBER, v_line_id NUMBER) IS
368: SELECT

Line 761: OPEN c_fm_rout_hdr(c_pm_btch.routing_id);

757:
758: PRINT_LINE ( '|'||LPAD(L_GMF_FORMULA,16,' ')||': '||RPAD(c_pm_btch.formula_no,32,' ')||' '||LPAD(L_GMF_VERSION,16,' ')||': '||
759: RPAD(c_pm_btch.formula_vers,5,' ')||' '||LPAD(L_GMF_ACTUAL_START_DATE,22,' ')||': '||RPAD(to_char(c_pm_btch.actual_start_date),18,' '));
760: IF (c_pm_btch.routing_id > 0) THEN
761: OPEN c_fm_rout_hdr(c_pm_btch.routing_id);
762: FETCH c_fm_rout_hdr INTO c_fm_rout;
763: CLOSE c_fm_rout_hdr;
764: PRINT_LINE ( '|'||LPAD(L_GMF_ROUTING,16,' ')||': '||
765: RPAD(c_fm_rout.routing_no,32,' ')||' '||LPAD(L_GMF_VERSION,16,' ')||': '||RPAD(c_fm_rout.routing_vers,5,' ')||' '||

Line 762: FETCH c_fm_rout_hdr INTO c_fm_rout;

758: PRINT_LINE ( '|'||LPAD(L_GMF_FORMULA,16,' ')||': '||RPAD(c_pm_btch.formula_no,32,' ')||' '||LPAD(L_GMF_VERSION,16,' ')||': '||
759: RPAD(c_pm_btch.formula_vers,5,' ')||' '||LPAD(L_GMF_ACTUAL_START_DATE,22,' ')||': '||RPAD(to_char(c_pm_btch.actual_start_date),18,' '));
760: IF (c_pm_btch.routing_id > 0) THEN
761: OPEN c_fm_rout_hdr(c_pm_btch.routing_id);
762: FETCH c_fm_rout_hdr INTO c_fm_rout;
763: CLOSE c_fm_rout_hdr;
764: PRINT_LINE ( '|'||LPAD(L_GMF_ROUTING,16,' ')||': '||
765: RPAD(c_fm_rout.routing_no,32,' ')||' '||LPAD(L_GMF_VERSION,16,' ')||': '||RPAD(c_fm_rout.routing_vers,5,' ')||' '||
766: LPAD(L_GMF_ACTUAL_CMPLT_DATE,22,' ')||': '||RPAD(to_char(c_pm_btch.actual_cmplt_date),18,' '));

Line 763: CLOSE c_fm_rout_hdr;

759: RPAD(c_pm_btch.formula_vers,5,' ')||' '||LPAD(L_GMF_ACTUAL_START_DATE,22,' ')||': '||RPAD(to_char(c_pm_btch.actual_start_date),18,' '));
760: IF (c_pm_btch.routing_id > 0) THEN
761: OPEN c_fm_rout_hdr(c_pm_btch.routing_id);
762: FETCH c_fm_rout_hdr INTO c_fm_rout;
763: CLOSE c_fm_rout_hdr;
764: PRINT_LINE ( '|'||LPAD(L_GMF_ROUTING,16,' ')||': '||
765: RPAD(c_fm_rout.routing_no,32,' ')||' '||LPAD(L_GMF_VERSION,16,' ')||': '||RPAD(c_fm_rout.routing_vers,5,' ')||' '||
766: LPAD(L_GMF_ACTUAL_CMPLT_DATE,22,' ')||': '||RPAD(to_char(c_pm_btch.actual_cmplt_date),18,' '));
767: ELSE