APPS.ISC_FS_INV_USG_ETL_PKG dependencies on ISC_FS_INV_USG_CONV_RATES

Line 142: isc_fs_inv_usg_conv_rates r

138: , r.base_currency_code
139: , nvl(r.conversion_rate1, -999) primary_rate
140: , nvl(r.conversion_rate2, -999) secondary_rate
141: FROM
142: isc_fs_inv_usg_conv_rates r
143: , mtl_parameters mp
144: , ( SELECT /*+ index_ffs(isc_fs_inv_usg_value_stg) */ DISTINCT
145: organization_id
146: , transaction_date

Line 214: , 'ISC_FS_INV_USG_CONV_RATES'

210: -- truncate the conversion rates work table
211: l_stmt_num := 50;
212: IF truncate_table
213: ( p_isc_schema
214: , 'ISC_FS_INV_USG_CONV_RATES'
215: , l_err_msg ) <> 0 THEN
216: LOGGER( l_proc_name, l_stmt_num, l_err_msg );
217: RAISE l_exception;
218: END IF;

Line 241: INTO ISC_FS_INV_USG_CONV_RATES

237: -- and hr_organization_information, take care of duplicate codes.
238:
239: l_stmt_num := 60;
240: INSERT /*+ append */
241: INTO ISC_FS_INV_USG_CONV_RATES
242: ( organization_id
243: , transaction_date
244: , base_currency_code
245: , conversion_rate1

Line 310: , 'ISC_FS_INV_USG_CONV_RATES'

306: -- gather statistics on conversion rates table before returning
307: l_stmt_num := 70;
308: IF GATHER_STATISTICS
309: ( p_isc_schema
310: , 'ISC_FS_INV_USG_CONV_RATES'
311: , l_err_msg ) <> 0 then
312: LOGGER( l_proc_name, l_stmt_num, l_err_msg );
313: RAISE l_exception;
314: END IF;

Line 703: ,ISC_FS_INV_USG_CONV_RATES c

699: ,g_program_application_id
700: ,g_request_id
701: FROM
702: ISC_FS_INV_USG_VALUE_STG s
703: ,ISC_FS_INV_USG_CONV_RATES c
704: WHERE
705: c.organization_id = s.organization_id
706: AND c.transaction_date = s.transaction_date;
707:

Line 728: , 'ISC_FS_INV_USG_CONV_RATES'

724:
725: l_stmt_num := 100;
726: IF TRUNCATE_TABLE
727: ( l_isc_schema
728: , 'ISC_FS_INV_USG_CONV_RATES'
729: , l_err_msg ) <> 0 THEN
730: LOGGER( l_proc_name, l_stmt_num, l_err_msg );
731: RAISE l_exception;
732: END IF;

Line 1032: ,ISC_FS_INV_USG_CONV_RATES c

1028: ,c.conversion_rate1
1029: ,c.conversion_rate2
1030: FROM
1031: ISC_FS_INV_USG_VALUE_STG s
1032: ,ISC_FS_INV_USG_CONV_RATES c
1033: WHERE
1034: c.organization_id = s.organization_id
1035: AND c.transaction_date = s.transaction_date
1036: ) t

Line 1113: , 'ISC_FS_INV_USG_CONV_RATES'

1109:
1110: l_stmt_num := 80;
1111: IF TRUNCATE_TABLE
1112: ( l_isc_schema
1113: , 'ISC_FS_INV_USG_CONV_RATES'
1114: , l_err_msg ) <> 0 THEN
1115: LOGGER( l_proc_name, l_stmt_num, l_err_msg );
1116: RAISE l_exception;
1117: END IF;