APPS.ONT_OIP_COMMON dependencies on HZ_PARTIES

Line 44: hz_parties party,

40: party.party_name,
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

Line 116: hz_parties cust_party,

112: gCustName ,
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,

Line 118: hz_parties party,

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
122: where

Line 119: hz_parties rel_party,

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
122: where
123: cst.cust_account_id = con.cust_account_id

Line 130: and rel.subject_table_name = 'HZ_PARTIES'

126: and cst.party_id = cust_party.party_id
127: and con.party_id = rel.party_id
128: and con.role_type = 'CONTACT'
129: and rel.subject_id = party.party_id
130: and rel.subject_table_name = 'HZ_PARTIES'
131: and rel.object_table_name = 'HZ_PARTIES'
132: and rel.object_id = acct.party_id
133: and acct.cust_account_id = con.cust_account_id
134: and rel.party_id = rel_party.party_id;

Line 131: and rel.object_table_name = 'HZ_PARTIES'

127: and con.party_id = rel.party_id
128: and con.role_type = 'CONTACT'
129: and rel.subject_id = party.party_id
130: and rel.subject_table_name = 'HZ_PARTIES'
131: and rel.object_table_name = 'HZ_PARTIES'
132: and rel.object_id = acct.party_id
133: and acct.cust_account_id = con.cust_account_id
134: and rel.party_id = rel_party.party_id;
135: