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_LOOKUP_VALUES

Line 170: l_hrl_to_region1 fnd_lookup_values.meaning%TYPE;

166: l_hrl_address_line_3 hr_locations_all.address_line_3%TYPE;
167: l_hrl_town_or_city hr_locations_all.town_or_city%TYPE;
168: l_hrl_postal_code hr_locations_all.postal_code%TYPE;
169: -- EMAILPO FPH START--
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;

Line 171: l_hrl_to_region2 fnd_lookup_values.meaning%TYPE;

167: l_hrl_town_or_city hr_locations_all.town_or_city%TYPE;
168: l_hrl_postal_code hr_locations_all.postal_code%TYPE;
169: -- EMAILPO FPH START--
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--

Line 172: l_hrl_to_region3 fnd_lookup_values.meaning%TYPE;

168: l_hrl_postal_code hr_locations_all.postal_code%TYPE;
169: -- EMAILPO FPH START--
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:

Line 812: for region1 or region3 the meaning should be printed instead of code from fnd_lookup_values

808: EMAILPO FPH
809: should not print region1, 2 and 3
810: for US address only region2 code should be printed ignoring 1 and 3
811: for non US addresses region1 i.e. County or region3 i.e. province should be printed
812: for region1 or region3 the meaning should be printed instead of code from fnd_lookup_values
813: Also country should be spelled out instead of code
814: */
815: /* Bug 2766736. Changed ftv.nls_territory to ftv.territory_short_name in
816: the select statement */

Line 846: fnd_lookup_values_vl flv1,

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 (+)
850: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)

Line 847: fnd_lookup_values_vl flv2,

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 (+)
850: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
851: and hrl.location_id = hlt.location_id and hlt.language = USERENV('LANG')

Line 848: fnd_lookup_values_vl flv3

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 (+)
850: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
851: and hrl.location_id = hlt.location_id and hlt.language = USERENV('LANG')
852: and hrl.region_2 = flv2.lookup_code (+)

Line 861: /* Bug 2791859 fnd_lookup_values_vl should be used instead of fnd_lookup_values */

857: and hrl.location_id = l_line_loc.ship_to_location_id;
858:
859: /* Bug 2646120. The country code is not a mandatory one in hr_locations. So the country code
860: may be null. Changed the join with ftv to outer join. */
861: /* Bug 2791859 fnd_lookup_values_vl should be used instead of fnd_lookup_values */
862:
863: exception
864: when no_data_found then
865:

Line 2374: l_operating_unit_state FND_LOOKUP_VALUES.MEANING%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--
2378: l_operating_unit_id NUMBER;

Line 2375: l_operating_unit_region2 FND_LOOKUP_VALUES.MEANING%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--
2378: l_operating_unit_id NUMBER;
2379:

Line 2376: l_operating_unit_region3 FND_LOOKUP_VALUES.MEANING%TYPE;

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--
2378: l_operating_unit_id NUMBER;
2379:
2380:

Line 2390: l_ship_to_region1 FND_LOOKUP_VALUES.MEANING%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--
2394:

Line 2391: l_ship_to_region2 FND_LOOKUP_VALUES.MEANING%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--
2394:
2395: l_vendor_desc PO_VENDORS.VENDOR_NAME%TYPE;

Line 2392: l_ship_to_region3 FND_LOOKUP_VALUES.MEANING%TYPE;

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--
2394:
2395: l_vendor_desc PO_VENDORS.VENDOR_NAME%TYPE;
2396: l_vendor_add1 PO_VENDOR_SITES.ADDRESS_LINE1%TYPE;

Line 2729: fnd_lookup_values_vl flv1,

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 (+)
2733: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)

Line 2730: fnd_lookup_values_vl flv2,

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 (+)
2733: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
2734: and hrl.location_id = hlt.location_id

Line 2731: fnd_lookup_values_vl flv3

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 (+)
2733: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
2734: and hrl.location_id = hlt.location_id
2735: and hlt.language = USERENV('LANG')

Line 2940: fnd_lookup_values_vl flv1,

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 (+)
2944: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)

Line 2941: fnd_lookup_values_vl flv2,

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 (+)
2944: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
2945: and hrl.location_id = hlt.location_id

Line 2942: fnd_lookup_values_vl flv3

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 (+)
2944: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
2945: and hrl.location_id = hlt.location_id
2946: and hlt.language = USERENV('LANG')

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 3184: fnd_lookup_values_vl flv3

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 (+)
3188: and houv.region_1 = flv3.lookup_code (+) and houv.country || '_COUNTY' = flv3.lookup_type (+)

Line 3229: fnd_lookup_values_vl flv1,

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 (+)
3233: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)

Line 3230: fnd_lookup_values_vl flv2,

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 (+)
3233: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
3234: and hrl.location_id = hlt.location_id

Line 3231: fnd_lookup_values_vl flv3

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 (+)
3233: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
3234: and hrl.location_id = hlt.location_id
3235: and hlt.language = USERENV('LANG')