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.FTE_PROCESS_REQUESTS dependencies on WSH_ORG_CARRIER_SERVICES

Line 580: FROM wsh_org_carrier_services wocs,

576: service_level = p_service;
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

Line 594: FROM wsh_org_carrier_services wocs,

590: nvl(wc.generic_flag, 'N') = 'Y';
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

Line 608: FROM wsh_org_carrier_services wocs,

604: nvl(wc.generic_flag, 'N') = 'Y';
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