APPS.WSH_UTIL_VALIDATE dependencies on WSH_CARRIERS_V

Line 2859: from wsh_carriers_v

2855: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_CARRIER';
2856: --
2857: cursor l_carrier_csr is
2858: select carrier_id
2859: from wsh_carriers_v
2860: where nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
2861: and carrier_id = x_carrier_id
2862: and nvl(generic_flag, 'N') = 'N'
2863: and active = 'A'

Line 2866: from wsh_carriers_v

2862: and nvl(generic_flag, 'N') = 'N'
2863: and active = 'A'
2864: union all
2865: select carrier_id
2866: from wsh_carriers_v
2867: where nvl(x_carrier_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2868: and carrier_name = p_carrier_name
2869: and nvl(generic_flag, 'N') = 'N'
2870: and active = 'A';

Line 2981: wsh_carriers_v wcv

2977: wcs.service_level,
2978: wcs.mode_of_transport
2979: from wsh_carrier_services wcs,
2980: wsh_org_carrier_services wocs,
2981: wsh_carriers_v wcv
2982: where wcs.carrier_service_id = wocs.carrier_service_id
2983: and wcs.carrier_id = wcv.carrier_id
2984: and wcv.active = 'A'
2985: and NVL(wcv.generic_flag, 'N') = 'N'

Line 2999: wsh_carriers_v wcv

2995: wcs.service_level,
2996: wcs.mode_of_transport
2997: from wsh_carrier_services wcs,
2998: wsh_org_carrier_services wocs,
2999: wsh_carriers_v wcv
3000: where wcs.carrier_service_id = wocs.carrier_service_id
3001: and wcs.carrier_id = wcv.carrier_id
3002: and wcv.active = 'A'
3003: and NVL(wcv.generic_flag, 'N') = 'N'

Line 3015: wsh_carriers_v wcv

3011: -- Bug 2757672
3012: select wcs.ship_method_code
3013: from wsh_carrier_services wcs,
3014: wsh_org_carrier_services wocs,
3015: wsh_carriers_v wcv
3016: where wcs.carrier_service_id = wocs.carrier_service_id
3017: and wcs.carrier_id = wcv.carrier_id
3018: and wcv.active = 'A'
3019: and NVL(wcv.generic_flag, 'N') = 'N'

Line 3043: wsh_carriers_v wcv

3039: -- Bug 2757672
3040: select wcs.ship_method_code
3041: from wsh_carrier_services wcs,
3042: wsh_org_carrier_services wocs,
3043: wsh_carriers_v wcv
3044: where wcs.carrier_service_id = wocs.carrier_service_id
3045: and wcs.carrier_id = wcv.carrier_id
3046: and wcv.active = 'A'
3047: and NVL(wcv.generic_flag, 'N') = 'N'

Line 3082: wsh_carriers_v wcv

3078: select wcs.carrier_id,
3079: wcs.service_level,
3080: wcs.mode_of_transport
3081: from wsh_carrier_services wcs,
3082: wsh_carriers_v wcv
3083: where wcs.ship_method_code = x_ship_method_code
3084: and wcs.carrier_id = wcv.carrier_id
3085: and nvl(wcs.enabled_flag, 'N') = 'Y'
3086: and wcv.active = 'A'

Line 3093: wsh_carriers_v wcv

3089: cursor l_trip_carrier_services_csr is
3090: -- Bug 2757672
3091: select distinct wcs.ship_method_code
3092: from wsh_carrier_services wcs,
3093: wsh_carriers_v wcv
3094: where wcs.carrier_id = x_carrier_id
3095: and wcs.carrier_id = wcv.carrier_id
3096: and nvl(wcs.enabled_flag, 'N') = 'Y'
3097: and wcv.active = 'A'