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_SUPPLIER_ADDRESS_PKG dependencies on HZ_RELATIONSHIPS

Line 1065: /* Bug 6610366 , Checking the Status from hz_relationships as status column

1061: l_number NUMBER;
1062:
1063: l_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;
1064:
1065: /* Bug 6610366 , Checking the Status from hz_relationships as status column
1066: in hz_org_contacts is obsoleted in R12 ,Also checking for */
1067:
1068: CURSOR l_cur3 IS
1069: SELECT hzr.relationship_id, hzr.party_id rel_party_id, hoc.org_contact_id

Line 1070: FROM ap_suppliers pv, hz_relationships hzr, hz_org_contacts hoc

1066: in hz_org_contacts is obsoleted in R12 ,Also checking for */
1067:
1068: CURSOR l_cur3 IS
1069: SELECT hzr.relationship_id, hzr.party_id rel_party_id, hoc.org_contact_id
1070: FROM ap_suppliers pv, hz_relationships hzr, hz_org_contacts hoc
1071: WHERE pv.vendor_id = p_vendor_id
1072: AND hzr.relationship_type = 'CONTACT'
1073: AND hzr.relationship_code = 'CONTACT_OF'
1074: AND hzr.subject_id = p_contact_party_id