DBA Data[Home] [Help]

APPS.ONT_OIP_COMMON dependencies on HZ_CUST_ACCOUNT_ROLES

Line 45: hz_cust_account_roles roles

41: roles.cust_account_id,
42: nvl(roles.cust_acct_site_id,0)
43: from fnd_user fnd,
44: hz_parties party,
45: hz_cust_account_roles roles
46: where fnd.customer_id = party.party_id
47: and party.party_type='PARTY_RELATIONSHIP'
48: and party.party_id = roles.party_id
49: and roles.status ='A'

Line 117: hz_cust_account_roles con,

113: gCustomerID,
114: gCustomerAddrID
115: from hz_cust_accounts cst,
116: hz_parties cust_party,
117: hz_cust_account_roles con,
118: hz_parties party,
119: hz_parties rel_party,
120: hz_relationships rel,
121: hz_cust_accounts acct