[Home] [Help]
2403: FOR UPDATE NOWAIT;
2404: ----Bug No: 5067291
2405: CURSOR c3 is
2406: SELECT yt.party_id
2407: FROM HZ_CUST_ACCOUNT_ROLES yt,ra_customer_merges m,HZ_CUST_ACCOUNTS ca,hz_relationships rel
2408: WHERE m.customer_id=ca.cust_account_id
2409: AND m.duplicate_id = yt.cust_account_id
2410: AND rel.party_id = yt.party_id
2411: AND rel.subject_type = 'PERSON'
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
3064: AND acct_role.cust_acct_site_id IS NULL
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
3223: AND acct_role.cust_acct_site_id = from_site_id
3447: END IF;
3448:
3449: IF l_dup_exists = FND_API.G_TRUE THEN
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 )
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
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'
4043: AND TO_CHAR(SUBJECT_ID) ||
4044: RELATIONSHIP_CODE = (
4045: SELECT TO_CHAR(SUBJECT_ID) ||
4046: RELATIONSHIP_CODE
4047: FROM HZ_RELATIONSHIPS,HZ_CUST_ACCOUNTS ACCT
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