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.OPI_DBI_PROD_SCRAP_PKG dependencies on OPI_DBI_RPT_UTIL_PKG

Line 67: opi_dbi_rpt_util_pkg.process_parameters (p_param,

63: THEN l_period_type := p_param(i).parameter_value;
64: END IF;
65: END LOOP;
66: -- get all the query parameters
67: opi_dbi_rpt_util_pkg.process_parameters (p_param,
68: l_view_by,
69: l_view_by_col,
70: l_comparison_type,
71: l_xtd,

Line 160: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

156:
157: -- Main Outer query
158:
159: -- Column to get view by column name
160: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
161: (p_view_by_dim);
162:
163: -- Quantity columns for
164: get_qty_columns (p_view_by_dim, l_description, l_uom, l_qty1,

Line 170: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)

166:
167: -- Outer select clause
168: l_sel_clause :=
169: 'SELECT
170: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
171: || l_view_by_col_name || ' OPI_ATTRIBUTE1,
172: ' || l_description || ' OPI_ATTRIBUTE2,
173: ' || l_uom || ' OPI_ATTRIBUTE3,';
174:

Line 184: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.p_scrap_val')

180:
181: l_sel_clause := l_sel_clause || l_qty1 || ' OPI_MEASURE1,
182: ' || l_qty2 || ' OPI_MEASURE2,
183: ' || l_qty3 || ' OPI_MEASURE3,
184: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.p_scrap_val')
185: || ' OPI_MEASURE4,
186: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_val')
187: || ' OPI_MEASURE5,
188: ' || opi_dbi_rpt_util_pkg.change_str ('oset.c_scrap_val',

Line 186: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_val')

182: ' || l_qty2 || ' OPI_MEASURE2,
183: ' || l_qty3 || ' OPI_MEASURE3,
184: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.p_scrap_val')
185: || ' OPI_MEASURE4,
186: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_val')
187: || ' OPI_MEASURE5,
188: ' || opi_dbi_rpt_util_pkg.change_str ('oset.c_scrap_val',
189: 'oset.p_scrap_val',
190: 'oset.p_scrap_val',

Line 188: ' || opi_dbi_rpt_util_pkg.change_str ('oset.c_scrap_val',

184: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.p_scrap_val')
185: || ' OPI_MEASURE4,
186: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_val')
187: || ' OPI_MEASURE5,
188: ' || opi_dbi_rpt_util_pkg.change_str ('oset.c_scrap_val',
189: 'oset.p_scrap_val',
190: 'oset.p_scrap_val',
191: 'OPI_MEASURE6') || ',
192: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_production_val')

Line 192: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_production_val')

188: ' || opi_dbi_rpt_util_pkg.change_str ('oset.c_scrap_val',
189: 'oset.p_scrap_val',
190: 'oset.p_scrap_val',
191: 'OPI_MEASURE6') || ',
192: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_production_val')
193: || ' OPI_MEASURE7,
194: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val',
195: 'oset.p_production_val',
196: 'OPI_MEASURE8') || ',

Line 194: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val',

190: 'oset.p_scrap_val',
191: 'OPI_MEASURE6') || ',
192: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_production_val')
193: || ' OPI_MEASURE7,
194: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val',
195: 'oset.p_production_val',
196: 'OPI_MEASURE8') || ',
197: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val',
198: 'oset.c_production_val',

Line 197: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val',

193: || ' OPI_MEASURE7,
194: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val',
195: 'oset.p_production_val',
196: 'OPI_MEASURE8') || ',
197: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val',
198: 'oset.c_production_val',
199: 'OPI_MEASURE9') || ',
200: ' || opi_dbi_rpt_util_pkg.change_pct_str ('oset.c_scrap_val',
201: 'oset.c_production_val',

Line 200: ' || opi_dbi_rpt_util_pkg.change_pct_str ('oset.c_scrap_val',

196: 'OPI_MEASURE8') || ',
197: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val',
198: 'oset.c_production_val',
199: 'OPI_MEASURE9') || ',
200: ' || opi_dbi_rpt_util_pkg.change_pct_str ('oset.c_scrap_val',
201: 'oset.c_production_val',
202: 'oset.p_scrap_val',
203: 'oset.p_production_val',
204: 'OPI_MEASURE10') || ',

Line 205: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_val_total')

