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_PURGE_GEN dependencies on HZ_CONTACT_POINTS

Line 1158: or exists (select 'Y' from HZ_CONTACT_POINTS

1154: (select 'Y' from AS_SALES_LEAD_CONTACTS
1155: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1156: ))
1157:
1158: or exists (select 'Y' from HZ_CONTACT_POINTS
1159: xx where xx.OWNER_TABLE_ID = temp.party_id
1160: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1161: and exists
1162: (select 'Y' from AS_SALES_LEAD_CONTACTS

Line 1169: (select 'Y' from HZ_CONTACT_POINTS

1165: or exists (select 'Y' from HZ_PARTY_SITES
1166: xx where xx.PARTY_ID = temp.party_id
1167: and (nvl(STATUS, 'A') in ('A','I'))
1168: and exists
1169: (select 'Y' from HZ_CONTACT_POINTS
1170: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1171: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1172: and exists
1173: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

Line 1367: or exists (select 'Y' from HZ_CONTACT_POINTS

1363: (select 'Y' from AS_SALES_CREDITS_DENORM
1364: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1365: ))
1366:
1367: or exists (select 'Y' from HZ_CONTACT_POINTS
1368: xx where xx.OWNER_TABLE_ID = temp.party_id
1369: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1370: and exists
1371: (select 'Y' from AS_LEAD_CONTACTS_ALL

Line 1378: (select 'Y' from HZ_CONTACT_POINTS

1374: or exists (select 'Y' from HZ_PARTY_SITES
1375: xx where xx.PARTY_ID = temp.party_id
1376: and (nvl(STATUS, 'A') in ('A','I'))
1377: and exists
1378: (select 'Y' from HZ_CONTACT_POINTS
1379: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1380: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1381: and exists
1382: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

Line 1446: or exists (select 'Y' from HZ_CONTACT_POINTS

1442:
1443: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CNT_PERSON_PARTY_ID = temp.party_id
1444: )
1445:
1446: or exists (select 'Y' from HZ_CONTACT_POINTS
1447: xx where xx.OWNER_TABLE_ID = temp.party_id
1448: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1449: and exists
1450: (select 'Y' from AS_SALES_LEADS

Line 1457: (select 'Y' from HZ_CONTACT_POINTS

1453: or exists (select 'Y' from HZ_PARTY_SITES
1454: xx where xx.PARTY_ID = temp.party_id
1455: and (nvl(STATUS, 'A') in ('A','I'))
1456: and exists
1457: (select 'Y' from HZ_CONTACT_POINTS
1458: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1459: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1460: and exists
1461: (select 'Y' from AS_SALES_LEADS zz where zz.PRIMARY_CONTACT_PHONE_ID = yy.CONTACT_POINT_ID )))

Line 1477: or exists (select 'Y' from HZ_CONTACT_POINTS

1473: (select 'Y' from AS_SALES_LEAD_CONTACTS
1474: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1475: ))
1476:
1477: or exists (select 'Y' from HZ_CONTACT_POINTS
1478: xx where xx.OWNER_TABLE_ID = temp.party_id
1479: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1480: and exists
1481: (select 'Y' from AS_SALES_LEAD_CONTACTS

Line 1488: (select 'Y' from HZ_CONTACT_POINTS

1484: or exists (select 'Y' from HZ_PARTY_SITES
1485: xx where xx.PARTY_ID = temp.party_id
1486: and (nvl(STATUS, 'A') in ('A','I'))
1487: and exists
1488: (select 'Y' from HZ_CONTACT_POINTS
1489: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1490: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1491: and exists
1492: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

Line 1686: or exists (select 'Y' from HZ_CONTACT_POINTS

1682: (select 'Y' from AS_SALES_CREDITS_DENORM
1683: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1684: ))
1685:
1686: or exists (select 'Y' from HZ_CONTACT_POINTS
1687: xx where xx.OWNER_TABLE_ID = temp.party_id
1688: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1689: and exists
1690: (select 'Y' from AS_LEAD_CONTACTS_ALL

Line 1697: (select 'Y' from HZ_CONTACT_POINTS

1693: or exists (select 'Y' from HZ_PARTY_SITES
1694: xx where xx.PARTY_ID = temp.party_id
1695: and (nvl(STATUS, 'A') in ('A','I'))
1696: and exists
1697: (select 'Y' from HZ_CONTACT_POINTS
1698: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1699: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1700: and exists
1701: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

Line 1765: or exists (select 'Y' from HZ_CONTACT_POINTS

1761:
1762: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CNT_PERSON_PARTY_ID = temp.party_id
1763: )
1764:
1765: or exists (select 'Y' from HZ_CONTACT_POINTS
1766: xx where xx.OWNER_TABLE_ID = temp.party_id
1767: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1768: and exists
1769: (select 'Y' from AS_SALES_LEADS

Line 1776: (select 'Y' from HZ_CONTACT_POINTS

1772: or exists (select 'Y' from HZ_PARTY_SITES
1773: xx where xx.PARTY_ID = temp.party_id
1774: and (nvl(STATUS, 'A') in ('A','I'))
1775: and exists
1776: (select 'Y' from HZ_CONTACT_POINTS
1777: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1778: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1779: and exists
1780: (select 'Y' from AS_SALES_LEADS zz where zz.PRIMARY_CONTACT_PHONE_ID = yy.CONTACT_POINT_ID )))

Line 2010: or exists (select 'Y' from HZ_CONTACT_POINTS

2006:
2007: or exists (select 'Y' from OKL_TXL_RCPT_APPS_B xx where xx.ILE_ID = temp.party_id
2008: )
2009:
2010: or exists (select 'Y' from HZ_CONTACT_POINTS
2011: xx where xx.OWNER_TABLE_ID = temp.party_id
2012: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2013: and exists
2014: (select 'Y' from OKL_RELOCATE_ASSETS_B

Line 2021: (select 'Y' from HZ_CONTACT_POINTS

2017: or exists (select 'Y' from HZ_PARTY_SITES
2018: xx where xx.PARTY_ID = temp.party_id
2019: and (nvl(STATUS, 'A') in ('A','I'))
2020: and exists
2021: (select 'Y' from HZ_CONTACT_POINTS
2022: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2023: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2024: and exists
2025: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));

Line 2059: or exists (select 'Y' from HZ_CONTACT_POINTS

2055:
2056: or exists (select 'Y' from OKL_TXL_RCPT_APPS_B xx where xx.ILE_ID = temp.party_id
2057: )
2058:
2059: or exists (select 'Y' from HZ_CONTACT_POINTS
2060: xx where xx.OWNER_TABLE_ID = temp.party_id
2061: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2062: and exists
2063: (select 'Y' from OKL_RELOCATE_ASSETS_B

Line 2070: (select 'Y' from HZ_CONTACT_POINTS

2066: or exists (select 'Y' from HZ_PARTY_SITES
2067: xx where xx.PARTY_ID = temp.party_id
2068: and (nvl(STATUS, 'A') in ('A','I'))
2069: and exists
2070: (select 'Y' from HZ_CONTACT_POINTS
2071: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2072: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2073: and exists
2074: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));

Line 2327: or exists (select 'Y' from HZ_CONTACT_POINTS

2323: (select 'Y' from JTF_TASK_AUDITS_B
2324: yy where yy.OLD_ADDRESS_ID=xx.PARTY_SITE_ID
2325: ))
2326:
2327: or exists (select 'Y' from HZ_CONTACT_POINTS
2328: xx where xx.OWNER_TABLE_ID = temp.party_id
2329: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2330: and exists
2331: (select 'Y' from JTF_TASK_PHONES

Line 2338: (select 'Y' from HZ_CONTACT_POINTS

2334: or exists (select 'Y' from HZ_PARTY_SITES
2335: xx where xx.PARTY_ID = temp.party_id
2336: and (nvl(STATUS, 'A') in ('A','I'))
2337: and exists
2338: (select 'Y' from HZ_CONTACT_POINTS
2339: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2340: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2341: and exists
2342: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

Line 2513: or exists (select 'Y' from HZ_CONTACT_POINTS

2509: (select 'Y' from JTF_TASK_AUDITS_B
2510: yy where yy.OLD_ADDRESS_ID=xx.PARTY_SITE_ID
2511: ))
2512:
2513: or exists (select 'Y' from HZ_CONTACT_POINTS
2514: xx where xx.OWNER_TABLE_ID = temp.party_id
2515: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2516: and exists
2517: (select 'Y' from JTF_TASK_PHONES

Line 2524: (select 'Y' from HZ_CONTACT_POINTS

2520: or exists (select 'Y' from HZ_PARTY_SITES
2521: xx where xx.PARTY_ID = temp.party_id
2522: and (nvl(STATUS, 'A') in ('A','I'))
2523: and exists
2524: (select 'Y' from HZ_CONTACT_POINTS
2525: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2526: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2527: and exists
2528: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))