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 AS_LEADS_ALL

Line 1260: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id

1256:
1257: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CUSTOMER_ID = temp.party_id
1258: )
1259:
1260: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1261: )
1262:
1263: or exists (select 'Y' from HZ_PARTY_SITES
1264: xx where xx.PARTY_ID = temp.party_id

Line 1267: (select 'Y' from AS_LEADS_ALL

1263: or exists (select 'Y' from HZ_PARTY_SITES
1264: xx where xx.PARTY_ID = temp.party_id
1265: and (nvl(STATUS, 'A') in ('A','I'))
1266: and exists
1267: (select 'Y' from AS_LEADS_ALL
1268: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1269: ))
1270:
1271: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id

Line 1271: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id

1267: (select 'Y' from AS_LEADS_ALL
1268: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1269: ))
1270:
1271: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id
1272: )
1273:
1274: or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID = temp.party_id
1275: )

Line 1274: or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID = temp.party_id

1270:
1271: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id
1272: )
1273:
1274: or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID = temp.party_id
1275: )
1276:
1277: or exists (select 'Y' from AS_LEAD_COMPETITORS xx where xx.COMPETITOR_ID = temp.party_id
1278: )

Line 1579: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id

1575:
1576: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CUSTOMER_ID = temp.party_id
1577: )
1578:
1579: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1580: )
1581:
1582: or exists (select 'Y' from HZ_PARTY_SITES
1583: xx where xx.PARTY_ID = temp.party_id

Line 1586: (select 'Y' from AS_LEADS_ALL

1582: or exists (select 'Y' from HZ_PARTY_SITES
1583: xx where xx.PARTY_ID = temp.party_id
1584: and (nvl(STATUS, 'A') in ('A','I'))
1585: and exists
1586: (select 'Y' from AS_LEADS_ALL
1587: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1588: ))
1589:
1590: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id

Line 1590: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id

1586: (select 'Y' from AS_LEADS_ALL
1587: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1588: ))
1589:
1590: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id
1591: )
1592:
1593: or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID = temp.party_id
1594: )

Line 1593: or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID = temp.party_id

1589:
1590: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id
1591: )
1592:
1593: or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID = temp.party_id
1594: )
1595:
1596: or exists (select 'Y' from AS_LEAD_COMPETITORS xx where xx.COMPETITOR_ID = temp.party_id
1597: )