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_WIP_COMP_OPM_PKG dependencies on OPI_DBI_OPM_WIP_LED_CURRENT

Line 48: 'opi_dbi_opm_wip_led_current');

44:
45: Modifications to this procedure should be applied to collect_opm_tst_current.
46: */
47: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
48: 'opi_dbi_opm_wip_led_current');
49:
50: INSERT INTO opi_dbi_opm_wip_led_current
51: ( orgn_code,
52: item_id,

Line 50: INSERT INTO opi_dbi_opm_wip_led_current

46: */
47: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
48: 'opi_dbi_opm_wip_led_current');
49:
50: INSERT INTO opi_dbi_opm_wip_led_current
51: ( orgn_code,
52: item_id,
53: gl_trans_date,
54: trans_qty,

Line 290: FROM opi_dbi_opm_wip_led_current

286: SUM(trans_qty) trans_qty, SUM(amount_base) amount_base
287: FROM
288: (
289: SELECT orgn_code, item_id, gl_trans_date, trans_qty, amount_base
290: FROM opi_dbi_opm_wip_led_current
291: UNION ALL
292: SELECT orgn_code, item_id, gl_trans_date, trans_qty, amount_base
293: FROM opi_dbi_opm_wip_tst_current
294: )

Line 366: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_led_current');

362: -- Clear OPM-specific work tables
363: l_stmt_id := 10;
364: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_tst_current');
365: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_tst_prior');
366: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_led_current');
367:
368: -- Check if all the bounds have been properly set up
369: l_stmt_id := 20;
370: IF (NOT (opi_dbi_common_mod_init_pkg.init_end_bounds_setup

Line 408: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_led_current');

404: -- Following line moved to capture_opm_tst_prior by CDALY 11/13/03
405: -- EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_tst_current');
406:
407: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_tst_prior');
408: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_led_current');
409:
410: -- all done, so return successfully.
411: l_stmt_id := 100;
412: retcode := s_SUCCESS;

Line 492: FROM opi_dbi_opm_wip_led_current

488: SUM(trans_qty) trans_qty, SUM(amount_base) amount_base
489: FROM
490: (
491: SELECT orgn_code, item_id, gl_trans_date, trans_qty, amount_base
492: FROM opi_dbi_opm_wip_led_current
493: UNION ALL
494: SELECT orgn_code, item_id, gl_trans_date, trans_qty, amount_base
495: FROM opi_dbi_opm_wip_tst_current
496: UNION ALL

Line 582: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_led_current');

578: capture_opm_tst_prior;
579:
580:
581: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_tst_current');
582: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_led_current');
583:
584: -- Check if all the bounds have been properly set up
585: l_stmt_id := 20;
586: IF (NOT (opi_dbi_common_mod_init_pkg.init_end_bounds_setup

Line 635: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_led_current');

631: -- Following line moved to capture_opm_tst_prior by CDALY 11/13/03
632: -- EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_tst_current');
633:
634: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_tst_prior');
635: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' || 'opi_dbi_opm_wip_led_current');
636:
637: -- all done, so return successfully.
638: l_stmt_id := 100;
639: retcode := s_SUCCESS;