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_TL

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 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 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 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 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 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,