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.OKL_AM_ASSET_RETURN_WF dependencies on JTF_RS_RESOURCE_EXTNS

Line 588: jtf_rs_Resource_extns a,

584: IS
585: SELECT count(*)
586: FROM jtf_rs_teams_vl t,
587: jtf_rs_role_relations_vl jtfr,
588: jtf_rs_Resource_extns a,
589: jtf_rs_Team_Members b,
590: jtf_rs_Groups_b d,
591: jtf_rs_resource_extns re,
592: wf_users wu

Line 591: jtf_rs_resource_extns re,

587: jtf_rs_role_relations_vl jtfr,
588: jtf_rs_Resource_extns a,
589: jtf_rs_Team_Members b,
590: jtf_rs_Groups_b d,
591: jtf_rs_resource_extns re,
592: wf_users wu
593: WHERE t.team_id = c_team_id
594: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
595: AND nvl (t.end_date_active, sysdate + 1) >= sysdate

Line 734: jtf_rs_resource_extns_vl re,

730: SELECT wu.name, wu.display_name
731: FROM jtf_rs_teams_vl t,
732: jtf_rs_role_relations_vl jtfr,
733: jtf_rs_team_members_vl tm,
734: jtf_rs_resource_extns_vl re,
735: wf_users WU
736: WHERE t.team_id = c_team_id
737: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
738: AND nvl (t.end_date_active, sysdate + 1) >= sysdate

Line 757: jtf_rs_resource_extns_vl re,

753: SELECT wu.name, wu.display_name
754: FROM jtf_rs_teams_vl t,
755: jtf_rs_role_relations_vl jtfr,
756: jtf_rs_team_members_vl tm,
757: jtf_rs_resource_extns_vl re,
758: wf_users WU
759: WHERE t.team_id = c_team_id
760: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
761: AND nvl (t.end_date_active, sysdate + 1) >= sysdate

Line 780: jtf_rs_resource_extns_vl re,

776: SELECT wu.name, wu.display_name
777: FROM jtf_rs_teams_vl t,
778: jtf_rs_role_relations_vl jtfr,
779: jtf_rs_team_members_vl tm,
780: jtf_rs_resource_extns_vl re,
781: wf_users WU
782: WHERE t.team_id = c_team_id
783: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
784: AND nvl (t.end_date_active, sysdate + 1) >= sysdate

Line 2412: jtf_rs_Resource_extns a,

2408: IS
2409: SELECT count(1)
2410: FROM jtf_rs_teams_b t,
2411: jtf_rs_role_relations_vl jtfr,
2412: jtf_rs_Resource_extns a,
2413: jtf_rs_Team_Members b,
2414: jtf_rs_Groups_b d,
2415: jtf_rs_resource_extns re,
2416: wf_users WU

Line 2415: jtf_rs_resource_extns re,

2411: jtf_rs_role_relations_vl jtfr,
2412: jtf_rs_Resource_extns a,
2413: jtf_rs_Team_Members b,
2414: jtf_rs_Groups_b d,
2415: jtf_rs_resource_extns re,
2416: wf_users WU
2417: WHERE
2418: t.team_id = c_team_id
2419: AND nvl (t.start_date_active, sysdate - 1) <= sysdate

Line 2570: jtf_rs_Resource_extns a,

2566: IS
2567: SELECT wu.name, wu.display_name
2568: FROM jtf_rs_teams_vl t,
2569: jtf_rs_role_relations_vl jtfr,
2570: jtf_rs_Resource_extns a,
2571: jtf_rs_Team_Members b,
2572: jtf_rs_Groups_b d,
2573: jtf_rs_resource_extns re,
2574: wf_users WU

Line 2573: jtf_rs_resource_extns re,

2569: jtf_rs_role_relations_vl jtfr,
2570: jtf_rs_Resource_extns a,
2571: jtf_rs_Team_Members b,
2572: jtf_rs_Groups_b d,
2573: jtf_rs_resource_extns re,
2574: wf_users WU
2575: WHERE t.team_id = c_team_id
2576: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
2577: AND nvl (t.end_date_active, sysdate + 1) >= sysdate