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_BPA_UTILS_PKG dependencies on HZ_PARTIES

Line 517: hz_parties party

513: CURSOR c_cont_name( id in number ) IS
514: SELECT party.person_first_name ||' '|| party.person_last_name attn
515: FROM hz_cust_account_roles acct_role,
516: hz_relationships rel,
517: hz_parties party
518: WHERE acct_role.cust_account_role_id = id
519: AND acct_role.ROLE_TYPE = 'CONTACT'
520: AND acct_role.party_id = rel.party_id
521: AND rel.subject_id = party.party_id

Line 522: AND rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

518: WHERE acct_role.cust_account_role_id = id
519: AND acct_role.ROLE_TYPE = 'CONTACT'
520: AND acct_role.party_id = rel.party_id
521: AND rel.subject_id = party.party_id
522: AND rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
523: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
524: AND rel.DIRECTIONAL_FLAG = 'F';
525:
526: l_contact_name varchar2(240) := null;

Line 523: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

519: AND acct_role.ROLE_TYPE = 'CONTACT'
520: AND acct_role.party_id = rel.party_id
521: AND rel.subject_id = party.party_id
522: AND rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
523: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
524: AND rel.DIRECTIONAL_FLAG = 'F';
525:
526: l_contact_name varchar2(240) := null;
527: BEGIN

Line 549: and cont_point.owner_table_name = 'HZ_PARTIES'

545: from hz_contact_points cont_point,
546: hz_cust_account_roles acct_role
547: where acct_role.cust_account_role_id = id
548: and acct_role.party_id = cont_point.owner_table_id
549: and cont_point.owner_table_name = 'HZ_PARTIES'
550: and nvl(cont_point.phone_line_type, cont_point.contact_point_type) = 'GEN';
551: l_phone varchar2(240) := null;
552: BEGIN
553: FOR crec IN c_cont_phone(p_contact_id)

Line 575: and cont_point.owner_table_name = 'HZ_PARTIES'

571: from hz_contact_points cont_point,
572: hz_cust_account_roles acct_role
573: where acct_role.cust_account_role_id = id
574: and acct_role.party_id = cont_point.owner_table_id
575: and cont_point.owner_table_name = 'HZ_PARTIES'
576: and nvl(cont_point.phone_line_type, cont_point.contact_point_type) = 'FAX';
577: l_fax varchar2(240) := null;
578: BEGIN
579: FOR crec IN c_cont_fax(p_contact_id)