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_LEAD_CONTACTS

Line 1154: (select 'Y' from AS_SALES_LEAD_CONTACTS

1150: exists (select 'Y' from HZ_PARTY_SITES
1151: xx where xx.PARTY_ID = temp.party_id
1152: and (nvl(STATUS, 'A') in ('A','I'))
1153: and exists
1154: (select 'Y' from AS_SALES_LEAD_CONTACTS
1155: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1156: ))
1157:
1158: or exists (select 'Y' from HZ_CONTACT_POINTS

Line 1162: (select 'Y' from AS_SALES_LEAD_CONTACTS

1158: or exists (select 'Y' from HZ_CONTACT_POINTS
1159: xx where xx.OWNER_TABLE_ID = temp.party_id
1160: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1161: and exists
1162: (select 'Y' from AS_SALES_LEAD_CONTACTS
1163: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1164: ))
1165: or exists (select 'Y' from HZ_PARTY_SITES
1166: xx where xx.PARTY_ID = temp.party_id

Line 1173: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

1169: (select 'Y' from HZ_CONTACT_POINTS
1170: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1171: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1172: and exists
1173: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1174:
1175: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1176: )
1177:

Line 1175: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id

1171: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1172: and exists
1173: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1174:
1175: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1176: )
1177:
1178: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id
1179: )

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

1253:
1254: or exists (select 'Y' from AS_SALES_LEADS xx where xx.CUSTOMER_ID = temp.party_id
1255: )
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: )

Line 1400: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1396: (select 'Y' from HZ_ORG_CONTACTS
1397: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1398: and nvl(STATUS, 'A') in ('A','I')
1399: and exists
1400: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1401: or exists (select 'Y' from HZ_RELATIONSHIPS
1402: xx where xx.OBJECT_ID = temp.party_id
1403: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1404: AND directional_flag = 'F')

Line 1410: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1406: (select 'Y' from HZ_ORG_CONTACTS
1407: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1408: and nvl(STATUS, 'A') in ('A','I')
1409: and exists
1410: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1411: or exists (select 'Y' from HZ_RELATIONSHIPS
1412: xx where xx.PARTY_ID = temp.party_id
1413: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1414: AND directional_flag = 'F')

Line 1420: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1416: (select 'Y' from HZ_ORG_CONTACTS
1417: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1418: and nvl(STATUS, 'A') in ('A','I')
1419: and exists
1420: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1421: or exists (select 'Y' from HZ_RELATIONSHIPS
1422: xx where xx.SUBJECT_ID = temp.party_id
1423: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1424: AND directional_flag = 'F')

Line 1430: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1426: (select 'Y' from HZ_ORG_CONTACTS
1427: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1428: and nvl(STATUS, 'A') in ('A','I')
1429: and exists
1430: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1431:
1432: or exists (select 'Y' from HZ_PARTY_SITES
1433: xx where xx.PARTY_ID = temp.party_id
1434: and (nvl(STATUS, 'A') in ('A','I'))

Line 1473: (select 'Y' from AS_SALES_LEAD_CONTACTS

1469: exists (select 'Y' from HZ_PARTY_SITES
1470: xx where xx.PARTY_ID = temp.party_id
1471: and (nvl(STATUS, 'A') in ('A','I'))
1472: and exists
1473: (select 'Y' from AS_SALES_LEAD_CONTACTS
1474: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1475: ))
1476:
1477: or exists (select 'Y' from HZ_CONTACT_POINTS

Line 1481: (select 'Y' from AS_SALES_LEAD_CONTACTS

1477: or exists (select 'Y' from HZ_CONTACT_POINTS
1478: xx where xx.OWNER_TABLE_ID = temp.party_id
1479: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1480: and exists
1481: (select 'Y' from AS_SALES_LEAD_CONTACTS
1482: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1483: ))
1484: or exists (select 'Y' from HZ_PARTY_SITES
1485: xx where xx.PARTY_ID = temp.party_id

Line 1492: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

1488: (select 'Y' from HZ_CONTACT_POINTS
1489: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1490: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1491: and exists
1492: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1493:
1494: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1495: )
1496:

Line 1494: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id

1490: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1491: and exists
1492: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1493:
1494: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1495: )
1496:
1497: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id
1498: )

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

1572:
1573: or exists (select 'Y' from AS_SALES_LEADS xx where xx.CUSTOMER_ID = temp.party_id
1574: )
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: )

Line 1719: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1715: (select 'Y' from HZ_ORG_CONTACTS
1716: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1717: and nvl(STATUS, 'A') in ('A','I')
1718: and exists
1719: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1720: or exists (select 'Y' from HZ_RELATIONSHIPS
1721: xx where xx.OBJECT_ID = temp.party_id
1722: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1723: AND directional_flag = 'F')

Line 1729: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1725: (select 'Y' from HZ_ORG_CONTACTS
1726: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1727: and nvl(STATUS, 'A') in ('A','I')
1728: and exists
1729: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1730: or exists (select 'Y' from HZ_RELATIONSHIPS
1731: xx where xx.PARTY_ID = temp.party_id
1732: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1733: AND directional_flag = 'F')

Line 1739: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1735: (select 'Y' from HZ_ORG_CONTACTS
1736: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1737: and nvl(STATUS, 'A') in ('A','I')
1738: and exists
1739: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1740: or exists (select 'Y' from HZ_RELATIONSHIPS
1741: xx where xx.SUBJECT_ID = temp.party_id
1742: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1743: AND directional_flag = 'F')

Line 1749: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1745: (select 'Y' from HZ_ORG_CONTACTS
1746: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1747: and nvl(STATUS, 'A') in ('A','I')
1748: and exists
1749: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1750:
1751: or exists (select 'Y' from HZ_PARTY_SITES
1752: xx where xx.PARTY_ID = temp.party_id
1753: and (nvl(STATUS, 'A') in ('A','I'))