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_CREATE_BATCH_PVT dependencies on DUAL

Line 202: FROM DUAL

198: l_temp NUMBER;
199: duplicate_wip_entity EXCEPTION;
200: CURSOR Cur_wip_entity IS
201: SELECT 1
202: FROM DUAL
203: WHERE EXISTS (SELECT 1
204: FROM wip_entities
205: WHERE organization_id = p_organization_id
206: AND wip_entity_name = p_batch_no);

Line 441: FROM DUAL

437: ,v_batch_no VARCHAR2
438: ,v_batch_type VARCHAR2)
439: IS
440: SELECT 1
441: FROM DUAL
442: WHERE EXISTS (
443: SELECT 1
444: FROM gme_batch_header
445: WHERE batch_no = v_batch_no

Line 1577: SELECT trim(TO_CHAR(systimestamp,'DD:MM:YYYY HH24:MI:SS:FF6')) INTO l_doc_timestamp FROM DUAL;

1573: /*5698727 rework Begin we use timestamp initially as its unique. later we update
1574: with actual batch_no
1575: gme_common_pvt.create_document_no (l_in_batch_header
1576: ,x_batch_header_rec);*/
1577: SELECT trim(TO_CHAR(systimestamp,'DD:MM:YYYY HH24:MI:SS:FF6')) INTO l_doc_timestamp FROM DUAL;
1578:
1579: IF g_debug <= gme_debug.g_log_statement THEN
1580: gme_debug.put_line ( g_pkg_name
1581: || '.'