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 3067: AND rel.subject_table_name = 'HZ_PARTIES'

3063: AND acct_role.cust_account_id = p_from_account_id
3064: AND acct_role.cust_acct_site_id IS NULL
3065: AND acct_role.party_id = rel.party_id
3066: AND org.party_relationship_id = rel.relationship_id
3067: AND rel.subject_table_name = 'HZ_PARTIES'
3068: AND rel.object_table_name = 'HZ_PARTIES'
3069: AND acct_role.cust_account_id = acct.cust_account_id
3070: AND acct.party_id = rel.object_id
3071: AND rel.subject_id <> p_to_party_id ;--5067291

Line 3068: AND rel.object_table_name = 'HZ_PARTIES'

3064: AND acct_role.cust_acct_site_id IS NULL
3065: AND acct_role.party_id = rel.party_id
3066: AND org.party_relationship_id = rel.relationship_id
3067: AND rel.subject_table_name = 'HZ_PARTIES'
3068: AND rel.object_table_name = 'HZ_PARTIES'
3069: AND acct_role.cust_account_id = acct.cust_account_id
3070: AND acct.party_id = rel.object_id
3071: AND rel.subject_id <> p_to_party_id ;--5067291
3072: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */

Line 3226: AND rel.subject_table_name = 'HZ_PARTIES'

3222: AND acct_role.cust_account_id = p_from_account_id
3223: AND acct_role.cust_acct_site_id = from_site_id
3224: AND acct_role.party_id = rel.party_id
3225: AND org.party_relationship_id = rel.relationship_id
3226: AND rel.subject_table_name = 'HZ_PARTIES'
3227: AND rel.object_table_name = 'HZ_PARTIES'
3228: AND acct_role.cust_account_id = acct.cust_account_id
3229: AND acct.party_id = rel.object_id
3230: AND rel.subject_id <> p_to_party_id;--5067291

Line 3227: AND rel.object_table_name = 'HZ_PARTIES'

3223: AND acct_role.cust_acct_site_id = from_site_id
3224: AND acct_role.party_id = rel.party_id
3225: AND org.party_relationship_id = rel.relationship_id
3226: AND rel.subject_table_name = 'HZ_PARTIES'
3227: AND rel.object_table_name = 'HZ_PARTIES'
3228: AND acct_role.cust_account_id = acct.cust_account_id
3229: AND acct.party_id = rel.object_id
3230: AND rel.subject_id <> p_to_party_id;--5067291
3231: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */

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

3399: l_insert VARCHAR2(10) := FND_API.G_FALSE;
3400: l_sql VARCHAR2(1000);
3401: l_direction_code VARCHAR2(30);
3402: --Start of Bug No: 4387523
3403: CURSOR c_party_type(p_party_id NUMBER) IS SELECT party_type from hz_parties
3404: where party_id = p_party_id;
3405: l_party_type varchar2(30);
3406: --End of Bug No: 4387523
3407: BEGIN

Line 3456: AND subject_table_name = 'HZ_PARTIES'

3452: WHERE relationship_id = (
3453: SELECT party_relationship_id
3454: FROM hz_org_contacts
3455: WHERE org_contact_id = x_org_contact_id )
3456: AND subject_table_name = 'HZ_PARTIES'
3457: AND object_table_name = 'HZ_PARTIES'
3458: AND rownum = 1;
3459: /* AND directional_flag = 'F'; */ /* Bug No : 2359461 */
3460:

Line 3457: AND object_table_name = 'HZ_PARTIES'

3453: SELECT party_relationship_id
3454: FROM hz_org_contacts
3455: WHERE org_contact_id = x_org_contact_id )
3456: AND subject_table_name = 'HZ_PARTIES'
3457: AND object_table_name = 'HZ_PARTIES'
3458: AND rownum = 1;
3459: /* AND directional_flag = 'F'; */ /* Bug No : 2359461 */
3460:
3461: ELSE

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

3502:
3503: -------Update the new party relationship rec with the merge-to party
3504: l_org_contact_rec.party_rel_rec.object_id := p_to_party_id;
3505: --Start of Bug No: 4387523
3506: if(l_org_contact_rec.party_rel_rec.object_table_name ='HZ_PARTIES') then
3507: open c_party_type(l_org_contact_rec.party_rel_rec.object_id);
3508: fetch c_party_type into l_party_type;
3509: close c_party_type;
3510: l_org_contact_rec.party_rel_rec.object_type := l_party_type;

Line 3599: do_copy_contact_points ( 'HZ_PARTIES',

3595: --contact points in party level
3596:
3597:
3598:
3599: do_copy_contact_points ( 'HZ_PARTIES',
3600: p_org_party_id,
3601: x_org_party_id,
3602: p_from_account_id );
3603:

Line 3664: do_copy_contact_points ( 'HZ_PARTIES',

3660: BEGIN
3661:
3662: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint()+' );
3663:
3664: do_copy_contact_points ( 'HZ_PARTIES',
3665: p_from_party_id,
3666: p_to_party_id,
3667: p_from_account_id );
3668:

Line 3771: | hz_contact_points.owner_table_name = 'HZ_PARTIES'

3767: | MODIFICATION HISTORY
3768: |
3769: | Jianying Huang 25-OCT-00 Remove parameter orgContactId. from_party_id
3770: | should be used by cursor. Add new condition:
3771: | hz_contact_points.owner_table_name = 'HZ_PARTIES'
3772: | Jianying Huang 25-OCT-00 After call create_contact_point API,
3773: | if return_status is not 'success', we need to
3774: | populate an exception.
3775: | Jianying Huang 27-OCT-00 Since contacts of 'phone' type also goes

Line 4040: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4036: SELECT 'same relationships'
4037: FROM HZ_RELATIONSHIPS rel
4038: WHERE rel.RELATIONSHIP_ID = org.PARTY_RELATIONSHIP_ID
4039: AND rel.OBJECT_ID = p_to_party_id
4040: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4041: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
4042: /* AND DIRECTIONAL_FLAG = 'F' */ /* Bug No : 2359461 */
4043: AND TO_CHAR(SUBJECT_ID) ||
4044: RELATIONSHIP_CODE = (

Line 4041: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

4037: FROM HZ_RELATIONSHIPS rel
4038: WHERE rel.RELATIONSHIP_ID = org.PARTY_RELATIONSHIP_ID
4039: AND rel.OBJECT_ID = p_to_party_id
4040: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4041: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
4042: /* AND DIRECTIONAL_FLAG = 'F' */ /* Bug No : 2359461 */
4043: AND TO_CHAR(SUBJECT_ID) ||
4044: RELATIONSHIP_CODE = (
4045: SELECT TO_CHAR(SUBJECT_ID) ||

Line 4052: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4048: WHERE RELATIONSHIP_ID =
4049: p_from_party_rel_id
4050: AND OBJECT_ID = ACCT.PARTY_ID
4051: AND ACCT.CUST_ACCOUNT_ID = p_from_account_id
4052: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4053: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
4054: /* AND DIRECTIONAL_FLAG = 'F' */ /* Bug No : 2359461 */
4055: ) )
4056: AND ORG_CONTACT_ID <> p_from_org_contact_id;

Line 4053: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

4049: p_from_party_rel_id
4050: AND OBJECT_ID = ACCT.PARTY_ID
4051: AND ACCT.CUST_ACCOUNT_ID = p_from_account_id
4052: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4053: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
4054: /* AND DIRECTIONAL_FLAG = 'F' */ /* Bug No : 2359461 */
4055: ) )
4056: AND ORG_CONTACT_ID <> p_from_org_contact_id;
4057: