APPS.FTE_LTL_LOADER dependencies on WSH_ZONE_REGIONS

Line 92: wsh_zone_regions ozr,

88: l.carrier_id
89: FROM
90: fte_lanes l,
91: fte_tariff_carriers tc,
92: wsh_zone_regions ozr,
93: wsh_zone_regions dzr,
94: wsh_regions owr,
95: wsh_regions dwr
96: WHERE

Line 93: wsh_zone_regions dzr,

89: FROM
90: fte_lanes l,
91: fte_tariff_carriers tc,
92: wsh_zone_regions ozr,
93: wsh_zone_regions dzr,
94: wsh_regions owr,
95: wsh_regions dwr
96: WHERE
97: l.tariff_name = p_tariff_name AND

Line 2397: wsh_zone_regions w,

2393: CURSOR GET_ZONE_COUNTRY(p_zone_name IN VARCHAR2) IS
2394: SELECT
2395: w2.country_code
2396: FROM
2397: wsh_zone_regions w,
2398: fte_interface_zones f,
2399: wsh_regions w2
2400: WHERE
2401: w.parent_region_id = f.zone_id AND

Line 3579: -- create Zones into WSH_REGIONS, WSH_REGIONS_TL and WSH_ZONE_REGIONS

3575: l_zone_name VARCHAR2(125);
3576:
3577: --+
3578: -- This cursor is used to collect queried rows from fte_interface_zones. Those are used to
3579: -- create Zones into WSH_REGIONS, WSH_REGIONS_TL and WSH_ZONE_REGIONS
3580: --+
3581: CURSOR BULK_ZONES(p_load_id NUMBER) IS
3582: SELECT
3583: zone_name,

Line 4674: wsh_zone_regions ozr,

4670: MAX(ozr.postal_code_from) origin_low,
4671: MAX(dzr.postal_code_from) destination_low
4672: FROM
4673: fte_lanes l,
4674: wsh_zone_regions ozr,
4675: wsh_zone_regions dzr
4676: WHERE
4677: l.lane_type = p_lane_type AND
4678: l.tariff_name = p_tariff_name AND

Line 4675: wsh_zone_regions dzr

4671: MAX(dzr.postal_code_from) destination_low
4672: FROM
4673: fte_lanes l,
4674: wsh_zone_regions ozr,
4675: wsh_zone_regions dzr
4676: WHERE
4677: l.lane_type = p_lane_type AND
4678: l.tariff_name = p_tariff_name AND
4679: ozr.parent_region_id = l.origin_id AND