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

Line 2497: AND cont_point.owner_table_name = 'HZ_PARTIES'

2493: and AR_CUSTOMER_CALL_TOPICS.site_use_id(+) = site_use_id_1
2494: AND AR_CUSTOMER_CALL_TOPICS.PHONE_ID = cont_point.contact_point_id
2495: AND AR_CUSTOMER_CALL_TOPICS.CONTACT_ID = car.cust_account_role_id
2496: AND car.party_id = cont_point.owner_table_id
2497: AND cont_point.owner_table_name = 'HZ_PARTIES'
2498: AND cont_point.contact_point_type not in ('EDI','EMAIL','WEB')
2499: AND AR_CUSTOMER_CALL_TOPICS.CUSTOMER_TRX_ID =
2500: AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID (+)
2501: AND AR_CUSTOMER_CALL_TOPICS.CUSTOMER_CALL_TOPIC_ID =

Line 2769: hz_parties party,

2765: RTRIM(RPAD(decode(cont_point.contact_point_type,'TLX',
2766: cont_point.telex_number,
2767: cont_point.phone_number), 15))
2768: from hz_cust_account_roles acct_role,
2769: hz_parties party,
2770: hz_relationships rel,
2771: hz_org_contacts org_cont,
2772: hz_contact_points cont_point,
2773: hz_cust_account_roles car

Line 2779: and rel.subject_table_name = 'HZ_PARTIES'

2775: and acct_role.party_id = rel.party_id
2776: and acct_role.role_type = 'CONTACT'
2777: and org_cont.party_relationship_id = rel.relationship_id
2778: and rel.subject_id = party.party_id
2779: and rel.subject_table_name = 'HZ_PARTIES'
2780: and rel.object_table_name = 'HZ_PARTIES'
2781: and rel.directional_flag = 'F'
2782: and acct_role.cust_account_role_id = car.cust_account_role_id(+)
2783: and car.party_id = cont_point.owner_table_id(+)

Line 2780: and rel.object_table_name = 'HZ_PARTIES'

2776: and acct_role.role_type = 'CONTACT'
2777: and org_cont.party_relationship_id = rel.relationship_id
2778: and rel.subject_id = party.party_id
2779: and rel.subject_table_name = 'HZ_PARTIES'
2780: and rel.object_table_name = 'HZ_PARTIES'
2781: and rel.directional_flag = 'F'
2782: and acct_role.cust_account_role_id = car.cust_account_role_id(+)
2783: and car.party_id = cont_point.owner_table_id(+)
2784: and cont_point.owner_table_name(+) = 'HZ_PARTIES'

Line 2784: and cont_point.owner_table_name(+) = 'HZ_PARTIES'

2780: and rel.object_table_name = 'HZ_PARTIES'
2781: and rel.directional_flag = 'F'
2782: and acct_role.cust_account_role_id = car.cust_account_role_id(+)
2783: and car.party_id = cont_point.owner_table_id(+)
2784: and cont_point.owner_table_name(+) = 'HZ_PARTIES'
2785: and cont_point.contact_point_type(+) NOT IN ('EDI','EMAIL','WEB')
2786: and nvl(nvl(cont_point.phone_line_type,
2787: cont_point.contact_point_type), 'GEN') = 'GEN'
2788: and nvl( acct_role.status,'A') = 'A'