DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on WSH_ORG_CARRIER_SERVICES

Line 2980: wsh_org_carrier_services wocs,

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
2984: and wcv.active = 'A'

Line 2998: wsh_org_carrier_services wocs,

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
3002: and wcv.active = 'A'

Line 3014: wsh_org_carrier_services wocs,

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
3018: and wcv.active = 'A'

Line 3042: wsh_org_carrier_services wocs,

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
3046: and wcv.active = 'A'