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 PV_REFERRALS_B

Line 70: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id

66:
67: or exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_PARTY_ID = temp.party_id
68: )
69:
70: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id
71: )
72:
73: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
74: )

Line 73: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id

69:
70: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id
71: )
72:
73: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
74: )
75:
76: or exists (select 'Y' from HZ_PARTY_SITES
77: xx where xx.PARTY_ID = temp.party_id

Line 80: (select 'Y' from PV_REFERRALS_B

76: or exists (select 'Y' from HZ_PARTY_SITES
77: xx where xx.PARTY_ID = temp.party_id
78: and (nvl(STATUS, 'A') in ('A','I'))
79: and exists
80: (select 'Y' from PV_REFERRALS_B
81: yy where yy.CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
82: ))
83:
84: or exists (select 'Y' from HZ_PARTY_SITES

Line 92: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

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 )))
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')

Line 102: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

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 )))
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')

Line 112: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

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 )))
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')

Line 122: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

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 )))
123:
124: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_id
125: )
126:

Line 124: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_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 )))
123:
124: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_id
125: )
126:
127: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.RELATED_PARTY_ID = temp.party_id
128: )

Line 169: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id

165:
166: or exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_PARTY_ID = temp.party_id
167: )
168:
169: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id
170: )
171:
172: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
173: )

Line 172: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id

168:
169: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id
170: )
171:
172: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
173: )
174:
175: or exists (select 'Y' from HZ_PARTY_SITES
176: xx where xx.PARTY_ID = temp.party_id

Line 179: (select 'Y' from PV_REFERRALS_B

175: or exists (select 'Y' from HZ_PARTY_SITES
176: xx where xx.PARTY_ID = temp.party_id
177: and (nvl(STATUS, 'A') in ('A','I'))
178: and exists
179: (select 'Y' from PV_REFERRALS_B
180: yy where yy.CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
181: ))
182:
183: or exists (select 'Y' from HZ_PARTY_SITES

Line 191: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

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 )))
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')

Line 201: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

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 )))
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')

Line 211: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

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 )))
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')

Line 221: (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

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 )))
222:
223: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_id
224: )
225:

Line 223: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_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 )))
222:
223: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_id
224: )
225:
226: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.RELATED_PARTY_ID = temp.party_id
227: )