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.JTF_NOTES_PKG dependencies on JTF_OBJECTS_B

Line 537: l_select_id jtf_objects_b.select_id%type;

533: p_note_context_type_id IN NUMBER) RETURN VARCHAR2
534: IS
535:
536: l_note_context_value VARCHAR2(240);
537: l_select_id jtf_objects_b.select_id%type;
538: l_select_name jtf_objects_b.select_name%type;
539: l_tablename jtf_objects_b.from_table%type;
540: l_where_clause jtf_objects_b.where_clause%type;
541: v_cursor number;

Line 538: l_select_name jtf_objects_b.select_name%type;

534: IS
535:
536: l_note_context_value VARCHAR2(240);
537: l_select_id jtf_objects_b.select_id%type;
538: l_select_name jtf_objects_b.select_name%type;
539: l_tablename jtf_objects_b.from_table%type;
540: l_where_clause jtf_objects_b.where_clause%type;
541: v_cursor number;
542: v_create_string varchar2(3000);

Line 539: l_tablename jtf_objects_b.from_table%type;

535:
536: l_note_context_value VARCHAR2(240);
537: l_select_id jtf_objects_b.select_id%type;
538: l_select_name jtf_objects_b.select_name%type;
539: l_tablename jtf_objects_b.from_table%type;
540: l_where_clause jtf_objects_b.where_clause%type;
541: v_cursor number;
542: v_create_string varchar2(3000);
543: v_numrows number;

Line 540: l_where_clause jtf_objects_b.where_clause%type;

536: l_note_context_value VARCHAR2(240);
537: l_select_id jtf_objects_b.select_id%type;
538: l_select_name jtf_objects_b.select_name%type;
539: l_tablename jtf_objects_b.from_table%type;
540: l_where_clause jtf_objects_b.where_clause%type;
541: v_cursor number;
542: v_create_string varchar2(3000);
543: v_numrows number;
544: