APPS.HZ_PURGE_GEN dependencies on AS_SALES_CREDITS_DENORM

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

1341: (select 'Y' from AS_SALES_CREDITS
1342: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1343: ))
1344:
1345: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1346: )
1347:
1348: or exists (select 'Y' from HZ_PARTY_SITES
1349: xx where xx.PARTY_ID = temp.party_id

Line 1352: (select 'Y' from AS_SALES_CREDITS_DENORM

1348: or exists (select 'Y' from HZ_PARTY_SITES
1349: xx where xx.PARTY_ID = temp.party_id
1350: and (nvl(STATUS, 'A') in ('A','I'))
1351: and exists
1352: (select 'Y' from AS_SALES_CREDITS_DENORM
1353: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1354: ))
1355:
1356: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID = temp.party_id

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

1352: (select 'Y' from AS_SALES_CREDITS_DENORM
1353: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1354: ))
1355:
1356: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID = temp.party_id
1357: )
1358:
1359: or exists (select 'Y' from HZ_PARTY_SITES
1360: xx where xx.PARTY_ID = temp.party_id

Line 1363: (select 'Y' from AS_SALES_CREDITS_DENORM

1359: or exists (select 'Y' from HZ_PARTY_SITES
1360: xx where xx.PARTY_ID = temp.party_id
1361: and (nvl(STATUS, 'A') in ('A','I'))
1362: and exists
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

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

1660: (select 'Y' from AS_SALES_CREDITS
1661: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1662: ))
1663:
1664: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1665: )
1666:
1667: or exists (select 'Y' from HZ_PARTY_SITES
1668: xx where xx.PARTY_ID = temp.party_id

Line 1671: (select 'Y' from AS_SALES_CREDITS_DENORM

1667: or exists (select 'Y' from HZ_PARTY_SITES
1668: xx where xx.PARTY_ID = temp.party_id
1669: and (nvl(STATUS, 'A') in ('A','I'))
1670: and exists
1671: (select 'Y' from AS_SALES_CREDITS_DENORM
1672: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1673: ))
1674:
1675: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID = temp.party_id

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

1671: (select 'Y' from AS_SALES_CREDITS_DENORM
1672: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1673: ))
1674:
1675: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID = temp.party_id
1676: )
1677:
1678: or exists (select 'Y' from HZ_PARTY_SITES
1679: xx where xx.PARTY_ID = temp.party_id

Line 1682: (select 'Y' from AS_SALES_CREDITS_DENORM

1678: or exists (select 'Y' from HZ_PARTY_SITES
1679: xx where xx.PARTY_ID = temp.party_id
1680: and (nvl(STATUS, 'A') in ('A','I'))
1681: and exists
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

Line 3990: --AS_SALES_CREDITS_DENORM;CLOSE_COMPETITOR_ID

3986: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3987: temp.party_id in (select /*+ parallel(xx)*/ xx.INCUMBENT_PARTNER_PARTY_ID from AS_SALES_LEADS xx
3988: );
3989: end if;
3990: --AS_SALES_CREDITS_DENORM;CLOSE_COMPETITOR_ID
3991: appid:=279;
3992: if(regid_proc = true) then
3993: 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
3994:

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

3991: appid:=279;
3992: if(regid_proc = true) then
3993: 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
3994:
3995: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx
3996: );
3997: else
3998: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3999: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx

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

3995: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx
3996: );
3997: else
3998: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3999: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx
4000: );
4001: end if;
4002: --AS_LEADS_LOG;CUSTOMER_ID
4003: appid:=279;