APPS.WSH_UTIL_VALIDATE dependencies on WSH_ORG_CARRIER_SERVICES

Line 3002: wsh_org_carrier_services wocs,

2998: select wcs.carrier_id,
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'

Line 3020: wsh_org_carrier_services wocs,

3016: select wcs.carrier_id,
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'

Line 3036: wsh_org_carrier_services wocs,

3032: cursor l_dlvy_carrier_services_csr is
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'

Line 3064: wsh_org_carrier_services wocs,

3060: cursor l_dlvy_carrier_services_csr_tp is
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'

Line 5986: wsh_org_carrier_services wocs

5982: select ship_method_code
5983: into x_ship_method_code
5984: from wsh_carriers wc,
5985: wsh_carrier_services wcs,
5986: wsh_org_carrier_services wocs
5987: where wocs.organization_id = p_organization_id
5988: and wocs.carrier_service_id = wcs.carrier_service_id
5989: and wcs.mode_of_transport = p_mode_of_transport
5990: and wcs.service_level = p_service_level