APPS.WSH_UTIL_VALIDATE dependencies on WSH_CARRIERS_V

Line 2881: from wsh_carriers_v

2877: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_CARRIER';
2878: --
2879: cursor l_carrier_csr is
2880: select carrier_id
2881: from wsh_carriers_v
2882: where nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
2883: and carrier_id = x_carrier_id
2884: and nvl(generic_flag, 'N') = 'N'
2885: and active = 'A'

Line 2888: from wsh_carriers_v

2884: and nvl(generic_flag, 'N') = 'N'
2885: and active = 'A'
2886: union all
2887: select carrier_id
2888: from wsh_carriers_v
2889: where nvl(x_carrier_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2890: and carrier_name = p_carrier_name
2891: and nvl(generic_flag, 'N') = 'N'
2892: and active = 'A';

Line 3003: wsh_carriers_v wcv

2999: wcs.service_level,
3000: wcs.mode_of_transport
3001: from wsh_carrier_services wcs,
3002: wsh_org_carrier_services wocs,
3003: wsh_carriers_v wcv
3004: where wcs.carrier_service_id = wocs.carrier_service_id
3005: and wcs.carrier_id = wcv.carrier_id
3006: and wcv.active = 'A'
3007: and NVL(wcv.generic_flag, 'N') = 'N'

Line 3021: wsh_carriers_v wcv

3017: wcs.service_level,
3018: wcs.mode_of_transport
3019: from wsh_carrier_services wcs,
3020: wsh_org_carrier_services wocs,
3021: wsh_carriers_v wcv
3022: where wcs.carrier_service_id = wocs.carrier_service_id
3023: and wcs.carrier_id = wcv.carrier_id
3024: and wcv.active = 'A'
3025: and NVL(wcv.generic_flag, 'N') = 'N'

Line 3037: wsh_carriers_v wcv

3033: -- Bug 2757672
3034: select wcs.ship_method_code
3035: from wsh_carrier_services wcs,
3036: wsh_org_carrier_services wocs,
3037: wsh_carriers_v wcv
3038: where wcs.carrier_service_id = wocs.carrier_service_id
3039: and wcs.carrier_id = wcv.carrier_id
3040: and wcv.active = 'A'
3041: and NVL(wcv.generic_flag, 'N') = 'N'

Line 3065: wsh_carriers_v wcv

3061: -- Bug 2757672
3062: select wcs.ship_method_code
3063: from wsh_carrier_services wcs,
3064: wsh_org_carrier_services wocs,
3065: wsh_carriers_v wcv
3066: where wcs.carrier_service_id = wocs.carrier_service_id
3067: and wcs.carrier_id = wcv.carrier_id
3068: and wcv.active = 'A'
3069: and NVL(wcv.generic_flag, 'N') = 'N'

Line 3104: wsh_carriers_v wcv

3100: select wcs.carrier_id,
3101: wcs.service_level,
3102: wcs.mode_of_transport
3103: from wsh_carrier_services wcs,
3104: wsh_carriers_v wcv
3105: where wcs.ship_method_code = x_ship_method_code
3106: and wcs.carrier_id = wcv.carrier_id
3107: and nvl(wcs.enabled_flag, 'N') = 'Y'
3108: and wcv.active = 'A'

Line 3115: wsh_carriers_v wcv

3111: cursor l_trip_carrier_services_csr is
3112: -- Bug 2757672
3113: select distinct wcs.ship_method_code
3114: from wsh_carrier_services wcs,
3115: wsh_carriers_v wcv
3116: where wcs.carrier_id = x_carrier_id
3117: and wcs.carrier_id = wcv.carrier_id
3118: and nvl(wcs.enabled_flag, 'N') = 'Y'
3119: and wcv.active = 'A'

Line 6075: FROM wsh_carriers_v

6071: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Validate_Freight_Code';
6072: --
6073: CURSOR l_carrier_csr is
6074: SELECT carrier_id
6075: FROM wsh_carriers_v
6076: WHERE nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
6077: AND carrier_id = x_carrier_id
6078: AND nvl(generic_flag, 'N') = 'N'
6079: AND active = 'A'

Line 6082: FROM wsh_carriers_v

6078: AND nvl(generic_flag, 'N') = 'N'
6079: AND active = 'A'
6080: UNION ALL
6081: SELECT carrier_id
6082: FROM wsh_carriers_v
6083: WHERE nvl(x_carrier_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6084: AND freight_code = p_freight_code
6085: AND nvl(generic_flag, 'N') = 'N'
6086: AND active = 'A';