APPS.PO_EMAIL_GENERATE dependencies on HZ_LOCATIONS

Line 960: from hz_locations

956: into l_hrl_description,
957: l_hrl_address_line_1, l_hrl_address_line_2,
958: l_hrl_address_line_3, l_hrl_town_or_city,
959: l_hrl_postal_code, l_hrl_country
960: from hz_locations
961: where location_id = l_line_loc.ship_to_location_id;*/
962:
963: --Bug 9356725 Added following sql to get state info in email notification
964: SELECT

Line 986: HZ_LOCATIONS HLC,

982: l_hrl_postal_code,
983: l_hrl_country,
984: l_hrl_to_region1
985: FROM
986: HZ_LOCATIONS HLC,
987: FND_LOOKUP_VALUES FCL1,
988: FND_LOOKUP_VALUES FCL2,
989: FND_LOOKUP_VALUES FCL3
990: WHERE

Line 3057: FROM hz_locations hrl

3053: l_ship_to_add3,
3054: l_ship_to_city,
3055: l_ship_to_postal_code,
3056: l_ship_to_country
3057: FROM hz_locations hrl
3058: where HRL.location_id = l_location_id;*/
3059: --Bug 9356725 Added the following sql to get state info
3060: SELECT
3061: HLC.DESCRIPTION,

Line 3082: HZ_LOCATIONS HLC,

3078: l_ship_to_postal_code,
3079: l_ship_to_country,
3080: l_ship_to_region2
3081: FROM
3082: HZ_LOCATIONS HLC,
3083: FND_LOOKUP_VALUES FCL1,
3084: FND_LOOKUP_VALUES FCL2,
3085: FND_LOOKUP_VALUES FCL3
3086: WHERE

Line 3341: FROM hz_locations hrl

3337: l_ship_to_add3,
3338: l_ship_to_city,
3339: l_ship_to_postal_code,
3340: l_ship_to_country
3341: FROM hz_locations hrl
3342: where HRL.location_id = l_location_id;*/
3343: --Bug 9356725 Added the following sql to get state info
3344: SELECT
3345: HLC.DESCRIPTION,

Line 3366: HZ_LOCATIONS HLC,

3362: l_ship_to_postal_code,
3363: l_ship_to_country,
3364: l_ship_to_region2
3365: FROM
3366: HZ_LOCATIONS HLC,
3367: FND_LOOKUP_VALUES FCL1,
3368: FND_LOOKUP_VALUES FCL2,
3369: FND_LOOKUP_VALUES FCL3
3370: WHERE