DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_ORG_CARRIER_SERVICES

Line 1197: FROM wsh_carriers wc,wsh_carrier_services wcs,wsh_org_carrier_services wocs

1193:
1194: ---BUG No:4241880.Cursor changed
1195: CURSOR get_freight(p_ship_method_code VARCHAR2,p_organization_id NUMBER) IS
1196: SELECT freight_code
1197: FROM wsh_carriers wc,wsh_carrier_services wcs,wsh_org_carrier_services wocs
1198: WHERE wc.carrier_id=wcs.carrier_id AND
1199: wcs.carrier_service_id=wocs.carrier_service_id AND
1200: wcs.ship_method_code = p_ship_method_code AND
1201: wocs.organization_id = p_organization_id;

Line 1877: FROM wsh_carrier_services wcs, wsh_org_carrier_services wocs

1873:
1874: ---BUG No:4241880.Cursor changed
1875: CURSOR org_ship_method (l_organization_id NUMBER,l_ship_method_code VARCHAR2) IS
1876: SELECT ship_method_code
1877: FROM wsh_carrier_services wcs, wsh_org_carrier_services wocs
1878: WHERE wocs.organization_id=l_organization_id
1879: and wocs.carrier_service_id=wcs.carrier_service_id
1880: AND wcs.ship_method_code=l_ship_method_code;
1881: ---BUG No:4241880.Cursor changed ends