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.CS_SERVICEREQUEST_UTIL dependencies on HZ_PARTY_SITE_USES

Line 3513: Hz_Party_Site_Uses su

3509:
3510: CURSOR Bill_To_Site IS
3511: SELECT su.party_site_use_id
3512: FROM Hz_Party_Sites s,
3513: Hz_Party_Site_Uses su
3514: WHERE s.party_site_id = su.party_site_id
3515: AND s.party_site_id = p_bill_to_site_id
3516: AND s.party_id = p_bill_to_party_id
3517: AND s.status = 'A'

Line 3573: -- # 2615775 - removed reference to hz_party_site_uses..

3569:
3570: BEGIN
3571:
3572: -- Fix to bug # 2529361.included keyword distinct in select clause.
3573: -- # 2615775 - removed reference to hz_party_site_uses..
3574:
3575: SELECT DISTINCT s.party_id INTO l_install_customer_id
3576: FROM Hz_Party_Sites s
3577: WHERE s.party_site_id = p_install_site_id

Line 6163: Hz_Party_Site_Uses su

6159:
6160: CURSOR Site_Site_Use IS
6161: SELECT s.status
6162: FROM Hz_Party_Sites s,
6163: Hz_Party_Site_Uses su
6164: WHERE s.party_site_id = su.party_site_id
6165: AND s.party_site_id = p_site_id
6166: AND s.party_id = p_party_id
6167: AND su.party_site_use_id = p_site_use_id

Line 6227: Hz_Party_Site_Uses su

6223:
6224: CURSOR Bill_To_Site_Use IS
6225: SELECT s.party_site_id
6226: FROM Hz_Party_Sites s,
6227: Hz_Party_Site_Uses su
6228: WHERE s.party_site_id = su.party_site_id
6229: AND su.party_site_use_id = p_site_use_id
6230: AND s.party_id = p_party_id
6231: AND s.status = 'A'