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 3515: Hz_Party_Site_Uses su

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

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

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

Line 6165: Hz_Party_Site_Uses su

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

Line 6229: Hz_Party_Site_Uses su

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