DBA Data[Home] [Help]

APPS.PO_VENDORS_PVT dependencies on PO_VENDOR_CONTACTS

Line 194: from po_vendor_contacts pvc

190: BETWEEN nvl(trunc(user1.start_date), trunc(sysdate))
191: AND nvl(trunc(user1.end_date), trunc(sysdate))
192: and v_vendor_site_id not in
193: (select pvc.vendor_site_id
194: from po_vendor_contacts pvc
195: , ak_web_user_sec_attr_values ak3
196: where ak3.attribute_code='ICX_SUPPLIER_CONTACT_ID'
197: and ak3.web_user_id=ak1.web_user_id
198: and ak3.ATTRIBUTE_APPLICATION_ID=177