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 CM_CMPT_DTL

Line 448: FROM cm_cmpt_dtl cst

444: CURSOR c_get_period_info (l_batch_id IN gme_batch_header.batch_id%TYPE)
445: IS
446: -- See if any of the matl lines has been costed and frozen.
447: SELECT COUNT (1)
448: FROM cm_cmpt_dtl cst
449: ,cm_acst_led aled
450: ,gme_material_details md
451: ,gme_batch_header bh
452: WHERE bh.batch_id = l_batch_id

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