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.ISC_DBI_BSA_OBJECTS_C dependencies on ISC_DBI_TMP_BSA_ORDER_LINES

Line 83: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';

79:
80: bis_collection_utilities.put_line('Truncating the temp tables');
81: fii_util.start_timer;
82:
83: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';
84: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';
85:
86: fii_util.stop_timer;
87: fii_util.print_timer('Truncated the temp tables in');

Line 110: insert /+ APPEND PARALLEL(F) / into isc_dbi_tmp_bsa_order_lines f (

106:
107: bis_collection_utilities.put_line('Identifying blanket sales agreements');
108: fii_util.start_timer;
109:
110: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_tmp_bsa_order_lines f (
111: order_line_id,
112: order_line_header_id,
113: order_number,
114: line_number,

Line 243: from isc_dbi_tmp_bsa_order_lines tmp);

239: fii_currency.get_global_rate_primary(transactional_curr_code, time_activation_date_id)) rate1,
240: decode(transactional_curr_code, g_sec_global_currency, 1,
241: fii_currency.get_global_rate_secondary(transactional_curr_code, time_activation_date_id)) rate2
242: from (select /*+ PARALLEL(tmp) */ distinct transactional_curr_code, time_activation_date_id
243: from isc_dbi_tmp_bsa_order_lines tmp);
244:
245: return(l_bsa_count);
246:
247: exception

Line 345: from isc_dbi_tmp_bsa_order_lines

