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 1092: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id

1088:
1089: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1090: )
1091:
1092: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1093: )
1094:
1095: or exists (select 'Y' from HZ_PARTY_SITES
1096: xx where xx.PARTY_ID = temp.party_id

Line 1099: (select 'Y' from AS_INTERESTS_ALL

1095: or exists (select 'Y' from HZ_PARTY_SITES
1096: xx where xx.PARTY_ID = temp.party_id
1097: and (nvl(STATUS, 'A') in ('A','I'))
1098: and exists
1099: (select 'Y' from AS_INTERESTS_ALL
1100: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1101: ))
1102:
1103: or exists (select 'Y' from HZ_PARTY_SITES

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

1107: (select 'Y' from HZ_ORG_CONTACTS
1108: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1109: and nvl(STATUS, 'A') in ('A','I')
1110: and exists
1111: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1112: or exists (select 'Y' from HZ_RELATIONSHIPS
1113: xx where xx.OBJECT_ID = temp.party_id
1114: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1115: AND directional_flag = 'F')

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

1117: (select 'Y' from HZ_ORG_CONTACTS
1118: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1119: and nvl(STATUS, 'A') in ('A','I')
1120: and exists
1121: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1122: or exists (select 'Y' from HZ_RELATIONSHIPS
1123: xx where xx.PARTY_ID = temp.party_id
1124: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1125: AND directional_flag = 'F')

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

1127: (select 'Y' from HZ_ORG_CONTACTS
1128: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1129: and nvl(STATUS, 'A') in ('A','I')
1130: and exists
1131: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1132: or exists (select 'Y' from HZ_RELATIONSHIPS
1133: xx where xx.SUBJECT_ID = temp.party_id
1134: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1135: AND directional_flag = 'F')

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

1137: (select 'Y' from HZ_ORG_CONTACTS
1138: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1139: and nvl(STATUS, 'A') in ('A','I')
1140: and exists
1141: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1142:
1143: or exists (select 'Y' from HZ_PARTY_SITES
1144: xx where xx.PARTY_ID = temp.party_id
1145: and (nvl(STATUS, 'A') in ('A','I'))

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

1407:
1408: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1409: )
1410:
1411: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1412: )
1413:
1414: or exists (select 'Y' from HZ_PARTY_SITES
1415: xx where xx.PARTY_ID = temp.party_id

Line 1418: (select 'Y' from AS_INTERESTS_ALL

1414: or exists (select 'Y' from HZ_PARTY_SITES
1415: xx where xx.PARTY_ID = temp.party_id
1416: and (nvl(STATUS, 'A') in ('A','I'))
1417: and exists
1418: (select 'Y' from AS_INTERESTS_ALL
1419: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1420: ))
1421:
1422: or exists (select 'Y' from HZ_PARTY_SITES

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

1426: (select 'Y' from HZ_ORG_CONTACTS
1427: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1428: and nvl(STATUS, 'A') in ('A','I')
1429: and exists
1430: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1431: or exists (select 'Y' from HZ_RELATIONSHIPS
1432: xx where xx.OBJECT_ID = temp.party_id
1433: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1434: AND directional_flag = 'F')

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

1436: (select 'Y' from HZ_ORG_CONTACTS
1437: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1438: and nvl(STATUS, 'A') in ('A','I')
1439: and exists
1440: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1441: or exists (select 'Y' from HZ_RELATIONSHIPS
1442: xx where xx.PARTY_ID = temp.party_id
1443: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1444: AND directional_flag = 'F')

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

1446: (select 'Y' from HZ_ORG_CONTACTS
1447: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1448: and nvl(STATUS, 'A') in ('A','I')
1449: and exists
1450: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1451: or exists (select 'Y' from HZ_RELATIONSHIPS
1452: xx where xx.SUBJECT_ID = temp.party_id
1453: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1454: AND directional_flag = 'F')

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

1456: (select 'Y' from HZ_ORG_CONTACTS
1457: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1458: and nvl(STATUS, 'A') in ('A','I')
1459: and exists
1460: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1461:
1462: or exists (select 'Y' from HZ_PARTY_SITES
1463: xx where xx.PARTY_ID = temp.party_id
1464: and (nvl(STATUS, 'A') in ('A','I'))