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.GME_REOPEN_BATCH_PVT dependencies on GMF_PERIOD_STATUSES

Line 26: REM * GMF team. Add conditions on table gmf_period_statuses to see if *

22: REM * Pawan Kumar Corrected the code. *
23: REM * *
24: REM * 21-JAN-11 G. Muratore Bug 10634518 *
25: REM * Frontport 11i bug 6853392. Rework using R12 tables and joins per *
26: REM * GMF team. Add conditions on table gmf_period_statuses to see if *
27: REM * batch_close_date is in open period. PROCEDURE: is_period_open *
28: REM **********************************************************************
29: */
30: g_package_name CONSTANT VARCHAR2 (30) := 'GME_REOPEN_BATCH_PVT';

Line 464: FROM cm_cmpt_dtl cst, cm_acst_led aled, gme_material_details md, gme_batch_header bh, gmf_period_statuses d

460: -- Bug 10634518 - Frontport 11i bug 6853392 but also rework using R12 tables and joins per GMF team.
461: CURSOR c_get_period_info (l_batch_id IN gme_batch_header.batch_id%TYPE)
462: IS
463: SELECT COUNT(1)
464: FROM cm_cmpt_dtl cst, cm_acst_led aled, gme_material_details md, gme_batch_header bh, gmf_period_statuses d
465: WHERE bh.batch_id = l_batch_id
466: AND bh.batch_id = md.batch_id
467: AND md.material_detail_id = aled.transline_id
468: AND aled.source_ind = 0