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 87: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id

83:
84: or exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_PARTY_ID = temp.party_id
85: )
86:
87: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id
88: )
89:
90: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
91: )

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

86:
87: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id
88: )
89:
90: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
91: )
92:
93: or exists (select 'Y' from HZ_PARTY_SITES
94: xx where xx.PARTY_ID = temp.party_id

Line 97: (select 'Y' from PV_REFERRALS_B

93: or exists (select 'Y' from HZ_PARTY_SITES
94: xx where xx.PARTY_ID = temp.party_id
95: and (nvl(STATUS, 'A') in ('A','I'))
96: and exists
97: (select 'Y' from PV_REFERRALS_B
98: yy where yy.CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
99: ))
100:
101: or exists (select 'Y' from HZ_PARTY_SITES

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

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

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

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

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

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

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

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 )))
140:
141: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_id
142: )
143:

Line 141: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_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 )))
140:
141: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_id
142: )
143:
144: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.RELATED_PARTY_ID = temp.party_id
145: )

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

182:
183: or exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_PARTY_ID = temp.party_id
184: )
185:
186: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id
187: )
188:
189: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
190: )

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

185:
186: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id
187: )
188:
189: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
190: )
191:
192: or exists (select 'Y' from HZ_PARTY_SITES
193: xx where xx.PARTY_ID = temp.party_id

Line 196: (select 'Y' from PV_REFERRALS_B

192: or exists (select 'Y' from HZ_PARTY_SITES
193: xx where xx.PARTY_ID = temp.party_id
194: and (nvl(STATUS, 'A') in ('A','I'))
195: and exists
196: (select 'Y' from PV_REFERRALS_B
197: yy where yy.CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
198: ))
199:
200: or exists (select 'Y' from HZ_PARTY_SITES

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

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

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

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

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

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

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

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 )))
239:
240: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_id
241: )
242:

Line 240: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_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 )))
239:
240: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_id
241: )
242:
243: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.RELATED_PARTY_ID = temp.party_id
244: )