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

Line 56: isc_dbi_sutil_pkg.process_parameters (

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

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

173:
174: -- initialization block
175:
176: -- Column to get view by column name
177: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
178:
179: -- fact column view by's
180: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
181:

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

176: -- Column to get view by column name
177: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
178:
179: -- fact column view by's
180: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
181:
182: -- Outer select clause
183: l_sel_clause :=
184: 'SELECT

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

181:
182: -- Outer select clause
183: l_sel_clause :=
184: 'SELECT
185: ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim)
186: || 'oset.ISC_MEASURE_9 ISC_MEASURE_9,
187: ' || 'oset.ISC_MEASURE_1 ISC_MEASURE_1,
188: ' || 'oset.ISC_MEASURE_12 ISC_MEASURE_12,
189: ' || 'oset.ISC_MEASURE_2 ISC_MEASURE_2,

Line 223: ' || isc_dbi_sutil_pkg.change_str (

219: nvl(c_freight_cost_total,0) ISC_MEASURE_12,
220: nvl(p_freight_volume,0) ISC_MEASURE_10,
221: nvl(c_freight_volume,0) ISC_MEASURE_4,
222: nvl(c_freight_volume_total,0) ISC_MEASURE_15,
223: ' || isc_dbi_sutil_pkg.change_str (
224: p_new_numerator => 'c_freight_cost',
225: p_old_numerator => 'p_freight_cost',
226: p_denominator => 'p_freight_cost',
227: p_measure_name => 'ISC_MEASURE_2') || ', -- Rated Fr Cost Change

Line 228: ' || isc_dbi_sutil_pkg.change_str (

224: p_new_numerator => 'c_freight_cost',
225: p_old_numerator => 'p_freight_cost',
226: p_denominator => 'p_freight_cost',
227: p_measure_name => 'ISC_MEASURE_2') || ', -- Rated Fr Cost Change
228: ' || isc_dbi_sutil_pkg.change_str (
229: p_new_numerator => 'c_freight_cost_total',
230: p_old_numerator => 'p_freight_cost_total',
231: p_denominator => 'p_freight_cost_total',
232: p_measure_name => 'ISC_MEASURE_13') || ', -- Grand Total Rated Fr Cost Change

Line 233: ' || isc_dbi_sutil_pkg.rate_str (

229: p_new_numerator => 'c_freight_cost_total',
230: p_old_numerator => 'p_freight_cost_total',
231: p_denominator => 'p_freight_cost_total',
232: p_measure_name => 'ISC_MEASURE_13') || ', -- Grand Total Rated Fr Cost Change
233: ' || isc_dbi_sutil_pkg.rate_str (
234: p_numerator => 'c_freight_cost',
235: p_denominator => 'c_freight_cost_total',
236: p_rate_type => 'PERCENT',
237: p_measure_name => 'ISC_MEASURE_3') || ', -- Percent of Total Fr Cost

Line 238: ' || isc_dbi_sutil_pkg.rate_str (

234: p_numerator => 'c_freight_cost',
235: p_denominator => 'c_freight_cost_total',
236: p_rate_type => 'PERCENT',
237: p_measure_name => 'ISC_MEASURE_3') || ', -- Percent of Total Fr Cost
238: ' || isc_dbi_sutil_pkg.rate_str (
239: p_numerator => 'c_freight_cost_total',
240: p_denominator => 'c_freight_cost_total',
241: p_rate_type => 'PERCENT',
242: p_measure_name => 'ISC_MEASURE_14') || ', -- Grand total Percent of Total Fr Cost

Line 243: ' || isc_dbi_sutil_pkg.change_str (

239: p_numerator => 'c_freight_cost_total',
240: p_denominator => 'c_freight_cost_total',
241: p_rate_type => 'PERCENT',
242: p_measure_name => 'ISC_MEASURE_14') || ', -- Grand total Percent of Total Fr Cost
243: ' || isc_dbi_sutil_pkg.change_str (
244: p_new_numerator => 'c_freight_volume',
245: p_old_numerator => 'p_freight_volume',
246: p_denominator => 'p_freight_volume',
247: p_measure_name => 'ISC_MEASURE_5') || ', -- Rated Fr Volume Change

Line 248: ' || isc_dbi_sutil_pkg.change_str (

244: p_new_numerator => 'c_freight_volume',
245: p_old_numerator => 'p_freight_volume',
246: p_denominator => 'p_freight_volume',
247: p_measure_name => 'ISC_MEASURE_5') || ', -- Rated Fr Volume Change
248: ' || isc_dbi_sutil_pkg.change_str (
249: p_new_numerator => 'c_freight_volume_total',
250: p_old_numerator => 'p_freight_volume_total',
251: p_denominator => 'p_freight_volume_total',
252: p_measure_name => 'ISC_MEASURE_16') || ', -- Grand Total Rated Fr Volume Change

