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.RA_CUSTOMER_TEXT_PKG dependencies on HZ_PARTIES

Line 256: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNTS c

252:
253: FOR cust in (
254: SELECT cust_account_id, p.party_id,
255: party_name||' '||ACCOUNT_NUMBER||' '||tax_reference || ' ' data
256: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNTS c
257: WHERE p.party_id = c.party_id
258: AND c.cust_account_id = sites.cust_account_id)
259: LOOP
260: l_party_id := cust.party_id;

Line 274: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,

270:
271: FOR cont in (
272: SELECT rel.PARTY_ID rel_party_id,
273: p.PERSON_FIRST_NAME || ' ' || p.PERSON_LAST_NAME|| ' ' name
274: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,
275: APPS.HZ_RELATIONSHIPS rel
276: WHERE ar.cust_account_id = sites.cust_account_id
277: AND (ar.cust_acct_site_id is null)
278: AND ar.ROLE_TYPE = 'CONTACT'

Line 281: AND rel.subject_table_name = 'HZ_PARTIES'

277: AND (ar.cust_acct_site_id is null)
278: AND ar.ROLE_TYPE = 'CONTACT'
279: AND ar.party_id = rel.party_id
280: AND p.party_id = rel.subject_id
281: AND rel.subject_table_name = 'HZ_PARTIES'
282: AND rel.object_table_name = 'HZ_PARTIES'
283: AND rel.DIRECTIONAL_FLAG = 'F')
284: LOOP
285: write_to_lob(site_lob,cont.name,stvar);

Line 282: AND rel.object_table_name = 'HZ_PARTIES'

278: AND ar.ROLE_TYPE = 'CONTACT'
279: AND ar.party_id = rel.party_id
280: AND p.party_id = rel.subject_id
281: AND rel.subject_table_name = 'HZ_PARTIES'
282: AND rel.object_table_name = 'HZ_PARTIES'
283: AND rel.DIRECTIONAL_FLAG = 'F')
284: LOOP
285: write_to_lob(site_lob,cont.name,stvar);
286:

Line 291: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

287: FOR cp1 IN (
288: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
289: ' ' || EMAIL_ADDRESS || ' ' phone
290: FROM APPS.hz_contact_points
291: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
292: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
293: AND OWNER_TABLE_ID = cont.rel_party_id)
294: LOOP
295: write_to_lob(site_lob,cp1.phone,stvar);

Line 303: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

299: FOR cp1 IN (
300: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
301: ' ' || EMAIL_ADDRESS || ' ' phone
302: FROM APPS.hz_contact_points
303: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
304: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
305: AND OWNER_TABLE_ID = l_party_id)
306: LOOP
307: write_to_lob(site_lob,cp1.phone,stvar);

Line 313: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,

309:
310: FOR cont in (
311: SELECT rel.PARTY_ID rel_party_id,
312: p.PERSON_FIRST_NAME || ' ' || p.PERSON_LAST_NAME|| ' ' name
313: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,
314: APPS.HZ_RELATIONSHIPS rel
315: WHERE ar.cust_account_id = sites.cust_account_id
316: AND (ar.cust_acct_site_id = sites.cust_acct_site_id)
317: AND ar.ROLE_TYPE = 'CONTACT'

Line 320: AND rel.subject_table_name = 'HZ_PARTIES'

316: AND (ar.cust_acct_site_id = sites.cust_acct_site_id)
317: AND ar.ROLE_TYPE = 'CONTACT'
318: AND ar.party_id = rel.party_id
319: AND p.party_id = rel.subject_id
320: AND rel.subject_table_name = 'HZ_PARTIES'
321: AND rel.object_table_name = 'HZ_PARTIES'
322: AND rel.DIRECTIONAL_FLAG = 'F')
323: LOOP
324: write_to_lob(site_lob,cont.name,stvar);

Line 321: AND rel.object_table_name = 'HZ_PARTIES'

317: AND ar.ROLE_TYPE = 'CONTACT'
318: AND ar.party_id = rel.party_id
319: AND p.party_id = rel.subject_id
320: AND rel.subject_table_name = 'HZ_PARTIES'
321: AND rel.object_table_name = 'HZ_PARTIES'
322: AND rel.DIRECTIONAL_FLAG = 'F')
323: LOOP
324: write_to_lob(site_lob,cont.name,stvar);
325:

Line 330: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

326: FOR cp1 IN (
327: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
328: ' ' || EMAIL_ADDRESS || ' ' phone
329: FROM APPS.hz_contact_points
330: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
331: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
332: AND OWNER_TABLE_ID = cont.rel_party_id)
333: LOOP
334: write_to_lob(site_lob,cp1.phone,stvar);

Line 380: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNTS c

376:
377: FOR cust in (
378: SELECT cust_account_id, p.party_id,
379: party_name||' '||ACCOUNT_NUMBER||' '||tax_reference || ' ' data
380: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNTS c
381: WHERE p.party_id = c.party_id
382: AND c.cust_account_id = sites.cust_account_id)
383: LOOP
384: l_party_id := cust.party_id;

Line 400: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

396: FOR cp1 IN (
397: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
398: ' ' || EMAIL_ADDRESS || ' ' phone
399: FROM APPS.hz_contact_points
400: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
401: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
402: AND OWNER_TABLE_ID = l_party_id)
403: LOOP
404: write_to_char(cp1.phone,site_char);

Line 411: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,

407: /*
408: FOR cont in (
409: SELECT rel.PARTY_ID rel_party_id,
410: p.PERSON_FIRST_NAME || ' ' || p.PERSON_LAST_NAME|| ' ' name
411: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,
412: APPS.HZ_PARTY_RELATIONSHIPS rel
413: WHERE ar.cust_account_id = sites.cust_account_id
414: AND (ar.cust_acct_site_id = sites.cust_acct_site_id)
415: AND ar.ROLE_TYPE = 'CONTACT'

Line 425: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

421: FOR cp1 IN (
422: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
423: ' ' || EMAIL_ADDRESS || ' ' phone
424: FROM APPS.hz_contact_points
425: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
426: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
427: AND OWNER_TABLE_ID = cont.rel_party_id)
428: LOOP
429: write_to_char(cp1.phone,site_char);