201: 'oset.c_production_val',
202: 'oset.p_scrap_val',
203: 'oset.p_production_val',
204: 'OPI_MEASURE10') || ',
205: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_val_total')
206: || ' OPI_MEASURE11,
207: ' || opi_dbi_rpt_util_pkg.change_str ('oset.c_scrap_val_total',
208: 'oset.p_scrap_val_total',
209: 'oset.p_scrap_val_total',

Line 207: ' || opi_dbi_rpt_util_pkg.change_str ('oset.c_scrap_val_total',

203: 'oset.p_production_val',
204: 'OPI_MEASURE10') || ',
205: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_val_total')
206: || ' OPI_MEASURE11,
207: ' || opi_dbi_rpt_util_pkg.change_str ('oset.c_scrap_val_total',
208: 'oset.p_scrap_val_total',
209: 'oset.p_scrap_val_total',
210: 'OPI_MEASURE12') || ',
211: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_production_val_total')

Line 211: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_production_val_total')

207: ' || opi_dbi_rpt_util_pkg.change_str ('oset.c_scrap_val_total',
208: 'oset.p_scrap_val_total',
209: 'oset.p_scrap_val_total',
210: 'OPI_MEASURE12') || ',
211: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_production_val_total')
212: || ' OPI_MEASURE13,
213: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val_total',
214: 'oset.c_production_val_total',
215: 'OPI_MEASURE14') || ',

Line 213: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val_total',

209: 'oset.p_scrap_val_total',
210: 'OPI_MEASURE12') || ',
211: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_production_val_total')
212: || ' OPI_MEASURE13,
213: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val_total',
214: 'oset.c_production_val_total',
215: 'OPI_MEASURE14') || ',
216: ' || opi_dbi_rpt_util_pkg.change_pct_str ('oset.c_scrap_val_total',
217: 'oset.c_production_val_total',

Line 216: ' || opi_dbi_rpt_util_pkg.change_pct_str ('oset.c_scrap_val_total',

212: || ' OPI_MEASURE13,
213: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val_total',
214: 'oset.c_production_val_total',
215: 'OPI_MEASURE14') || ',
216: ' || opi_dbi_rpt_util_pkg.change_pct_str ('oset.c_scrap_val_total',
217: 'oset.c_production_val_total',
218: 'oset.p_scrap_val_total',
219: 'oset.p_production_val_total',
220: 'OPI_MEASURE15') || ',

Line 221: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val',

217: 'oset.c_production_val_total',
218: 'oset.p_scrap_val_total',
219: 'oset.p_production_val_total',
220: 'OPI_MEASURE15') || ',
221: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val',
222: 'oset.c_production_val',
223: 'OPI_MEASURE16') || ',
224: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val',
225: 'oset.p_production_val',

Line 224: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val',

220: 'OPI_MEASURE15') || ',
221: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val',
222: 'oset.c_production_val',
223: 'OPI_MEASURE16') || ',
224: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val',
225: 'oset.p_production_val',
226: 'OPI_MEASURE17') || ',
227: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val_total',
228: 'oset.c_production_val_total',

Line 227: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val_total',

223: 'OPI_MEASURE16') || ',
224: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val',
225: 'oset.p_production_val',
226: 'OPI_MEASURE17') || ',
227: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val_total',
228: 'oset.c_production_val_total',
229: 'OPI_MEASURE18') || ',
230: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val_total',
231: 'oset.p_production_val_total',

Line 230: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val_total',

226: 'OPI_MEASURE17') || ',
227: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_scrap_val_total',
228: 'oset.c_production_val_total',
229: 'OPI_MEASURE18') || ',
230: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_scrap_val_total',
231: 'oset.p_production_val_total',
232: 'OPI_MEASURE19') ;
233:
234: RETURN l_sel_clause;

Line 259: p_qty1 := opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_qty');

255: WHEN p_dim_name = 'ITEM+ENI_ITEM_ORG' THEN
256: BEGIN
257: p_description := 'v.description';
258: p_uom := 'v2.unit_of_measure';
259: p_qty1 := opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_qty');
260: p_qty2 := opi_dbi_rpt_util_pkg.nvl_str
261: ('oset.c_production_qty');
262: p_qty3 := opi_dbi_rpt_util_pkg.percent_str
263: ('oset.c_scrap_qty',

Line 260: p_qty2 := opi_dbi_rpt_util_pkg.nvl_str

256: BEGIN
257: p_description := 'v.description';
258: p_uom := 'v2.unit_of_measure';
259: p_qty1 := opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_qty');
260: p_qty2 := opi_dbi_rpt_util_pkg.nvl_str
261: ('oset.c_production_qty');
262: p_qty3 := opi_dbi_rpt_util_pkg.percent_str
263: ('oset.c_scrap_qty',
264: 'oset.c_production_qty',

Line 262: p_qty3 := opi_dbi_rpt_util_pkg.percent_str

258: p_uom := 'v2.unit_of_measure';
259: p_qty1 := opi_dbi_rpt_util_pkg.nvl_str ('oset.c_scrap_qty');
260: p_qty2 := opi_dbi_rpt_util_pkg.nvl_str
261: ('oset.c_production_qty');
262: p_qty3 := opi_dbi_rpt_util_pkg.percent_str
263: ('oset.c_scrap_qty',
264: 'oset.c_production_qty',
265: '');
266: END;

Line 311: opi_dbi_rpt_util_pkg.process_parameters (p_param,

307: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
308: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
309:
310: -- get all the query parameters
311: opi_dbi_rpt_util_pkg.process_parameters (p_param,
312: l_view_by,
313: l_view_by_col,
314: l_comparison_type,
315: l_xtd,

Line 394: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.p_scrap_val')

390:
391: l_sel_clause :=
392: 'SELECT
393: ' || ' cal.name VIEWBY,
394: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.p_scrap_val')
395: || ' OPI_MEASURE1,
396: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_scrap_val')
397: || ' OPI_MEASURE2,
398: ' || opi_dbi_rpt_util_pkg.change_str ('iset.c_scrap_val',

Line 396: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_scrap_val')

392: 'SELECT
393: ' || ' cal.name VIEWBY,
394: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.p_scrap_val')
395: || ' OPI_MEASURE1,
396: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_scrap_val')
397: || ' OPI_MEASURE2,
398: ' || opi_dbi_rpt_util_pkg.change_str ('iset.c_scrap_val',
399: 'iset.p_scrap_val',
400: 'iset.p_scrap_val',

Line 398: ' || opi_dbi_rpt_util_pkg.change_str ('iset.c_scrap_val',

394: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.p_scrap_val')
395: || ' OPI_MEASURE1,
396: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_scrap_val')
397: || ' OPI_MEASURE2,
398: ' || opi_dbi_rpt_util_pkg.change_str ('iset.c_scrap_val',
399: 'iset.p_scrap_val',
400: 'iset.p_scrap_val',
401: 'OPI_MEASURE3') || ',
402: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_production_val')

Line 402: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_production_val')

398: ' || opi_dbi_rpt_util_pkg.change_str ('iset.c_scrap_val',
399: 'iset.p_scrap_val',
400: 'iset.p_scrap_val',
401: 'OPI_MEASURE3') || ',
402: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_production_val')
403: || ' OPI_MEASURE4,
404: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_scrap_val',
405: 'iset.p_production_val',
406: 'OPI_MEASURE5') || ',

Line 404: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_scrap_val',

400: 'iset.p_scrap_val',
401: 'OPI_MEASURE3') || ',
402: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_production_val')
403: || ' OPI_MEASURE4,
404: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_scrap_val',
405: 'iset.p_production_val',
406: 'OPI_MEASURE5') || ',
407: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_scrap_val',
408: 'iset.c_production_val',

Line 407: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_scrap_val',

403: || ' OPI_MEASURE4,
404: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_scrap_val',
405: 'iset.p_production_val',
406: 'OPI_MEASURE5') || ',
407: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_scrap_val',
408: 'iset.c_production_val',
409: 'OPI_MEASURE6') || ',
410: ' || opi_dbi_rpt_util_pkg.change_pct_str ('iset.c_scrap_val',
411: 'iset.c_production_val',

Line 410: ' || opi_dbi_rpt_util_pkg.change_pct_str ('iset.c_scrap_val',

406: 'OPI_MEASURE5') || ',
407: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_scrap_val',
408: 'iset.c_production_val',
409: 'OPI_MEASURE6') || ',
410: ' || opi_dbi_rpt_util_pkg.change_pct_str ('iset.c_scrap_val',
411: 'iset.c_production_val',
412: 'iset.p_scrap_val',
413: 'iset.p_production_val',
414: 'OPI_MEASURE7');