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 HZ_CUST_ACCOUNT_ROLES

Line 182: hz_cust_account_roles ROLE,

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
185: AND Party.party_type = 'PERSON'
186: AND Role.current_role_state = 'A'

Line 207: hz_cust_account_roles roles

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'
210: AND party.party_id = roles.party_id
211: AND roles.status ='A'

Line 318: hz_cust_account_roles roles

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'
321: and party.party_id = roles.party_id
322: and roles.status ='A'

Line 409: hz_cust_account_roles con,

405: gCustomerID,
406: gCustomerAddrID
407: from hz_cust_accounts cst,
408: hz_parties cust_party,
409: hz_cust_account_roles con,
410: hz_parties party,
411: hz_parties rel_party,
412: hz_relationships rel,
413: hz_cust_accounts acct