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.PV_WORKFLOW_PUB dependencies on JTF_NOTES_VL

Line 2833: from jtf_notes_vl

2829: document_type in out nocopy varchar2) IS
2830:
2831: cursor lc_get_notes(pc_entity_id number) is
2832: select entered_date, entered_by_name, notes, NOTES_DETAIL
2833: from jtf_notes_vl
2834: where source_object_code = 'OPPORTUNITY'
2835: AND SOURCE_OBJECT_ID = pc_entity_id
2836: AND NOTE_STATUS = 'E' -- only publish notes
2837: ORDER BY CREATION_DATE DESC;

Line 2841: from jtf_notes_vl

2837: ORDER BY CREATION_DATE DESC;
2838:
2839: cursor lc_max_lengths(pc_entity_id number) is
2840: select max(length(entered_date)), max(length(entered_by_name))
2841: from jtf_notes_vl
2842: where source_object_code = 'OPPORTUNITY'
2843: AND SOURCE_OBJECT_ID = pc_entity_id
2844: AND NOTE_STATUS = 'E';
2845: