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

Line 58: isc_dbi_sutil_pkg.process_parameters (

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

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

190:
191: -- initialization block
192:
193: -- Column to get view by column name
194: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
195:
196: -- fact column view by's
197: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
198:

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

193: -- Column to get view by column name
194: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
195:
196: -- fact column view by's
197: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
198:
199: -- Outer select clause
200: l_sel_clause :=
201: 'SELECT

Line 202: ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim)

198:
199: -- Outer select clause
200: l_sel_clause :=
201: 'SELECT
202: ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim)
203: || 'oset.ISC_MEASURE_9 ISC_MEASURE_9,
204: ' || 'oset.ISC_MEASURE_1 ISC_MEASURE_1,
205: ' || 'oset.ISC_MEASURE_12 ISC_MEASURE_12,
206: ' || 'oset.ISC_MEASURE_2 ISC_MEASURE_2,

Line 240: ' || isc_dbi_sutil_pkg.change_str (

236: nvl(c_freight_cost_total,0) ISC_MEASURE_12,
237: nvl(p_freight_distance,0) ISC_MEASURE_10,
238: nvl(c_freight_distance,0) ISC_MEASURE_4,
239: nvl(c_freight_distance_total,0) ISC_MEASURE_15,
240: ' || isc_dbi_sutil_pkg.change_str (
241: p_new_numerator => 'c_freight_cost',
242: p_old_numerator => 'p_freight_cost',
243: p_denominator => 'p_freight_cost',
244: p_measure_name => 'ISC_MEASURE_2') || ', -- Rated Fr Cost Change

Line 245: ' || isc_dbi_sutil_pkg.change_str (

241: p_new_numerator => 'c_freight_cost',
242: p_old_numerator => 'p_freight_cost',
243: p_denominator => 'p_freight_cost',
244: p_measure_name => 'ISC_MEASURE_2') || ', -- Rated Fr Cost Change
245: ' || isc_dbi_sutil_pkg.change_str (
246: p_new_numerator => 'c_freight_cost_total',
247: p_old_numerator => 'p_freight_cost_total',
248: p_denominator => 'p_freight_cost_total',
249: p_measure_name => 'ISC_MEASURE_13') || ', -- Grand Total Rated Fr Cost Change

Line 250: ' || isc_dbi_sutil_pkg.rate_str (

246: p_new_numerator => 'c_freight_cost_total',
247: p_old_numerator => 'p_freight_cost_total',
248: p_denominator => 'p_freight_cost_total',
249: p_measure_name => 'ISC_MEASURE_13') || ', -- Grand Total Rated Fr Cost Change
250: ' || isc_dbi_sutil_pkg.rate_str (
251: p_numerator => 'c_freight_cost',
252: p_denominator => 'c_freight_cost_total',
253: p_rate_type => 'PERCENT',
254: p_measure_name => 'ISC_MEASURE_3') || ', -- Percent of Total Fr Cost

Line 255: ' || isc_dbi_sutil_pkg.rate_str (

251: p_numerator => 'c_freight_cost',
252: p_denominator => 'c_freight_cost_total',
253: p_rate_type => 'PERCENT',
254: p_measure_name => 'ISC_MEASURE_3') || ', -- Percent of Total Fr Cost
255: ' || isc_dbi_sutil_pkg.rate_str (
256: p_numerator => 'c_freight_cost_total',
257: p_denominator => 'c_freight_cost_total',
258: p_rate_type => 'PERCENT',
259: p_measure_name => 'ISC_MEASURE_14') || ', -- Grand total Percent of Total Fr Cost

Line 260: ' || isc_dbi_sutil_pkg.change_str (

256: p_numerator => 'c_freight_cost_total',
257: p_denominator => 'c_freight_cost_total',
258: p_rate_type => 'PERCENT',
259: p_measure_name => 'ISC_MEASURE_14') || ', -- Grand total Percent of Total Fr Cost
260: ' || isc_dbi_sutil_pkg.change_str (
261: p_new_numerator => 'c_freight_distance',
262: p_old_numerator => 'p_freight_distance',
263: p_denominator => 'p_freight_distance',
264: p_measure_name => 'ISC_MEASURE_5') || ', -- Rated Fr Distance Change

Line 265: ' || isc_dbi_sutil_pkg.change_str (

261: p_new_numerator => 'c_freight_distance',
262: p_old_numerator => 'p_freight_distance',
263: p_denominator => 'p_freight_distance',
264: p_measure_name => 'ISC_MEASURE_5') || ', -- Rated Fr Distance Change
265: ' || isc_dbi_sutil_pkg.change_str (
266: p_new_numerator => 'c_freight_distance_total',
267: p_old_numerator => 'p_freight_distance_total',
268: p_denominator => 'p_freight_distance_total',
269: p_measure_name => 'ISC_MEASURE_16') || ', -- Grand Total Rated Fr Distance Change

Line 270: ' || isc_dbi_sutil_pkg.rate_str (

266: p_new_numerator => 'c_freight_distance_total',
267: p_old_numerator => 'p_freight_distance_total',
268: p_denominator => 'p_freight_distance_total',
269: p_measure_name => 'ISC_MEASURE_16') || ', -- Grand Total Rated Fr Distance Change
270: ' || isc_dbi_sutil_pkg.rate_str (
271: p_numerator => 'c_freight_distance',
272: p_denominator => 'c_freight_distance_total',
273: p_rate_type => 'PERCENT',
274: p_measure_name => 'ISC_MEASURE_6') || ', -- Percent of Total Fr Distance

Line 275: ' || isc_dbi_sutil_pkg.rate_str (

271: p_numerator => 'c_freight_distance',
272: p_denominator => 'c_freight_distance_total',
273: p_rate_type => 'PERCENT',
274: p_measure_name => 'ISC_MEASURE_6') || ', -- Percent of Total Fr Distance
275: ' || isc_dbi_sutil_pkg.rate_str (
276: p_numerator => 'c_freight_cost_total',
277: p_denominator => 'c_freight_cost_total',
278: p_rate_type => 'PERCENT',
279: p_measure_name => 'ISC_MEASURE_17') || ', -- Grand total Percent of total Fr Cost

Line 280: ' || isc_dbi_sutil_pkg.rate_str (

276: p_numerator => 'c_freight_cost_total',
277: p_denominator => 'c_freight_cost_total',
278: p_rate_type => 'PERCENT',
279: p_measure_name => 'ISC_MEASURE_17') || ', -- Grand total Percent of total Fr Cost
280: ' || isc_dbi_sutil_pkg.rate_str (
281: p_numerator => 'p_freight_cost',
282: p_denominator => 'p_freight_distance',
283: p_rate_type => 'RATIO',
284: p_measure_name => 'ISC_MEASURE_11') || ', -- Fr Cost per Distance Prior

Line 285: ' || isc_dbi_sutil_pkg.rate_str (

281: p_numerator => 'p_freight_cost',
282: p_denominator => 'p_freight_distance',
283: p_rate_type => 'RATIO',
284: p_measure_name => 'ISC_MEASURE_11') || ', -- Fr Cost per Distance Prior
285: ' || isc_dbi_sutil_pkg.rate_str (
286: p_numerator => 'c_freight_cost',
287: p_denominator => 'c_freight_distance',
288: p_rate_type => 'RATIO',
289: p_measure_name => 'ISC_MEASURE_7') || ', -- Fr Cost per Distance

Line 290: ' || isc_dbi_sutil_pkg.rate_str (

286: p_numerator => 'c_freight_cost',
287: p_denominator => 'c_freight_distance',
288: p_rate_type => 'RATIO',
289: p_measure_name => 'ISC_MEASURE_7') || ', -- Fr Cost per Distance
290: ' || isc_dbi_sutil_pkg.rate_str (
291: p_numerator => 'c_freight_cost_total',
292: p_denominator => 'c_freight_distance_total',
293: p_rate_type => 'RATIO',
294: p_measure_name => 'ISC_MEASURE_18') || ', -- Grand Total Fr Cost per Distance

Line 295: ' || isc_dbi_sutil_pkg.change_rate_str (

291: p_numerator => 'c_freight_cost_total',
292: p_denominator => 'c_freight_distance_total',
293: p_rate_type => 'RATIO',
294: p_measure_name => 'ISC_MEASURE_18') || ', -- Grand Total Fr Cost per Distance
295: ' || isc_dbi_sutil_pkg.change_rate_str (
296: p_new_numerator => 'c_freight_cost',
297: p_new_denominator => 'c_freight_distance',
298: p_old_numerator => 'p_freight_cost',
299: p_old_denominator => 'p_freight_distance',

Line 302: ' || isc_dbi_sutil_pkg.change_rate_str (

298: p_old_numerator => 'p_freight_cost',
299: p_old_denominator => 'p_freight_distance',
300: p_rate_type => 'RATIO',
301: p_measure_name => 'ISC_MEASURE_8') || ', -- Fr Cost per Distance Change
302: ' || isc_dbi_sutil_pkg.change_rate_str (
303: p_new_numerator => 'c_freight_cost_total',
304: p_new_denominator => 'c_freight_distance_total',
305: p_old_numerator => 'p_freight_cost_total',
306: p_old_denominator => 'p_freight_distance_total',