APPS.FTE_PROCESS_REQUESTS dependencies on WSH_CARRIER_SERVICES

Line 568: FROM wsh_carrier_services

564: FROM dual;
565:
566: CURSOR get_ship_method_meaning(p_ship_method_code VARCHAR2) IS
567: SELECT ship_method_meaning
568: FROM wsh_carrier_services
569: WHERE ship_method_code = p_ship_method_code;
570:
571: CURSOR get_ship_method_meaning2(p_carrier_id NUMBER, p_mode VARCHAR2, p_service VARCHAR2) IS
572: SELECT ship_method_meaning

Line 573: FROM wsh_carrier_services

569: WHERE ship_method_code = p_ship_method_code;
570:
571: CURSOR get_ship_method_meaning2(p_carrier_id NUMBER, p_mode VARCHAR2, p_service VARCHAR2) IS
572: SELECT ship_method_meaning
573: FROM wsh_carrier_services
574: WHERE carrier_id = p_carrier_id AND
575: mode_of_transport = p_mode AND
576: service_level = p_service;
577:

Line 581: wsh_carrier_services wcs,

577:
578: CURSOR get_generic_sm(p_mode VARCHAR2, p_service VARCHAR2, p_org_id NUMBER) IS
579: SELECT wcs.ship_method_code
580: FROM wsh_org_carrier_services wocs,
581: wsh_carrier_services wcs,
582: wsh_carriers wc
583: WHERE wcs.service_level= p_service AND
584: wcs.mode_of_transport= p_mode AND
585: wcs.enabled_flag = 'Y' AND

Line 595: wsh_carrier_services wcs,

591:
592: CURSOR get_generic_sm_on_mod(p_mode VARCHAR2, p_org_id NUMBER) IS
593: SELECT wcs.ship_method_code
594: FROM wsh_org_carrier_services wocs,
595: wsh_carrier_services wcs,
596: wsh_carriers wc
597: WHERE
598: wcs.mode_of_transport = p_mode AND
599: wcs.enabled_flag = 'Y' AND

Line 609: wsh_carrier_services wcs,

605:
606: CURSOR get_generic_sm_on_ser( p_service VARCHAR2, p_org_id NUMBER) IS
607: SELECT wcs.ship_method_code
608: FROM wsh_org_carrier_services wocs,
609: wsh_carrier_services wcs,
610: wsh_carriers wc
611: WHERE wcs.service_level = p_service AND
612: wcs.enabled_flag = 'Y' AND
613: wcs.carrier_service_id = wocs.carrier_service_id AND