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 1051: (select 'Y' from AS_SALES_LEAD_CONTACTS

1047: exists (select 'Y' from HZ_PARTY_SITES
1048: xx where xx.PARTY_ID = temp.party_id
1049: and (nvl(STATUS, 'A') in ('A','I'))
1050: and exists
1051: (select 'Y' from AS_SALES_LEAD_CONTACTS
1052: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1053: ))
1054:
1055: or exists (select 'Y' from HZ_CONTACT_POINTS

Line 1059: (select 'Y' from AS_SALES_LEAD_CONTACTS

1055: or exists (select 'Y' from HZ_CONTACT_POINTS
1056: xx where xx.OWNER_TABLE_ID = temp.party_id
1057: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1058: and exists
1059: (select 'Y' from AS_SALES_LEAD_CONTACTS
1060: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1061: ))
1062: or exists (select 'Y' from HZ_PARTY_SITES
1063: xx where xx.PARTY_ID = temp.party_id

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

1066: (select 'Y' from HZ_CONTACT_POINTS
1067: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1068: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1069: and exists
1070: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1071:
1072: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1073: )
1074:

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

1068: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1069: and exists
1070: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1071:
1072: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1073: )
1074:
1075: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id
1076: )

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

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: )
1156:
1157: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1158: )

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

1293: (select 'Y' from HZ_ORG_CONTACTS
1294: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1295: and nvl(STATUS, 'A') in ('A','I')
1296: and exists
1297: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1298: or exists (select 'Y' from HZ_RELATIONSHIPS
1299: xx where xx.OBJECT_ID = temp.party_id
1300: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1301: AND directional_flag = 'F')

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

1303: (select 'Y' from HZ_ORG_CONTACTS
1304: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1305: and nvl(STATUS, 'A') in ('A','I')
1306: and exists
1307: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1308: or exists (select 'Y' from HZ_RELATIONSHIPS
1309: xx where xx.PARTY_ID = temp.party_id
1310: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1311: AND directional_flag = 'F')

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

1313: (select 'Y' from HZ_ORG_CONTACTS
1314: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1315: and nvl(STATUS, 'A') in ('A','I')
1316: and exists
1317: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1318: or exists (select 'Y' from HZ_RELATIONSHIPS
1319: xx where xx.SUBJECT_ID = temp.party_id
1320: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1321: AND directional_flag = 'F')

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

1323: (select 'Y' from HZ_ORG_CONTACTS
1324: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1325: and nvl(STATUS, 'A') in ('A','I')
1326: and exists
1327: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1328:
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'))

Line 1370: (select 'Y' from AS_SALES_LEAD_CONTACTS

1366: exists (select 'Y' from HZ_PARTY_SITES
1367: xx where xx.PARTY_ID = temp.party_id
1368: and (nvl(STATUS, 'A') in ('A','I'))
1369: and exists
1370: (select 'Y' from AS_SALES_LEAD_CONTACTS
1371: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1372: ))
1373:
1374: or exists (select 'Y' from HZ_CONTACT_POINTS

Line 1378: (select 'Y' from AS_SALES_LEAD_CONTACTS

1374: or exists (select 'Y' from HZ_CONTACT_POINTS
1375: xx where xx.OWNER_TABLE_ID = temp.party_id
1376: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1377: and exists
1378: (select 'Y' from AS_SALES_LEAD_CONTACTS
1379: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1380: ))
1381: or exists (select 'Y' from HZ_PARTY_SITES
1382: xx where xx.PARTY_ID = temp.party_id

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

1385: (select 'Y' from HZ_CONTACT_POINTS
1386: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1387: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1388: and exists
1389: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1390:
1391: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1392: )
1393:

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

1387: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1388: and exists
1389: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1390:
1391: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1392: )
1393:
1394: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id
1395: )

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

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: )
1475:
1476: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1477: )

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

1612: (select 'Y' from HZ_ORG_CONTACTS
1613: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1614: and nvl(STATUS, 'A') in ('A','I')
1615: and exists
1616: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1617: or exists (select 'Y' from HZ_RELATIONSHIPS
1618: xx where xx.OBJECT_ID = temp.party_id
1619: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1620: AND directional_flag = 'F')

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

1622: (select 'Y' from HZ_ORG_CONTACTS
1623: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1624: and nvl(STATUS, 'A') in ('A','I')
1625: and exists
1626: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1627: or exists (select 'Y' from HZ_RELATIONSHIPS
1628: xx where xx.PARTY_ID = temp.party_id
1629: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1630: AND directional_flag = 'F')

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

1632: (select 'Y' from HZ_ORG_CONTACTS
1633: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1634: and nvl(STATUS, 'A') in ('A','I')
1635: and exists
1636: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1637: or exists (select 'Y' from HZ_RELATIONSHIPS
1638: xx where xx.SUBJECT_ID = temp.party_id
1639: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1640: AND directional_flag = 'F')

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

1642: (select 'Y' from HZ_ORG_CONTACTS
1643: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1644: and nvl(STATUS, 'A') in ('A','I')
1645: and exists
1646: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1647:
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'))