341: blanket_number,
342: to_char(time_activation_date_id, 'MM/DD/YYYY') time_activation_date_id,
343: to_char(time_expiration_date_id, 'MM/DD/YYYY') time_expiration_date_id,
344: to_char(time_termination_date_id,'MM/DD/YYYY') time_termination_date_id
345: from isc_dbi_tmp_bsa_order_lines
346: where (least(time_activation_date_id,
347: nvl(time_expiration_date_id,time_activation_date_id),
348: nvl(time_termination_date_id,time_activation_date_id)) < l_time_min
349: or greatest(time_activation_date_id,

Line 367: from isc_dbi_tmp_bsa_order_lines tmp;

363: min(time_termination_date_id), max(time_termination_date_id)
364: into l_min_act_date, l_max_act_date,
365: l_min_exp_date, l_max_exp_date,
366: l_min_trm_date, l_max_trm_date
367: from isc_dbi_tmp_bsa_order_lines tmp;
368:
369: l_min := least(l_min_act_date,
370: nvl(l_min_exp_date,l_min_act_date),
371: nvl(l_min_trm_date,l_min_act_date));

Line 613: from isc_dbi_tmp_bsa_order_lines tmp,

609: tmp.program_id,
610: tmp.program_login_id,
611: tmp.program_application_id,
612: tmp.request_id
613: from isc_dbi_tmp_bsa_order_lines tmp,
614: isc_curr_bsa_order_lines curr,
615: jtf_rs_srp_groups sg,
616: hz_cust_accounts cust_acct
617: where tmp.transactional_curr_code = curr.from_currency

Line 647: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';

643:
644: bis_collection_utilities.put_line('Truncating the temp tables');
645: fii_util.start_timer;
646:
647: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';
648: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';
649:
650: fii_util.stop_timer;
651: fii_util.print_timer('Truncated the temp tables in');

Line 732: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');

728: bis_collection_utilities.put_line('Analyzing temp tables');
729: fii_util.start_timer;
730:
731: fnd_stats.gather_table_stats(ownname => g_isc_schema,
732: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');
733: fnd_stats.gather_table_stats(ownname => g_isc_schema,
734: tabname => 'ISC_CURR_BSA_ORDER_LINES');
735:
736: fii_util.stop_timer;

Line 818: insert /+ APPEND PARALLEL(F) / into isc_dbi_tmp_bsa_order_lines f (

814: -- delete obsoleted records from base summary
815:
816: fii_util.start_timer;
817:
818: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_tmp_bsa_order_lines f (
819: order_line_id,
820: order_line_header_id,
821: order_number,
822: line_number,

Line 952: from isc_dbi_tmp_bsa_order_lines tmp);

948: fii_currency.get_global_rate_primary(transactional_curr_code, time_activation_date_id)) rate1,
949: decode(transactional_curr_code, g_sec_global_currency, 1,
950: fii_currency.get_global_rate_secondary(transactional_curr_code, time_activation_date_id)) rate2
951: from (select /*+ PARALLEL(tmp) */ distinct transactional_curr_code, time_activation_date_id
952: from isc_dbi_tmp_bsa_order_lines tmp);
953:
954: fii_util.stop_timer;
955: fii_util.print_timer('Retrieved '||sql%rowcount||' currency rates in');
956: commit;

Line 960: update isc_dbi_tmp_bsa_order_lines set batch_id = ceil(rownum/g_batch_size);

956: commit;
957:
958: fii_util.start_timer;
959:
960: update isc_dbi_tmp_bsa_order_lines set batch_id = ceil(rownum/g_batch_size);
961: l_total := sql%rowcount;
962: commit;
963:
964: fii_util.stop_timer;

Line 1000: from isc_dbi_tmp_bsa_order_lines

996: blanket_number,
997: to_char(time_activation_date_id, 'MM/DD/YYYY') time_activation_date_id,
998: to_char(time_expiration_date_id, 'MM/DD/YYYY') time_expiration_date_id,
999: to_char(time_termination_date_id,'MM/DD/YYYY') time_termination_date_id
1000: from isc_dbi_tmp_bsa_order_lines
1001: where (least(time_activation_date_id,
1002: nvl(time_expiration_date_id,time_activation_date_id),
1003: nvl(time_termination_date_id,time_activation_date_id)) < l_time_min
1004: or greatest(time_activation_date_id,

Line 1022: from isc_dbi_tmp_bsa_order_lines tmp;

1018: min(time_termination_date_id), max(time_termination_date_id)
1019: into l_min_act_date, l_max_act_date,
1020: l_min_exp_date, l_max_exp_date,
1021: l_min_trm_date, l_max_trm_date
1022: from isc_dbi_tmp_bsa_order_lines tmp;
1023:
1024: l_min := least(l_min_act_date,
1025: nvl(l_min_exp_date,l_min_act_date),
1026: nvl(l_min_trm_date,l_min_act_date));

Line 1158: isc_dbi_tmp_bsa_order_lines t

1154: from (select f.blanket_line_id,
1155: t.order_line_id,
1156: rank() over (partition by f.blanket_line_id order by t.order_line_id) rnk
1157: from isc_dbi_bsa_order_lines_f f,
1158: isc_dbi_tmp_bsa_order_lines t
1159: where f.blanket_line_id = t.blanket_line_id
1160: and f.order_line_id is null
1161: and t.order_line_id is not null)
1162: where rnk = 1;

Line 1258: from isc_dbi_tmp_bsa_order_lines tmp,

1254: tmp.program_id,
1255: tmp.program_login_id,
1256: tmp.program_application_id,
1257: tmp.request_id
1258: from isc_dbi_tmp_bsa_order_lines tmp,
1259: isc_curr_bsa_order_lines curr,
1260: jtf_rs_srp_groups sg,
1261: hz_cust_accounts cust_acct
1262: where tmp.transactional_curr_code = curr.from_currency

Line 1503: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');

1499: bis_collection_utilities.put_line('Analyzing temp tables');
1500: fii_util.start_timer;
1501:
1502: fnd_stats.gather_table_stats(ownname => g_isc_schema,
1503: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');
1504: fnd_stats.gather_table_stats(ownname => g_isc_schema,
1505: tabname => 'ISC_CURR_BSA_ORDER_LINES');
1506:
1507: fii_util.stop_timer;