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_MSITE_RESP_MGR_PVT dependencies on FND_APPLICATION_VL

Line 401: FROM jtf_msite_resps_vl MR, fnd_responsibility_vl R, fnd_application_vl A

397: MR.object_version_number, R.responsibility_id, R.application_id,
398: MR.display_name, A.application_name,
399: R.responsibility_key, R.responsibility_name, MR.start_date_active,
400: MR.end_date_active, MR.sort_order
401: FROM jtf_msite_resps_vl MR, fnd_responsibility_vl R, fnd_application_vl A
402: WHERE MR.msite_id = p_msite_id
403: AND MR.responsibility_id = R.responsibility_id
404: AND MR.application_id = R.application_id
405: AND R.application_id = A.application_id;

Line 414: FROM jtf_msite_resps_vl MR, fnd_responsibility_vl R, fnd_application_vl A

410: MR.object_version_number, R.responsibility_id, R.application_id,
411: MR.display_name, A.application_name,
412: R.responsibility_key, R.responsibility_name, MR.start_date_active,
413: MR.end_date_active, MR.sort_order
414: FROM jtf_msite_resps_vl MR, fnd_responsibility_vl R, fnd_application_vl A
415: WHERE MR.msite_id = p_msite_id
416: AND MR.application_id = p_application_id
417: AND MR.responsibility_id = R.responsibility_id
418: AND MR.application_id = R.application_id

Line 542: 'SELECT R.responsibility_id, R.application_id FROM fnd_responsibility_vl R, fnd_application_vl A WHERE R.application_id = A.application_id AND ' || l_application_id_sql_str;

538: --
539: -- Construct the database sql query
540: --
541: l_db_sql :=
542: 'SELECT R.responsibility_id, R.application_id FROM fnd_responsibility_vl R, fnd_application_vl A WHERE R.application_id = A.application_id AND ' || l_application_id_sql_str;
543:
544: --
545: -- Based on the query criteria
546: --

Line 706: 'SELECT R.responsibility_id, R.application_id, A.application_name, R.responsibility_key, R.responsibility_name, R.description, R.start_date, R.end_date FROM fnd_responsibility_vl R, fnd_application_vl A WHERE ' ||

702: --
703: -- Construct the database sql query
704: --
705: l_db_sql :=
706: 'SELECT R.responsibility_id, R.application_id, A.application_name, R.responsibility_key, R.responsibility_name, R.description, R.start_date, R.end_date FROM fnd_responsibility_vl R, fnd_application_vl A WHERE ' ||
707: ' R.application_id = A.application_id AND ' ||
708: l_tmp_str;
709:
710: --