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.AR_INVOICE_UTILS dependencies on HZ_RELATIONSHIPS

Line 786: hz_relationships rel,

782: AND NOT EXISTS
783: (SELECT 'X'
784: FROM hz_cust_account_roles acct_role,
785: hz_parties party,
786: hz_relationships rel,
787: hz_org_contacts org_cont,
788: hz_parties rel_party
789: WHERE acct_role.party_id = rel.party_id
790: AND acct_role.role_type = 'CONTACT'

Line 841: hz_relationships rel,

837: AND NOT EXISTS
838: (SELECT 'X'
839: FROM hz_cust_account_roles acct_role,
840: hz_parties party,
841: hz_relationships rel,
842: hz_org_contacts org_cont,
843: hz_parties rel_party
844: WHERE acct_role.party_id = rel.party_id
845: AND acct_role.role_type = 'CONTACT'

Line 3300: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,

3296: LOOP
3297: BEGIN
3298: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3299: INTO l_contact_id
3300: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3301: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3302: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3303: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3304: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID

Line 3499: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,

3495: LOOP
3496: BEGIN
3497: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3498: INTO l_contact_id
3499: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3500: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3501: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3502: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3503: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID