DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on JTF_PARTY_ALL_CONTACTS_V

Line 4233: , jtf_party_all_contacts_v pc

4229: , pc.person_first_name first_name
4230: , pc.person_title title
4231: , tp.phone_id
4232: FROM jtf_task_contacts tc
4233: , jtf_party_all_contacts_v pc
4234: , jtf_task_phones_v tp
4235: WHERE tc.task_id = p_task_id
4236: AND tc.contact_id IN (pc.party_id, pc.subject_party_id)
4237: AND tp.task_contact_id (+) = tc.task_contact_id;