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_BULK_PUB dependencies on AD_DDL

Line 2848: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.drop_table, 'drop table ' || l_mp_winner_target, l_mp_winner_target);

2844: /* create a temp table that will contain all the transaction objects */
2845: /* and their matching territories in a single row */
2846: /* drop the table if it alreday exists */
2847: BEGIN
2848: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.drop_table, 'drop table ' || l_mp_winner_target, l_mp_winner_target);
2849: EXCEPTION
2850: when others then
2851: jty_log(FND_LOG.LEVEL_STATEMENT,
2852: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',

Line 2886: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_mp_winner_target);

2882: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
2883: substr(l_dyn_str, 1, 4000));
2884:
2885: /* create the table in jtf schema */
2886: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_mp_winner_target);
2887:
2888: jty_log(FND_LOG.LEVEL_STATEMENT,
2889: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
2890: 'Table ' || l_mp_winner_target || ' successfully created');

Line 2896: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.drop_table, 'drop table ' || l_dmc_winner_target, l_dmc_winner_target);

2892: /* create a temp table that will contain only the distinct */
2893: /* combination of matching territories in a single row */
2894: /* drop the table if it alreday exists */
2895: BEGIN
2896: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.drop_table, 'drop table ' || l_dmc_winner_target, l_dmc_winner_target);
2897: EXCEPTION
2898: when others then
2899: jty_log(FND_LOG.LEVEL_STATEMENT,
2900: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',

Line 2929: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_dmc_winner_target);

2925: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
2926: substr(l_dyn_str, 1, 4000));
2927:
2928: /* Create the table in JTF schema */
2929: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_dmc_winner_target);
2930:
2931: jty_log(FND_LOG.LEVEL_STATEMENT,
2932: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
2933: 'Table ' || l_dmc_winner_target || ' successfully created');

Line 3039: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_index, l_dyn_str, l_dmc_winner_target || 'N');

3035: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target_index',
3036: substr(l_dyn_str, 1, 4000));
3037:
3038: /* Create the index in JTF schema */
3039: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_index, l_dyn_str, l_dmc_winner_target || 'N');
3040:
3041: /* update the temporary table to maintain the link */
3042: /* between txn objects and unique terr matching combinations */
3043: l_dyn_str :=