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.CSM_MTL_PARAMETERS_EVENT_PKG dependencies on ASG_USER

Line 273: (SELECT 1 FROM csp_inv_loc_assignments inv,asg_user au

269: )
270: UNION
271: SELECT acc.access_id,acc.user_id FROM CSM_INTERORG_PARAMETERS_ACC acc
272: WHERE NOT EXISTS
273: (SELECT 1 FROM csp_inv_loc_assignments inv,asg_user au
274: WHERE au.resource_id =inv.resource_id AND au.user_id=acc.user_id AND inv.organization_id in (acc.from_organization_id,acc.to_organization_id));
275:
276: BEGIN
277:

Line 345: FOR rec IN (SELECT user_id,resource_id from asg_user where MULTI_PLATFORM='Y' and enabled='Y')

341: CSM_UTIL_PKG.LOG('Processing inserts', 'CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_INTERORG_ACC', FND_LOG.LEVEL_PROCEDURE);
342: -- process all inserts
343:
344:
345: FOR rec IN (SELECT user_id,resource_id from asg_user where MULTI_PLATFORM='Y' and enabled='Y')
346: LOOP
347: OPEN c_mtl_parameters_ins_csr(rec.USER_ID,rec.RESOURCE_ID);
348: LOOP
349: l_tab_access_id.DELETE;

Line 429: FROM ORG_FREIGHT_TL oft,asg_user au,WSH_CARRIER_SHIP_METHODS_V sm

425: -- inserts cur
426: CURSOR c_inv_org_freights_ins_csr
427: IS
428: SELECT csm_mtl_parameters_acc_s.nextval as ACCESS_ID,au.user_id, oft.organization_id,oft.freight_code,sm.ship_method_code
429: FROM ORG_FREIGHT_TL oft,asg_user au,WSH_CARRIER_SHIP_METHODS_V sm
430: WHERE oft.LANGUAGE=au.language
431: and nvl(oft.disable_date,sysdate+1) > sysdate
432: AND oft.organization_id=sm.organization_id(+)
433: AND oft.freight_code=sm.freight_code(+)

Line 449: FROM CSM_INV_ORG_FREIGHTS_ACC acc,ORG_FREIGHT_TL oft,asg_user au

445: -- updates cur
446: CURSOR c_inv_org_freights_upd_csr(b_lrd DATE)
447: IS
448: SELECT acc.access_id,acc.user_id
449: FROM CSM_INV_ORG_FREIGHTS_ACC acc,ORG_FREIGHT_TL oft,asg_user au
450: WHERE acc.organization_id = oft.organization_id
451: AND acc.freight_code=oft.freight_code
452: AND au.user_id=acc.user_id
453: AND oft.language=au.language

Line 469: WHERE NOT EXISTS (SELECT 1 FROM ORG_FREIGHT_TL oft,CSP_INV_LOC_ASSIGNMENTS ass,asg_user au

465: CURSOR c_inv_org_freights_del_csr
466: IS
467: SELECT acc.access_id,acc.user_id
468: FROM CSM_INV_ORG_FREIGHTS_ACC acc
469: WHERE NOT EXISTS (SELECT 1 FROM ORG_FREIGHT_TL oft,CSP_INV_LOC_ASSIGNMENTS ass,asg_user au
470: WHERE acc.organization_id = oft.organization_id
471: AND acc.freight_code=oft.freight_code
472: AND acc.user_id=au.user_id
473: AND nvl(oft.disable_date,sysdate+1) > sysdate