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_ALL

Line 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)

322: , i.trans_detail_object_id
323: , i.top_level_terr_id
324: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
325: FROM jtf_terr_results_GT_MT i ) o
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

Line 328: , jtf_terr_all jta

324: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
325: FROM jtf_terr_results_GT_MT i ) o
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

Line 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)

476: , i.trans_detail_object_id
477: , i.top_level_terr_id
478: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
479: FROM jtf_terr_results_GT_MT i ) o
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

Line 482: , jtf_terr_all jta

478: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
479: FROM jtf_terr_results_GT_MT i ) o
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

Line 578: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)

574: , i.trans_detail_object_id
575: , i.top_level_terr_id
576: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
577: FROM jtf_terr_results_GT_MT i ) o
578: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
579: ) WT
580: , jtf_terr_all jta
581: WHERE WT.terr_id = jta.terr_id
582: AND EXISTS (

Line 580: , jtf_terr_all jta

576: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
577: FROM jtf_terr_results_GT_MT i ) o
578: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
579: ) WT
580: , jtf_terr_all jta
581: WHERE WT.terr_id = jta.terr_id
582: AND EXISTS (
583: SELECT 1
584: FROM

Line 773: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)

769: , i.trans_detail_object_id
770: , i.top_level_terr_id
771: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
772: FROM jtf_terr_results_GT_MT i ) o
773: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
774: ) WT
775: , jtf_terr_all jta
776: , jtf_terr_all jta_p
777: , jtf_terr_rsc_all jtr

Line 775: , jtf_terr_all jta

771: ORDER BY i.absolute_rank DESC, i.terr_id) AS TERR_RANK
772: FROM jtf_terr_results_GT_MT i ) o
773: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
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

Line 776: , jtf_terr_all jta_p

772: FROM jtf_terr_results_GT_MT i ) o
773: WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id)
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

Line 1362: , jtf_terr_all jta

1358: , txn_date
1359: FROM jtf_terr_results_GT_wt
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

Line 1555: , jtf_terr_all jta

1551: , txn_date
1552: FROM jtf_terr_results_GT_wt
1553:
1554: ) WINNERS
1555: , jtf_terr_all jta
1556: WHERE WINNERS.win_terr_id = jta.terr_id
1557: AND EXISTS (
1558: SELECT 1
1559: FROM

Line 1847: , jtf_terr_all jta

1843: , txn_date
1844: FROM jtf_terr_results_GT_wt
1845:
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

Line 1848: , jtf_terr_all jta_p

1844: FROM jtf_terr_results_GT_wt
1845:
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