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.ONT_OIP_COMMON dependencies on FND_USER

Line 180: FROM fnd_user fnd,

176: Party.email_address UserEmail,
177: Party.party_name CustName,
178: Role.cust_account_id CustomerId,
179: nvl(Role.cust_acct_site_id, 0) CustomerAddrID
180: FROM fnd_user fnd,
181: hz_parties Party,
182: hz_cust_account_roles ROLE,
183: hz_relationships Rel
184: WHERE Party.party_id = fnd.customer_id

Line 196: AND fnd.user_id = pUserId

192: AND Rel.subject_type = 'PERSON'
193: AND (Rel.end_date IS NULL OR Rel.end_date > SYSDATE)
194: AND Rel.status = 'A'
195: AND Rel.subject_table_name = 'HZ_PARTIES'
196: AND fnd.user_id = pUserId
197: UNION
198: SELECT roles.cust_account_role_id,
199: party.person_first_name,
200: party.person_last_name,

Line 205: FROM fnd_user fnd,

201: party.email_address,
202: party.party_name,
203: roles.cust_account_id,
204: nvl(roles.cust_acct_site_id,0)
205: FROM fnd_user fnd,
206: hz_parties party,
207: hz_cust_account_roles roles
208: WHERE fnd.customer_id = party.party_id
209: AND party.party_type='PARTY_RELATIONSHIP'

Line 213: AND fnd.user_id=pUserID

209: AND party.party_type='PARTY_RELATIONSHIP'
210: AND party.party_id = roles.party_id
211: AND roles.status ='A'
212: AND party.status='A'
213: AND fnd.user_id=pUserID
214: UNION
215: SELECT 0 ContactID,
216: party.person_first_name UserFName,
217: party.person_last_name UserLName,

Line 222: FROM fnd_user fnd,

218: party.email_address UserEmail,
219: party.party_name CustName,
220: cust.cust_account_id CustomerId,
221: 0 CustomerAddrID
222: FROM fnd_user fnd,
223: hz_parties party,
224: hz_cust_accounts cust
225: WHERE fnd.customer_id = party.party_id
226: AND party.party_type = 'PERSON'

Line 230: AND fnd.user_id = pUserId;

226: AND party.party_type = 'PERSON'
227: AND party.status = 'A'
228: AND cust.party_id = party.party_id
229: AND cust.status = 'A'
230: AND fnd.user_id = pUserId;
231:
232:
233: lContactId NUMBER;
234: lUserFName VARCHAR2(500);

Line 316: from fnd_user fnd,

312: party.email_address,
313: party.party_name,
314: roles.cust_account_id,
315: nvl(roles.cust_acct_site_id,0)
316: from fnd_user fnd,
317: hz_parties party,
318: hz_cust_account_roles roles
319: where fnd.customer_id = party.party_id
320: and party.party_type='PARTY_RELATIONSHIP'

Line 324: and fnd.user_id=lUserID

320: and party.party_type='PARTY_RELATIONSHIP'
321: and party.party_id = roles.party_id
322: and roles.status ='A'
323: and party.status='A'
324: and fnd.user_id=lUserID
325: UNION -----added the below query for bug# 7456410 ,8467122
326: SELECT
327: Nvl(NULL,0) ,
328: party.person_first_name,

Line 335: fnd_user fnd,

331: party.party_name,
332: cust.cust_account_id ,
333: Nvl(NULL,0)
334: FROM
335: fnd_user fnd,
336: hz_parties party,
337: hz_cust_accounts cust
338: WHERE fnd.customer_id = party.party_id
339: AND party.party_type='PERSON'

Line 342: AND fnd.user_id=lUserID;

338: WHERE fnd.customer_id = party.party_id
339: AND party.party_type='PERSON'
340: AND party.status = 'A'
341: AND cust.party_id=party.party_id
342: AND fnd.user_id=lUserID;
343:
344: --
345: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
346: --