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.WSH_UTIL_VALIDATE dependencies on WSH_CARRIER_SERVICES

Line 2979: from wsh_carrier_services wcs,

2975: -- Bug 2757672
2976: select wcs.carrier_id,
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

Line 2997: from wsh_carrier_services wcs,

2993: -- Bug 2757672
2994: select wcs.carrier_id,
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

Line 3013: from wsh_carrier_services wcs,

3009: --
3010: cursor l_dlvy_carrier_services_csr is
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

Line 3041: from wsh_carrier_services wcs,

3037: --if caller is TP use below cursor (no org check)
3038: cursor l_dlvy_carrier_services_csr_tp is
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

Line 3081: from wsh_carrier_services wcs,

3077: -- Bug 2757672
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'

Line 3092: from wsh_carrier_services wcs,

3088: --
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'

Line 5033: -- COMMENT : Validates Active Ship_Method_Code/Name against wsh_carrier_services.

5029: -- Bug#3880569: Adding a new procedure Validate_Active_SM
5030: --========================================================================
5031: -- PROCEDURE : Validate_Active_SM
5032: --
5033: -- COMMENT : Validates Active Ship_Method_Code/Name against wsh_carrier_services.
5034: -- If both values are specified then only Ship_Method_Code is used
5035: --========================================================================
5036:
5037: PROCEDURE Validate_Active_SM

Line 5045: from fnd_lookup_values_vl flv, wsh_carrier_services wcs

5041:
5042: CURSOR check_ship_method IS
5043: select flv.lookup_code ship_method_code,
5044: flv.meaning
5045: from fnd_lookup_values_vl flv, wsh_carrier_services wcs
5046: where flv.lookup_code = wcs.ship_method_code
5047: and wcs.ship_method_code = p_ship_method_code
5048: and flv.lookup_type = 'SHIP_METHOD'
5049: and flv.view_application_id = 3

Line 5054: from fnd_lookup_values_vl flv, wsh_carrier_services wcs

5050: and wcs.enabled_flag='Y'
5051: UNION ALL
5052: select flv.lookup_code ship_method_code,
5053: flv.meaning
5054: from fnd_lookup_values_vl flv, wsh_carrier_services wcs
5055: where flv.lookup_code = wcs.ship_method_code
5056: and NVL(p_ship_method_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR
5057: and flv.lookup_type = 'SHIP_METHOD'
5058: and flv.view_application_id = 3