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.JTY_ASSIGN_REALTIME_PUB dependencies on JTF_RS_ROLES_B

Line 332: , jtf_rs_roles_b inv

328: , jtf_terr_all jta
329: , jtf_terr_rsc_all jtr
330: , jtf_terr_rsc_access_all jtra
331: , jtf_qual_types_all jqta
332: , jtf_rs_roles_b inv
333: WHERE WT.terr_id = jta.terr_id
334: AND WT.terr_id = jtr.terr_id
335: AND ( (TRUNC(jtr.start_date_active) BETWEEN trunc(p_plan_start_date) AND trunc(p_plan_end_date) ) OR
336: ( TRUNC(jtr.end_date_active) BETWEEN trunc(p_plan_start_date) AND trunc(p_plan_end_date) ) OR

Line 486: , jtf_rs_roles_b inv

482: , jtf_terr_all jta
483: , jtf_terr_rsc_all jtr
484: , jtf_terr_rsc_access_all jtra
485: , jtf_qual_types_all jqta
486: , jtf_rs_roles_b inv
487: WHERE WT.terr_id = jta.terr_id
488: AND WT.terr_id = jtr.terr_id
489: AND jtr.end_date_active >= WT.txn_date
490: AND jtr.start_date_active <= WT.txn_date

Line 1366: , jtf_rs_roles_b inv

1362: , jtf_terr_all jta
1363: , jtf_terr_rsc_all jtr
1364: , jtf_terr_rsc_access_all jtra
1365: , jtf_qual_types_all jqta
1366: , jtf_rs_roles_b inv
1367: WHERE WINNERS.win_terr_id = jta.terr_id
1368: AND WINNERS.win_terr_id = jtr.terr_id
1369: AND jtr.end_date_active >= WINNERS.txn_date
1370: AND jtr.start_date_active <= WINNERS.txn_date