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 FND_TERRITORIES_VL

Line 178: l_hrl_country fnd_territories_vl.territory_short_name%TYPE;

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;
177: /* Bug 2766736. Changed nls_territory to territory_short_name */
178: l_hrl_country fnd_territories_vl.territory_short_name%TYPE;
179: -- EMAILPO FPH END--
180:
181: --bug fix 2257742
182: l_min_unit fnd_currencies.minimum_accountable_unit%TYPE;

Line 927: fnd_territories_vl ftv,

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,
931: fnd_lookup_values_vl flv4

Line 2594: l_operating_unit_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%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;
2596: l_operating_unit_region2 FND_LOOKUP_VALUES.MEANING%TYPE;
2597: l_operating_unit_region3 FND_LOOKUP_VALUES.MEANING%TYPE;
2598: -- EMAILPO FPH END--

Line 2610: l_ship_to_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%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;
2612: l_ship_to_region2 FND_LOOKUP_VALUES.MEANING%TYPE;
2613: l_ship_to_region3 FND_LOOKUP_VALUES.MEANING%TYPE;
2614: -- EMAILPO FPH END--

Line 2624: l_vendor_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

2620: l_vendor_city PO_VENDOR_SITES.CITY%TYPE;
2621: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2622: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;
2623: /* Bug 2766736. Changed nls_territory to territory_short_name */
2624: l_vendor_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2625: l_vendor_site_id NUMBER;
2626:
2627: l_vendor_id NUMBER;
2628:

Line 2636: fnd_territories_vl.territory_short_name */

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;
2640: l_bill_to_region3 hr_locations_all.region_3%TYPE;

Line 2637: l_bill_to_country fnd_territories_vl.territory_short_name%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;
2640: l_bill_to_region3 hr_locations_all.region_3%TYPE;
2641: l_bill_to_id NUMBER;

Line 3015: fnd_territories_vl ftv,

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,
3019: fnd_lookup_values_vl flv4

Line 3299: fnd_territories_vl ftv,

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,
3303: fnd_lookup_values_vl flv4

Line 3637: from hr_organization_units_v houv, fnd_territories_vl ftv, fnd_lookup_values_vl flv1, fnd_lookup_values_vl flv2,

3633: into
3634: l_operating_unit_desc, l_operating_unit_add1,
3635: l_operating_unit_add2, l_operating_unit_add3, l_operating_unit_city,
3636: l_operating_unit_state,l_operating_unit_postal_code, l_operating_unit_country
3637: from hr_organization_units_v houv, fnd_territories_vl ftv, fnd_lookup_values_vl flv1, fnd_lookup_values_vl flv2,
3638: fnd_lookup_values_vl flv3
3639: where
3640: houv.region_1 = flv1.lookup_code (+) and houv.country || '_PROVINCE' = flv1.lookup_type (+)
3641: and houv.region_2 = flv2.lookup_code (+) and houv.country || '_STATE' = flv2.lookup_type (+)

Line 3683: fnd_territories_vl ftv,

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,
3687: fnd_lookup_values_vl flv4

Line 3717: from po_vendor_sites pvs , fnd_territories_vl ftv

3713: ftv.territory_short_name, zip
3714: into
3715: l_vendor_add1, l_vendor_add2, l_vendor_add3, l_vendor_city, l_vendor_state,
3716: l_vendor_country, l_vendor_zip
3717: from po_vendor_sites pvs , fnd_territories_vl ftv
3718: where
3719: ftv.territory_code(+) = pvs.country --
3720: and vendor_site_id = l_vendor_site_id;
3721: