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_TERR_RSC_ACCESS_ALL

Line 330: , jtf_terr_rsc_access_all jtra

326: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
327: ) WT
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

Line 484: , jtf_terr_rsc_access_all jtra

480: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
481: ) WT
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

Line 586: , jtf_terr_rsc_access_all jtra

582: AND EXISTS (
583: SELECT 1
584: FROM
585: jtf_terr_rsc_all jtr
586: , jtf_terr_rsc_access_all jtra
587: , jtf_qual_types_all jqta
588: WHERE WT.terr_id = jtr.terr_id
589: AND jtr.end_date_active >= WT.txn_date
590: AND jtr.start_date_active <= WT.txn_date

Line 778: , jtf_terr_rsc_access_all jtra

774: ) WT
775: , jtf_terr_all jta
776: , jtf_terr_all jta_p
777: , jtf_terr_rsc_all jtr
778: , jtf_terr_rsc_access_all jtra
779: , jtf_qual_types_all jqta
780: , (select a.group_id resource_id, a.group_name resource_name, 'RS_GROUP' resource_type
781: from jtf_rs_groups_tl a
782: where a.language = userenv('LANG')

Line 1364: , jtf_terr_rsc_access_all jtra

1360:
1361: ) WINNERS
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

Line 1561: , jtf_terr_rsc_access_all jtra

1557: AND EXISTS (
1558: SELECT 1
1559: FROM
1560: jtf_terr_rsc_all jtr
1561: , jtf_terr_rsc_access_all jtra
1562: , jtf_qual_types_all jqta
1563: WHERE WINNERS.win_terr_id = jtr.terr_id
1564: AND jtr.end_date_active >= WINNERS.txn_date
1565: AND jtr.start_date_active <= WINNERS.txn_date

Line 1850: , jtf_terr_rsc_access_all jtra

1846: ) WINNERS
1847: , jtf_terr_all jta
1848: , jtf_terr_all jta_p
1849: , jtf_terr_rsc_all jtr
1850: , jtf_terr_rsc_access_all jtra
1851: , jtf_qual_types_all jqta
1852: , (select a.group_id resource_id, a.group_name resource_name, 'RS_GROUP' resource_type
1853: from jtf_rs_groups_tl a
1854: where a.language = userenv('LANG')