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.ARP_CMERGE_ARCUS dependencies on HZ_PARTIES

Line 3375: AND rel.subject_table_name = 'HZ_PARTIES'

3371: AND acct_role.cust_account_id = p_from_account_id
3372: AND acct_role.cust_acct_site_id IS NULL
3373: AND acct_role.party_id = rel.party_id
3374: AND org.party_relationship_id = rel.relationship_id
3375: AND rel.subject_table_name = 'HZ_PARTIES'
3376: AND rel.object_table_name = 'HZ_PARTIES'
3377: AND acct_role.cust_account_id = acct.cust_account_id
3378: AND acct.party_id = rel.object_id
3379: AND rel.subject_id <> p_to_party_id ;--5067291

Line 3376: AND rel.object_table_name = 'HZ_PARTIES'

3372: AND acct_role.cust_acct_site_id IS NULL
3373: AND acct_role.party_id = rel.party_id
3374: AND org.party_relationship_id = rel.relationship_id
3375: AND rel.subject_table_name = 'HZ_PARTIES'
3376: AND rel.object_table_name = 'HZ_PARTIES'
3377: AND acct_role.cust_account_id = acct.cust_account_id
3378: AND acct.party_id = rel.object_id
3379: AND rel.subject_id <> p_to_party_id ;--5067291
3380: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */

Line 3534: AND rel.subject_table_name = 'HZ_PARTIES'

3530: AND acct_role.cust_account_id = p_from_account_id
3531: AND acct_role.cust_acct_site_id = from_site_id
3532: AND acct_role.party_id = rel.party_id
3533: AND org.party_relationship_id = rel.relationship_id
3534: AND rel.subject_table_name = 'HZ_PARTIES'
3535: AND rel.object_table_name = 'HZ_PARTIES'
3536: AND acct_role.cust_account_id = acct.cust_account_id
3537: AND acct.party_id = rel.object_id
3538: AND rel.subject_id <> p_to_party_id;--5067291

Line 3535: AND rel.object_table_name = 'HZ_PARTIES'

3531: AND acct_role.cust_acct_site_id = from_site_id
3532: AND acct_role.party_id = rel.party_id
3533: AND org.party_relationship_id = rel.relationship_id
3534: AND rel.subject_table_name = 'HZ_PARTIES'
3535: AND rel.object_table_name = 'HZ_PARTIES'
3536: AND acct_role.cust_account_id = acct.cust_account_id
3537: AND acct.party_id = rel.object_id
3538: AND rel.subject_id <> p_to_party_id;--5067291
3539: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */

Line 3711: CURSOR c_party_type(p_party_id NUMBER) IS SELECT party_type from hz_parties

3707: l_insert VARCHAR2(10) := FND_API.G_FALSE;
3708: l_sql VARCHAR2(1000);
3709: l_direction_code VARCHAR2(30);
3710: --Start of Bug No: 4387523
3711: CURSOR c_party_type(p_party_id NUMBER) IS SELECT party_type from hz_parties
3712: where party_id = p_party_id;
3713: l_party_type varchar2(30);
3714: --End of Bug No: 4387523
3715: BEGIN

Line 3764: AND subject_table_name = 'HZ_PARTIES'

3760: WHERE relationship_id = (
3761: SELECT party_relationship_id
3762: FROM hz_org_contacts
3763: WHERE org_contact_id = x_org_contact_id )
3764: AND subject_table_name = 'HZ_PARTIES'
3765: AND object_table_name = 'HZ_PARTIES'
3766: AND rownum = 1;
3767: /* AND directional_flag = 'F'; */ /* Bug No : 2359461 */
3768:

Line 3765: AND object_table_name = 'HZ_PARTIES'

3761: SELECT party_relationship_id
3762: FROM hz_org_contacts
3763: WHERE org_contact_id = x_org_contact_id )
3764: AND subject_table_name = 'HZ_PARTIES'
3765: AND object_table_name = 'HZ_PARTIES'
3766: AND rownum = 1;
3767: /* AND directional_flag = 'F'; */ /* Bug No : 2359461 */
3768:
3769: ELSE

