APPS.OKS_IB_UTIL_PVT dependencies on PO_VENDOR_CONTACTS

Line 36: po_vendor_contacts c

32: FROM jtf_rs_resource_extns rsc,
33: ap_supplier_sites_all pvs,
34: hz_party_sites hps,
35: hz_locations hl,
36: po_vendor_contacts c
37: WHERE rsc.CATEGORY = 'SUPPLIER_CONTACT'
38: AND c.vendor_contact_id = rsc.source_id
39: AND pvs.vendor_site_id = c.vendor_site_id
40: AND pvs.org_id = p_org_id

Line 92: PO_VENDOR_CONTACTS C

88: SELECT C.LAST_NAME ||' '||c.first_name name, c.phone, c.email_address email
89: FROM
90: JTF_RS_RESOURCE_EXTNS RSC ,
91: PO_VENDOR_SITES_ALL S ,
92: PO_VENDOR_CONTACTS C
93: WHERE
94: RSC.CATEGORY = 'SUPPLIER_CONTACT'
95: AND C.VENDOR_CONTACT_ID = RSC.SOURCE_ID
96: AND S.VENDOR_SITE_ID = C.VENDOR_SITE_ID