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_RESULTS_GT_L1

Line 891: l_terr_L1_target := 'JTF_TERR_RESULTS_GT_L1';

887:
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889: l_worker_id := 1;
890: l_matches_target := 'JTF_TERR_RESULTS_GT_MT';
891: l_terr_L1_target := 'JTF_TERR_RESULTS_GT_L1';
892: l_terr_L2_target := 'JTF_TERR_RESULTS_GT_L2';
893: l_terr_L3_target := 'JTF_TERR_RESULTS_GT_L3';
894: l_terr_L4_target := 'JTF_TERR_RESULTS_GT_L4';
895: l_terr_L5_target := 'JTF_TERR_RESULTS_GT_L5';

Line 904: DELETE FROM JTF_TERR_RESULTS_GT_L1;

900: ELSE
901: l_date_effective := false;
902: END IF;
903:
904: DELETE FROM JTF_TERR_RESULTS_GT_L1;
905: DELETE FROM JTF_TERR_RESULTS_GT_L2;
906: DELETE FROM JTF_TERR_RESULTS_GT_L3;
907: DELETE FROM JTF_TERR_RESULTS_GT_L4;
908: DELETE FROM JTF_TERR_RESULTS_GT_L5;

Line 941: FROM jtf_terr_results_gt_l1;

937: -- debug message
938: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
939: SELECT COUNT(*)
940: INTO l_winner_no_of_records
941: FROM jtf_terr_results_gt_l1;
942:
943: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
944: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l1',
945: 'Number of records inserted into jtf_terr_results_gt_l1 table : ' || l_winner_no_of_records);

Line 945: 'Number of records inserted into jtf_terr_results_gt_l1 table : ' || l_winner_no_of_records);

941: FROM jtf_terr_results_gt_l1;
942:
943: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
944: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l1',
945: 'Number of records inserted into jtf_terr_results_gt_l1 table : ' || l_winner_no_of_records);
946: END IF;
947:
948: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (
949: p_terr_LEVEL_target_tbl => l_terr_L2_target,

Line 1249: FROM jtf_terr_results_GT_L1 LX

1245: SELECT LX.trans_object_id
1246: , LX.trans_detail_object_id
1247: , LX.WIN_TERR_ID
1248: , LX.txn_date
1249: FROM jtf_terr_results_GT_L1 LX
1250: , ( SELECT trans_object_id
1251: , trans_detail_object_id
1252: , WIN_TERR_ID WIN_TERR_ID
1253: FROM JTF_terr_results_GT_L1

Line 1253: FROM JTF_terr_results_GT_L1

1249: FROM jtf_terr_results_GT_L1 LX
1250: , ( SELECT trans_object_id
1251: , trans_detail_object_id
1252: , WIN_TERR_ID WIN_TERR_ID
1253: FROM JTF_terr_results_GT_L1
1254: MINUS
1255: SELECT trans_object_id
1256: , trans_detail_object_id
1257: , ul_terr_id WIN_TERR_ID

Line 1442: FROM jtf_terr_results_GT_L1 LX

1438: SELECT LX.trans_object_id
1439: , LX.trans_detail_object_id
1440: , LX.WIN_TERR_ID
1441: , LX.txn_date
1442: FROM jtf_terr_results_GT_L1 LX
1443: , ( SELECT trans_object_id
1444: , trans_detail_object_id
1445: , WIN_TERR_ID WIN_TERR_ID
1446: FROM JTF_terr_results_GT_L1

Line 1446: FROM JTF_terr_results_GT_L1

1442: FROM jtf_terr_results_GT_L1 LX
1443: , ( SELECT trans_object_id
1444: , trans_detail_object_id
1445: , WIN_TERR_ID WIN_TERR_ID
1446: FROM JTF_terr_results_GT_L1
1447: MINUS
1448: SELECT trans_object_id
1449: , trans_detail_object_id
1450: , ul_terr_id WIN_TERR_ID

Line 1734: FROM jtf_terr_results_GT_L1 LX

1730: SELECT LX.trans_object_id
1731: , LX.trans_detail_object_id
1732: , LX.WIN_TERR_ID
1733: , LX.txn_date
1734: FROM jtf_terr_results_GT_L1 LX
1735: , ( SELECT trans_object_id
1736: , trans_detail_object_id
1737: , WIN_TERR_ID WIN_TERR_ID
1738: FROM JTF_terr_results_GT_L1

Line 1738: FROM JTF_terr_results_GT_L1

1734: FROM jtf_terr_results_GT_L1 LX
1735: , ( SELECT trans_object_id
1736: , trans_detail_object_id
1737: , WIN_TERR_ID WIN_TERR_ID
1738: FROM JTF_terr_results_GT_L1
1739: MINUS
1740: SELECT trans_object_id
1741: , trans_detail_object_id
1742: , ul_terr_id WIN_TERR_ID