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.MSC_CL_ITEM_PULL dependencies on MSC_APPS_INSTANCES

Line 387: from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;

383: -- If the base installed_flag is same as userenv lang- then dont go to TL table
384:
385: select instance_code, DECODE(A2M_DBLINK, NULL, MSC_UTIL.NULL_DBLINK, A2M_DBLINK)
386: into lv_icode, v_dblink_a2m
387: from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;
388:
389: v_sql_stmt := ' select item_name_from_kfv '
390: ||' from MRP_AP_APPS_INSTANCES_ALL'||MSC_CL_PULL.v_dblink
391: ||' WHERE INSTANCE_ID = '||MSC_CL_PULL.v_instance_id

Line 483: from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;

479: -- If the base installed_flag is same as userenv lang- then dont go to TL table
480:
481: select instance_code, DECODE(A2M_DBLINK, NULL, MSC_UTIL.NULL_DBLINK, A2M_DBLINK)
482: into lv_icode, v_dblink_a2m
483: from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;
484:
485: v_sql_stmt := ' select item_name_from_kfv '
486: ||' from MRP_AP_APPS_INSTANCES_ALL'||MSC_CL_PULL.v_dblink
487: ||' WHERE INSTANCE_ID = '||MSC_CL_PULL.v_instance_id