DBA Data[Home] [Help]

APPS.FTE_LTL_LOADER dependencies on WSH_REGIONS_TL

Line 661: wsh_regions_tl oz,

657: FROM
658: fte_lanes l,
659: hz_parties hzp,
660: qp_list_headers_tl qlht,
661: wsh_regions_tl oz,
662: wsh_regions_tl dz,
663: fte_lane_rate_charts flrc,
664: fte_prc_parameters prc
665: WHERE

Line 662: wsh_regions_tl dz,

658: fte_lanes l,
659: hz_parties hzp,
660: qp_list_headers_tl qlht,
661: wsh_regions_tl oz,
662: wsh_regions_tl dz,
663: fte_lane_rate_charts flrc,
664: fte_prc_parameters prc
665: WHERE
666: l.tariff_name = p_tariff_name 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 3656: wsh_regions_tl

3652: region_id
3653: INTO
3654: l_zone_id
3655: FROM
3656: wsh_regions_tl
3657: WHERE
3658: zone = l_zone_name;
3659: END IF;
3660: