APPS.ARP_CMERGE_ARCUS dependencies on HZ_ORG_CONTACTS

Line 3059: hz_org_contacts org,

3055: rel.relationship_id,
3056: -- FOR ORG-CONTACT REC
3057: org.org_contact_id
3058: FROM hz_cust_account_roles acct_role,
3059: hz_org_contacts org,
3060: hz_relationships rel,
3061: hz_cust_accounts acct
3062: WHERE acct_role.role_type = 'CONTACT'
3063: AND acct_role.cust_account_id = p_from_account_id

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

3165: | as customer contact points, we'd better to migrate
3166: | it here because it should be a phone number for
3167: | contacts as well as for accounts.
3168: | Jianying Huang 16-DEC-00 Move common code to do_merge_contacts.
3169: | Jianying Huang 28-DEC-00 Since we ignore hz_org_contacts.party_site_id
3170: | in account merge context, we do not need select merge-to's
3171: | address id.
3172: |
3173: +===========================================================================*/

Line 3218: hz_org_contacts org,

3214: --as per discussion with Gautam Prothia, we ignore party_site_id in customer
3215: --merge context
3216: -- org.party_site_id
3217: FROM hz_cust_account_roles acct_role,
3218: hz_org_contacts org,
3219: hz_relationships rel,
3220: hz_cust_accounts acct
3221: WHERE acct_role.role_type = 'CONTACT'
3222: AND acct_role.cust_account_id = p_from_account_id

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

3231: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */
3232:
3233: --select merge_from/to account site id.
3234: --we will no longer select merge-to address id because
3235: --party_site_id in hz_org_contacts is ignored in customer
3236: --merge context.
3237:
3238: CURSOR d IS
3239: SELECT DISTINCT duplicate_address_id --, customer_address_id

Line 3454: FROM hz_org_contacts

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

Line 4010: FROM HZ_ORG_CONTACTS org

4006:
4007: CURSOR dupcheck IS
4008: SELECT
4009: MIN(ORG_CONTACT_ID)
4010: FROM HZ_ORG_CONTACTS org
4011: WHERE DEPARTMENT_CODE ||
4012: DEPARTMENT ||
4013: TITLE ||
4014: JOB_TITLE ||

Line 4033: FROM HZ_ORG_CONTACTS

4029: TO_CHAR(MANAGED_BY) ||
4030: REFERENCE_USE_FLAG ||
4031: RANK ||
4032: STATUS
4033: FROM HZ_ORG_CONTACTS
4034: WHERE ORG_CONTACT_ID = p_from_org_contact_id )
4035: AND EXISTS (
4036: SELECT 'same relationships'
4037: FROM HZ_RELATIONSHIPS rel

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

4765: | MODIFICATION HISTORY
4766: | Jianying Huang 27-NOV-00 After call create_* API,
4767: | if return_status is not 'success', we need to
4768: | populate an exception.
4769: | Jianying Huang 27-NOV-00 Remove 'UPDATE hz_org_contacts ..'
4770: | and 'UPDATE hz_contact_points..' part. We should
4771: | not modify contacts data in party level. Instead,
4772: | we should migrate those data during merge process.
4773: | Jianying Huang 27-NOV-00 Added condition that we create profile amts