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 88: (select 'Y' from HZ_ORG_CONTACTS

84: or exists (select 'Y' from HZ_PARTY_SITES
85: xx where xx.PARTY_ID = temp.party_id
86: and (nvl(STATUS, 'A') in ('A','I'))
87: and exists
88: (select 'Y' from HZ_ORG_CONTACTS
89: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
90: and nvl(STATUS, 'A') in ('A','I')
91: and exists
92: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 98: (select 'Y' from HZ_ORG_CONTACTS

94: xx where xx.OBJECT_ID = temp.party_id
95: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
96: AND directional_flag = 'F')
97: and exists
98: (select 'Y' from HZ_ORG_CONTACTS
99: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
100: and nvl(STATUS, 'A') in ('A','I')
101: and exists
102: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 108: (select 'Y' from HZ_ORG_CONTACTS

104: xx where xx.PARTY_ID = temp.party_id
105: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
106: AND directional_flag = 'F')
107: and exists
108: (select 'Y' from HZ_ORG_CONTACTS
109: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
110: and nvl(STATUS, 'A') in ('A','I')
111: and exists
112: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 118: (select 'Y' from HZ_ORG_CONTACTS

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

Line 187: (select 'Y' from HZ_ORG_CONTACTS

183: or exists (select 'Y' from HZ_PARTY_SITES
184: xx where xx.PARTY_ID = temp.party_id
185: and (nvl(STATUS, 'A') in ('A','I'))
186: and exists
187: (select 'Y' from HZ_ORG_CONTACTS
188: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
189: and nvl(STATUS, 'A') in ('A','I')
190: and exists
191: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 197: (select 'Y' from HZ_ORG_CONTACTS

193: xx where xx.OBJECT_ID = temp.party_id
194: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
195: AND directional_flag = 'F')
196: and exists
197: (select 'Y' from HZ_ORG_CONTACTS
198: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
199: and nvl(STATUS, 'A') in ('A','I')
200: and exists
201: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 207: (select 'Y' from HZ_ORG_CONTACTS

203: xx where xx.PARTY_ID = temp.party_id
204: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
205: AND directional_flag = 'F')
206: and exists
207: (select 'Y' from HZ_ORG_CONTACTS
208: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
209: and nvl(STATUS, 'A') in ('A','I')
210: and exists
211: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 217: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1107: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1117: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1127: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1137: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1181: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1191: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1201: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1211: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1293: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1303: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1313: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1323: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1426: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1436: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1446: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1456: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1500: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1510: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1520: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1530: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1612: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1622: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1632: (select 'Y' from HZ_ORG_CONTACTS

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

Line 1642: (select 'Y' from HZ_ORG_CONTACTS

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

Line 2078: (select 'Y' from HZ_ORG_CONTACTS

2074: or exists (select 'Y' from HZ_PARTY_SITES
2075: xx where xx.PARTY_ID = temp.party_id
2076: and (nvl(STATUS, 'A') in ('A','I'))
2077: and exists
2078: (select 'Y' from HZ_ORG_CONTACTS
2079: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2080: and nvl(STATUS, 'A') in ('A','I')
2081: and exists
2082: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 2088: (select 'Y' from HZ_ORG_CONTACTS

2084: xx where xx.OBJECT_ID = temp.party_id
2085: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2086: AND directional_flag = 'F')
2087: and exists
2088: (select 'Y' from HZ_ORG_CONTACTS
2089: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2090: and nvl(STATUS, 'A') in ('A','I')
2091: and exists
2092: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 2098: (select 'Y' from HZ_ORG_CONTACTS

2094: xx where xx.PARTY_ID = temp.party_id
2095: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2096: AND directional_flag = 'F')
2097: and exists
2098: (select 'Y' from HZ_ORG_CONTACTS
2099: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2100: and nvl(STATUS, 'A') in ('A','I')
2101: and exists
2102: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 2108: (select 'Y' from HZ_ORG_CONTACTS

2104: xx where xx.SUBJECT_ID = temp.party_id
2105: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2106: AND directional_flag = 'F')
2107: and exists
2108: (select 'Y' from HZ_ORG_CONTACTS
2109: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2110: and nvl(STATUS, 'A') in ('A','I')
2111: and exists
2112: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 2160: (select 'Y' from HZ_ORG_CONTACTS

2156: or exists (select 'Y' from HZ_PARTY_SITES
2157: xx where xx.PARTY_ID = temp.party_id
2158: and (nvl(STATUS, 'A') in ('A','I'))
2159: and exists
2160: (select 'Y' from HZ_ORG_CONTACTS
2161: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2162: and nvl(STATUS, 'A') in ('A','I')
2163: and exists
2164: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 2170: (select 'Y' from HZ_ORG_CONTACTS

2166: xx where xx.OBJECT_ID = temp.party_id
2167: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2168: AND directional_flag = 'F')
2169: and exists
2170: (select 'Y' from HZ_ORG_CONTACTS
2171: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2172: and nvl(STATUS, 'A') in ('A','I')
2173: and exists
2174: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 2180: (select 'Y' from HZ_ORG_CONTACTS

2176: xx where xx.PARTY_ID = temp.party_id
2177: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2178: AND directional_flag = 'F')
2179: and exists
2180: (select 'Y' from HZ_ORG_CONTACTS
2181: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2182: and nvl(STATUS, 'A') in ('A','I')
2183: and exists
2184: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 2190: (select 'Y' from HZ_ORG_CONTACTS

2186: xx where xx.SUBJECT_ID = temp.party_id
2187: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2188: AND directional_flag = 'F')
2189: and exists
2190: (select 'Y' from HZ_ORG_CONTACTS
2191: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2192: and nvl(STATUS, 'A') in ('A','I')
2193: and exists
2194: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

Line 2425: (select 'Y' from HZ_ORG_CONTACTS

2421: or exists (select 'Y' from HZ_PARTY_SITES
2422: xx where xx.PARTY_ID = temp.party_id
2423: and (nvl(STATUS, 'A') in ('A','I'))
2424: and exists
2425: (select 'Y' from HZ_ORG_CONTACTS
2426: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2427: and nvl(STATUS, 'A') in ('A','I')
2428: and exists
2429: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2435: (select 'Y' from HZ_ORG_CONTACTS

2431: xx where xx.OBJECT_ID = temp.party_id
2432: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2433: AND directional_flag = 'F')
2434: and exists
2435: (select 'Y' from HZ_ORG_CONTACTS
2436: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2437: and nvl(STATUS, 'A') in ('A','I')
2438: and exists
2439: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2445: (select 'Y' from HZ_ORG_CONTACTS

2441: xx where xx.PARTY_ID = temp.party_id
2442: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2443: AND directional_flag = 'F')
2444: and exists
2445: (select 'Y' from HZ_ORG_CONTACTS
2446: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2447: and nvl(STATUS, 'A') in ('A','I')
2448: and exists
2449: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2455: (select 'Y' from HZ_ORG_CONTACTS

2451: xx where xx.SUBJECT_ID = temp.party_id
2452: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2453: AND directional_flag = 'F')
2454: and exists
2455: (select 'Y' from HZ_ORG_CONTACTS
2456: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2457: and nvl(STATUS, 'A') in ('A','I')
2458: and exists
2459: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2619: (select 'Y' from HZ_ORG_CONTACTS

2615: or exists (select 'Y' from HZ_PARTY_SITES
2616: xx where xx.PARTY_ID = temp.party_id
2617: and (nvl(STATUS, 'A') in ('A','I'))
2618: and exists
2619: (select 'Y' from HZ_ORG_CONTACTS
2620: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2621: and nvl(STATUS, 'A') in ('A','I')
2622: and exists
2623: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2629: (select 'Y' from HZ_ORG_CONTACTS

2625: xx where xx.OBJECT_ID = temp.party_id
2626: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2627: AND directional_flag = 'F')
2628: and exists
2629: (select 'Y' from HZ_ORG_CONTACTS
2630: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2631: and nvl(STATUS, 'A') in ('A','I')
2632: and exists
2633: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2639: (select 'Y' from HZ_ORG_CONTACTS

2635: xx where xx.PARTY_ID = temp.party_id
2636: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2637: AND directional_flag = 'F')
2638: and exists
2639: (select 'Y' from HZ_ORG_CONTACTS
2640: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2641: and nvl(STATUS, 'A') in ('A','I')
2642: and exists
2643: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

Line 2649: (select 'Y' from HZ_ORG_CONTACTS

2645: xx where xx.SUBJECT_ID = temp.party_id
2646: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2647: AND directional_flag = 'F')
2648: and exists
2649: (select 'Y' from HZ_ORG_CONTACTS
2650: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2651: and nvl(STATUS, 'A') in ('A','I')
2652: and exists
2653: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))