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.EDR_STANDARD dependencies on EDR_PSIG_DOCUMENTS

Line 18: from edr_psig_documents

14: --Bug 3468810: end
15:
16: --Bug 4565450: start
17: select PSIG_STATUS into p_status
18: from edr_psig_documents
19: where EVENT_NAME=p_event
20: and EVENT_KEY=p_event_key
21: and PSIG_TIMESTAMP =
22: (select MAX(PSIG_TIMESTAMP)

Line 23: from edr_psig_documents

19: where EVENT_NAME=p_event
20: and EVENT_KEY=p_event_key
21: and PSIG_TIMESTAMP =
22: (select MAX(PSIG_TIMESTAMP)
23: from edr_psig_documents
24: where EVENT_NAME=p_event
25: and EVENT_KEY=p_event_key
26: and rownum < 2);
27: --Bug 4565450: end

Line 578: l_sql:='select document_id from edr_psig_documents where ' || l_where_clause || ' )' ;

574:
575: end Loop;
576:
577: /* Construct SQL */
578: l_sql:='select document_id from edr_psig_documents where ' || l_where_clause || ' )' ;
579:
580: /* Open Dynamic sql */
581: IF dbms_sql.is_open(l_dbms_cur) THEN
582: dbms_sql.close_cursor(l_dbms_cur);