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.POS_BATCH_IMPORT_PKG dependencies on HZ_RELATIONSHIPS

Line 975: FROM hz_relationships

971: SELECT relationship_id,
972: party_id
973: INTO l_relationship_id,
974: l_rel_party_id
975: FROM hz_relationships
976: WHERE subject_id = l_org_party_id
977: AND subject_type = 'ORGANIZATION'
978: AND object_id = l_per_party_id
979: AND object_type = 'PERSON';

Line 4081: hz_relationships hzr,

4077: BEGIN
4078: SELECT 1
4079: INTO l_count
4080: FROM ap_suppliers pv,
4081: hz_relationships hzr,
4082: hz_org_contacts hoc
4083: WHERE pv.vendor_id = vendor_contact_rec.vendor_id
4084: AND hzr.relationship_type = 'CONTACT'
4085: AND hzr.relationship_code = 'CONTACT_OF'