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 308: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,

304: NLS_UPPER(COUNTY) COUNTY,
305: NLS_UPPER(STATE) STATE,
306: NLS_UPPER(PROVINCE) PROVINCE,
307: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
308: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,
309: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
310: HZ_FORMAT_PUB.format_address(location_id, null, null, ',' , null) as Address,
311: 'Y' as IDENTIFYING_ADDRESS_FLAG
312: Bulk Collect

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

306: NLS_UPPER(PROVINCE) PROVINCE,
307: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
308: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,
309: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
310: HZ_FORMAT_PUB.format_address(location_id, null, null, ',' , null) as Address,
311: 'Y' as IDENTIFYING_ADDRESS_FLAG
312: Bulk Collect
313: INTO l_site_address_details
314: FROM HZ_LOCATIONS

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

327: NLS_UPPER(PROVINCE) PROVINCE,
328: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
329: COUNTRY,
330: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
331: HZ_FORMAT_PUB.format_address(location_id, null, null, ',' , null) as Address,
332: 'Y' as IDENTIFYING_ADDRESS_FLAG ,
333: GEOMETRY_SOURCE,
334: ( SELECT rlv.meaning FROM RRS_LOOKUPS_V rlv WHERE rlv.lookup_type = 'RRS_GEO_SOURCE'
335: AND rlv.lookup_code = HL.GEOMETRY_SOURCE ) GEOMETRY_SOURCE_MEANING,

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

1785: NLS_UPPER(COUNTY) COUNTY,
1786: NLS_UPPER(STATE) STATE,
1787: NLS_UPPER(PROVINCE) PROVINCE,
1788: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
1789: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,
1790: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
1791: HZ_FORMAT_PUB.format_address(HL.location_id, null, null, ',' , null) as Address,
1792: HPS.IDENTIFYING_ADDRESS_FLAG
1793: BULK COLLECT

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

1787: NLS_UPPER(PROVINCE) PROVINCE,
1788: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
1789: NLS_UPPER(hz_format_pub.get_tl_territory_name(COUNTRY)) COUNTRY,
1790: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
1791: HZ_FORMAT_PUB.format_address(HL.location_id, null, null, ',' , null) as Address,
1792: HPS.IDENTIFYING_ADDRESS_FLAG
1793: BULK COLLECT
1794: INTO l_site_party_dets
1795: FROM HZ_LOCATIONS HL

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

1810: NLS_UPPER(PROVINCE) PROVINCE,
1811: NLS_UPPER(POSTAL_CODE) POSTAL_CODE,
1812: COUNTRY,
1813: FTV.TERRITORY_SHORT_NAME COUNTRY_NAME,
1814: HZ_FORMAT_PUB.format_address(HL.location_id, null, null, ',' , null) as Address,
1815: HPS.IDENTIFYING_ADDRESS_FLAG,
1816: ( select AL.MEANING
1817: from AR_LOOKUPS AL
1818: where AL.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'