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_LEADS

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

1147: (select 'Y' from AS_ACCESSES_ALL
1148: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1149: ))
1150:
1151: or exists (select 'Y' from AS_SALES_LEADS xx where xx.CUSTOMER_ID = temp.party_id
1152: )
1153:
1154: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CUSTOMER_ID = temp.party_id
1155: )

Line 1333: (select 'Y' from AS_SALES_LEADS

1329: or exists (select 'Y' from HZ_PARTY_SITES
1330: xx where xx.PARTY_ID = temp.party_id
1331: and (nvl(STATUS, 'A') in ('A','I'))
1332: and exists
1333: (select 'Y' from AS_SALES_LEADS
1334: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1335: ))
1336:
1337: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CONTACT_PARTY_ID = temp.party_id

Line 1337: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CONTACT_PARTY_ID = temp.party_id

1333: (select 'Y' from AS_SALES_LEADS
1334: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1335: ))
1336:
1337: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CONTACT_PARTY_ID = temp.party_id
1338: )
1339:
1340: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CNT_PERSON_PARTY_ID = temp.party_id
1341: )

Line 1340: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CNT_PERSON_PARTY_ID = temp.party_id

1336:
1337: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CONTACT_PARTY_ID = temp.party_id
1338: )
1339:
1340: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CNT_PERSON_PARTY_ID = temp.party_id
1341: )
1342:
1343: or exists (select 'Y' from HZ_CONTACT_POINTS
1344: xx where xx.OWNER_TABLE_ID = temp.party_id

Line 1347: (select 'Y' from AS_SALES_LEADS

1343: or exists (select 'Y' from HZ_CONTACT_POINTS
1344: xx where xx.OWNER_TABLE_ID = temp.party_id
1345: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1346: and exists
1347: (select 'Y' from AS_SALES_LEADS
1348: yy where yy.PRIMARY_CONTACT_PHONE_ID=xx.CONTACT_POINT_ID
1349: ))
1350: or exists (select 'Y' from HZ_PARTY_SITES
1351: xx where xx.PARTY_ID = temp.party_id

Line 1358: (select 'Y' from AS_SALES_LEADS zz where zz.PRIMARY_CONTACT_PHONE_ID = yy.CONTACT_POINT_ID )))

1354: (select 'Y' from HZ_CONTACT_POINTS
1355: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1356: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1357: and exists
1358: (select 'Y' from AS_SALES_LEADS zz where zz.PRIMARY_CONTACT_PHONE_ID = yy.CONTACT_POINT_ID )))
1359:
1360: or exists (select 'Y' from AS_AP_ACCOUNT_PLANS xx where xx.CUST_PARTY_ID = temp.party_id
1361: );
1362: else

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

1466: (select 'Y' from AS_ACCESSES_ALL
1467: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1468: ))
1469:
1470: or exists (select 'Y' from AS_SALES_LEADS xx where xx.CUSTOMER_ID = temp.party_id
1471: )
1472:
1473: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CUSTOMER_ID = temp.party_id
1474: )

Line 1652: (select 'Y' from AS_SALES_LEADS

1648: or exists (select 'Y' from HZ_PARTY_SITES
1649: xx where xx.PARTY_ID = temp.party_id
1650: and (nvl(STATUS, 'A') in ('A','I'))
1651: and exists
1652: (select 'Y' from AS_SALES_LEADS
1653: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1654: ))
1655:
1656: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CONTACT_PARTY_ID = temp.party_id

Line 1656: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CONTACT_PARTY_ID = temp.party_id

1652: (select 'Y' from AS_SALES_LEADS
1653: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1654: ))
1655:
1656: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CONTACT_PARTY_ID = temp.party_id
1657: )
1658:
1659: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CNT_PERSON_PARTY_ID = temp.party_id
1660: )

Line 1659: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CNT_PERSON_PARTY_ID = temp.party_id

