APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_CONTACT_POINTS

Line 1799: FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp

1795: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
1796: ,cp.PHONE_LINE_TYPE
1797: ,cp.STATUS
1798: ,cp.CONTACT_POINT_PURPOSE
1799: FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp
1800: WHERE cp.owner_table_id = g.owner_id
1801: AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,'HZ_PARTIES')
1802: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I');
1803:

Line 1964: FROM HZ_CONTACT_POINTS cp, HZ_DQM_SYNC_INTERFACE d

1960: , H_TX10(1)
1961: , H_TX11(1)
1962: , H_TX12(1)
1963: , H_TX13(1)
1964: FROM HZ_CONTACT_POINTS cp, HZ_DQM_SYNC_INTERFACE d
1965: WHERE d.ENTITY = 'CONTACT_POINTS'
1966: AND cp.contact_point_id = p_contact_point_id
1967: AND cp.contact_point_id = d.RECORD_ID
1968: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I') and rownum = 1 ;

Line 2111: FROM hz_contact_points

2107: l_org_contact_id := -1;
2108: l_party_site_id := -1;
2109:
2110: SELECT owner_table_name,owner_table_id INTO l_ot_table, l_ot_id
2111: FROM hz_contact_points
2112: WHERE contact_point_id = p_contact_point_id;
2113:
2114: IF l_ot_table = 'HZ_PARTY_SITES' THEN
2115: SELECT p.party_id, ps.party_site_id, party_type

Line 2188: FROM HZ_CONTACT_POINTS cp

2184: ,H_TX10(1)
2185: ,H_TX11(1)
2186: ,H_TX12(1)
2187: ,H_TX13(1)
2188: FROM HZ_CONTACT_POINTS cp
2189: WHERE
2190: cp.contact_point_id = p_contact_point_id
2191: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I') and rownum = 1 ;
2192:

Line 3994: FROM HZ_DQM_SYNC_INTERFACE dsi,HZ_CONTACT_POINTS cp

3990: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
3991: ,cp.PHONE_LINE_TYPE
3992: ,cp.STATUS
3993: ,cp.CONTACT_POINT_PURPOSE
3994: FROM HZ_DQM_SYNC_INTERFACE dsi,HZ_CONTACT_POINTS cp
3995: WHERE dsi.record_id = cp.contact_point_id
3996: AND dsi.entity = 'CONTACT_POINTS'
3997: AND dsi.operation = p_operation
3998: AND dsi.staged_flag = 'N'

Line 4535: FROM hz_contact_points cp, hz_imp_contactpts_sg cps, hz_imp_batch_details bd

4531: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
4532: ,cp.PHONE_LINE_TYPE
4533: ,cp.STATUS
4534: ,cp.CONTACT_POINT_PURPOSE
4535: FROM hz_contact_points cp, hz_imp_contactpts_sg cps, hz_imp_batch_details bd
4536: WHERE cp.request_id = bd.main_conc_req_id
4537: AND bd.batch_id = cps.batch_id
4538: AND cp.contact_point_id = cps.contact_point_id
4539: AND cps.batch_id = p_batch_id