APPS.ONT_OIP_COMMON dependencies on HZ_PARTIES

Line 181: hz_parties Party,

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

Line 195: AND Rel.subject_table_name = 'HZ_PARTIES'

191: AND Rel.party_id = Role.party_id
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,

Line 206: hz_parties party,

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

Line 223: hz_parties party,

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'
227: AND party.status = 'A'

Line 317: hz_parties party,

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

Line 336: hz_parties party,

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'
340: AND party.status = 'A'

Line 408: hz_parties cust_party,

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

Line 410: hz_parties party,

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

Line 411: hz_parties rel_party,

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
414: where
415: cst.cust_account_id = con.cust_account_id

Line 422: and rel.subject_table_name = 'HZ_PARTIES'

418: and cst.party_id = cust_party.party_id
419: and con.party_id = rel.party_id
420: and con.role_type = 'CONTACT'
421: and rel.subject_id = party.party_id
422: and rel.subject_table_name = 'HZ_PARTIES'
423: and rel.object_table_name = 'HZ_PARTIES'
424: and rel.object_id = acct.party_id
425: and acct.cust_account_id = con.cust_account_id
426: and rel.party_id = rel_party.party_id;

Line 423: and rel.object_table_name = 'HZ_PARTIES'

419: and con.party_id = rel.party_id
420: and con.role_type = 'CONTACT'
421: and rel.subject_id = party.party_id
422: and rel.subject_table_name = 'HZ_PARTIES'
423: and rel.object_table_name = 'HZ_PARTIES'
424: and rel.object_id = acct.party_id
425: and acct.cust_account_id = con.cust_account_id
426: and rel.party_id = rel_party.party_id;
427: