DBA Data[Home] [Help]

APPS.JTF_NOTES_MERGE_PKG dependencies on JTF_OBJECT_USAGES

Line 78: , jtf_object_usages oue

74: , last_updated_by = hz_utility_pub.user_id
75: , last_update_login = hz_utility_pub.last_update_login
76: WHERE source_object_code IN (SELECT ojt.object_code
77: FROM jtf_objects_b ojt
78: , jtf_object_usages oue
79: WHERE ojt.object_code = oue.object_code
80: AND oue.object_user_code = 'NOTES'
81: AND ojt.from_table ='HZ_PARTIES'
82: )

Line 96: , jtf_object_usages oue

92: , last_updated_by = hz_utility_pub.user_id
93: , last_update_login = hz_utility_pub.last_update_login
94: WHERE source_object_code IN (SELECT ojt.object_code
95: FROM jtf_objects_b ojt
96: , jtf_object_usages oue
97: WHERE ojt.object_code = oue.object_code
98: AND oue.object_user_code = 'NOTES'
99: AND ojt.from_table ='HZ_PARTY_SITES'
100: )

Line 194: , jtf_object_usages oue

190: , last_updated_by = hz_utility_pub.user_id
191: , last_update_login = hz_utility_pub.last_update_login
192: WHERE note_context_type IN (SELECT ojt.object_code
193: FROM jtf_objects_b ojt
194: , jtf_object_usages oue
195: WHERE ojt.object_code = oue.object_code
196: AND oue.object_user_code = 'NOTES'
197: AND ojt.from_table ='HZ_PARTIES'
198: )

Line 212: , jtf_object_usages oue

208: , last_updated_by = hz_utility_pub.user_id
209: , last_update_login = hz_utility_pub.last_update_login
210: WHERE note_context_type IN (SELECT ojt.object_code
211: FROM jtf_objects_b ojt
212: , jtf_object_usages oue
213: WHERE ojt.object_code = oue.object_code
214: AND oue.object_user_code = 'NOTES'
215: AND ojt.from_table ='HZ_PARTY_SITES'
216: )