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 ORG_FREIGHT_TL

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