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.PO_EMAIL_GENERATE dependencies on HR_LOCATIONS_ALL

Line 166: l_hrl_location hr_locations_all.location_code%TYPE;

162: -- l_header_note_to_vendor varchar2(240);
163:
164: x_pb_count number;
165:
166: l_hrl_location hr_locations_all.location_code%TYPE;
167: l_hrl_description hr_locations_all.description%TYPE;
168: l_hrl_address_line_1 hr_locations_all.address_line_1%TYPE;
169: l_hrl_address_line_2 hr_locations_all.address_line_2%TYPE;
170: l_hrl_address_line_3 hr_locations_all.address_line_3%TYPE;

Line 167: l_hrl_description hr_locations_all.description%TYPE;

163:
164: x_pb_count number;
165:
166: l_hrl_location hr_locations_all.location_code%TYPE;
167: l_hrl_description hr_locations_all.description%TYPE;
168: l_hrl_address_line_1 hr_locations_all.address_line_1%TYPE;
169: l_hrl_address_line_2 hr_locations_all.address_line_2%TYPE;
170: l_hrl_address_line_3 hr_locations_all.address_line_3%TYPE;
171: l_hrl_town_or_city hr_locations_all.town_or_city%TYPE;

Line 168: l_hrl_address_line_1 hr_locations_all.address_line_1%TYPE;

164: x_pb_count number;
165:
166: l_hrl_location hr_locations_all.location_code%TYPE;
167: l_hrl_description hr_locations_all.description%TYPE;
168: l_hrl_address_line_1 hr_locations_all.address_line_1%TYPE;
169: l_hrl_address_line_2 hr_locations_all.address_line_2%TYPE;
170: l_hrl_address_line_3 hr_locations_all.address_line_3%TYPE;
171: l_hrl_town_or_city hr_locations_all.town_or_city%TYPE;
172: l_hrl_postal_code hr_locations_all.postal_code%TYPE;

Line 169: l_hrl_address_line_2 hr_locations_all.address_line_2%TYPE;

165:
166: l_hrl_location hr_locations_all.location_code%TYPE;
167: l_hrl_description hr_locations_all.description%TYPE;
168: l_hrl_address_line_1 hr_locations_all.address_line_1%TYPE;
169: l_hrl_address_line_2 hr_locations_all.address_line_2%TYPE;
170: l_hrl_address_line_3 hr_locations_all.address_line_3%TYPE;
171: l_hrl_town_or_city hr_locations_all.town_or_city%TYPE;
172: l_hrl_postal_code hr_locations_all.postal_code%TYPE;
173: -- EMAILPO FPH START--

Line 170: l_hrl_address_line_3 hr_locations_all.address_line_3%TYPE;

166: l_hrl_location hr_locations_all.location_code%TYPE;
167: l_hrl_description hr_locations_all.description%TYPE;
168: l_hrl_address_line_1 hr_locations_all.address_line_1%TYPE;
169: l_hrl_address_line_2 hr_locations_all.address_line_2%TYPE;
170: l_hrl_address_line_3 hr_locations_all.address_line_3%TYPE;
171: l_hrl_town_or_city hr_locations_all.town_or_city%TYPE;
172: l_hrl_postal_code hr_locations_all.postal_code%TYPE;
173: -- EMAILPO FPH START--
174: l_hrl_to_region1 fnd_lookup_values.meaning%TYPE;

Line 171: l_hrl_town_or_city hr_locations_all.town_or_city%TYPE;

167: l_hrl_description hr_locations_all.description%TYPE;
168: l_hrl_address_line_1 hr_locations_all.address_line_1%TYPE;
169: l_hrl_address_line_2 hr_locations_all.address_line_2%TYPE;
170: l_hrl_address_line_3 hr_locations_all.address_line_3%TYPE;
171: l_hrl_town_or_city hr_locations_all.town_or_city%TYPE;
172: l_hrl_postal_code hr_locations_all.postal_code%TYPE;
173: -- EMAILPO FPH START--
174: l_hrl_to_region1 fnd_lookup_values.meaning%TYPE;
175: l_hrl_to_region2 fnd_lookup_values.meaning%TYPE;

Line 172: l_hrl_postal_code hr_locations_all.postal_code%TYPE;

