DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on HZ_LOCATIONS

Line 874: from hz_locations

870: into l_hrl_description,
871: l_hrl_address_line_1, l_hrl_address_line_2,
872: l_hrl_address_line_3, l_hrl_town_or_city,
873: l_hrl_postal_code, l_hrl_country
874: from hz_locations
875: where location_id = l_line_loc.ship_to_location_id;
876:
877: exception
878: when no_data_found then

Line 2766: FROM hz_locations hrl

2762: l_ship_to_add3,
2763: l_ship_to_city,
2764: l_ship_to_postal_code,
2765: l_ship_to_country
2766: FROM hz_locations hrl
2767: where HRL.location_id = l_location_id;
2768:
2769: exception
2770: when no_data_found then

Line 2977: FROM hz_locations hrl

2973: l_ship_to_add3,
2974: l_ship_to_city,
2975: l_ship_to_postal_code,
2976: l_ship_to_country
2977: FROM hz_locations hrl
2978: where HRL.location_id = l_location_id;
2979:
2980: exception
2981: