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.RRS_SITE_INFO dependencies on HZ_FORMAT_PUB

Line 300: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,

296: NLS_UPPER(COUNTY) COUNTY,
297: NLS_UPPER(STATE) STATE,
298: NLS_UPPER(PROVINCE) PROVINCE,
299: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
300: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,
301: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
302: HZ_FORMAT_PUB.format_address(location_id, null, null, ',' , null) as Address,
303: 'Y' as IDENTIFYING_ADDRESS_FLAG
304: Bulk Collect

Line 302: HZ_FORMAT_PUB.format_address(location_id, null, null, ',' , null) as Address,

298: NLS_UPPER(PROVINCE) PROVINCE,
299: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
300: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,
301: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
302: HZ_FORMAT_PUB.format_address(location_id, null, null, ',' , null) as Address,
303: 'Y' as IDENTIFYING_ADDRESS_FLAG
304: Bulk Collect
305: INTO l_site_address_details
306: FROM HZ_LOCATIONS

Line 323: HZ_FORMAT_PUB.format_address(location_id, null, null, ',' , null) as Address,

319: NLS_UPPER(PROVINCE) PROVINCE,
320: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
321: COUNTRY,
322: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
323: HZ_FORMAT_PUB.format_address(location_id, null, null, ',' , null) as Address,
324: 'Y' as IDENTIFYING_ADDRESS_FLAG
325: Bulk Collect
326: INTO l_site_address_details
327: FROM HZ_LOCATIONS

Line 1720: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,

1716: NLS_UPPER(COUNTY) COUNTY,
1717: NLS_UPPER(STATE) STATE,
1718: NLS_UPPER(PROVINCE) PROVINCE,
1719: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
1720: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,
1721: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
1722: HZ_FORMAT_PUB.format_address(HL.location_id, null, null, ',' , null) as Address,
1723: HPS.IDENTIFYING_ADDRESS_FLAG
1724: BULK COLLECT

Line 1722: HZ_FORMAT_PUB.format_address(HL.location_id, null, null, ',' , null) as Address,

1718: NLS_UPPER(PROVINCE) PROVINCE,
1719: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
1720: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,
1721: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
1722: HZ_FORMAT_PUB.format_address(HL.location_id, null, null, ',' , null) as Address,
1723: HPS.IDENTIFYING_ADDRESS_FLAG
1724: BULK COLLECT
1725: INTO l_site_party_dets
1726: FROM HZ_LOCATIONS HL

Line 1746: HZ_FORMAT_PUB.format_address(HL.location_id, null, null, ',' , null) as Address,

1742: NLS_UPPER(PROVINCE) PROVINCE,
1743: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
1744: COUNTRY,
1745: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
1746: HZ_FORMAT_PUB.format_address(HL.location_id, null, null, ',' , null) as Address,
1747: HPS.IDENTIFYING_ADDRESS_FLAG
1748: BULK COLLECT
1749: INTO l_site_party_dets
1750: FROM HZ_LOCATIONS HL