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_VL

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 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')