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.OPI_DBI_JOBS_PKG dependencies on GME_MATERIAL_DETAILS

Line 967: FROM gme_material_details dtl,

963: g_program_id,
964: g_program_login_id,
965: g_program_application_id,
966: g_request_id
967: FROM gme_material_details dtl,
968: gme_batch_header hdr
969: WHERE
970: hdr.batch_id = dtl.batch_id
971: and dtl.line_type in (1,2) /* coproducts, by-products */

Line 1375: from gme_material_details dtl,

1371: g_program_id PROGRAM_ID,
1372: g_program_login_id PROGRAM_LOGIN_ID,
1373: g_program_application_id PROGRAM_APPLICATION_ID,
1374: g_request_id REQUEST_ID
1375: from gme_material_details dtl,
1376: gme_batch_header hdr
1377: where hdr.batch_id = dtl.batch_id
1378: and dtl.line_type in (1,2) /* coproducts and by-products*/
1379: and nvl(ACTUAL_START_DATE, g_global_start_date) >= g_global_start_date