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 1157: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id

1153:
1154: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CUSTOMER_ID = temp.party_id
1155: )
1156:
1157: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1158: )
1159:
1160: or exists (select 'Y' from HZ_PARTY_SITES
1161: xx where xx.PARTY_ID = temp.party_id

Line 1164: (select 'Y' from AS_LEADS_ALL

1160: or exists (select 'Y' from HZ_PARTY_SITES
1161: xx where xx.PARTY_ID = temp.party_id
1162: and (nvl(STATUS, 'A') in ('A','I'))
1163: and exists
1164: (select 'Y' from AS_LEADS_ALL
1165: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1166: ))
1167:
1168: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id

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

1164: (select 'Y' from AS_LEADS_ALL
1165: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1166: ))
1167:
1168: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id
1169: )
1170:
1171: or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID = temp.party_id
1172: )

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

1167:
1168: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id
1169: )
1170:
1171: or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID = temp.party_id
1172: )
1173:
1174: or exists (select 'Y' from AS_LEAD_COMPETITORS xx where xx.COMPETITOR_ID = temp.party_id
1175: )

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

1472:
1473: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CUSTOMER_ID = temp.party_id
1474: )
1475:
1476: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1477: )
1478:
1479: or exists (select 'Y' from HZ_PARTY_SITES
1480: xx where xx.PARTY_ID = temp.party_id

Line 1483: (select 'Y' from AS_LEADS_ALL

1479: or exists (select 'Y' from HZ_PARTY_SITES
1480: xx where xx.PARTY_ID = temp.party_id
1481: and (nvl(STATUS, 'A') in ('A','I'))
1482: and exists
1483: (select 'Y' from AS_LEADS_ALL
1484: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1485: ))
1486:
1487: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id

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

1483: (select 'Y' from AS_LEADS_ALL
1484: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1485: ))
1486:
1487: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id
1488: )
1489:
1490: or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID = temp.party_id
1491: )

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

1486:
1487: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID = temp.party_id
1488: )
1489:
1490: or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID = temp.party_id
1491: )
1492:
1493: or exists (select 'Y' from AS_LEAD_COMPETITORS xx where xx.COMPETITOR_ID = temp.party_id
1494: )