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_SALES_CREDITS_DENORM

Line 1242: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

1238: (select 'Y' from AS_SALES_CREDITS
1239: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1240: ))
1241:
1242: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1243: )
1244:
1245: or exists (select 'Y' from HZ_PARTY_SITES
1246: xx where xx.PARTY_ID = temp.party_id

Line 1249: (select 'Y' from AS_SALES_CREDITS_DENORM

1245: or exists (select 'Y' from HZ_PARTY_SITES
1246: xx where xx.PARTY_ID = temp.party_id
1247: and (nvl(STATUS, 'A') in ('A','I'))
1248: and exists
1249: (select 'Y' from AS_SALES_CREDITS_DENORM
1250: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1251: ))
1252:
1253: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID = temp.party_id

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

1249: (select 'Y' from AS_SALES_CREDITS_DENORM
1250: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1251: ))
1252:
1253: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID = temp.party_id
1254: )
1255:
1256: or exists (select 'Y' from HZ_PARTY_SITES
1257: xx where xx.PARTY_ID = temp.party_id

Line 1260: (select 'Y' from AS_SALES_CREDITS_DENORM

1256: or exists (select 'Y' from HZ_PARTY_SITES
1257: xx where xx.PARTY_ID = temp.party_id
1258: and (nvl(STATUS, 'A') in ('A','I'))
1259: and exists
1260: (select 'Y' from AS_SALES_CREDITS_DENORM
1261: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1262: ))
1263:
1264: or exists (select 'Y' from HZ_CONTACT_POINTS

Line 1561: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

1557: (select 'Y' from AS_SALES_CREDITS
1558: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1559: ))
1560:
1561: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1562: )
1563:
1564: or exists (select 'Y' from HZ_PARTY_SITES
1565: xx where xx.PARTY_ID = temp.party_id

Line 1568: (select 'Y' from AS_SALES_CREDITS_DENORM

1564: or exists (select 'Y' from HZ_PARTY_SITES
1565: xx where xx.PARTY_ID = temp.party_id
1566: and (nvl(STATUS, 'A') in ('A','I'))
1567: and exists
1568: (select 'Y' from AS_SALES_CREDITS_DENORM
1569: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1570: ))
1571:
1572: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID = temp.party_id

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

1568: (select 'Y' from AS_SALES_CREDITS_DENORM
1569: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1570: ))
1571:
1572: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID = temp.party_id
1573: )
1574:
1575: or exists (select 'Y' from HZ_PARTY_SITES
1576: xx where xx.PARTY_ID = temp.party_id

Line 1579: (select 'Y' from AS_SALES_CREDITS_DENORM

1575: or exists (select 'Y' from HZ_PARTY_SITES
1576: xx where xx.PARTY_ID = temp.party_id
1577: and (nvl(STATUS, 'A') in ('A','I'))
1578: and exists
1579: (select 'Y' from AS_SALES_CREDITS_DENORM
1580: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1581: ))
1582:
1583: or exists (select 'Y' from HZ_CONTACT_POINTS

Line 3950: --AS_SALES_CREDITS_DENORM;CLOSE_COMPETITOR_ID

3946: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3947: temp.party_id in (select /*+ parallel(xx)*/ xx.INCUMBENT_PARTNER_PARTY_ID from AS_SALES_LEADS xx
3948: );
3949: end if;
3950: --AS_SALES_CREDITS_DENORM;CLOSE_COMPETITOR_ID
3951: appid:=279;
3952: if(regid_proc = true) then
3953: insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and
3954:

Line 3955: temp.party_id in (select /+ parallel(xx)/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx

3951: appid:=279;
3952: if(regid_proc = true) then
3953: insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and
3954:
3955: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx
3956: );
3957: else
3958: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3959: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx

Line 3959: temp.party_id in (select /+ parallel(xx)/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx

3955: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx
3956: );
3957: else
3958: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3959: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx
3960: );
3961: end if;
3962: --AS_LEADS_LOG;CUSTOMER_ID
3963: appid:=279;