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.PV_TERR_ASSIGN_PUB dependencies on HZ_PARTY_SITES

Line 1833: FROM HZ_PARTY_SITES SITE,

1829: PARTY.employees_total employees_total,
1830: upper(PARTY.party_name) party_name,
1831: PARTY.category_code category_code,
1832: PARTY.curr_fy_potential_revenue annual_revenue
1833: FROM HZ_PARTY_SITES SITE,
1834: HZ_PARTIES PARTY
1835: WHERE SITE.status = 'A'
1836: AND SITE.identifying_address_flag = 'Y'
1837: AND PARTY.party_id = cv_party_id

Line 1856: FROM HZ_PARTY_SITES SITE,

1852: PARTY.employees_total employees_total,
1853: upper(PARTY.party_name) party_name,
1854: PARTY.category_code category_code,
1855: PARTY.curr_fy_potential_revenue annual_revenue
1856: FROM HZ_PARTY_SITES SITE,
1857: HZ_CONTACT_POINTS CNTPNT,
1858: HZ_LOCATIONS LOC,
1859: HZ_PARTIES PARTY
1860: WHERE SITE.status = 'A'

Line 1866: AND CNTPNT.owner_table_name(+) = 'HZ_PARTY_SITES'

1862: AND PARTY.party_id = cv_party_id
1863: AND SITE.party_id = PARTY.party_id
1864: AND PARTY.party_type = 'ORGANIZATION'
1865: AND PARTY.status = 'A'
1866: AND CNTPNT.owner_table_name(+) = 'HZ_PARTY_SITES'
1867: AND CNTPNT.owner_table_id(+) = SITE.party_site_id
1868: AND CNTPNT.status(+) = 'A'
1869: AND CNTPNT.primary_flag(+) = 'Y'
1870: AND CNTPNT.contact_point_type(+) = 'PHONE'