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_CAT_VALIDATE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 76


    select 'Y'
    from fte_lanes fl,
         wsh_regions_tl wr,
         hz_locations hl,
         wsh_regions wrb
    where fl.origin_id = wr.region_id
    and wr.region_id = wrb.region_id
    and fl.lane_id = p_lane_id
    and hl.location_id = p_location_id
    and nvl(wr.city,'XX') = decode(wr.city, NULL, 'XX', nvl(hl.city,wr.city))
    and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
    and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
    and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
    and nvl(wrb.state_code,'XX') = nvl(hl.state,wrb.state_code)
union
    select 'Y'
    from fte_lanes fl,
         wsh_regions_tl wr,
	 hr_locations_all hl, hr_locations_all_tl hlt,
         wsh_regions wrb
    where fl.origin_id = wr.region_id
    and wr.region_id = wrb.region_id
    and fl.lane_id = p_lane_id
    and hl.location_id = p_location_id
    and nvl(wr.city,'XX') = decode(wr.city, NULL, 'XX', nvl(hl.town_or_city,wr.city))
    and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
    and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
    and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
    and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
    and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
             = nvl (hr_general.get_business_group_id, -99)
    and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
;

Line: 113


    select 'Y'
    from fte_lanes fl,
         wsh_regions_tl wr,
         hz_locations hl,
         wsh_regions wrb
    where fl.destination_id = wr.region_id
    and wr.region_id = wrb.region_id
    and fl.lane_id = p_lane_id
    and hl.location_id = p_location_id
    and nvl(wr.city,'XX') = decode(wr.city, NULL, 'XX', nvl(hl.city,wr.city))
    and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
    and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
    and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
    and nvl(wrb.state_code,'XX') = nvl(hl.state,wrb.state_code)
union
    select 'Y'
    from fte_lanes fl,
         wsh_regions_tl wr,
	 hr_locations_all hl, hr_locations_all_tl hlt,
         wsh_regions wrb
    where fl.destination_id = wr.region_id
    and wr.region_id = wrb.region_id
    and fl.lane_id = p_lane_id
    and hl.location_id = p_location_id
    and nvl(wr.city,'XX') = decode(wr.city, NULL, 'XX', nvl(hl.town_or_city,wr.city))
    and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
    and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
    and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
    and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
    and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
             = nvl (hr_general.get_business_group_id, -99)
    and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
;

Line: 149


    select 'Y'
    from fte_lanes fl,
         wsh_regions_tl wr,
         hz_locations hl,
         wsh_regions wrb
    where fl.destination_id = wr.region_id
    and wr.region_id = wrb.region_id
    and fl.lane_id = p_lane_id
    and hl.location_id = p_location_id
    and nvl(wr.city,'XX') = decode(wr.city, NULL, 'XX', nvl(hl.city,wr.city))
    and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
    and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
    and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
    and nvl(wrb.state_code,'XX') = nvl(hl.state,wrb.state_code)
union
    select 'Y'
    from fte_lanes fl,
         wsh_regions_tl wr,
	 hr_locations_all hl, hr_locations_all_tl hlt,
         wsh_regions wrb
    where (fl.origin_id = wr.region_id or fl.DESTINATION_ID = wr.region_id)
    and wr.region_id = wrb.region_id
    and fl.lane_id = p_lane_id
    and hl.location_id = p_location_id
    and nvl(wr.city,'XX') = decode(wr.city, NULL, 'XX', nvl(hl.town_or_city,wr.city))
    and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
    and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
    and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
    and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
    and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
             = nvl (hr_general.get_business_group_id, -99)
    and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
;

Line: 336


   select  departure_date, arrival_date from fte_schedules
   where lane_id = p_lane_id and schedules_id = p_schedule_id
   and departure_date is not null and arrival_date is not null;

Line: 447


   select 'Y' from fte_lane_services where service_code = p_service_type and lane_id = p_lane_id;