Line 3814: if(l_org_contact_rec.party_rel_rec.object_table_name ='HZ_PARTIES') then

3810:
3811: -------Update the new party relationship rec with the merge-to party
3812: l_org_contact_rec.party_rel_rec.object_id := p_to_party_id;
3813: --Start of Bug No: 4387523
3814: if(l_org_contact_rec.party_rel_rec.object_table_name ='HZ_PARTIES') then
3815: open c_party_type(l_org_contact_rec.party_rel_rec.object_id);
3816: fetch c_party_type into l_party_type;
3817: close c_party_type;
3818: l_org_contact_rec.party_rel_rec.object_type := l_party_type;

Line 3907: do_copy_contact_points ( 'HZ_PARTIES',

3903: --contact points in party level
3904:
3905:
3906:
3907: do_copy_contact_points ( 'HZ_PARTIES',
3908: p_org_party_id,
3909: x_org_party_id,
3910: p_from_account_id );
3911:

Line 3972: do_copy_contact_points ( 'HZ_PARTIES',

3968: BEGIN
3969:
3970: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint()+' );
3971:
3972: do_copy_contact_points ( 'HZ_PARTIES',
3973: p_from_party_id,
3974: p_to_party_id,
3975: p_from_account_id );
3976:

Line 4079: | hz_contact_points.owner_table_name = 'HZ_PARTIES'

4075: | MODIFICATION HISTORY
4076: |
4077: | Jianying Huang 25-OCT-00 Remove parameter orgContactId. from_party_id
4078: | should be used by cursor. Add new condition:
4079: | hz_contact_points.owner_table_name = 'HZ_PARTIES'
4080: | Jianying Huang 25-OCT-00 After call create_contact_point API,
4081: | if return_status is not 'success', we need to
4082: | populate an exception.
4083: | Jianying Huang 27-OCT-00 Since contacts of 'phone' type also goes

Line 4348: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4344: SELECT 'same relationships'
4345: FROM HZ_RELATIONSHIPS rel
4346: WHERE rel.RELATIONSHIP_ID = org.PARTY_RELATIONSHIP_ID
4347: AND rel.OBJECT_ID = p_to_party_id
4348: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4349: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
4350: /* AND DIRECTIONAL_FLAG = 'F' */ /* Bug No : 2359461 */
4351: AND TO_CHAR(SUBJECT_ID) ||
4352: RELATIONSHIP_CODE = (

Line 4349: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

4345: FROM HZ_RELATIONSHIPS rel
4346: WHERE rel.RELATIONSHIP_ID = org.PARTY_RELATIONSHIP_ID
4347: AND rel.OBJECT_ID = p_to_party_id
4348: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4349: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
4350: /* AND DIRECTIONAL_FLAG = 'F' */ /* Bug No : 2359461 */
4351: AND TO_CHAR(SUBJECT_ID) ||
4352: RELATIONSHIP_CODE = (
4353: SELECT TO_CHAR(SUBJECT_ID) ||

Line 4360: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4356: WHERE RELATIONSHIP_ID =
4357: p_from_party_rel_id
4358: AND OBJECT_ID = ACCT.PARTY_ID
4359: AND ACCT.CUST_ACCOUNT_ID = p_from_account_id
4360: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4361: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
4362: /* AND DIRECTIONAL_FLAG = 'F' */ /* Bug No : 2359461 */
4363: ) )
4364: AND ORG_CONTACT_ID <> p_from_org_contact_id;

Line 4361: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

4357: p_from_party_rel_id
4358: AND OBJECT_ID = ACCT.PARTY_ID
4359: AND ACCT.CUST_ACCOUNT_ID = p_from_account_id
4360: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4361: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
4362: /* AND DIRECTIONAL_FLAG = 'F' */ /* Bug No : 2359461 */
4363: ) )
4364: AND ORG_CONTACT_ID <> p_from_org_contact_id;
4365: