APPS.ISC_DBI_BSA_OBJECTS_C dependencies on ISC_CURR_BSA_ORDER_LINES

Line 84: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';

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');
88: bis_collection_utilities.put_line(' ');

Line 230: insert /*+ APPEND */ into isc_curr_bsa_order_lines f (

226: fii_util.stop_timer;
227: fii_util.print_timer('Identified ' || l_bsa_count || ' blanket sales agreement in');
228: commit;
229:
230: insert /*+ APPEND */ into isc_curr_bsa_order_lines f (
231: from_currency,
232: conversion_date,
233: rate1,
234: rate2

Line 263: FROM isc_curr_bsa_order_lines tmp

259: from_currency,
260: g_global_currency to_currency,
261: g_global_rate_type rate_type,
262: decode(rate1, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') status
263: FROM isc_curr_bsa_order_lines tmp
264: WHERE rate1 < 0
265: UNION
266: SELECT distinct decode(rate2, -3, to_date('01/01/1999','MM/DD/RRRR'), conversion_date) CURR_CONV_DATE,
267: from_currency,

Line 271: FROM isc_curr_bsa_order_lines tmp

267: from_currency,
268: g_sec_global_currency to_currency,
269: g_sec_global_rate_type rate_type,
270: decode(rate2, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') status
271: FROM isc_curr_bsa_order_lines tmp
272: WHERE rate2 < 0
273: AND g_sec_curr_def = 'Y';
274:
275:

Line 614: isc_curr_bsa_order_lines curr,

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
618: and tmp.time_activation_date_id = curr.conversion_date

Line 648: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';

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');
652: bis_collection_utilities.put_line(' ');

Line 734: tabname => 'ISC_CURR_BSA_ORDER_LINES');

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;
737: fii_util.print_timer('Analyzed the temp tables in ');
738:

Line 939: insert /*+ APPEND */ into isc_curr_bsa_order_lines f (

935: commit;
936:
937: fii_util.start_timer;
938:
939: insert /*+ APPEND */ into isc_curr_bsa_order_lines f (
940: from_currency,
941: conversion_date,
942: rate1,
943: rate2

Line 1259: isc_curr_bsa_order_lines curr,

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
1263: and tmp.time_activation_date_id = curr.conversion_date

Line 1505: tabname => 'ISC_CURR_BSA_ORDER_LINES');

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;
1508: fii_util.print_timer('Analyzed the temp tables in ');
1509: