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_CST_REC_RT_PKG dependencies on ISC_DBI_SUTIL_PKG

Line 54: isc_dbi_sutil_pkg.process_parameters (

50: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
51: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
52:
53: -- get all the query parameters
54: isc_dbi_sutil_pkg.process_parameters (
55: p_param => p_param,
56: p_view_by => l_view_by,
57: p_view_by_col_name => l_view_by_col,
58: p_comparison_type => l_comparison_type,

Line 182: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);

178:
179: -- initialization block
180:
181: -- Column to get view by column name
182: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
183:
184: -- fact column view by's
185: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
186:

Line 185: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);

181: -- Column to get view by column name
182: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
183:
184: -- fact column view by's
185: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
186:
187:
188: -- Outer select clause
189: l_sel_clause :=

Line 191: ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim);

187:
188: -- Outer select clause
189: l_sel_clause :=
190: 'SELECT
191: ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim);
192: IF p_view_by_dim = 'ITEM+ENI_ITEM_ORG' THEN
193: l_sel_clause := l_sel_clause || '
194: v.description ISC_ATTRIBUTE_2, -- Description
195: v2.uom_code ISC_ATTRIBUTE_3, -- UOM

Line 257: ' || isc_dbi_sutil_pkg.change_str (

253: nvl(p_freight_charge,0) ISC_MEASURE_4,
254: nvl(c_freight_charge,0) ISC_MEASURE_5,
255: nvl(c_freight_cost_total,0) ISC_MEASURE_11,
256: nvl(c_freight_charge_total,0) ISC_MEASURE_13,
257: ' || isc_dbi_sutil_pkg.change_str (
258: p_new_numerator => 'c_freight_cost',
259: p_old_numerator => 'p_freight_cost',
260: p_denominator => 'p_freight_cost',
261: p_measure_name => 'ISC_MEASURE_3') || ', -- Estimated Fr Cost Change

Line 262: ' || isc_dbi_sutil_pkg.change_str (

258: p_new_numerator => 'c_freight_cost',
259: p_old_numerator => 'p_freight_cost',
260: p_denominator => 'p_freight_cost',
261: p_measure_name => 'ISC_MEASURE_3') || ', -- Estimated Fr Cost Change
262: ' || isc_dbi_sutil_pkg.change_str (
263: p_new_numerator => 'c_freight_charge',
264: p_old_numerator => 'p_freight_charge',
265: p_denominator => 'p_freight_charge',
266: p_measure_name => 'ISC_MEASURE_6') || ', -- Order Fr Charge Change

Line 267: ' || isc_dbi_sutil_pkg.rate_str (

263: p_new_numerator => 'c_freight_charge',
264: p_old_numerator => 'p_freight_charge',
265: p_denominator => 'p_freight_charge',
266: p_measure_name => 'ISC_MEASURE_6') || ', -- Order Fr Charge Change
267: ' || isc_dbi_sutil_pkg.rate_str (
268: p_numerator => 'c_freight_charge',
269: p_denominator => 'c_freight_charge_total',
270: p_rate_type => 'PERCENT',
271: p_measure_name => 'ISC_MEASURE_7') || ', -- Percent of Total Fr Cost

Line 272: ' || isc_dbi_sutil_pkg.rate_str (

268: p_numerator => 'c_freight_charge',
269: p_denominator => 'c_freight_charge_total',
270: p_rate_type => 'PERCENT',
271: p_measure_name => 'ISC_MEASURE_7') || ', -- Percent of Total Fr Cost
272: ' || isc_dbi_sutil_pkg.rate_str (
273: p_numerator => 'p_freight_charge',
274: p_denominator => 'p_freight_cost',
275: p_rate_type => 'PERCENT',
276: p_measure_name => 'ISC_MEASURE_8') || ', -- Prior Recovery Rate

Line 277: ' || isc_dbi_sutil_pkg.rate_str (

273: p_numerator => 'p_freight_charge',
274: p_denominator => 'p_freight_cost',
275: p_rate_type => 'PERCENT',
276: p_measure_name => 'ISC_MEASURE_8') || ', -- Prior Recovery Rate
277: ' || isc_dbi_sutil_pkg.rate_str (
278: p_numerator => 'c_freight_charge',
279: p_denominator => 'c_freight_cost',
280: p_rate_type => 'PERCENT',
281: p_measure_name => 'ISC_MEASURE_9') || ', -- Recovery Rate

Line 282: ' || isc_dbi_sutil_pkg.change_rate_str (

278: p_numerator => 'c_freight_charge',
279: p_denominator => 'c_freight_cost',
280: p_rate_type => 'PERCENT',
281: p_measure_name => 'ISC_MEASURE_9') || ', -- Recovery Rate
282: ' || isc_dbi_sutil_pkg.change_rate_str (
283: p_new_numerator => 'c_freight_charge',
284: p_new_denominator => 'c_freight_cost',
285: p_old_numerator => 'p_freight_charge',
286: p_old_denominator => 'p_freight_cost',

Line 289: ' || isc_dbi_sutil_pkg.change_str (

285: p_old_numerator => 'p_freight_charge',
286: p_old_denominator => 'p_freight_cost',
287: p_rate_type => 'PERCENT',
288: p_measure_name => 'ISC_MEASURE_10') || ', -- Recovery Rate Change
289: ' || isc_dbi_sutil_pkg.change_str (
290: p_new_numerator => 'c_freight_cost_total',
291: p_old_numerator => 'p_freight_cost_total',
292: p_denominator => 'p_freight_cost_total',
293: p_measure_name => 'ISC_MEASURE_12') || ', --Grand Total Estimated Fr Cost Change

Line 294: ' || isc_dbi_sutil_pkg.change_str (

290: p_new_numerator => 'c_freight_cost_total',
291: p_old_numerator => 'p_freight_cost_total',
292: p_denominator => 'p_freight_cost_total',
293: p_measure_name => 'ISC_MEASURE_12') || ', --Grand Total Estimated Fr Cost Change
294: ' || isc_dbi_sutil_pkg.change_str (
295: p_new_numerator => 'c_freight_charge_total',
296: p_old_numerator => 'p_freight_charge_total',
297: p_denominator => 'p_freight_charge_total',
298: p_measure_name => 'ISC_MEASURE_14') || ', --Grand Total Fr Charge Change

Line 299: ' || isc_dbi_sutil_pkg.rate_str (

295: p_new_numerator => 'c_freight_charge_total',
296: p_old_numerator => 'p_freight_charge_total',
297: p_denominator => 'p_freight_charge_total',
298: p_measure_name => 'ISC_MEASURE_14') || ', --Grand Total Fr Charge Change
299: ' || isc_dbi_sutil_pkg.rate_str (
300: p_numerator => 'c_freight_charge_total',
301: p_denominator => 'c_freight_charge_total',
302: p_rate_type => 'PERCENT',
303: p_measure_name => 'ISC_MEASURE_15') || ', -- Grand Total Percent of Total Fr Cost

Line 304: ' || isc_dbi_sutil_pkg.rate_str (

300: p_numerator => 'c_freight_charge_total',
301: p_denominator => 'c_freight_charge_total',
302: p_rate_type => 'PERCENT',
303: p_measure_name => 'ISC_MEASURE_15') || ', -- Grand Total Percent of Total Fr Cost
304: ' || isc_dbi_sutil_pkg.rate_str (
305: p_numerator => 'c_freight_charge_total',
306: p_denominator => 'c_freight_cost_total',
307: p_rate_type => 'PERCENT',
308: p_measure_name => 'ISC_MEASURE_16') || ', -- Grand Total Recovery Rate

Line 309: ' || isc_dbi_sutil_pkg.change_rate_str (

305: p_numerator => 'c_freight_charge_total',
306: p_denominator => 'c_freight_cost_total',
307: p_rate_type => 'PERCENT',
308: p_measure_name => 'ISC_MEASURE_16') || ', -- Grand Total Recovery Rate
309: ' || isc_dbi_sutil_pkg.change_rate_str (
310: p_new_numerator => 'c_freight_charge_total',
311: p_new_denominator => 'c_freight_cost_total',
312: p_old_numerator => 'p_freight_charge_total',
313: p_old_denominator => 'p_freight_cost_total',