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

Line 67: isc_dbi_sutil_pkg.process_parameters (

63: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
64:
65: -- get all the query parameters
66:
67: isc_dbi_sutil_pkg.process_parameters (
68: p_param => p_param,
69: p_view_by => l_view_by,
70: p_view_by_col_name => l_view_by_col,
71: p_comparison_type => l_comparison_type,

Line 113: isc_dbi_sutil_pkg.process_parameters (

109: END IF;
110:
111: IF (l_view_by <> 'ORGANIZATION+ORGANIZATION_SUBINVENTORY'
112: AND l_where_clause2 NOT LIKE '%fact.subinventory%') THEN
113: isc_dbi_sutil_pkg.process_parameters (
114: p_param => p_param,
115: p_view_by => l_view_by,
116: p_view_by_col_name => l_view_by_col,
117: p_comparison_type => l_comparison_type,

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

240:
241: -- initialization block
242:
243: -- Column to get view by column name
244: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
245:
246: -- fact column view by's
247: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
248:

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

243: -- Column to get view by column name
244: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
245:
246: -- fact column view by's
247: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
248:
249:
250: -- Outer select clause
251: l_sel_clause :=

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

249:
250: -- Outer select clause
251: l_sel_clause :=
252: 'SELECT
253: ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim);
254: IF p_view_by_dim = 'ITEM+ENI_ITEM_ORG' THEN
255: l_sel_clause := l_sel_clause || '
256: v.description ISC_ATTRIBUTE_4, -- Description
257: v2.uom_code ISC_ATTRIBUTE_5, -- UOM

Line 313: ' || isc_dbi_sutil_pkg.change_str (

309: ' || l_view_by_fact_col || ',
310: ' || l_inner_qty_sel_clause1 || '
311: p_pick_release_cnt ISC_MEASURE_2,
312: c_pick_release_cnt ISC_MEASURE_3,
313: ' || isc_dbi_sutil_pkg.change_str (
314: p_new_numerator => 'c_pick_release_cnt',
315: p_old_numerator => 'p_pick_release_cnt',
316: p_denominator => 'p_pick_release_cnt',
317: p_measure_name => 'ISC_MEASURE_4') || ',

Line 321: ' || isc_dbi_sutil_pkg.change_str (

317: p_measure_name => 'ISC_MEASURE_4') || ',
318: ' || l_inner_qty_sel_clause2 || '
319: p_ship_confirm_cnt ISC_MEASURE_6,
320: c_ship_confirm_cnt ISC_MEASURE_7,
321: ' || isc_dbi_sutil_pkg.change_str (
322: p_new_numerator => 'c_ship_confirm_cnt',
323: p_old_numerator => 'p_ship_confirm_cnt',
324: p_denominator => 'p_ship_confirm_cnt',
325: p_measure_name => 'ISC_MEASURE_8') || ',

Line 338: ' || isc_dbi_sutil_pkg.change_str (

334: ELSE ((c_release_to_ship*24/c_ship_confirm_cnt
335: - p_release_to_ship*24/p_ship_confirm_cnt))
336: END ISC_MEASURE_11,
337: c_pick_release_cnt_total ISC_MEASURE_12,
338: ' || isc_dbi_sutil_pkg.change_str (
339: p_new_numerator => 'c_pick_release_cnt_total',
340: p_old_numerator => 'p_pick_release_cnt_total',
341: p_denominator => 'p_pick_release_cnt_total',
342: p_measure_name => 'ISC_MEASURE_13') || ',

Line 344: ' || isc_dbi_sutil_pkg.change_str (

340: p_old_numerator => 'p_pick_release_cnt_total',
341: p_denominator => 'p_pick_release_cnt_total',
342: p_measure_name => 'ISC_MEASURE_13') || ',
343: c_ship_confirm_cnt_total ISC_MEASURE_14,
344: ' || isc_dbi_sutil_pkg.change_str (
345: p_new_numerator => 'c_ship_confirm_cnt_total',
346: p_old_numerator => 'p_ship_confirm_cnt_total',
347: p_denominator => 'p_ship_confirm_cnt_total',
348: p_measure_name => 'ISC_MEASURE_15') || ',

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

383:
384: -- initialization block
385:
386: -- Column to get view by column name
387: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
388:
389: -- fact column view by's
390: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
391:

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

386: -- Column to get view by column name
387: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
388:
389: -- fact column view by's
390: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
391:
392:
393: -- Outer select clause
394: l_sel_clause :=

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

392:
393: -- Outer select clause
394: l_sel_clause :=
395: 'SELECT
396: ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim);
397: IF p_view_by_dim = 'ITEM+ENI_ITEM_ORG' THEN
398: l_sel_clause := l_sel_clause || '
399: v.description ISC_ATTRIBUTE_4, -- Description
400: v2.uom_code ISC_ATTRIBUTE_5, -- UOM

Line 457: ' || isc_dbi_sutil_pkg.change_str (

453: NULL ISC_MEASURE_3,
454: NULL ISC_MEASURE_4,
455: p_ship_confirm_cnt ISC_MEASURE_6,
456: c_ship_confirm_cnt ISC_MEASURE_7,
457: ' || isc_dbi_sutil_pkg.change_str (
458: p_new_numerator => 'c_ship_confirm_cnt',
459: p_old_numerator => 'p_ship_confirm_cnt',
460: p_denominator => 'p_ship_confirm_cnt',
461: p_measure_name => 'ISC_MEASURE_8') || ',

Line 474: ' || isc_dbi_sutil_pkg.change_str (

470: ELSE ((c_release_to_ship*24/c_ship_confirm_cnt
471: - p_release_to_ship*24/p_ship_confirm_cnt))
472: END ISC_MEASURE_11,
473: c_ship_confirm_cnt_total ISC_MEASURE_14,
474: ' || isc_dbi_sutil_pkg.change_str (
475: p_new_numerator => 'c_ship_confirm_cnt_total',
476: p_old_numerator => 'p_ship_confirm_cnt_total',
477: p_denominator => 'p_ship_confirm_cnt_total',
478: p_measure_name => 'ISC_MEASURE_15') || ',