APPS.PO_VENDORS_PVT dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 141: ak_web_user_sec_attr_values ak1,

137: -- cursor to select vendor level contacts
138: cursor vendor_only_username(v_vendor_id NUMBER) IS
139: select DISTINCT user1.user_name
140: from fnd_user user1,
141: ak_web_user_sec_attr_values ak1,
142: fnd_user_resp_groups fur
143: where ak1.attribute_code='ICX_SUPPLIER_ORG_ID'
144: and ak1.number_value=v_vendor_id
145: and ak1.ATTRIBUTE_APPLICATION_ID=177

Line 156: from ak_web_user_sec_attr_values ak2

152: BETWEEN nvl(trunc(user1.start_date), trunc(sysdate))
153: AND nvl(trunc(user1.end_date), trunc(sysdate))
154: and not exists(
155: select 1
156: from ak_web_user_sec_attr_values ak2
157: where ak2.attribute_code='ICX_SUPPLIER_CONTACT_ID'
158: and ak2.web_user_id=ak1.web_user_id
159: and ak2.ATTRIBUTE_APPLICATION_ID=177)
160: and not exists(

Line 162: from ak_web_user_sec_attr_values ak3

158: and ak2.web_user_id=ak1.web_user_id
159: and ak2.ATTRIBUTE_APPLICATION_ID=177)
160: and not exists(
161: select 1
162: from ak_web_user_sec_attr_values ak3
163: where ak3.attribute_code='ICX_SUPPLIER_SITE_ID'
164: and ak3.web_user_id=ak1.web_user_id
165: and ak3.ATTRIBUTE_APPLICATION_ID=177)
166: order by user1.user_name;

Line 173: ak_web_user_sec_attr_values ak1,

169: cursor vendor_site_username(v_vendor_id NUMBER
170: , v_vendor_site_id number) IS
171: select DISTINCT user1.user_name
172: from fnd_user user1,
173: ak_web_user_sec_attr_values ak1,
174: ak_web_user_sec_attr_values ak2,
175: fnd_user_resp_groups fur
176: where
177: user1.user_id=ak1.web_user_id

Line 174: ak_web_user_sec_attr_values ak2,

170: , v_vendor_site_id number) IS
171: select DISTINCT user1.user_name
172: from fnd_user user1,
173: ak_web_user_sec_attr_values ak1,
174: ak_web_user_sec_attr_values ak2,
175: fnd_user_resp_groups fur
176: where
177: user1.user_id=ak1.web_user_id
178: and ak1.attribute_code='ICX_SUPPLIER_ORG_ID'

Line 195: , ak_web_user_sec_attr_values ak3

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
199: and ak3.number_value=pvc.vendor_contact_id)

Line 207: ak_web_user_sec_attr_values ak1,

203: cursor vendor_contact_username(v_vendor_id NUMBER
204: , v_vendor_contact_id NUMBER) IS
205: select DISTINCT user1.user_name
206: from fnd_user user1,
207: ak_web_user_sec_attr_values ak1,
208: ak_web_user_sec_attr_values ak3,
209: fnd_user_resp_groups fur
210: where user1.user_id=ak1.web_user_id
211: and ak1.attribute_code='ICX_SUPPLIER_ORG_ID'

Line 208: ak_web_user_sec_attr_values ak3,

204: , v_vendor_contact_id NUMBER) IS
205: select DISTINCT user1.user_name
206: from fnd_user user1,
207: ak_web_user_sec_attr_values ak1,
208: ak_web_user_sec_attr_values ak3,
209: fnd_user_resp_groups fur
210: where user1.user_id=ak1.web_user_id
211: and ak1.attribute_code='ICX_SUPPLIER_ORG_ID'
212: and ak1.number_value=v_vendor_id