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 1288: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

1284: (select 'Y' from HZ_ORG_CONTACTS
1285: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1286: and nvl(STATUS, 'A') in ('A','I')
1287: and exists
1288: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1289: or exists (select 'Y' from HZ_RELATIONSHIPS
1290: xx where xx.OBJECT_ID = temp.party_id
1291: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1292: AND directional_flag = 'F')

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

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

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

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

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

1314: (select 'Y' from HZ_ORG_CONTACTS
1315: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1316: and nvl(STATUS, 'A') in ('A','I')
1317: and exists
1318: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1319:
1320: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1321: )
1322:

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

1316: and nvl(STATUS, 'A') in ('A','I')
1317: and exists
1318: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1319:
1320: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1321: )
1322:
1323: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1324: )

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

1319:
1320: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1321: )
1322:
1323: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1324: )
1325:
1326: or exists (select 'Y' from HZ_PARTY_SITES
1327: xx where xx.PARTY_ID = temp.party_id

Line 1330: (select 'Y' from AS_LEAD_CONTACTS_ALL

1326: or exists (select 'Y' from HZ_PARTY_SITES
1327: xx where xx.PARTY_ID = temp.party_id
1328: and (nvl(STATUS, 'A') in ('A','I'))
1329: and exists
1330: (select 'Y' from AS_LEAD_CONTACTS_ALL
1331: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1332: ))
1333:
1334: or exists (select 'Y' from AS_SALES_CREDITS xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

Line 1371: (select 'Y' from AS_LEAD_CONTACTS_ALL

1367: or exists (select 'Y' from HZ_CONTACT_POINTS
1368: xx where xx.OWNER_TABLE_ID = temp.party_id
1369: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1370: and exists
1371: (select 'Y' from AS_LEAD_CONTACTS_ALL
1372: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1373: ))
1374: or exists (select 'Y' from HZ_PARTY_SITES
1375: xx where xx.PARTY_ID = temp.party_id

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

1378: (select 'Y' from HZ_CONTACT_POINTS
1379: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1380: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1381: and exists
1382: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1383:
1384: or exists (select 'Y' from HZ_PARTY_SITES
1385: xx where xx.PARTY_ID = temp.party_id
1386: and (nvl(STATUS, 'A') in ('A','I'))

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

1603: (select 'Y' from HZ_ORG_CONTACTS
1604: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1605: and nvl(STATUS, 'A') in ('A','I')
1606: and exists
1607: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1608: or exists (select 'Y' from HZ_RELATIONSHIPS
1609: xx where xx.OBJECT_ID = temp.party_id
1610: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1611: AND directional_flag = 'F')

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

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

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

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

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

1633: (select 'Y' from HZ_ORG_CONTACTS
1634: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1635: and nvl(STATUS, 'A') in ('A','I')
1636: and exists
1637: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1638:
1639: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1640: )
1641:

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

1635: and nvl(STATUS, 'A') in ('A','I')
1636: and exists
1637: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1638:
1639: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1640: )
1641:
1642: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1643: )

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

1638:
1639: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID = temp.party_id
1640: )
1641:
1642: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1643: )
1644:
1645: or exists (select 'Y' from HZ_PARTY_SITES
1646: xx where xx.PARTY_ID = temp.party_id

Line 1649: (select 'Y' from AS_LEAD_CONTACTS_ALL

1645: or exists (select 'Y' from HZ_PARTY_SITES
1646: xx where xx.PARTY_ID = temp.party_id
1647: and (nvl(STATUS, 'A') in ('A','I'))
1648: and exists
1649: (select 'Y' from AS_LEAD_CONTACTS_ALL
1650: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1651: ))
1652:
1653: or exists (select 'Y' from AS_SALES_CREDITS xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

Line 1690: (select 'Y' from AS_LEAD_CONTACTS_ALL

1686: or exists (select 'Y' from HZ_CONTACT_POINTS
1687: xx where xx.OWNER_TABLE_ID = temp.party_id
1688: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1689: and exists
1690: (select 'Y' from AS_LEAD_CONTACTS_ALL
1691: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1692: ))
1693: or exists (select 'Y' from HZ_PARTY_SITES
1694: xx where xx.PARTY_ID = temp.party_id

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

1697: (select 'Y' from HZ_CONTACT_POINTS
1698: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1699: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1700: and exists
1701: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1702:
1703: or exists (select 'Y' from HZ_PARTY_SITES
1704: xx where xx.PARTY_ID = temp.party_id
1705: and (nvl(STATUS, 'A') in ('A','I'))