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_PSIG dependencies on FND_LOOKUP_VALUES_VL

Line 2544: fnd_lookup_values_vl lookup1

2540: into l_result
2541:
2542: from edr_psig_documents evid,
2543: wf_events_vl wfev,
2544: fnd_lookup_values_vl lookup1
2545:
2546: where
2547: evid.event_name = wfev.name
2548: and lookup1.lookup_type = 'EDR_DOCUMENT_STATUS'

Line 2682: fnd_lookup_values_vl lookup1

2678:
2679: into l_result
2680:
2681: from edr_Trans_ackn ackn,
2682: fnd_lookup_values_vl lookup1
2683:
2684: where ackn.erecord_id = p_document_id
2685: and lookup1.lookup_type = 'EDR_TRANS_STATUS'
2686: and lookup1.lookup_code = ackn.transaction_status;

Line 2716: from fnd_lookup_values_vl lookup3,

2712: PRINT.PRINT_REQUESTED_BY as PRINT_REQUESTER,
2713: PRINT.USER_DISPLAY_NAME as PRINT_REQUESTER_DISPLAY_NAME,
2714: PRINT.PRINT_REQUESTED_DATE as PRINT_EVENT_DATE,
2715: (select lookup3.meaning
2716: from fnd_lookup_values_vl lookup3,
2717: edr_psig_documents printevid
2718: where lookup3.lookup_code = printevid.psig_status
2719: and lookup3.lookup_type = 'EDR_DOCUMENT_STATUS'
2720: and printevid.document_id = print.print_document_id