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_RELATIONSHIPS

Line 93: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
93: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 103: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
103: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 113: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
113: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 192: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
192: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 202: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
202: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 212: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
212: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 293: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.OBJECT_ID = temp.party_id

289:
290: or exists (select 'Y' from HZ_ORGANIZATION_PROFILES xx where xx.DISPLAYED_DUNS_PARTY_ID = temp.party_id
291: and (nvl(STATUS, 'A') in ('A','I')))
292:
293: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.OBJECT_ID = temp.party_id
294: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
295: AND directional_flag = 'F'))
296:
297: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.SUBJECT_ID = temp.party_id

Line 297: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.SUBJECT_ID = temp.party_id

293: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.OBJECT_ID = temp.party_id
294: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
295: AND directional_flag = 'F'))
296:
297: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.SUBJECT_ID = temp.party_id
298: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
299: AND directional_flag = 'F'));
300: else
301: delete from hz_purge_gt temp where

Line 324: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.OBJECT_ID = temp.party_id

320:
321: or exists (select 'Y' from HZ_ORGANIZATION_PROFILES xx where xx.DISPLAYED_DUNS_PARTY_ID = temp.party_id
322: and (nvl(STATUS, 'A') in ('A','I')))
323:
324: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.OBJECT_ID = temp.party_id
325: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
326: AND directional_flag = 'F'))
327:
328: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.SUBJECT_ID = temp.party_id

Line 328: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.SUBJECT_ID = temp.party_id

324: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.OBJECT_ID = temp.party_id
325: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
326: AND directional_flag = 'F'))
327:
328: or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.SUBJECT_ID = temp.party_id
329: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
330: AND directional_flag = 'F'));
331: end if;
332:

