APPS.CSM_MTL_PARAMETERS_EVENT_PKG dependencies on WSH_CARRIER_SHIP_METHODS_V

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 480: AND NOT EXISTS (SELECT 1 FROM WSH_CARRIER_SHIP_METHODS_V sm

476: UNION
477: (SELECT acc.access_id,acc.user_id
478: FROM CSM_INV_ORG_FREIGHTS_ACC acc
479: WHERE acc.ship_method_code IS NOT NULL
480: AND NOT EXISTS (SELECT 1 FROM WSH_CARRIER_SHIP_METHODS_V sm
481: WHERE acc.organization_id = sm.organization_id
482: AND acc.ship_method_code=sm.ship_method_code
483: AND acc.freight_code=sm.freight_code
484: AND SM.ENABLED_FLAG='Y'

Line 490: AND EXISTS (SELECT 1 FROM WSH_CARRIER_SHIP_METHODS_V sm

486: UNION ALL
487: SELECT acc.access_id,acc.user_id
488: FROM CSM_INV_ORG_FREIGHTS_ACC acc
489: WHERE acc.ship_method_code IS NULL
490: AND EXISTS (SELECT 1 FROM WSH_CARRIER_SHIP_METHODS_V sm
491: WHERE acc.organization_id = sm.organization_id
492: AND acc.freight_code=sm.freight_code
493: AND SM.ENABLED_FLAG='Y'
494: AND sysdate between sm.start_date_active AND nvl(sm.end_date_active, sysdate+1)));