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_LEAD_CONTACTS_ALL

Line 1185: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1181: (select 'Y' from HZ_ORG_CONTACTS
1182: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1183: and nvl(STATUS, 'A') in ('A','I')
1184: and exists
1185: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1186: or exists (select 'Y' from HZ_RELATIONSHIPS
1187: xx where xx.OBJECT_ID = temp.party_id
1188: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1189: AND directional_flag = 'F')

Line 1195: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1191: (select 'Y' from HZ_ORG_CONTACTS
1192: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1193: and nvl(STATUS, 'A') in ('A','I')
1194: and exists
1195: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1196: or exists (select 'Y' from HZ_RELATIONSHIPS
1197: xx where xx.PARTY_ID = temp.party_id
1198: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1199: AND directional_flag = 'F')

Line 1205: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1201: (select 'Y' from HZ_ORG_CONTACTS
1202: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1203: and nvl(STATUS, 'A') in ('A','I')
1204: and exists
1205: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1206: or exists (select 'Y' from HZ_RELATIONSHIPS
1207: xx where xx.SUBJECT_ID = temp.party_id
1208: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1209: AND directional_flag = 'F')

Line 1215: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1211: (select 'Y' from HZ_ORG_CONTACTS
1212: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1213: and nvl(STATUS, 'A') in ('A','I')
1214: and exists
1215: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1216:
1217: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1218: )
1219:

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

1213: and nvl(STATUS, 'A') in ('A','I')
1214: and exists
1215: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1216:
1217: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1218: )
1219:
1220: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1221: )

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

1216:
1217: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1218: )
1219:
1220: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1221: )
1222:
1223: or exists (select 'Y' from HZ_PARTY_SITES
1224: xx where xx.PARTY_ID = temp.party_id

Line 1227: (select 'Y' from AS_LEAD_CONTACTS_ALL

1223: or exists (select 'Y' from HZ_PARTY_SITES
1224: xx where xx.PARTY_ID = temp.party_id
1225: and (nvl(STATUS, 'A') in ('A','I'))
1226: and exists
1227: (select 'Y' from AS_LEAD_CONTACTS_ALL
1228: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1229: ))
1230:
1231: or exists (select 'Y' from AS_SALES_CREDITS xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

Line 1268: (select 'Y' from AS_LEAD_CONTACTS_ALL

1264: or exists (select 'Y' from HZ_CONTACT_POINTS
1265: xx where xx.OWNER_TABLE_ID = temp.party_id
1266: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1267: and exists
1268: (select 'Y' from AS_LEAD_CONTACTS_ALL
1269: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1270: ))
1271: or exists (select 'Y' from HZ_PARTY_SITES
1272: xx where xx.PARTY_ID = temp.party_id

Line 1279: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

1275: (select 'Y' from HZ_CONTACT_POINTS
1276: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1277: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1278: and exists
1279: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1280:
1281: or exists (select 'Y' from HZ_PARTY_SITES
1282: xx where xx.PARTY_ID = temp.party_id
1283: and (nvl(STATUS, 'A') in ('A','I'))

Line 1504: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1500: (select 'Y' from HZ_ORG_CONTACTS
1501: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1502: and nvl(STATUS, 'A') in ('A','I')
1503: and exists
1504: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1505: or exists (select 'Y' from HZ_RELATIONSHIPS
1506: xx where xx.OBJECT_ID = temp.party_id
1507: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1508: AND directional_flag = 'F')

Line 1514: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1510: (select 'Y' from HZ_ORG_CONTACTS
1511: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1512: and nvl(STATUS, 'A') in ('A','I')
1513: and exists
1514: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1515: or exists (select 'Y' from HZ_RELATIONSHIPS
1516: xx where xx.PARTY_ID = temp.party_id
1517: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1518: AND directional_flag = 'F')

Line 1524: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1520: (select 'Y' from HZ_ORG_CONTACTS
1521: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1522: and nvl(STATUS, 'A') in ('A','I')
1523: and exists
1524: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1525: or exists (select 'Y' from HZ_RELATIONSHIPS
1526: xx where xx.SUBJECT_ID = temp.party_id
1527: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1528: AND directional_flag = 'F')

Line 1534: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1530: (select 'Y' from HZ_ORG_CONTACTS
1531: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1532: and nvl(STATUS, 'A') in ('A','I')
1533: and exists
1534: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1535:
1536: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1537: )
1538:

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

1532: and nvl(STATUS, 'A') in ('A','I')
1533: and exists
1534: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1535:
1536: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1537: )
1538:
1539: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1540: )

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

1535:
1536: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1537: )
1538:
1539: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1540: )
1541:
1542: or exists (select 'Y' from HZ_PARTY_SITES
1543: xx where xx.PARTY_ID = temp.party_id

Line 1546: (select 'Y' from AS_LEAD_CONTACTS_ALL

1542: or exists (select 'Y' from HZ_PARTY_SITES
1543: xx where xx.PARTY_ID = temp.party_id
1544: and (nvl(STATUS, 'A') in ('A','I'))
1545: and exists
1546: (select 'Y' from AS_LEAD_CONTACTS_ALL
1547: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1548: ))
1549:
1550: or exists (select 'Y' from AS_SALES_CREDITS xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

Line 1587: (select 'Y' from AS_LEAD_CONTACTS_ALL

1583: or exists (select 'Y' from HZ_CONTACT_POINTS
1584: xx where xx.OWNER_TABLE_ID = temp.party_id
1585: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1586: and exists
1587: (select 'Y' from AS_LEAD_CONTACTS_ALL
1588: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1589: ))
1590: or exists (select 'Y' from HZ_PARTY_SITES
1591: xx where xx.PARTY_ID = temp.party_id

Line 1598: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

1594: (select 'Y' from HZ_CONTACT_POINTS
1595: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1596: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1597: and exists
1598: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1599:
1600: or exists (select 'Y' from HZ_PARTY_SITES
1601: xx where xx.PARTY_ID = temp.party_id
1602: and (nvl(STATUS, 'A') in ('A','I'))