168: l_hrl_address_line_1 hr_locations_all.address_line_1%TYPE;
169: l_hrl_address_line_2 hr_locations_all.address_line_2%TYPE;
170: l_hrl_address_line_3 hr_locations_all.address_line_3%TYPE;
171: l_hrl_town_or_city hr_locations_all.town_or_city%TYPE;
172: l_hrl_postal_code hr_locations_all.postal_code%TYPE;
173: -- EMAILPO FPH START--
174: l_hrl_to_region1 fnd_lookup_values.meaning%TYPE;
175: l_hrl_to_region2 fnd_lookup_values.meaning%TYPE;
176: l_hrl_to_region3 fnd_lookup_values.meaning%TYPE;

Line 900: -- when this SQL is executed; fetch translated columns from hr_locations_all_tl

896: /* Bug 2766736. Changed ftv.nls_territory to ftv.territory_short_name in
897: the select statement */
898:
899: -- Bug 3574886: Query from base tables in case the session context is not set correctly
900: -- when this SQL is executed; fetch translated columns from hr_locations_all_tl
901: select distinct
902: hlt.location_code,
903: hlt.description,
904: hrl.address_line_1,

Line 925: from hr_locations_all hrl,

921: l_hrl_town_or_city,
922: l_hrl_postal_code,
923: l_hrl_country,
924: l_hrl_to_region1
925: from hr_locations_all hrl,
926: hr_locations_all_tl hlt,
927: fnd_territories_vl ftv,
928: fnd_lookup_values_vl flv1,
929: fnd_lookup_values_vl flv2,

Line 926: hr_locations_all_tl hlt,

922: l_hrl_postal_code,
923: l_hrl_country,
924: l_hrl_to_region1
925: from hr_locations_all hrl,
926: hr_locations_all_tl hlt,
927: fnd_territories_vl ftv,
928: fnd_lookup_values_vl flv1,
929: fnd_lookup_values_vl flv2,
930: fnd_lookup_values_vl flv3,

Line 2586: l_operating_unit_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;

2582:
2583: l_document VARCHAR2(32000) := '';
2584: x_display_type varchar2(60);
2585:
2586: l_operating_unit_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;
2587: l_operating_unit_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2588: l_operating_unit_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2589: l_operating_unit_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2590: l_operating_unit_city HR_LOCATIONS_ALL.town_or_city%TYPE;

Line 2587: l_operating_unit_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;

2583: l_document VARCHAR2(32000) := '';
2584: x_display_type varchar2(60);
2585:
2586: l_operating_unit_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;
2587: l_operating_unit_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2588: l_operating_unit_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2589: l_operating_unit_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2590: l_operating_unit_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2591: l_operating_unit_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

Line 2588: l_operating_unit_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;

2584: x_display_type varchar2(60);
2585:
2586: l_operating_unit_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;
2587: l_operating_unit_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2588: l_operating_unit_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2589: l_operating_unit_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2590: l_operating_unit_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2591: l_operating_unit_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2592: -- EMAILPO FPH START--

Line 2589: l_operating_unit_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;

2585:
2586: l_operating_unit_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;
2587: l_operating_unit_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2588: l_operating_unit_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2589: l_operating_unit_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2590: l_operating_unit_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2591: l_operating_unit_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2592: -- EMAILPO FPH START--
2593: /* Bug 2766736. Changed nls_territory to territory_short_name */

Line 2590: l_operating_unit_city HR_LOCATIONS_ALL.town_or_city%TYPE;

2586: l_operating_unit_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;
2587: l_operating_unit_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2588: l_operating_unit_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2589: l_operating_unit_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2590: l_operating_unit_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2591: l_operating_unit_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2592: -- EMAILPO FPH START--
2593: /* Bug 2766736. Changed nls_territory to territory_short_name */
2594: l_operating_unit_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

Line 2591: l_operating_unit_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

2587: l_operating_unit_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2588: l_operating_unit_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2589: l_operating_unit_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2590: l_operating_unit_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2591: l_operating_unit_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2592: -- EMAILPO FPH START--
2593: /* Bug 2766736. Changed nls_territory to territory_short_name */
2594: l_operating_unit_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2595: l_operating_unit_state FND_LOOKUP_VALUES.MEANING%TYPE;

