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.MSD_DEM_COLLECT_LEVEL_TYPES dependencies on MSD_DEM_NEW_ITEMS

Line 361: FROM msd_dem_new_items

357: IS
358: SELECT 1
359: FROM dual
360: WHERE EXISTS (SELECT 1
361: FROM msd_dem_new_items
362: WHERE sr_instance_id = p_sr_instance_id
363: AND process_flag = 2);
364:
365:

Line 379: TYPE INV_ITEM_ID_TAB IS TABLE OF msd_dem_new_items.inventory_item_id%TYPE;

375: x_item_staging_table VARCHAR2(100) := NULL;
376: x_master_org NUMBER := NULL;
377: x_category_set_id NUMBER := NULL;
378:
379: TYPE INV_ITEM_ID_TAB IS TABLE OF msd_dem_new_items.inventory_item_id%TYPE;
380: x_inv_item_id_tab INV_ITEM_ID_TAB;
381:
382: BEGIN
383:

Line 438: UPDATE msd_dem_new_items

434: EXECUTE IMMEDIATE x_sql USING p_sr_instance_id, p_sr_instance_id, x_master_org, x_category_set_id;
435: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
436:
437: /* Set the process_flag */
438: UPDATE msd_dem_new_items
439: SET process_flag = 1
440: WHERE sr_instance_id = p_sr_instance_id
441: AND process_flag = 2;
442: