DBA Data[Home] [Help]

APPS.POS_VENDOR_UTIL_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 164: FROM ak_web_user_sec_attr_values akw, ap_supplier_sites_all pvs

160: AND ROWNUM < 3;
161:
162: CURSOR l_invalid_site_cur IS
163: SELECT akw.number_value
164: FROM ak_web_user_sec_attr_values akw, ap_supplier_sites_all pvs
165: WHERE akw.web_user_id = p_user_id
166: AND akw.attribute_code = 'ICX_SUPPLIER_SITE_ID'
167: AND akw.attribute_application_id = 177
168: AND akw.number_value = pvs.vendor_site_id

Line 185: FROM ap_supplier_sites_all

181: AND akw.attribute_application_id = 177
182: AND akw.number_value = pvc.vendor_contact_id
183: AND pvc.vendor_site_id not in
184: (SELECT vendor_site_id
185: FROM ap_supplier_sites_all
186: WHERE vendor_id in
187: (select vendor_id
188: from ap_suppliers
189: start with vendor_id = l_root_vendor_id