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 174: l_hrl_country fnd_territories_vl.territory_short_name%TYPE;

170: l_hrl_to_region1 fnd_lookup_values.meaning%TYPE;
171: l_hrl_to_region2 fnd_lookup_values.meaning%TYPE;
172: l_hrl_to_region3 fnd_lookup_values.meaning%TYPE;
173: /* Bug 2766736. Changed nls_territory to territory_short_name */
174: l_hrl_country fnd_territories_vl.territory_short_name%TYPE;
175: -- EMAILPO FPH END--
176:
177: --bug fix 2257742
178: l_min_unit fnd_currencies.minimum_accountable_unit%TYPE;

Line 845: fnd_territories_vl ftv,

841: l_hrl_country,
842: l_hrl_to_region1
843: from hr_locations_all hrl,
844: hr_locations_all_tl hlt,
845: fnd_territories_vl ftv,
846: fnd_lookup_values_vl flv1,
847: fnd_lookup_values_vl flv2,
848: fnd_lookup_values_vl flv3
849: where hrl.region_1 = flv1.lookup_code (+)

Line 2373: l_operating_unit_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

2369: l_operating_unit_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2370: l_operating_unit_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2371: -- EMAILPO FPH START--
2372: /* Bug 2766736. Changed nls_territory to territory_short_name */
2373: l_operating_unit_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2374: l_operating_unit_state FND_LOOKUP_VALUES.MEANING%TYPE;
2375: l_operating_unit_region2 FND_LOOKUP_VALUES.MEANING%TYPE;
2376: l_operating_unit_region3 FND_LOOKUP_VALUES.MEANING%TYPE;
2377: -- EMAILPO FPH END--

Line 2389: l_ship_to_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

2385: l_ship_to_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2386: l_ship_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2387: -- EMAILPO FPH START--
2388: /* Bug 2766736. Changed nls_territory to territory_short_name */
2389: l_ship_to_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2390: l_ship_to_region1 FND_LOOKUP_VALUES.MEANING%TYPE;
2391: l_ship_to_region2 FND_LOOKUP_VALUES.MEANING%TYPE;
2392: l_ship_to_region3 FND_LOOKUP_VALUES.MEANING%TYPE;
2393: -- EMAILPO FPH END--

Line 2403: l_vendor_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

2399: l_vendor_city PO_VENDOR_SITES.CITY%TYPE;
2400: l_vendor_state PO_VENDOR_SITES.STATE%TYPE;
2401: l_vendor_zip PO_VENDOR_SITES.ZIP%TYPE;
2402: /* Bug 2766736. Changed nls_territory to territory_short_name */
2403: l_vendor_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2404: l_vendor_site_id NUMBER;
2405:
2406: l_vendor_id NUMBER;
2407:

Line 2415: fnd_territories_vl.territory_short_name */

2411: l_bill_to_add3 hr_locations_all.address_line_3%TYPE;
2412: l_bill_to_city hr_locations_all.town_or_city%TYPE;
2413: l_bill_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2414: /* Bug 2766736. Changed hr_locations_all.country to
2415: fnd_territories_vl.territory_short_name */
2416: l_bill_to_country fnd_territories_vl.territory_short_name%TYPE;
2417: l_bill_to_region1 hr_locations_all.region_1%TYPE;
2418: l_bill_to_region2 hr_locations_all.region_2%TYPE;
2419: l_bill_to_region3 hr_locations_all.region_3%TYPE;

Line 2416: l_bill_to_country fnd_territories_vl.territory_short_name%TYPE;

2412: l_bill_to_city hr_locations_all.town_or_city%TYPE;
2413: l_bill_to_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2414: /* Bug 2766736. Changed hr_locations_all.country to
2415: fnd_territories_vl.territory_short_name */
2416: l_bill_to_country fnd_territories_vl.territory_short_name%TYPE;
2417: l_bill_to_region1 hr_locations_all.region_1%TYPE;
2418: l_bill_to_region2 hr_locations_all.region_2%TYPE;
2419: l_bill_to_region3 hr_locations_all.region_3%TYPE;
2420: l_bill_to_id NUMBER;

Line 2728: fnd_territories_vl ftv,

2724: l_ship_to_country,
2725: l_ship_to_region2
2726: FROM hr_locations_all hrl,
2727: hr_locations_all_tl hlt,
2728: fnd_territories_vl ftv,
2729: fnd_lookup_values_vl flv1,
2730: fnd_lookup_values_vl flv2,
2731: fnd_lookup_values_vl flv3
2732: where hrl.region_1 = flv1.lookup_code (+)

Line 2939: fnd_territories_vl ftv,

2935: l_ship_to_country,
2936: l_ship_to_region2
2937: FROM hr_locations_all hrl,
2938: hr_locations_all_tl hlt,
2939: fnd_territories_vl ftv,
2940: fnd_lookup_values_vl flv1,
2941: fnd_lookup_values_vl flv2,
2942: fnd_lookup_values_vl flv3
2943: where hrl.region_1 = flv1.lookup_code (+)

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

3179: into
3180: l_operating_unit_desc, l_operating_unit_add1,
3181: l_operating_unit_add2, l_operating_unit_add3, l_operating_unit_city,
3182: l_operating_unit_state,l_operating_unit_postal_code, l_operating_unit_country
3183: from hr_organization_units_v houv, fnd_territories_vl ftv, fnd_lookup_values_vl flv1, fnd_lookup_values_vl flv2,
3184: fnd_lookup_values_vl flv3
3185: where
3186: houv.region_1 = flv1.lookup_code (+) and houv.country || '_PROVINCE' = flv1.lookup_type (+)
3187: and houv.region_2 = flv2.lookup_code (+) and houv.country || '_STATE' = flv2.lookup_type (+)

Line 3228: fnd_territories_vl ftv,

3224: l_bill_to_postal_code,
3225: l_bill_to_region2
3226: from hr_locations_all hrl,
3227: hr_locations_all_tl hlt,
3228: fnd_territories_vl ftv,
3229: fnd_lookup_values_vl flv1,
3230: fnd_lookup_values_vl flv2,
3231: fnd_lookup_values_vl flv3
3232: where hrl.region_1 = flv1.lookup_code (+)

Line 3259: from po_vendor_sites pvs , fnd_territories_vl ftv

3255: ftv.territory_short_name, zip
3256: into
3257: l_vendor_add1, l_vendor_add2, l_vendor_add3, l_vendor_city, l_vendor_state,
3258: l_vendor_country, l_vendor_zip
3259: from po_vendor_sites pvs , fnd_territories_vl ftv
3260: where
3261: ftv.territory_code(+) = nvl(pvs.country_of_origin_code, pvs.country)
3262: and vendor_site_id = l_vendor_site_id;
3263: