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 HZ_ORG_CONTACTS

Line 105: (select 'Y' from HZ_ORG_CONTACTS

101: or exists (select 'Y' from HZ_PARTY_SITES
102: xx where xx.PARTY_ID = temp.party_id
103: and (nvl(STATUS, 'A') in ('A','I'))
104: and exists
105: (select 'Y' from HZ_ORG_CONTACTS
106: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
107: and nvl(STATUS, 'A') in ('A','I')
108: and exists
109: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 115: (select 'Y' from HZ_ORG_CONTACTS

111: xx where xx.OBJECT_ID = temp.party_id
112: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
113: AND directional_flag = 'F')
114: and exists
115: (select 'Y' from HZ_ORG_CONTACTS
116: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
117: and nvl(STATUS, 'A') in ('A','I')
118: and exists
119: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 125: (select 'Y' from HZ_ORG_CONTACTS

121: xx where xx.PARTY_ID = temp.party_id
122: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
123: AND directional_flag = 'F')
124: and exists
125: (select 'Y' from HZ_ORG_CONTACTS
126: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
127: and nvl(STATUS, 'A') in ('A','I')
128: and exists
129: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 135: (select 'Y' from HZ_ORG_CONTACTS

131: xx where xx.SUBJECT_ID = temp.party_id
132: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
133: AND directional_flag = 'F')
134: and exists
135: (select 'Y' from HZ_ORG_CONTACTS
136: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
137: and nvl(STATUS, 'A') in ('A','I')
138: and exists
139: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 204: (select 'Y' from HZ_ORG_CONTACTS

200: or exists (select 'Y' from HZ_PARTY_SITES
201: xx where xx.PARTY_ID = temp.party_id
202: and (nvl(STATUS, 'A') in ('A','I'))
203: and exists
204: (select 'Y' from HZ_ORG_CONTACTS
205: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
206: and nvl(STATUS, 'A') in ('A','I')
207: and exists
208: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 214: (select 'Y' from HZ_ORG_CONTACTS

210: xx where xx.OBJECT_ID = temp.party_id
211: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
212: AND directional_flag = 'F')
213: and exists
214: (select 'Y' from HZ_ORG_CONTACTS
215: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
216: and nvl(STATUS, 'A') in ('A','I')
217: and exists
218: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 224: (select 'Y' from HZ_ORG_CONTACTS

220: xx where xx.PARTY_ID = temp.party_id
221: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
222: AND directional_flag = 'F')
223: and exists
224: (select 'Y' from HZ_ORG_CONTACTS
225: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
226: and nvl(STATUS, 'A') in ('A','I')
227: and exists
228: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 234: (select 'Y' from HZ_ORG_CONTACTS

230: xx where xx.SUBJECT_ID = temp.party_id
231: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
232: AND directional_flag = 'F')
233: and exists
234: (select 'Y' from HZ_ORG_CONTACTS
235: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
236: and nvl(STATUS, 'A') in ('A','I')
237: and exists
238: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 1210: (select 'Y' from HZ_ORG_CONTACTS

1206: or exists (select 'Y' from HZ_PARTY_SITES
1207: xx where xx.PARTY_ID = temp.party_id
1208: and (nvl(STATUS, 'A') in ('A','I'))
1209: and exists
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 )))

Line 1220: (select 'Y' from HZ_ORG_CONTACTS

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')
1219: and exists
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 )))

Line 1230: (select 'Y' from HZ_ORG_CONTACTS

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')
1229: and exists
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 )))

Line 1240: (select 'Y' from HZ_ORG_CONTACTS

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')
1239: and exists
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 )))

Line 1284: (select 'Y' from HZ_ORG_CONTACTS

1280: or exists (select 'Y' from HZ_PARTY_SITES
1281: xx where xx.PARTY_ID = temp.party_id
1282: and (nvl(STATUS, 'A') in ('A','I'))
1283: and exists
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 )))

Line 1294: (select 'Y' from HZ_ORG_CONTACTS

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')
1293: and exists
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 )))

Line 1304: (select 'Y' from HZ_ORG_CONTACTS

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')
1303: and exists
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 )))

Line 1314: (select 'Y' from HZ_ORG_CONTACTS

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')
1313: and exists
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 )))

Line 1396: (select 'Y' from HZ_ORG_CONTACTS

1392: or exists (select 'Y' from HZ_PARTY_SITES
1393: xx where xx.PARTY_ID = temp.party_id
1394: and (nvl(STATUS, 'A') in ('A','I'))
1395: and exists
1396: (select 'Y' from HZ_ORG_CONTACTS
1397: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1398: and nvl(STATUS, 'A') in ('A','I')
1399: and exists
1400: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 1406: (select 'Y' from HZ_ORG_CONTACTS

1402: xx where xx.OBJECT_ID = temp.party_id
1403: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1404: AND directional_flag = 'F')
1405: and exists
1406: (select 'Y' from HZ_ORG_CONTACTS
1407: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1408: and nvl(STATUS, 'A') in ('A','I')
1409: and exists
1410: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 1416: (select 'Y' from HZ_ORG_CONTACTS

1412: xx where xx.PARTY_ID = temp.party_id
1413: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1414: AND directional_flag = 'F')
1415: and exists
1416: (select 'Y' from HZ_ORG_CONTACTS
1417: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1418: and nvl(STATUS, 'A') in ('A','I')
1419: and exists
1420: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 1426: (select 'Y' from HZ_ORG_CONTACTS

1422: xx where xx.SUBJECT_ID = temp.party_id
1423: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1424: AND directional_flag = 'F')
1425: and exists
1426: (select 'Y' from HZ_ORG_CONTACTS
1427: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1428: and nvl(STATUS, 'A') in ('A','I')
1429: and exists
1430: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 1529: (select 'Y' from HZ_ORG_CONTACTS

1525: or exists (select 'Y' from HZ_PARTY_SITES
1526: xx where xx.PARTY_ID = temp.party_id
1527: and (nvl(STATUS, 'A') in ('A','I'))
1528: and exists
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 )))

Line 1539: (select 'Y' from HZ_ORG_CONTACTS

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')
1538: and exists
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 )))

Line 1549: (select 'Y' from HZ_ORG_CONTACTS

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')
1548: and exists
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 )))

Line 1559: (select 'Y' from HZ_ORG_CONTACTS

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')
1558: and exists
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 )))

Line 1603: (select 'Y' from HZ_ORG_CONTACTS

1599: or exists (select 'Y' from HZ_PARTY_SITES
1600: xx where xx.PARTY_ID = temp.party_id
1601: and (nvl(STATUS, 'A') in ('A','I'))
1602: and exists
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 )))

Line 1613: (select 'Y' from HZ_ORG_CONTACTS

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')
1612: and exists
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 )))

Line 1623: (select 'Y' from HZ_ORG_CONTACTS

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')
1622: and exists
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 )))

Line 1633: (select 'Y' from HZ_ORG_CONTACTS

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')
1632: and exists
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 )))

Line 1715: (select 'Y' from HZ_ORG_CONTACTS

1711: or exists (select 'Y' from HZ_PARTY_SITES
1712: xx where xx.PARTY_ID = temp.party_id
1713: and (nvl(STATUS, 'A') in ('A','I'))
1714: and exists
1715: (select 'Y' from HZ_ORG_CONTACTS
1716: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1717: and nvl(STATUS, 'A') in ('A','I')
1718: and exists
1719: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 1725: (select 'Y' from HZ_ORG_CONTACTS

1721: xx where xx.OBJECT_ID = temp.party_id
1722: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1723: AND directional_flag = 'F')
1724: and exists
1725: (select 'Y' from HZ_ORG_CONTACTS
1726: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1727: and nvl(STATUS, 'A') in ('A','I')
1728: and exists
1729: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 1735: (select 'Y' from HZ_ORG_CONTACTS

1731: xx where xx.PARTY_ID = temp.party_id
1732: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1733: AND directional_flag = 'F')
1734: and exists
1735: (select 'Y' from HZ_ORG_CONTACTS
1736: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1737: and nvl(STATUS, 'A') in ('A','I')
1738: and exists
1739: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 1745: (select 'Y' from HZ_ORG_CONTACTS

1741: xx where xx.SUBJECT_ID = temp.party_id
1742: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
1743: AND directional_flag = 'F')
1744: and exists
1745: (select 'Y' from HZ_ORG_CONTACTS
1746: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
1747: and nvl(STATUS, 'A') in ('A','I')
1748: and exists
1749: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 2348: (select 'Y' from HZ_ORG_CONTACTS

2344: or exists (select 'Y' from HZ_PARTY_SITES
2345: xx where xx.PARTY_ID = temp.party_id
2346: and (nvl(STATUS, 'A') in ('A','I'))
2347: and exists
2348: (select 'Y' from HZ_ORG_CONTACTS
2349: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2350: and nvl(STATUS, 'A') in ('A','I')
2351: and exists
2352: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2358: (select 'Y' from HZ_ORG_CONTACTS

2354: xx where xx.OBJECT_ID = temp.party_id
2355: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2356: AND directional_flag = 'F')
2357: and exists
2358: (select 'Y' from HZ_ORG_CONTACTS
2359: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2360: and nvl(STATUS, 'A') in ('A','I')
2361: and exists
2362: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2368: (select 'Y' from HZ_ORG_CONTACTS

2364: xx where xx.PARTY_ID = temp.party_id
2365: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2366: AND directional_flag = 'F')
2367: and exists
2368: (select 'Y' from HZ_ORG_CONTACTS
2369: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2370: and nvl(STATUS, 'A') in ('A','I')
2371: and exists
2372: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2378: (select 'Y' from HZ_ORG_CONTACTS

2374: xx where xx.SUBJECT_ID = temp.party_id
2375: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2376: AND directional_flag = 'F')
2377: and exists
2378: (select 'Y' from HZ_ORG_CONTACTS
2379: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2380: and nvl(STATUS, 'A') in ('A','I')
2381: and exists
2382: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2534: (select 'Y' from HZ_ORG_CONTACTS

2530: or exists (select 'Y' from HZ_PARTY_SITES
2531: xx where xx.PARTY_ID = temp.party_id
2532: and (nvl(STATUS, 'A') in ('A','I'))
2533: and exists
2534: (select 'Y' from HZ_ORG_CONTACTS
2535: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2536: and nvl(STATUS, 'A') in ('A','I')
2537: and exists
2538: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2544: (select 'Y' from HZ_ORG_CONTACTS

2540: xx where xx.OBJECT_ID = temp.party_id
2541: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2542: AND directional_flag = 'F')
2543: and exists
2544: (select 'Y' from HZ_ORG_CONTACTS
2545: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2546: and nvl(STATUS, 'A') in ('A','I')
2547: and exists
2548: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2554: (select 'Y' from HZ_ORG_CONTACTS

2550: xx where xx.PARTY_ID = temp.party_id
2551: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2552: AND directional_flag = 'F')
2553: and exists
2554: (select 'Y' from HZ_ORG_CONTACTS
2555: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2556: and nvl(STATUS, 'A') in ('A','I')
2557: and exists
2558: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2564: (select 'Y' from HZ_ORG_CONTACTS

2560: xx where xx.SUBJECT_ID = temp.party_id
2561: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2562: AND directional_flag = 'F')
2563: and exists
2564: (select 'Y' from HZ_ORG_CONTACTS
2565: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2566: and nvl(STATUS, 'A') in ('A','I')
2567: and exists
2568: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))