eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_DNBUI_PVT dependencies on HZ_CONTACT_POINTS

Line 160: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_CONTACT_POINTS to

156: |
157: | RETURNS : NONE
158: |
159: | MODIFICATION HISTORY
160: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_CONTACT_POINTS to
161: | HZ_CONTACT_POINTS_R1
162: | 30-OCT-00 Jianying Huang Roll back the renaming table changes.
163: |
164: +======================================================================*/

Line 161: | HZ_CONTACT_POINTS_R1

Line 171: l_phone_number HZ_CONTACT_POINTS.raw_phone_number%TYPE;

167: p_party_id IN NUMBER,
168: p_source_type IN VARCHAR2)
169: RETURN VARCHAR2 IS
170:
171: l_phone_number HZ_CONTACT_POINTS.raw_phone_number%TYPE;
172: cursor primary_phone is
173: SELECT cp.raw_phone_number
174: FROM HZ_CONTACT_POINTS cp
175: WHERE cp.owner_table_id = p_party_id

Line 174: FROM HZ_CONTACT_POINTS cp

170:
171: l_phone_number HZ_CONTACT_POINTS.raw_phone_number%TYPE;
172: cursor primary_phone is
173: SELECT cp.raw_phone_number
174: FROM HZ_CONTACT_POINTS cp
175: WHERE cp.owner_table_id = p_party_id
176: AND cp.owner_table_name = 'HZ_PARTIES'
177: AND cp.actual_content_source = p_source_type
178: AND cp.CONTACT_POINT_TYPE = 'PHONE'

Line 185: FROM HZ_CONTACT_POINTS cp

181: AND cp.phone_line_type <> 'FAX';
182:
183: cursor all_phones is
184: SELECT cp.raw_phone_number
185: FROM HZ_CONTACT_POINTS cp
186: WHERE cp.owner_table_id = p_party_id
187: AND cp.owner_table_name = 'HZ_PARTIES'
188: AND cp.actual_content_source = p_source_type
189: AND cp.CONTACT_POINT_TYPE = 'PHONE'

Line 225: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_CONTACT_POINTS to

221: |
222: | RETURNS : NONE
223: |
224: | MODIFICATION HISTORY
225: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_CONTACT_POINTS to
226: | HZ_CONTACT_POINTS_R1
227: | 30-OCT-00 Jianying Huang Roll back the renaming table changes.
228: |
229: +======================================================================*/

Line 226: | HZ_CONTACT_POINTS_R1

Line 235: l_fax_number HZ_CONTACT_POINTS.raw_phone_number%TYPE;

231: function get_primary_fax_number(
232: p_party_id IN NUMBER,
233: p_source_type IN VARCHAR2)
234: RETURN VARCHAR2 IS
235: l_fax_number HZ_CONTACT_POINTS.raw_phone_number%TYPE;
236: cursor primary_phone is
237: SELECT cp.raw_phone_number
238: FROM HZ_CONTACT_POINTS cp
239: WHERE cp.owner_table_id = p_party_id

Line 238: FROM HZ_CONTACT_POINTS cp

234: RETURN VARCHAR2 IS
235: l_fax_number HZ_CONTACT_POINTS.raw_phone_number%TYPE;
236: cursor primary_phone is
237: SELECT cp.raw_phone_number
238: FROM HZ_CONTACT_POINTS cp
239: WHERE cp.owner_table_id = p_party_id
240: AND cp.owner_table_name = 'HZ_PARTIES'
241: AND cp.actual_content_source = p_source_type
242: AND cp.CONTACT_POINT_TYPE = 'PHONE'

Line 249: FROM HZ_CONTACT_POINTS cp

245: AND cp.phone_line_type = 'FAX';
246:
247: cursor all_phones is
248: SELECT cp.raw_phone_number
249: FROM HZ_CONTACT_POINTS cp
250: WHERE cp.owner_table_id = p_party_id
251: AND cp.owner_table_name = 'HZ_PARTIES'
252: AND cp.actual_content_source = p_source_type
253: AND cp.CONTACT_POINT_TYPE = 'PHONE'

Line 290: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_CONTACT_POINTS to

286: |
287: | RETURNS : NONE
288: |
289: | MODIFICATION HISTORY
290: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_CONTACT_POINTS to
291: | HZ_CONTACT_POINTS_R1
292: | 30-OCT-00 Jianying Huang Roll back the renaming table changes.
293: |
294: +======================================================================*/

Line 291: | HZ_CONTACT_POINTS_R1

Line 303: FROM HZ_CONTACT_POINTS cp

299: RETURN VARCHAR2 IS
300:
301: CURSOR c_phone_number IS
302: SELECT cp.raw_phone_number
303: FROM HZ_CONTACT_POINTS cp
304: WHERE cp.owner_table_id = p_party_id
305: AND cp.owner_table_name = 'HZ_PARTIES'
306: AND cp.actual_content_source = p_source_type
307: AND cp.status = 'A'