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_ORG_CONTACTS

Line 890: in hz_org_contacts is obsoleted in R12 ,Also checking for */

886:
887: l_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;
888:
889: /* Bug 6610366 , Checking the Status from hz_relationships as status column
890: in hz_org_contacts is obsoleted in R12 ,Also checking for */
891:
892: CURSOR l_cur3 IS
893: SELECT hzr.relationship_id, hzr.party_id rel_party_id, hoc.org_contact_id
894: FROM ap_suppliers pv, hz_relationships hzr, hz_org_contacts hoc

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

890: in hz_org_contacts is obsoleted in R12 ,Also checking for */
891:
892: CURSOR l_cur3 IS
893: SELECT hzr.relationship_id, hzr.party_id rel_party_id, hoc.org_contact_id
894: FROM ap_suppliers pv, hz_relationships hzr, hz_org_contacts hoc
895: WHERE pv.vendor_id = p_vendor_id
896: AND hzr.relationship_type = 'CONTACT'
897: AND hzr.relationship_code = 'CONTACT_OF'
898: AND hzr.subject_id = p_contact_party_id