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

Line 4081: HZ_RELATIONSHIPS REL,

4077: into l_bill_to_contact_last_name,l_bill_to_contact_first_name,l_bill_to_contact_job_title
4078: FROM
4079: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4080: HZ_PARTIES PARTY,
4081: HZ_RELATIONSHIPS REL,
4082: HZ_ORG_CONTACTS ORG_CONT
4083: WHERE
4084: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
4085: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 4113: HZ_RELATIONSHIPS REL,

4109: into l_ship_to_contact_last_name,l_ship_to_contact_first_name,l_ship_to_contact_job_title
4110: FROM
4111: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4112: HZ_PARTIES PARTY,
4113: HZ_RELATIONSHIPS REL,
4114: HZ_ORG_CONTACTS ORG_CONT,
4115: HZ_PARTIES REL_PARTY
4116: WHERE
4117: ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 4148: HZ_RELATIONSHIPS REL,

4144: into l_sold_to_contact_last_name,l_sold_to_contact_first_name,l_sold_to_contact_job_title
4145: FROM
4146: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4147: HZ_PARTIES PARTY,
4148: HZ_RELATIONSHIPS REL,
4149: HZ_ORG_CONTACTS ORG_CONT,
4150: HZ_PARTIES REL_PARTY
4151: WHERE
4152: ACCT_ROLE.PARTY_ID = REL.PARTY_ID