APPS.JTF_TASK_UWQ_PVT dependencies on JTF_TASK_CONTACTS

Line 37: FROM jtf_task_contacts jtc

33: SELECT decode(hcp.phone_country_code, NULL, NULL, '+'||hcp.phone_country_code||' ')||
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'

Line 43: AND jtp.owner_table_name = 'JTF_TASK_CONTACTS'

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
43: AND jtp.owner_table_name = 'JTF_TASK_CONTACTS'
44: AND jtp.primary_flag = 'Y'
45: AND hcp.contact_point_id = jtp.phone_id
46: AND hcp.contact_point_type = 'PHONE';
47:

Line 51: -- The phone must be retrieved from relationship party_id (= jtf_task_contacts.contact_id)

47:
48: -- Fixed bug 2467845:
49: -- Removed the hz_relationships from FROM clause
50: -- not to get the phone from subject_id.
51: -- The phone must be retrieved from relationship party_id (= jtf_task_contacts.contact_id)
52: CURSOR c_phone_hz (b_task_id NUMBER) IS
53: SELECT decode(hcp.phone_country_code, NULL, NULL, '+'||hcp.phone_country_code||' ')||
54: '('||hcp.phone_area_code||') '||
55: hcp.phone_number||

Line 57: FROM jtf_task_contacts jtc

53: SELECT decode(hcp.phone_country_code, NULL, NULL, '+'||hcp.phone_country_code||' ')||
54: '('||hcp.phone_area_code||') '||
55: hcp.phone_number||
56: decode(hcp.phone_extension, NULL, NULL, ' <'||hcp.phone_extension||'>') phone_number
57: FROM jtf_task_contacts jtc
58: , hz_contact_points hcp
59: WHERE jtc.task_id = b_task_id
60: AND jtc.primary_flag = 'Y'
61: AND hcp.owner_table_id = jtc.contact_id

Line 88: FROM jtf_task_contacts jtc

84: RETURN VARCHAR2
85: IS
86: CURSOR c_email (b_task_id NUMBER) IS
87: SELECT hcp.email_address
88: FROM jtf_task_contacts jtc
89: , hz_contact_points hcp
90: WHERE jtc.task_id = b_task_id
91: AND jtc.primary_flag = 'Y'
92: AND hcp.owner_table_id = jtc.contact_id