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_INTERESTS_ALL

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

1191:
1192: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1193: )
1194:
1195: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1196: )
1197:
1198: or exists (select 'Y' from HZ_PARTY_SITES
1199: xx where xx.PARTY_ID = temp.party_id

Line 1202: (select 'Y' from AS_INTERESTS_ALL

1198: or exists (select 'Y' from HZ_PARTY_SITES
1199: xx where xx.PARTY_ID = temp.party_id
1200: and (nvl(STATUS, 'A') in ('A','I'))
1201: and exists
1202: (select 'Y' from AS_INTERESTS_ALL
1203: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1204: ))
1205:
1206: or exists (select 'Y' from HZ_PARTY_SITES

Line 1214: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1210: (select 'Y' from HZ_ORG_CONTACTS
1211: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1212: and nvl(STATUS, 'A') in ('A','I')
1213: and exists
1214: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1215: or exists (select 'Y' from HZ_RELATIONSHIPS
1216: xx where xx.OBJECT_ID = temp.party_id
1217: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1218: AND directional_flag = 'F')

Line 1224: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1220: (select 'Y' from HZ_ORG_CONTACTS
1221: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1222: and nvl(STATUS, 'A') in ('A','I')
1223: and exists
1224: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1225: or exists (select 'Y' from HZ_RELATIONSHIPS
1226: xx where xx.PARTY_ID = temp.party_id
1227: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1228: AND directional_flag = 'F')

Line 1234: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1230: (select 'Y' from HZ_ORG_CONTACTS
1231: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1232: and nvl(STATUS, 'A') in ('A','I')
1233: and exists
1234: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1235: or exists (select 'Y' from HZ_RELATIONSHIPS
1236: xx where xx.SUBJECT_ID = temp.party_id
1237: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1238: AND directional_flag = 'F')

Line 1244: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1240: (select 'Y' from HZ_ORG_CONTACTS
1241: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1242: and nvl(STATUS, 'A') in ('A','I')
1243: and exists
1244: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1245:
1246: or exists (select 'Y' from HZ_PARTY_SITES
1247: xx where xx.PARTY_ID = temp.party_id
1248: and (nvl(STATUS, 'A') in ('A','I'))

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

1510:
1511: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1512: )
1513:
1514: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1515: )
1516:
1517: or exists (select 'Y' from HZ_PARTY_SITES
1518: xx where xx.PARTY_ID = temp.party_id

Line 1521: (select 'Y' from AS_INTERESTS_ALL

1517: or exists (select 'Y' from HZ_PARTY_SITES
1518: xx where xx.PARTY_ID = temp.party_id
1519: and (nvl(STATUS, 'A') in ('A','I'))
1520: and exists
1521: (select 'Y' from AS_INTERESTS_ALL
1522: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1523: ))
1524:
1525: or exists (select 'Y' from HZ_PARTY_SITES

Line 1533: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1529: (select 'Y' from HZ_ORG_CONTACTS
1530: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1531: and nvl(STATUS, 'A') in ('A','I')
1532: and exists
1533: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1534: or exists (select 'Y' from HZ_RELATIONSHIPS
1535: xx where xx.OBJECT_ID = temp.party_id
1536: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1537: AND directional_flag = 'F')

Line 1543: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1539: (select 'Y' from HZ_ORG_CONTACTS
1540: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1541: and nvl(STATUS, 'A') in ('A','I')
1542: and exists
1543: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1544: or exists (select 'Y' from HZ_RELATIONSHIPS
1545: xx where xx.PARTY_ID = temp.party_id
1546: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1547: AND directional_flag = 'F')

Line 1553: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1549: (select 'Y' from HZ_ORG_CONTACTS
1550: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1551: and nvl(STATUS, 'A') in ('A','I')
1552: and exists
1553: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1554: or exists (select 'Y' from HZ_RELATIONSHIPS
1555: xx where xx.SUBJECT_ID = temp.party_id
1556: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1557: AND directional_flag = 'F')

Line 1563: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1559: (select 'Y' from HZ_ORG_CONTACTS
1560: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1561: and nvl(STATUS, 'A') in ('A','I')
1562: and exists
1563: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1564:
1565: or exists (select 'Y' from HZ_PARTY_SITES
1566: xx where xx.PARTY_ID = temp.party_id
1567: and (nvl(STATUS, 'A') in ('A','I'))