APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_CONTACT_POINTS

Line 1825: FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp

1821: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
1822: ,cp.PHONE_LINE_TYPE
1823: ,cp.STATUS
1824: ,cp.CONTACT_POINT_PURPOSE
1825: FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp
1826: WHERE cp.owner_table_id = g.owner_id
1827: AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,'HZ_PARTIES')
1828: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I');
1829:

Line 1990: FROM HZ_CONTACT_POINTS cp, HZ_DQM_SYNC_INTERFACE d

1986: , H_TX10(1)
1987: , H_TX11(1)
1988: , H_TX12(1)
1989: , H_TX13(1)
1990: FROM HZ_CONTACT_POINTS cp, HZ_DQM_SYNC_INTERFACE d
1991: WHERE d.ENTITY = 'CONTACT_POINTS'
1992: AND cp.contact_point_id = p_contact_point_id
1993: AND cp.contact_point_id = d.RECORD_ID
1994: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I') and rownum = 1 ;

Line 2137: FROM hz_contact_points

2133: l_org_contact_id := -1;
2134: l_party_site_id := -1;
2135:
2136: SELECT owner_table_name,owner_table_id INTO l_ot_table, l_ot_id
2137: FROM hz_contact_points
2138: WHERE contact_point_id = p_contact_point_id;
2139:
2140: IF l_ot_table = 'HZ_PARTY_SITES' THEN
2141: SELECT p.party_id, ps.party_site_id, party_type

Line 2214: FROM HZ_CONTACT_POINTS cp

2210: ,H_TX10(1)
2211: ,H_TX11(1)
2212: ,H_TX12(1)
2213: ,H_TX13(1)
2214: FROM HZ_CONTACT_POINTS cp
2215: WHERE
2216: cp.contact_point_id = p_contact_point_id
2217: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I') and rownum = 1 ;
2218:

Line 4020: FROM HZ_DQM_SYNC_INTERFACE dsi,HZ_CONTACT_POINTS cp

4016: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
4017: ,cp.PHONE_LINE_TYPE
4018: ,cp.STATUS
4019: ,cp.CONTACT_POINT_PURPOSE
4020: FROM HZ_DQM_SYNC_INTERFACE dsi,HZ_CONTACT_POINTS cp
4021: WHERE dsi.record_id = cp.contact_point_id
4022: AND dsi.entity = 'CONTACT_POINTS'
4023: AND dsi.operation = p_operation
4024: AND dsi.staged_flag = 'N'

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

4557: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
4558: ,cp.PHONE_LINE_TYPE
4559: ,cp.STATUS
4560: ,cp.CONTACT_POINT_PURPOSE
4561: FROM hz_contact_points cp, hz_imp_contactpts_sg cps, hz_imp_batch_details bd
4562: WHERE cp.request_id = bd.main_conc_req_id
4563: AND bd.batch_id = cps.batch_id
4564: AND cp.contact_point_id = cps.contact_point_id
4565: AND cps.batch_id = p_batch_id