DBA Data[Home] [Help]

APPS.POS_SUPP_CONTACT_PKG dependencies on HZ_RELATIONSHIPS

Line 340: p_rel_object_version_number - object version number of the relationship record in hz_relationships

336: p_party_object_version_number - object version number of the relationship record in hz_parties
337: p_email_object_version_number - object version number of the email contact in hz_contact_points
338: p_phone_object_version_number - object version number of the phone contact in hz_contact_points
339: p_fax_object_version_number - object version number of the fax contact in hz_contact_points
340: p_rel_object_version_number - object version number of the relationship record in hz_relationships
341: p_cont_object_version_number - object version number of the hz_org_contacts record
342: p_person_party_obversion_num - object version number of the 'PERSON' party record in hz_parties
343:
344: OUT :

Line 402: FROM hz_org_contacts hoc, hz_relationships hzr, hz_parties hp

398: hzr.object_version_number rel_object_version_number,
399: hzr.party_id,
400: hzr.relationship_id,
401: hp.object_version_number rel_party_obj_ver_num
402: FROM hz_org_contacts hoc, hz_relationships hzr, hz_parties hp
403: WHERE hoc.party_relationship_id = hzr.relationship_id
404: AND hzr.object_table_name = 'HZ_PARTIES'
405: AND hzr.object_id = p_vendor_party_id
406: AND hzr.subject_table_name = 'HZ_PARTIES'