APPS.ARP_CMERGE_ARCUS dependencies on HZ_ORG_CONTACTS

Line 3367: hz_org_contacts org,

3363: rel.relationship_id,
3364: -- FOR ORG-CONTACT REC
3365: org.org_contact_id
3366: FROM hz_cust_account_roles acct_role,
3367: hz_org_contacts org,
3368: hz_relationships rel,
3369: hz_cust_accounts acct
3370: WHERE acct_role.role_type = 'CONTACT'
3371: AND acct_role.cust_account_id = p_from_account_id

Line 3477: | Jianying Huang 28-DEC-00 Since we ignore hz_org_contacts.party_site_id

3473: | as customer contact points, we'd better to migrate
3474: | it here because it should be a phone number for
3475: | contacts as well as for accounts.
3476: | Jianying Huang 16-DEC-00 Move common code to do_merge_contacts.
3477: | Jianying Huang 28-DEC-00 Since we ignore hz_org_contacts.party_site_id
3478: | in account merge context, we do not need select merge-to's
3479: | address id.
3480: |
3481: +===========================================================================*/

Line 3526: hz_org_contacts org,

3522: --as per discussion with Gautam Prothia, we ignore party_site_id in customer
3523: --merge context
3524: -- org.party_site_id
3525: FROM hz_cust_account_roles acct_role,
3526: hz_org_contacts org,
3527: hz_relationships rel,
3528: hz_cust_accounts acct
3529: WHERE acct_role.role_type = 'CONTACT'
3530: AND acct_role.cust_account_id = p_from_account_id

Line 3543: --party_site_id in hz_org_contacts is ignored in customer

3539: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */
3540:
3541: --select merge_from/to account site id.
3542: --we will no longer select merge-to address id because
3543: --party_site_id in hz_org_contacts is ignored in customer
3544: --merge context.
3545:
3546: CURSOR d IS
3547: SELECT DISTINCT duplicate_address_id --, customer_address_id

Line 3762: FROM hz_org_contacts

3758: SELECT party_id INTO x_org_party_id
3759: FROM hz_relationships
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;

Line 4318: FROM HZ_ORG_CONTACTS org

4314:
4315: CURSOR dupcheck IS
4316: SELECT
4317: MIN(ORG_CONTACT_ID)
4318: FROM HZ_ORG_CONTACTS org
4319: WHERE DEPARTMENT_CODE ||
4320: DEPARTMENT ||
4321: TITLE ||
4322: JOB_TITLE ||

Line 4341: FROM HZ_ORG_CONTACTS

4337: TO_CHAR(MANAGED_BY) ||
4338: REFERENCE_USE_FLAG ||
4339: RANK ||
4340: STATUS
4341: FROM HZ_ORG_CONTACTS
4342: WHERE ORG_CONTACT_ID = p_from_org_contact_id )
4343: AND EXISTS (
4344: SELECT 'same relationships'
4345: FROM HZ_RELATIONSHIPS rel

Line 5079: | Jianying Huang 27-NOV-00 Remove 'UPDATE hz_org_contacts ..'

5075: | MODIFICATION HISTORY
5076: | Jianying Huang 27-NOV-00 After call create_* API,
5077: | if return_status is not 'success', we need to
5078: | populate an exception.
5079: | Jianying Huang 27-NOV-00 Remove 'UPDATE hz_org_contacts ..'
5080: | and 'UPDATE hz_contact_points..' part. We should
5081: | not modify contacts data in party level. Instead,
5082: | we should migrate those data during merge process.
5083: | Jianying Huang 27-NOV-00 Added condition that we create profile amts