Line 2602: l_ship_to_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;

2598: -- EMAILPO FPH END--
2599: l_operating_unit_id NUMBER;
2600:
2601:
2602: l_ship_to_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;
2603: l_ship_to_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2604: l_ship_to_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2605: l_ship_to_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2606: l_ship_to_city HR_LOCATIONS_ALL.town_or_city%TYPE;

Line 2603: l_ship_to_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;

2599: l_operating_unit_id NUMBER;
2600:
2601:
2602: l_ship_to_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;
2603: l_ship_to_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2604: l_ship_to_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2605: l_ship_to_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2606: l_ship_to_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2607: l_ship_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

Line 2604: l_ship_to_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;

2600:
2601:
2602: l_ship_to_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;
2603: l_ship_to_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2604: l_ship_to_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2605: l_ship_to_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2606: l_ship_to_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2607: l_ship_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2608: -- EMAILPO FPH START--

Line 2605: l_ship_to_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;

2601:
2602: l_ship_to_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;
2603: l_ship_to_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2604: l_ship_to_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2605: l_ship_to_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2606: l_ship_to_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2607: l_ship_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2608: -- EMAILPO FPH START--
2609: /* Bug 2766736. Changed nls_territory to territory_short_name */

Line 2606: l_ship_to_city HR_LOCATIONS_ALL.town_or_city%TYPE;

2602: l_ship_to_desc HR_LOCATIONS_ALL.DESCRIPTION%TYPE;
2603: l_ship_to_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2604: l_ship_to_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2605: l_ship_to_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2606: l_ship_to_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2607: l_ship_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2608: -- EMAILPO FPH START--
2609: /* Bug 2766736. Changed nls_territory to territory_short_name */
2610: l_ship_to_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

Line 2607: l_ship_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

2603: l_ship_to_add1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2604: l_ship_to_add2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2605: l_ship_to_add3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2606: l_ship_to_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2607: l_ship_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2608: -- EMAILPO FPH START--
2609: /* Bug 2766736. Changed nls_territory to territory_short_name */
2610: l_ship_to_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2611: l_ship_to_region1 FND_LOOKUP_VALUES.MEANING%TYPE;

Line 2629: l_bill_to_desc hr_locations_all.description%TYPE;

2625: l_vendor_site_id NUMBER;
2626:
2627: l_vendor_id NUMBER;
2628:
2629: l_bill_to_desc hr_locations_all.description%TYPE;
2630: l_bill_to_add1 hr_locations_all.address_line_1%TYPE;
2631: l_bill_to_add2 hr_locations_all.address_line_2%TYPE;
2632: l_bill_to_add3 hr_locations_all.address_line_3%TYPE;
2633: l_bill_to_city hr_locations_all.town_or_city%TYPE;

Line 2630: l_bill_to_add1 hr_locations_all.address_line_1%TYPE;

2626:
2627: l_vendor_id NUMBER;
2628:
2629: l_bill_to_desc hr_locations_all.description%TYPE;
2630: l_bill_to_add1 hr_locations_all.address_line_1%TYPE;
2631: l_bill_to_add2 hr_locations_all.address_line_2%TYPE;
2632: l_bill_to_add3 hr_locations_all.address_line_3%TYPE;
2633: l_bill_to_city hr_locations_all.town_or_city%TYPE;
2634: l_bill_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

Line 2631: l_bill_to_add2 hr_locations_all.address_line_2%TYPE;

2627: l_vendor_id NUMBER;
2628:
2629: l_bill_to_desc hr_locations_all.description%TYPE;
2630: l_bill_to_add1 hr_locations_all.address_line_1%TYPE;
2631: l_bill_to_add2 hr_locations_all.address_line_2%TYPE;
2632: l_bill_to_add3 hr_locations_all.address_line_3%TYPE;
2633: l_bill_to_city hr_locations_all.town_or_city%TYPE;
2634: l_bill_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2635: /* Bug 2766736. Changed hr_locations_all.country to

Line 2632: l_bill_to_add3 hr_locations_all.address_line_3%TYPE;

2628:
2629: l_bill_to_desc hr_locations_all.description%TYPE;
2630: l_bill_to_add1 hr_locations_all.address_line_1%TYPE;
2631: l_bill_to_add2 hr_locations_all.address_line_2%TYPE;
2632: l_bill_to_add3 hr_locations_all.address_line_3%TYPE;
2633: l_bill_to_city hr_locations_all.town_or_city%TYPE;
2634: l_bill_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2635: /* Bug 2766736. Changed hr_locations_all.country to
2636: fnd_territories_vl.territory_short_name */

Line 2633: l_bill_to_city hr_locations_all.town_or_city%TYPE;

2629: l_bill_to_desc hr_locations_all.description%TYPE;
2630: l_bill_to_add1 hr_locations_all.address_line_1%TYPE;
2631: l_bill_to_add2 hr_locations_all.address_line_2%TYPE;
2632: l_bill_to_add3 hr_locations_all.address_line_3%TYPE;
2633: l_bill_to_city hr_locations_all.town_or_city%TYPE;
2634: l_bill_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2635: /* Bug 2766736. Changed hr_locations_all.country to
2636: fnd_territories_vl.territory_short_name */
2637: l_bill_to_country fnd_territories_vl.territory_short_name%TYPE;

Line 2634: l_bill_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

2630: l_bill_to_add1 hr_locations_all.address_line_1%TYPE;
2631: l_bill_to_add2 hr_locations_all.address_line_2%TYPE;
2632: l_bill_to_add3 hr_locations_all.address_line_3%TYPE;
2633: l_bill_to_city hr_locations_all.town_or_city%TYPE;
2634: l_bill_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2635: /* Bug 2766736. Changed hr_locations_all.country to
2636: fnd_territories_vl.territory_short_name */
2637: l_bill_to_country fnd_territories_vl.territory_short_name%TYPE;
2638: l_bill_to_region1 hr_locations_all.region_1%TYPE;

Line 2635: /* Bug 2766736. Changed hr_locations_all.country to

2631: l_bill_to_add2 hr_locations_all.address_line_2%TYPE;
2632: l_bill_to_add3 hr_locations_all.address_line_3%TYPE;
2633: l_bill_to_city hr_locations_all.town_or_city%TYPE;
2634: l_bill_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2635: /* Bug 2766736. Changed hr_locations_all.country to
2636: fnd_territories_vl.territory_short_name */
2637: l_bill_to_country fnd_territories_vl.territory_short_name%TYPE;
2638: l_bill_to_region1 hr_locations_all.region_1%TYPE;
2639: l_bill_to_region2 hr_locations_all.region_2%TYPE;

Line 2638: l_bill_to_region1 hr_locations_all.region_1%TYPE;

2634: l_bill_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2635: /* Bug 2766736. Changed hr_locations_all.country to
2636: fnd_territories_vl.territory_short_name */
2637: l_bill_to_country fnd_territories_vl.territory_short_name%TYPE;
2638: l_bill_to_region1 hr_locations_all.region_1%TYPE;
2639: l_bill_to_region2 hr_locations_all.region_2%TYPE;
2640: l_bill_to_region3 hr_locations_all.region_3%TYPE;
2641: l_bill_to_id NUMBER;
2642:

Line 2639: l_bill_to_region2 hr_locations_all.region_2%TYPE;

2635: /* Bug 2766736. Changed hr_locations_all.country to
2636: fnd_territories_vl.territory_short_name */
2637: l_bill_to_country fnd_territories_vl.territory_short_name%TYPE;
2638: l_bill_to_region1 hr_locations_all.region_1%TYPE;
2639: l_bill_to_region2 hr_locations_all.region_2%TYPE;
2640: l_bill_to_region3 hr_locations_all.region_3%TYPE;
2641: l_bill_to_id NUMBER;
2642:
2643:

Line 2640: l_bill_to_region3 hr_locations_all.region_3%TYPE;

2636: fnd_territories_vl.territory_short_name */
2637: l_bill_to_country fnd_territories_vl.territory_short_name%TYPE;
2638: l_bill_to_region1 hr_locations_all.region_1%TYPE;
2639: l_bill_to_region2 hr_locations_all.region_2%TYPE;
2640: l_bill_to_region3 hr_locations_all.region_3%TYPE;
2641: l_bill_to_id NUMBER;
2642:
2643:
2644: l_po_number PO_HEADERS_ALL.SEGMENT1%TYPE;

Line 2990: -- when this SQL is executed; fetch translated columns from hr_locations_all_tl

2986: /* Bug 2766736. Changed ftv.nls_territory to ftv.territory_short_name in
2987: the select statement. */
2988:
2989: -- Bug 3574886: Query from base tables in case the session context is not set correctly
2990: -- when this SQL is executed; fetch translated columns from hr_locations_all_tl
2991: select distinct hlt.description,
2992: hrl.address_line_1,
2993: hrl.address_line_2,
2994: hrl.address_line_3,

Line 3013: FROM hr_locations_all hrl,

3009: l_ship_to_city,
3010: l_ship_to_postal_code,
3011: l_ship_to_country,
3012: l_ship_to_region2
3013: FROM hr_locations_all hrl,
3014: hr_locations_all_tl hlt,
3015: fnd_territories_vl ftv,
3016: fnd_lookup_values_vl flv1,
3017: fnd_lookup_values_vl flv2,

Line 3014: hr_locations_all_tl hlt,

3010: l_ship_to_postal_code,
3011: l_ship_to_country,
3012: l_ship_to_region2
3013: FROM hr_locations_all hrl,
3014: hr_locations_all_tl hlt,
3015: fnd_territories_vl ftv,
3016: fnd_lookup_values_vl flv1,
3017: fnd_lookup_values_vl flv2,
3018: fnd_lookup_values_vl flv3,

Line 3274: -- when this SQL is executed; fetch translated columns from hr_locations_all_tl

3270: /* Bug 2766736. Changed ftv.nls_territory to ftv.territory_short_name in
3271: the select statement. */
3272:
3273: -- Bug 3574886: Query from base tables in case the session context is not set correctly
3274: -- when this SQL is executed; fetch translated columns from hr_locations_all_tl
3275: select distinct hlt.description,
3276: hrl.address_line_1,
3277: hrl.address_line_2,
3278: hrl.address_line_3,

Line 3297: FROM hr_locations_all hrl,

3293: l_ship_to_city,
3294: l_ship_to_postal_code,
3295: l_ship_to_country,
3296: l_ship_to_region2
3297: FROM hr_locations_all hrl,
3298: hr_locations_all_tl hlt,
3299: fnd_territories_vl ftv,
3300: fnd_lookup_values_vl flv1,
3301: fnd_lookup_values_vl flv2,

Line 3298: hr_locations_all_tl hlt,

3294: l_ship_to_postal_code,
3295: l_ship_to_country,
3296: l_ship_to_region2
3297: FROM hr_locations_all hrl,
3298: hr_locations_all_tl hlt,
3299: fnd_territories_vl ftv,
3300: fnd_lookup_values_vl flv1,
3301: fnd_lookup_values_vl flv2,
3302: fnd_lookup_values_vl flv3,

Line 3659: -- when this SQL is executed; fetch translated columns from hr_locations_all_tl

3655: the select statement. */
3656: begin
3657:
3658: -- Bug 3574886: Query from base tables in case the session context is not set correctly
3659: -- when this SQL is executed; fetch translated columns from hr_locations_all_tl
3660: select distinct hlt.description,
3661: hrl.address_line_1,
3662: hrl.address_line_2,
3663: hrl.address_line_3,

Line 3681: from hr_locations_all hrl,

3677: l_bill_to_city,
3678: l_bill_to_country,
3679: l_bill_to_postal_code,
3680: l_bill_to_region2
3681: from hr_locations_all hrl,
3682: hr_locations_all_tl hlt,
3683: fnd_territories_vl ftv,
3684: fnd_lookup_values_vl flv1,
3685: fnd_lookup_values_vl flv2,

Line 3682: hr_locations_all_tl hlt,

3678: l_bill_to_country,
3679: l_bill_to_postal_code,
3680: l_bill_to_region2
3681: from hr_locations_all hrl,
3682: hr_locations_all_tl hlt,
3683: fnd_territories_vl ftv,
3684: fnd_lookup_values_vl flv1,
3685: fnd_lookup_values_vl flv2,
3686: fnd_lookup_values_vl flv3,