DBA Data[Home] [Help]

APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_IMP_CONTACTPTS_SG

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