1655:
1656: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CONTACT_PARTY_ID = temp.party_id
1657: )
1658:
1659: or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CNT_PERSON_PARTY_ID = temp.party_id
1660: )
1661:
1662: or exists (select 'Y' from HZ_CONTACT_POINTS
1663: xx where xx.OWNER_TABLE_ID = temp.party_id

Line 1666: (select 'Y' from AS_SALES_LEADS

1662: or exists (select 'Y' from HZ_CONTACT_POINTS
1663: xx where xx.OWNER_TABLE_ID = temp.party_id
1664: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1665: and exists
1666: (select 'Y' from AS_SALES_LEADS
1667: yy where yy.PRIMARY_CONTACT_PHONE_ID=xx.CONTACT_POINT_ID
1668: ))
1669: or exists (select 'Y' from HZ_PARTY_SITES
1670: xx where xx.PARTY_ID = temp.party_id

Line 1677: (select 'Y' from AS_SALES_LEADS zz where zz.PRIMARY_CONTACT_PHONE_ID = yy.CONTACT_POINT_ID )))

1673: (select 'Y' from HZ_CONTACT_POINTS
1674: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1675: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1676: and exists
1677: (select 'Y' from AS_SALES_LEADS zz where zz.PRIMARY_CONTACT_PHONE_ID = yy.CONTACT_POINT_ID )))
1678:
1679: or exists (select 'Y' from AS_AP_ACCOUNT_PLANS xx where xx.CUST_PARTY_ID = temp.party_id
1680: );
1681: end if;

Line 3938: --AS_SALES_LEADS;INCUMBENT_PARTNER_PARTY_ID

3934: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3935: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx
3936: );
3937: end if;
3938: --AS_SALES_LEADS;INCUMBENT_PARTNER_PARTY_ID
3939: appid:=279;
3940: if(regid_proc = true) then
3941: 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
3942:

Line 3943: temp.party_id in (select /+ parallel(xx)/ xx.INCUMBENT_PARTNER_PARTY_ID from AS_SALES_LEADS xx

3939: appid:=279;
3940: if(regid_proc = true) then
3941: 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
3942:
3943: temp.party_id in (select /*+ parallel(xx)*/ xx.INCUMBENT_PARTNER_PARTY_ID from AS_SALES_LEADS xx
3944: );
3945: else
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

Line 3947: temp.party_id in (select /+ parallel(xx)/ xx.INCUMBENT_PARTNER_PARTY_ID from AS_SALES_LEADS xx

3943: temp.party_id in (select /*+ parallel(xx)*/ xx.INCUMBENT_PARTNER_PARTY_ID from AS_SALES_LEADS xx
3944: );
3945: else
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;

Line 4020: --AS_SALES_LEADS;REFERRED_BY

4016: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4017: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_CURRENT_ENVIRONMENT xx
4018: );
4019: end if;
4020: --AS_SALES_LEADS;REFERRED_BY
4021: appid:=279;
4022: if(regid_proc = true) then
4023: 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
4024:

Line 4025: temp.party_id in (select /+ parallel(xx)/ xx.REFERRED_BY from AS_SALES_LEADS xx

4021: appid:=279;
4022: if(regid_proc = true) then
4023: 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
4024:
4025: temp.party_id in (select /*+ parallel(xx)*/ xx.REFERRED_BY from AS_SALES_LEADS xx
4026: );
4027: else
4028: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4029: temp.party_id in (select /*+ parallel(xx)*/ xx.REFERRED_BY from AS_SALES_LEADS xx

Line 4029: temp.party_id in (select /+ parallel(xx)/ xx.REFERRED_BY from AS_SALES_LEADS xx

4025: temp.party_id in (select /*+ parallel(xx)*/ xx.REFERRED_BY from AS_SALES_LEADS xx
4026: );
4027: else
4028: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4029: temp.party_id in (select /*+ parallel(xx)*/ xx.REFERRED_BY from AS_SALES_LEADS xx
4030: );
4031: end if;
4032: --JTF_PERZ_DATA_V;ATTRIBUTE_VALUE
4033: appid:=514;