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 174: l_hrl_to_region1 fnd_lookup_values.meaning%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;
177: /* Bug 2766736. Changed nls_territory to territory_short_name */
178: l_hrl_country fnd_territories_vl.territory_short_name%TYPE;

Line 175: l_hrl_to_region2 fnd_lookup_values.meaning%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;
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--

Line 176: l_hrl_to_region3 fnd_lookup_values.meaning%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;
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:

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

889: EMAILPO FPH
890: should not print region1, 2 and 3
891: for US address only region2 code should be printed ignoring 1 and 3
892: for non US addresses region1 i.e. County or region3 i.e. province should be printed
893: for region1 or region3 the meaning should be printed instead of code from fnd_lookup_values
894: Also country should be spelled out instead of code
895: */
896: /* Bug 2766736. Changed ftv.nls_territory to ftv.territory_short_name in
897: the select statement */

Line 907: --hrl.town_or_city, --bug#5870952 commented to fetch tow_or_city from fnd_lookup_values

903: hlt.description,
904: hrl.address_line_1,
905: hrl.address_line_2,
906: hrl.address_line_3,
907: --hrl.town_or_city, --bug#5870952 commented to fetch tow_or_city from fnd_lookup_values
908: Decode(hrl.town_or_city,flv4.lookup_code,flv4.meaning,hrl.town_or_city),
909: hrl.postal_code,
910: ftv.territory_short_name,
911: nvl(decode(hrl.region_1, null,

Line 928: fnd_lookup_values_vl flv1,

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
932: where hrl.region_1 = flv1.lookup_code (+)

Line 929: fnd_lookup_values_vl flv2,

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
932: where hrl.region_1 = flv1.lookup_code (+)
933: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)

Line 930: fnd_lookup_values_vl flv3,

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
932: where hrl.region_1 = flv1.lookup_code (+)
933: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
934: and hrl.location_id = hlt.location_id and hlt.language = USERENV('LANG')

Line 931: fnd_lookup_values_vl flv4

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
932: where hrl.region_1 = flv1.lookup_code (+)
933: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
934: and hrl.location_id = hlt.location_id and hlt.language = USERENV('LANG')
935: and hrl.region_2 = flv2.lookup_code (+)

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

942: AND hrl.country || '_PROVINCE' = flv4.lookup_type (+);
943:
944: /* Bug 2646120. The country code is not a mandatory one in hr_locations. So the country code
945: may be null. Changed the join with ftv to outer join. */
946: /* Bug 2791859 fnd_lookup_values_vl should be used instead of fnd_lookup_values */
947:
948: exception
949: when no_data_found then
950:

Line 987: FND_LOOKUP_VALUES FCL1,

983: l_hrl_country,
984: l_hrl_to_region1
985: FROM
986: HZ_LOCATIONS HLC,
987: FND_LOOKUP_VALUES FCL1,
988: FND_LOOKUP_VALUES FCL2,
989: FND_LOOKUP_VALUES FCL3
990: WHERE
991: HLC.LOCATION_ID = l_line_loc.ship_to_location_id AND

Line 988: FND_LOOKUP_VALUES FCL2,

984: l_hrl_to_region1
985: FROM
986: HZ_LOCATIONS HLC,
987: FND_LOOKUP_VALUES FCL1,
988: FND_LOOKUP_VALUES FCL2,
989: FND_LOOKUP_VALUES FCL3
990: WHERE
991: HLC.LOCATION_ID = l_line_loc.ship_to_location_id AND
992: HLC.county = FCL1.LOOKUP_CODE (+) AND

Line 989: FND_LOOKUP_VALUES FCL3

985: FROM
986: HZ_LOCATIONS HLC,
987: FND_LOOKUP_VALUES FCL1,
988: FND_LOOKUP_VALUES FCL2,
989: FND_LOOKUP_VALUES FCL3
990: WHERE
991: HLC.LOCATION_ID = l_line_loc.ship_to_location_id AND
992: HLC.county = FCL1.LOOKUP_CODE (+) AND
993: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND

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

Line 2596: l_operating_unit_region2 FND_LOOKUP_VALUES.MEANING%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--
2599: l_operating_unit_id NUMBER;
2600:

Line 2597: l_operating_unit_region3 FND_LOOKUP_VALUES.MEANING%TYPE;

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--
2599: l_operating_unit_id NUMBER;
2600:
2601:

Line 2611: l_ship_to_region1 FND_LOOKUP_VALUES.MEANING%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--
2615:

Line 2612: l_ship_to_region2 FND_LOOKUP_VALUES.MEANING%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--
2615:
2616: l_vendor_desc PO_VENDORS.VENDOR_NAME%TYPE;

Line 2613: l_ship_to_region3 FND_LOOKUP_VALUES.MEANING%TYPE;

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--
2615:
2616: l_vendor_desc PO_VENDORS.VENDOR_NAME%TYPE;
2617: l_vendor_add1 PO_VENDOR_SITES.ADDRESS_LINE1%TYPE;

Line 2995: --hrl.town_or_city, -- bug#15993315 commented to fetch tow_or_city from fnd_lookup_values

2991: select distinct hlt.description,
2992: hrl.address_line_1,
2993: hrl.address_line_2,
2994: hrl.address_line_3,
2995: --hrl.town_or_city, -- bug#15993315 commented to fetch tow_or_city from fnd_lookup_values
2996: Decode(hrl.town_or_city,flv4.lookup_code,flv4.meaning,hrl.town_or_city) ,
2997: hrl.postal_code,
2998: ftv.territory_short_name,
2999: nvl(decode(hrl.region_1, null,

Line 3016: fnd_lookup_values_vl flv1,

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
3020: where hrl.region_1 = flv1.lookup_code (+)

Line 3017: fnd_lookup_values_vl flv2,

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
3020: where hrl.region_1 = flv1.lookup_code (+)
3021: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)

Line 3018: fnd_lookup_values_vl flv3,

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
3020: where hrl.region_1 = flv1.lookup_code (+)
3021: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
3022: and hrl.location_id = hlt.location_id

Line 3019: fnd_lookup_values_vl flv4

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
3020: where hrl.region_1 = flv1.lookup_code (+)
3021: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
3022: and hrl.location_id = hlt.location_id
3023: and hlt.language = USERENV('LANG')

Line 3083: FND_LOOKUP_VALUES FCL1,

3079: l_ship_to_country,
3080: l_ship_to_region2
3081: FROM
3082: HZ_LOCATIONS HLC,
3083: FND_LOOKUP_VALUES FCL1,
3084: FND_LOOKUP_VALUES FCL2,
3085: FND_LOOKUP_VALUES FCL3
3086: WHERE
3087: HLC.LOCATION_ID = l_location_id AND

Line 3084: FND_LOOKUP_VALUES FCL2,

3080: l_ship_to_region2
3081: FROM
3082: HZ_LOCATIONS HLC,
3083: FND_LOOKUP_VALUES FCL1,
3084: FND_LOOKUP_VALUES FCL2,
3085: FND_LOOKUP_VALUES FCL3
3086: WHERE
3087: HLC.LOCATION_ID = l_location_id AND
3088: HLC.county = FCL1.LOOKUP_CODE (+) AND

Line 3085: FND_LOOKUP_VALUES FCL3

3081: FROM
3082: HZ_LOCATIONS HLC,
3083: FND_LOOKUP_VALUES FCL1,
3084: FND_LOOKUP_VALUES FCL2,
3085: FND_LOOKUP_VALUES FCL3
3086: WHERE
3087: HLC.LOCATION_ID = l_location_id AND
3088: HLC.county = FCL1.LOOKUP_CODE (+) AND
3089: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND

Line 3279: --hrl.town_or_city, -- bug#15993315 commented to fetch town_or_city from fnd_lookup_values

3275: select distinct hlt.description,
3276: hrl.address_line_1,
3277: hrl.address_line_2,
3278: hrl.address_line_3,
3279: --hrl.town_or_city, -- bug#15993315 commented to fetch town_or_city from fnd_lookup_values
3280: Decode(hrl.town_or_city,flv4.lookup_code,flv4.meaning,hrl.town_or_city) ,
3281: hrl.postal_code,
3282: ftv.territory_short_name,
3283: nvl(decode(hrl.region_1, null,

Line 3300: fnd_lookup_values_vl flv1,

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
3304: where hrl.region_1 = flv1.lookup_code (+)

Line 3301: fnd_lookup_values_vl flv2,

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
3304: where hrl.region_1 = flv1.lookup_code (+)
3305: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)

Line 3302: fnd_lookup_values_vl flv3,

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
3304: where hrl.region_1 = flv1.lookup_code (+)
3305: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
3306: and hrl.location_id = hlt.location_id

Line 3303: fnd_lookup_values_vl flv4

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
3304: where hrl.region_1 = flv1.lookup_code (+)
3305: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
3306: and hrl.location_id = hlt.location_id
3307: and hlt.language = USERENV('LANG')

Line 3367: FND_LOOKUP_VALUES FCL1,

3363: l_ship_to_country,
3364: l_ship_to_region2
3365: FROM
3366: HZ_LOCATIONS HLC,
3367: FND_LOOKUP_VALUES FCL1,
3368: FND_LOOKUP_VALUES FCL2,
3369: FND_LOOKUP_VALUES FCL3
3370: WHERE
3371: HLC.LOCATION_ID = l_location_id AND

Line 3368: FND_LOOKUP_VALUES FCL2,

3364: l_ship_to_region2
3365: FROM
3366: HZ_LOCATIONS HLC,
3367: FND_LOOKUP_VALUES FCL1,
3368: FND_LOOKUP_VALUES FCL2,
3369: FND_LOOKUP_VALUES FCL3
3370: WHERE
3371: HLC.LOCATION_ID = l_location_id AND
3372: HLC.county = FCL1.LOOKUP_CODE (+) AND

Line 3369: FND_LOOKUP_VALUES FCL3

3365: FROM
3366: HZ_LOCATIONS HLC,
3367: FND_LOOKUP_VALUES FCL1,
3368: FND_LOOKUP_VALUES FCL2,
3369: FND_LOOKUP_VALUES FCL3
3370: WHERE
3371: HLC.LOCATION_ID = l_location_id AND
3372: HLC.county = FCL1.LOOKUP_CODE (+) AND
3373: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND

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

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

Line 3664: -- hrl.town_or_city, --bug#15993315 commented to fetch town_or_city from fnd_lookup_values

3660: select distinct hlt.description,
3661: hrl.address_line_1,
3662: hrl.address_line_2,
3663: hrl.address_line_3,
3664: -- hrl.town_or_city, --bug#15993315 commented to fetch town_or_city from fnd_lookup_values
3665: Decode(hrl.town_or_city,flv4.lookup_code,flv4.meaning,hrl.town_or_city) ,
3666: ftv.territory_short_name,
3667: hrl.postal_code,
3668: nvl(decode(hrl.region_1, null,

Line 3684: fnd_lookup_values_vl flv1,

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
3688: where hrl.region_1 = flv1.lookup_code (+)

Line 3685: fnd_lookup_values_vl flv2,

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
3688: where hrl.region_1 = flv1.lookup_code (+)
3689: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)

Line 3686: fnd_lookup_values_vl flv3,

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
3688: where hrl.region_1 = flv1.lookup_code (+)
3689: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
3690: and hrl.location_id = hlt.location_id

Line 3687: fnd_lookup_values_vl flv4

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
3688: where hrl.region_1 = flv1.lookup_code (+)
3689: and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
3690: and hrl.location_id = hlt.location_id
3691: and hlt.language = USERENV('LANG')