DBA Data[Home] [Help]

APPS.JTF_TASK_UWQ_PVT dependencies on JTF_TASK_PHONES

Line 38: , jtf_task_phones jtp

34: '('||hcp.phone_area_code||') '||
35: hcp.phone_number||
36: decode(hcp.phone_extension, NULL, NULL, ' <'||hcp.phone_extension||'>') phone_number
37: FROM jtf_task_contacts jtc
38: , jtf_task_phones jtp
39: , hz_contact_points hcp
40: WHERE jtc.task_id = b_task_id
41: AND jtc.primary_flag = 'Y'
42: AND jtp.task_contact_id = jtc.task_contact_id