Line 253: ' || isc_dbi_sutil_pkg.rate_str (

249: p_new_numerator => 'c_freight_volume_total',
250: p_old_numerator => 'p_freight_volume_total',
251: p_denominator => 'p_freight_volume_total',
252: p_measure_name => 'ISC_MEASURE_16') || ', -- Grand Total Rated Fr Volume Change
253: ' || isc_dbi_sutil_pkg.rate_str (
254: p_numerator => 'c_freight_volume',
255: p_denominator => 'c_freight_volume_total',
256: p_rate_type => 'PERCENT',
257: p_measure_name => 'ISC_MEASURE_6') || ', -- Percent of Total Fr Volume

Line 258: ' || isc_dbi_sutil_pkg.rate_str (

254: p_numerator => 'c_freight_volume',
255: p_denominator => 'c_freight_volume_total',
256: p_rate_type => 'PERCENT',
257: p_measure_name => 'ISC_MEASURE_6') || ', -- Percent of Total Fr Volume
258: ' || isc_dbi_sutil_pkg.rate_str (
259: p_numerator => 'c_freight_cost_total',
260: p_denominator => 'c_freight_cost_total',
261: p_rate_type => 'PERCENT',
262: p_measure_name => 'ISC_MEASURE_17') || ', -- Grand total Percent of total Fr Cost

Line 263: ' || isc_dbi_sutil_pkg.rate_str (

259: p_numerator => 'c_freight_cost_total',
260: p_denominator => 'c_freight_cost_total',
261: p_rate_type => 'PERCENT',
262: p_measure_name => 'ISC_MEASURE_17') || ', -- Grand total Percent of total Fr Cost
263: ' || isc_dbi_sutil_pkg.rate_str (
264: p_numerator => 'p_freight_cost',
265: p_denominator => 'p_freight_volume',
266: p_rate_type => 'RATIO',
267: p_measure_name => 'ISC_MEASURE_11') || ', -- Fr Cost per Volume Prior

Line 268: ' || isc_dbi_sutil_pkg.rate_str (

264: p_numerator => 'p_freight_cost',
265: p_denominator => 'p_freight_volume',
266: p_rate_type => 'RATIO',
267: p_measure_name => 'ISC_MEASURE_11') || ', -- Fr Cost per Volume Prior
268: ' || isc_dbi_sutil_pkg.rate_str (
269: p_numerator => 'c_freight_cost',
270: p_denominator => 'c_freight_volume',
271: p_rate_type => 'RATIO',
272: p_measure_name => 'ISC_MEASURE_7') || ', -- Fr Cost per Volume

Line 273: ' || isc_dbi_sutil_pkg.rate_str (

269: p_numerator => 'c_freight_cost',
270: p_denominator => 'c_freight_volume',
271: p_rate_type => 'RATIO',
272: p_measure_name => 'ISC_MEASURE_7') || ', -- Fr Cost per Volume
273: ' || isc_dbi_sutil_pkg.rate_str (
274: p_numerator => 'c_freight_cost_total',
275: p_denominator => 'c_freight_volume_total',
276: p_rate_type => 'RATIO',
277: p_measure_name => 'ISC_MEASURE_18') || ', -- Grand Total Fr Cost per Volume

Line 278: ' || isc_dbi_sutil_pkg.change_rate_str (

274: p_numerator => 'c_freight_cost_total',
275: p_denominator => 'c_freight_volume_total',
276: p_rate_type => 'RATIO',
277: p_measure_name => 'ISC_MEASURE_18') || ', -- Grand Total Fr Cost per Volume
278: ' || isc_dbi_sutil_pkg.change_rate_str (
279: p_new_numerator => 'c_freight_cost',
280: p_new_denominator => 'c_freight_volume',
281: p_old_numerator => 'p_freight_cost',
282: p_old_denominator => 'p_freight_volume',

Line 285: ' || isc_dbi_sutil_pkg.change_rate_str (

281: p_old_numerator => 'p_freight_cost',
282: p_old_denominator => 'p_freight_volume',
283: p_rate_type => 'RATIO',
284: p_measure_name => 'ISC_MEASURE_8') || ', -- Fr Cost per Volume Change
285: ' || isc_dbi_sutil_pkg.change_rate_str (
286: p_new_numerator => 'c_freight_cost_total',
287: p_new_denominator => 'c_freight_volume_total',
288: p_old_numerator => 'p_freight_cost_total',
289: p_old_denominator => 'p_freight_volume_total',