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_HR_LOCATION dependencies on FND_LOOKUP_VALUES

Line 97: , fnd_lookup_values flv1

93: , x_iso_territory_code
94: FROM hr_locations_all hrl
95: , fnd_territories fte
96: , fnd_territories_tl ftel
97: , fnd_lookup_values flv1
98: , fnd_lookup_values flv2
99: , fnd_lookup_values flv3
100: WHERE hrl.location_id = p_location_id
101: AND hrl.country = fte.territory_code (+)

Line 98: , fnd_lookup_values flv2

94: FROM hr_locations_all hrl
95: , fnd_territories fte
96: , fnd_territories_tl ftel
97: , fnd_lookup_values flv1
98: , fnd_lookup_values flv2
99: , fnd_lookup_values flv3
100: WHERE hrl.location_id = p_location_id
101: AND hrl.country = fte.territory_code (+)
102: AND hrl.country = ftel.territory_code (+)

Line 99: , fnd_lookup_values flv3

95: , fnd_territories fte
96: , fnd_territories_tl ftel
97: , fnd_lookup_values flv1
98: , fnd_lookup_values flv2
99: , fnd_lookup_values flv3
100: WHERE hrl.location_id = p_location_id
101: AND hrl.country = fte.territory_code (+)
102: AND hrl.country = ftel.territory_code (+)
103: AND DECODE(ftel.territory_code, NULL, '1', ftel.language) =

Line 180: , fnd_lookup_values flv1

176: , x_iso_territory_code
177: FROM hz_locations hzl
178: , fnd_territories fte
179: , fnd_territories_tl ftel
180: , fnd_lookup_values flv1
181: , fnd_lookup_values flv2
182: , fnd_lookup_values flv3
183: WHERE hzl.location_id = p_location_id
184: AND hzl.country = fte.territory_code (+)

Line 181: , fnd_lookup_values flv2

177: FROM hz_locations hzl
178: , fnd_territories fte
179: , fnd_territories_tl ftel
180: , fnd_lookup_values flv1
181: , fnd_lookup_values flv2
182: , fnd_lookup_values flv3
183: WHERE hzl.location_id = p_location_id
184: AND hzl.country = fte.territory_code (+)
185: AND hzl.country = ftel.territory_code (+)

Line 182: , fnd_lookup_values flv3

178: , fnd_territories fte
179: , fnd_territories_tl ftel
180: , fnd_lookup_values flv1
181: , fnd_lookup_values flv2
182: , fnd_lookup_values flv3
183: WHERE hzl.location_id = p_location_id
184: AND hzl.country = fte.territory_code (+)
185: AND hzl.country = ftel.territory_code (+)
186: AND DECODE(ftel.territory_code, NULL, '1', ftel.language) =

Line 394: FND_LOOKUP_VALUES FCL1,

390: x_contact_fax
391: FROM
392: HR_LOCATIONS HLC,
393: FND_TERRITORIES_TL FTE,
394: FND_LOOKUP_VALUES FCL1,
395: FND_LOOKUP_VALUES FCL2,
396: FND_LOOKUP_VALUES FCL3
397: Where
398: HLC.LOCATION_ID = p_location_id AND

Line 395: FND_LOOKUP_VALUES FCL2,

391: FROM
392: HR_LOCATIONS HLC,
393: FND_TERRITORIES_TL FTE,
394: FND_LOOKUP_VALUES FCL1,
395: FND_LOOKUP_VALUES FCL2,
396: FND_LOOKUP_VALUES FCL3
397: Where
398: HLC.LOCATION_ID = p_location_id AND
399: HLC.COUNTRY = FTE.TERRITORY_CODE (+) AND

Line 396: FND_LOOKUP_VALUES FCL3

392: HR_LOCATIONS HLC,
393: FND_TERRITORIES_TL FTE,
394: FND_LOOKUP_VALUES FCL1,
395: FND_LOOKUP_VALUES FCL2,
396: FND_LOOKUP_VALUES FCL3
397: Where
398: HLC.LOCATION_ID = p_location_id AND
399: HLC.COUNTRY = FTE.TERRITORY_CODE (+) AND
400: DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) =

Line 483: FND_LOOKUP_VALUES FCL1,

479: x_address_line_4
480: FROM
481: HZ_LOCATIONS HLC,
482: FND_TERRITORIES_TL FTE,
483: FND_LOOKUP_VALUES FCL1,
484: FND_LOOKUP_VALUES FCL2,
485: FND_LOOKUP_VALUES FCL3
486: WHERE
487: HLC.LOCATION_ID = p_location_id AND

Line 484: FND_LOOKUP_VALUES FCL2,

480: FROM
481: HZ_LOCATIONS HLC,
482: FND_TERRITORIES_TL FTE,
483: FND_LOOKUP_VALUES FCL1,
484: FND_LOOKUP_VALUES FCL2,
485: FND_LOOKUP_VALUES FCL3
486: WHERE
487: HLC.LOCATION_ID = p_location_id AND
488: HLC.COUNTRY = FTE.TERRITORY_CODE (+) AND

Line 485: FND_LOOKUP_VALUES FCL3

481: HZ_LOCATIONS HLC,
482: FND_TERRITORIES_TL FTE,
483: FND_LOOKUP_VALUES FCL1,
484: FND_LOOKUP_VALUES FCL2,
485: FND_LOOKUP_VALUES FCL3
486: WHERE
487: HLC.LOCATION_ID = p_location_id AND
488: HLC.COUNTRY = FTE.TERRITORY_CODE (+) AND
489: DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) =

Line 728: FND_LOOKUP_VALUES FCL1,

724: x_contact_fax
725: FROM
726: HR_LOCATIONS HLC,
727: FND_TERRITORIES_TL FTE,
728: FND_LOOKUP_VALUES FCL1,
729: FND_LOOKUP_VALUES FCL2,
730: FND_LOOKUP_VALUES FCL3
731: Where
732: HLC.LOCATION_ID = p_location_id AND

Line 729: FND_LOOKUP_VALUES FCL2,

725: FROM
726: HR_LOCATIONS HLC,
727: FND_TERRITORIES_TL FTE,
728: FND_LOOKUP_VALUES FCL1,
729: FND_LOOKUP_VALUES FCL2,
730: FND_LOOKUP_VALUES FCL3
731: Where
732: HLC.LOCATION_ID = p_location_id AND
733: HLC.COUNTRY = FTE.TERRITORY_CODE (+) AND

Line 730: FND_LOOKUP_VALUES FCL3

726: HR_LOCATIONS HLC,
727: FND_TERRITORIES_TL FTE,
728: FND_LOOKUP_VALUES FCL1,
729: FND_LOOKUP_VALUES FCL2,
730: FND_LOOKUP_VALUES FCL3
731: Where
732: HLC.LOCATION_ID = p_location_id AND
733: HLC.COUNTRY = FTE.TERRITORY_CODE (+) AND
734: DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) =

Line 998: FND_LOOKUP_VALUES FCL1,

994: l_style_code
995: FROM
996: HZ_LOCATIONS HLC,
997: FND_TERRITORIES_TL FTE,
998: FND_LOOKUP_VALUES FCL1,
999: FND_LOOKUP_VALUES FCL2,
1000: FND_LOOKUP_VALUES FCL3
1001: WHERE
1002: HLC.LOCATION_ID = p_location_id AND

Line 999: FND_LOOKUP_VALUES FCL2,

995: FROM
996: HZ_LOCATIONS HLC,
997: FND_TERRITORIES_TL FTE,
998: FND_LOOKUP_VALUES FCL1,
999: FND_LOOKUP_VALUES FCL2,
1000: FND_LOOKUP_VALUES FCL3
1001: WHERE
1002: HLC.LOCATION_ID = p_location_id AND
1003: HLC.COUNTRY = FTE.TERRITORY_CODE (+) AND

Line 1000: FND_LOOKUP_VALUES FCL3

996: HZ_LOCATIONS HLC,
997: FND_TERRITORIES_TL FTE,
998: FND_LOOKUP_VALUES FCL1,
999: FND_LOOKUP_VALUES FCL2,
1000: FND_LOOKUP_VALUES FCL3
1001: WHERE
1002: HLC.LOCATION_ID = p_location_id AND
1003: HLC.COUNTRY = FTE.TERRITORY_CODE (+) AND
1004: DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) =