Line 1112: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
1112: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 1122: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
1122: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 1132: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
1132: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 1186: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1196: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1206: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1298: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1308: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1318: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1431: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
1431: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 1441: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
1441: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 1451: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
1451: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 1505: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1515: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1525: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1617: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1627: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 1637: or exists (select 'Y' from HZ_RELATIONSHIPS

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

Line 2049: exists (select 'Y' from HZ_RELATIONSHIPS

2045: if(regid_proc = true) then
2046: insert into hz_application_trans_gt(app_id,party_id) select 200, temp.party_id from hz_purge_gt temp where
2047:
2048:
2049: exists (select 'Y' from HZ_RELATIONSHIPS
2050: xx where xx.OBJECT_ID = temp.party_id
2051: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2052: AND directional_flag = 'F')
2053: and exists

Line 2057: or exists (select 'Y' from HZ_RELATIONSHIPS

2053: and exists
2054: (select 'Y' from AP_SUPPLIER_CONTACTS
2055: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2056: ))
2057: or exists (select 'Y' from HZ_RELATIONSHIPS
2058: xx where xx.PARTY_ID = temp.party_id
2059: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2060: AND directional_flag = 'F')
2061: and exists

Line 2065: or exists (select 'Y' from HZ_RELATIONSHIPS

2061: and exists
2062: (select 'Y' from AP_SUPPLIER_CONTACTS
2063: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2064: ))
2065: or exists (select 'Y' from HZ_RELATIONSHIPS
2066: xx where xx.SUBJECT_ID = temp.party_id
2067: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2068: AND directional_flag = 'F')
2069: and exists

Line 2083: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
2083: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2093: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
2093: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2103: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
2103: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2131: exists (select 'Y' from HZ_RELATIONSHIPS

2127: else
2128: delete from hz_purge_gt temp where
2129:
2130:
2131: exists (select 'Y' from HZ_RELATIONSHIPS
2132: xx where xx.OBJECT_ID = temp.party_id
2133: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2134: AND directional_flag = 'F')
2135: and exists

Line 2139: or exists (select 'Y' from HZ_RELATIONSHIPS

2135: and exists
2136: (select 'Y' from AP_SUPPLIER_CONTACTS
2137: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2138: ))
2139: or exists (select 'Y' from HZ_RELATIONSHIPS
2140: xx where xx.PARTY_ID = temp.party_id
2141: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2142: AND directional_flag = 'F')
2143: and exists

Line 2147: or exists (select 'Y' from HZ_RELATIONSHIPS

2143: and exists
2144: (select 'Y' from AP_SUPPLIER_CONTACTS
2145: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2146: ))
2147: or exists (select 'Y' from HZ_RELATIONSHIPS
2148: xx where xx.SUBJECT_ID = temp.party_id
2149: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2150: AND directional_flag = 'F')
2151: and exists

Line 2165: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
2165: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2175: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
2175: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2185: or exists (select 'Y' from HZ_RELATIONSHIPS

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 )))
2185: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2430: or exists (select 'Y' from HZ_RELATIONSHIPS

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' ))))
2430: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2440: or exists (select 'Y' from HZ_RELATIONSHIPS

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' ))))
2440: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2450: or exists (select 'Y' from HZ_RELATIONSHIPS

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' ))))
2450: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2624: or exists (select 'Y' from HZ_RELATIONSHIPS

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' ))))
2624: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2634: or exists (select 'Y' from HZ_RELATIONSHIPS

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' ))))
2634: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 2644: or exists (select 'Y' from HZ_RELATIONSHIPS

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' ))))
2644: or exists (select 'Y' from HZ_RELATIONSHIPS
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

Line 3553: temp.party_id in (select /+ parallel (xx)/ xx.OBJECT_ID from HZ_RELATIONSHIPS

3549: appid:=177;
3550: if(regid_proc = true) then
3551: insert into hz_application_trans_gt(app_id,party_id) select 177, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 177 and appl.party_id=temp.party_id) and
3552:
3553: temp.party_id in (select /*+ parallel (xx)*/ xx.OBJECT_ID from HZ_RELATIONSHIPS
3554: xx
3555: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3556: AND directional_flag = 'F')
3557: and xx.RELATIONSHIP_ID

Line 3561: or temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_RELATIONSHIPS

3557: and xx.RELATIONSHIP_ID
3558: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3559: yy
3560: ))
3561: or temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_RELATIONSHIPS
3562: xx
3563: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3564: AND directional_flag = 'F')
3565: and xx.RELATIONSHIP_ID

Line 3569: or temp.party_id in (select /+ parallel (xx)/ xx.SUBJECT_ID from HZ_RELATIONSHIPS

3565: and xx.RELATIONSHIP_ID
3566: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3567: yy
3568: ))
3569: or temp.party_id in (select /*+ parallel (xx)*/ xx.SUBJECT_ID from HZ_RELATIONSHIPS
3570: xx
3571: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3572: AND directional_flag = 'F')
3573: and xx.RELATIONSHIP_ID

Line 3579: temp.party_id in (select /+ parallel (xx)/ xx.OBJECT_ID from HZ_RELATIONSHIPS

3575: yy
3576: ));
3577: else
3578: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3579: temp.party_id in (select /*+ parallel (xx)*/ xx.OBJECT_ID from HZ_RELATIONSHIPS
3580: xx
3581: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3582: AND directional_flag = 'F')
3583: and xx.RELATIONSHIP_ID

Line 3587: or temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_RELATIONSHIPS

3583: and xx.RELATIONSHIP_ID
3584: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3585: yy
3586: ))
3587: or temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_RELATIONSHIPS
3588: xx
3589: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3590: AND directional_flag = 'F')
3591: and xx.RELATIONSHIP_ID

Line 3595: or temp.party_id in (select /+ parallel (xx)/ xx.SUBJECT_ID from HZ_RELATIONSHIPS

3591: and xx.RELATIONSHIP_ID
3592: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3593: yy
3594: ))
3595: or temp.party_id in (select /*+ parallel (xx)*/ xx.SUBJECT_ID from HZ_RELATIONSHIPS
3596: xx
3597: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3598: AND directional_flag = 'F')
3599: and xx.RELATIONSHIP_ID