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

Line 55: isc_dbi_sutil_pkg.process_parameters (

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

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

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

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

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

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

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

Line 225: ' || isc_dbi_sutil_pkg.change_str (

221: nvl(p_freight_weight,0) ISC_MEASURE_10,
222: nvl(p_freight_weight_total,0) ISC_MEASURE_23,
223: nvl(c_freight_weight,0) ISC_MEASURE_4,
224: nvl(c_freight_weight_total,0) ISC_MEASURE_15,
225: ' || isc_dbi_sutil_pkg.change_str (
226: p_new_numerator => 'c_freight_cost',
227: p_old_numerator => 'p_freight_cost',
228: p_denominator => 'p_freight_cost',
229: p_measure_name => 'ISC_MEASURE_2') || ', -- Rated Fr Cost Change

Line 230: ' || isc_dbi_sutil_pkg.change_str (

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

Line 235: ' || isc_dbi_sutil_pkg.rate_str (

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

Line 240: ' || isc_dbi_sutil_pkg.rate_str (

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

Line 245: ' || isc_dbi_sutil_pkg.change_str (

241: p_numerator => 'c_freight_cost_total',
242: p_denominator => 'c_freight_cost_total',
243: p_rate_type => 'PERCENT',
244: p_measure_name => 'ISC_MEASURE_14') || ', -- Grand total Percent of Total Fr Cost
245: ' || isc_dbi_sutil_pkg.change_str (
246: p_new_numerator => 'c_freight_weight',
247: p_old_numerator => 'p_freight_weight',
248: p_denominator => 'p_freight_weight',
249: p_measure_name => 'ISC_MEASURE_5') || ', -- Rated Fr Weight Change

Line 250: ' || isc_dbi_sutil_pkg.change_str (

246: p_new_numerator => 'c_freight_weight',
247: p_old_numerator => 'p_freight_weight',
248: p_denominator => 'p_freight_weight',
249: p_measure_name => 'ISC_MEASURE_5') || ', -- Rated Fr Weight Change
250: ' || isc_dbi_sutil_pkg.change_str (
251: p_new_numerator => 'c_freight_weight_total',
252: p_old_numerator => 'p_freight_weight_total',
253: p_denominator => 'p_freight_weight_total',
254: p_measure_name => 'ISC_MEASURE_16') || ', -- Grand Total Rated Fr Weight Change

Line 255: ' || isc_dbi_sutil_pkg.rate_str (

251: p_new_numerator => 'c_freight_weight_total',
252: p_old_numerator => 'p_freight_weight_total',
253: p_denominator => 'p_freight_weight_total',
254: p_measure_name => 'ISC_MEASURE_16') || ', -- Grand Total Rated Fr Weight Change
255: ' || isc_dbi_sutil_pkg.rate_str (
256: p_numerator => 'c_freight_weight',
257: p_denominator => 'c_freight_weight_total',
258: p_rate_type => 'PERCENT',
259: p_measure_name => 'ISC_MEASURE_6') || ', -- Percent of Total Fr Weight

Line 260: ' || isc_dbi_sutil_pkg.rate_str (

256: p_numerator => 'c_freight_weight',
257: p_denominator => 'c_freight_weight_total',
258: p_rate_type => 'PERCENT',
259: p_measure_name => 'ISC_MEASURE_6') || ', -- Percent of Total Fr Weight
260: ' || isc_dbi_sutil_pkg.rate_str (
261: p_numerator => 'c_freight_cost_total',
262: p_denominator => 'c_freight_cost_total',
263: p_rate_type => 'PERCENT',
264: p_measure_name => 'ISC_MEASURE_17') || ', -- Grand total Percent of total Fr Cost

Line 265: ' || isc_dbi_sutil_pkg.rate_str (

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

Line 270: ' || isc_dbi_sutil_pkg.rate_str (

266: p_numerator => 'p_freight_cost',
267: p_denominator => 'p_freight_weight',
268: p_rate_type => 'RATIO',
269: p_measure_name => 'ISC_MEASURE_11') || ', -- Fr Cost per Weight Prior
270: ' || isc_dbi_sutil_pkg.rate_str (
271: p_numerator => 'p_freight_cost_total',
272: p_denominator => 'p_freight_weight_total',
273: p_rate_type => 'RATIO',
274: p_measure_name => 'ISC_MEASURE_21') || ', -- Grand total Fr Cost per Weight Prior

Line 275: ' || isc_dbi_sutil_pkg.rate_str (

271: p_numerator => 'p_freight_cost_total',
272: p_denominator => 'p_freight_weight_total',
273: p_rate_type => 'RATIO',
274: p_measure_name => 'ISC_MEASURE_21') || ', -- Grand total Fr Cost per Weight Prior
275: ' || isc_dbi_sutil_pkg.rate_str (
276: p_numerator => 'c_freight_cost',
277: p_denominator => 'c_freight_weight',
278: p_rate_type => 'RATIO',
279: p_measure_name => 'ISC_MEASURE_7') || ', -- Fr Cost per Weight

Line 280: ' || isc_dbi_sutil_pkg.rate_str (

276: p_numerator => 'c_freight_cost',
277: p_denominator => 'c_freight_weight',
278: p_rate_type => 'RATIO',
279: p_measure_name => 'ISC_MEASURE_7') || ', -- Fr Cost per Weight
280: ' || isc_dbi_sutil_pkg.rate_str (
281: p_numerator => 'c_freight_cost_total',
282: p_denominator => 'c_freight_weight_total',
283: p_rate_type => 'RATIO',
284: p_measure_name => 'ISC_MEASURE_18') || ', -- Grand Total Fr Cost per Weight

Line 285: ' || isc_dbi_sutil_pkg.change_rate_str (

281: p_numerator => 'c_freight_cost_total',
282: p_denominator => 'c_freight_weight_total',
283: p_rate_type => 'RATIO',
284: p_measure_name => 'ISC_MEASURE_18') || ', -- Grand Total Fr Cost per Weight
285: ' || isc_dbi_sutil_pkg.change_rate_str (
286: p_new_numerator => 'c_freight_cost',
287: p_new_denominator => 'c_freight_weight',
288: p_old_numerator => 'p_freight_cost',
289: p_old_denominator => 'p_freight_weight',

Line 292: ' || isc_dbi_sutil_pkg.change_rate_str (

288: p_old_numerator => 'p_freight_cost',
289: p_old_denominator => 'p_freight_weight',
290: p_rate_type => 'RATIO',
291: p_measure_name => 'ISC_MEASURE_8') || ', -- Fr Cost per Weight Change
292: ' || isc_dbi_sutil_pkg.change_rate_str (
293: p_new_numerator => 'c_freight_cost_total',
294: p_new_denominator => 'c_freight_weight_total',
295: p_old_numerator => 'p_freight_cost_total',
296: p_old_denominator => 'p_freight_weight_total',