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 793: hz_relationships rel,

789: AND NOT EXISTS
790: (SELECT 'X'
791: FROM hz_cust_account_roles acct_role,
792: hz_parties party,
793: hz_relationships rel,
794: hz_org_contacts org_cont,
795: hz_parties rel_party
796: WHERE acct_role.party_id = rel.party_id
797: AND acct_role.role_type = 'CONTACT'

Line 848: hz_relationships rel,

844: AND NOT EXISTS
845: (SELECT 'X'
846: FROM hz_cust_account_roles acct_role,
847: hz_parties party,
848: hz_relationships rel,
849: hz_org_contacts org_cont,
850: hz_parties rel_party
851: WHERE acct_role.party_id = rel.party_id
852: AND acct_role.role_type = 'CONTACT'

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

3391: LOOP
3392: BEGIN
3393: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3394: INTO l_contact_id
3395: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3396: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3397: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3398: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3399: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID

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

3590: LOOP
3591: BEGIN
3592: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3593: INTO l_contact_id
3594: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3595: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3596: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3597: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3598: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID