APPS.HZ_MERGE_ENTITY_ATTRI_PVT dependencies on HZ_PARTIES

Line 832: from hz_parties

828: l_automerge_flag varchar2(1);
829:
830: cursor get_obj_version_csr is
831: select object_version_number,orig_system_reference
832: from hz_parties
833: where party_id = p_merge_to_party_id;
834:
835: cursor get_attri_party_csr is
836: select attribute_party_id

Line 1467: ' from HZ_ORGANIZATION_PROFILES OP,HZ_PARTIES PARTY, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB '||

1463: then
1464: l_str := 'select party_id, decode('''||l_col_type||''',''D'',to_char(attri_value,''YYYY/MM/DD''),attri_value) from '||
1465: '(SELECT party_id, attri_value, rank() over (order by cntAttri desc) rank, '||l_date_clause || ' from '||
1466: '(SELECT OP.PARTY_ID, OP.'||l_col_name||' attri_value, count(*) over (partition by OP.'||l_col_name||') as cntAttri, '||'op.'||l_date_clause||
1467: ' from HZ_ORGANIZATION_PROFILES OP,HZ_PARTIES PARTY, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB '||
1468: 'WHERE OP.PARTY_ID =DSP.DUP_PARTY_ID AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID '||
1469: 'AND DS.DUP_SET_ID = DSP.DUP_SET_ID AND OP.PARTY_ID = PARTY.PARTY_ID '||
1470: 'AND sysdate between effective_start_date and nvl(effective_end_date,sysdate) '||
1471: 'AND OP.'||l_col_name||' is not null '||

Line 1481: ' from HZ_PERSON_PROFILES OP,HZ_PARTIES PARTY, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB '||

1477: else -- PERSON CASE
1478: l_str := 'select party_id, decode('''||l_col_type||''',''D'',to_char(attri_value,''YYYY/MM/DD''),attri_value) from '||
1479: '(SELECT party_id, attri_value, rank() over (order by cntAttri desc) rank, '||l_date_clause || ' from '||
1480: '(SELECT OP.PARTY_ID, OP.'||l_col_name||' attri_value, count(*) over (partition by OP.'||l_col_name||') as cntAttri, '||'op.'||l_date_clause||
1481: ' from HZ_PERSON_PROFILES OP,HZ_PARTIES PARTY, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB '||
1482: 'WHERE OP.PARTY_ID =DSP.DUP_PARTY_ID AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID '||
1483: 'AND DS.DUP_SET_ID = DSP.DUP_SET_ID AND OP.PARTY_ID = PARTY.PARTY_ID '||
1484: 'AND sysdate between effective_start_date and nvl(effective_end_date,sysdate) '||
1485: 'AND OP.'||l_col_name||' is not null '||

Line 1571: from hz_parties pro, hz_dup_set_parties mp

1567: select party_id
1568: from(
1569: select pro.party_id party_id,
1570: RANK() OVER (ORDER BY pro.last_update_date desc ) rank
1571: from hz_parties pro, hz_dup_set_parties mp
1572: where pro.party_id = mp.dup_party_id
1573: and mp.dup_set_id = p_merge_batch_id)
1574: where rank = 1 and rownum=1;
1575:

Line 1582: from hz_parties pro, hz_dup_set_parties mp

1578: select party_id
1579: from(
1580: select pro.party_id party_id,
1581: RANK() OVER (ORDER BY pro.creation_date desc, pro.party_id desc ) rank
1582: from hz_parties pro, hz_dup_set_parties mp
1583: where pro.party_id = mp.dup_party_id
1584: and mp.dup_set_id = p_merge_batch_id)
1585: where rank = 1;
1586:

Line 1595: from hz_parties pro, hz_dup_set_parties mp

1591: select party_id
1592: from(
1593: select pro.party_id party_id,
1594: RANK() OVER (ORDER BY pro.creation_date, pro.party_id ) rank
1595: from hz_parties pro, hz_dup_set_parties mp
1596: where pro.party_id = mp.dup_party_id
1597: and mp.dup_set_id = p_merge_batch_id)
1598: where rank = 1;
1599: