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 733: jtf_rs_Resource_extns a,

729: IS
730: SELECT wu.name, wu.display_name
731: FROM jtf_rs_teams_vl t,
732: jtf_rs_role_relations_vl jtfr,
733: jtf_rs_Resource_extns a,
734: jtf_rs_Team_Members b,
735: jtf_rs_Groups_b d,
736: jtf_rs_resource_extns re,
737: wf_users WU

Line 736: jtf_rs_resource_extns re,

732: jtf_rs_role_relations_vl jtfr,
733: jtf_rs_Resource_extns a,
734: jtf_rs_Team_Members b,
735: jtf_rs_Groups_b d,
736: jtf_rs_resource_extns re,
737: wf_users WU
738: WHERE t.team_id = c_team_id
739: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
740: AND nvl (t.end_date_active, sysdate + 1) >= sysdate

Line 2355: jtf_rs_Resource_extns a,

2351: IS
2352: SELECT count(1)
2353: FROM jtf_rs_teams_b t,
2354: jtf_rs_role_relations_vl jtfr,
2355: jtf_rs_Resource_extns a,
2356: jtf_rs_Team_Members b,
2357: jtf_rs_Groups_b d,
2358: jtf_rs_resource_extns re,
2359: wf_users WU

Line 2358: jtf_rs_resource_extns re,

2354: jtf_rs_role_relations_vl jtfr,
2355: jtf_rs_Resource_extns a,
2356: jtf_rs_Team_Members b,
2357: jtf_rs_Groups_b d,
2358: jtf_rs_resource_extns re,
2359: wf_users WU
2360: WHERE
2361: t.team_id = c_team_id
2362: AND nvl (t.start_date_active, sysdate - 1) <= sysdate

Line 2513: jtf_rs_Resource_extns a,

2509: IS
2510: SELECT wu.name, wu.display_name
2511: FROM jtf_rs_teams_vl t,
2512: jtf_rs_role_relations_vl jtfr,
2513: jtf_rs_Resource_extns a,
2514: jtf_rs_Team_Members b,
2515: jtf_rs_Groups_b d,
2516: jtf_rs_resource_extns re,
2517: wf_users WU

Line 2516: jtf_rs_resource_extns re,

2512: jtf_rs_role_relations_vl jtfr,
2513: jtf_rs_Resource_extns a,
2514: jtf_rs_Team_Members b,
2515: jtf_rs_Groups_b d,
2516: jtf_rs_resource_extns re,
2517: wf_users WU
2518: WHERE t.team_id = c_team_id
2519: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
2520: AND nvl (t.end_date_active, sysdate + 1) >= sysdate