[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select vendor_id
into l_vendor_id
from pos_supplier_users_v
where user_name = p_username;
select DISTINCT user1.user_name
from fnd_user user1,
ak_web_user_sec_attr_values ak1,
fnd_user_resp_groups fur
where ak1.attribute_code='ICX_SUPPLIER_ORG_ID'
and ak1.number_value=v_vendor_id
and ak1.ATTRIBUTE_APPLICATION_ID=177
and ak1.web_user_id=user1.user_id
and fur.responsibility_application_id = 177
and fur.start_date < sysdate
and nvl(fur.end_date, sysdate + 1) >= sysdate
and fur.user_id = user1.user_id
and trunc(sysdate)
BETWEEN nvl(trunc(user1.start_date), trunc(sysdate))
AND nvl(trunc(user1.end_date), trunc(sysdate))
and not exists(
select 1
from ak_web_user_sec_attr_values ak2
where ak2.attribute_code='ICX_SUPPLIER_CONTACT_ID'
and ak2.web_user_id=ak1.web_user_id
and ak2.ATTRIBUTE_APPLICATION_ID=177)
and not exists(
select 1
from ak_web_user_sec_attr_values ak3
where ak3.attribute_code='ICX_SUPPLIER_SITE_ID'
and ak3.web_user_id=ak1.web_user_id
and ak3.ATTRIBUTE_APPLICATION_ID=177)
order by user1.user_name;
select DISTINCT user1.user_name
from fnd_user user1,
ak_web_user_sec_attr_values ak1,
ak_web_user_sec_attr_values ak2,
fnd_user_resp_groups fur
where
user1.user_id=ak1.web_user_id
and ak1.attribute_code='ICX_SUPPLIER_ORG_ID'
and ak1.number_value=v_vendor_id
and ak1.ATTRIBUTE_APPLICATION_ID=177
and ak2.attribute_code='ICX_SUPPLIER_SITE_ID'
and ak2.number_value=v_vendor_site_id
and ak2.ATTRIBUTE_APPLICATION_ID=177
and ak1.web_user_id=ak2.web_user_id
and fur.responsibility_application_id = 177
and fur.user_id = user1.user_id
and fur.start_date < sysdate
and nvl(fur.end_date, sysdate + 1) >= sysdate
and trunc(sysdate)
BETWEEN nvl(trunc(user1.start_date), trunc(sysdate))
AND nvl(trunc(user1.end_date), trunc(sysdate))
and v_vendor_site_id not in
(select pvc.vendor_site_id
from po_vendor_contacts pvc
, ak_web_user_sec_attr_values ak3
where ak3.attribute_code='ICX_SUPPLIER_CONTACT_ID'
and ak3.web_user_id=ak1.web_user_id
and ak3.ATTRIBUTE_APPLICATION_ID=177
and ak3.number_value=pvc.vendor_contact_id)
order by user1.user_name;
select DISTINCT user1.user_name
from fnd_user user1,
ak_web_user_sec_attr_values ak1,
ak_web_user_sec_attr_values ak3,
fnd_user_resp_groups fur
where user1.user_id=ak1.web_user_id
and ak1.attribute_code='ICX_SUPPLIER_ORG_ID'
and ak1.number_value=v_vendor_id
and ak1.ATTRIBUTE_APPLICATION_ID=177
and ak3.attribute_code='ICX_SUPPLIER_CONTACT_ID'
and ak3.number_value=v_vendor_contact_id
and ak3.ATTRIBUTE_APPLICATION_ID=177
and ak1.web_user_id=ak3.web_user_id
and fur.responsibility_application_id = 177
and fur.user_id = user1.user_id
and fur.start_date < sysdate
and nvl(fur.end_date, sysdate + 1) >= sysdate
and trunc(sysdate)
BETWEEN nvl(trunc(user1.start_date), trunc(sysdate))
AND nvl(trunc(user1.end_date), trunc(sysdate))
order by user1.user_name;
select DECODE(p_external_contact_id, null, vendor_contact_id, p_external_contact_id) vendor_contact_id
,vendor_site_id, vendor_id, to_char(revision_num)
into l_vendor_contact_id
,l_vendor_site_id, l_vendor_id, l_temp
from po_headers_all
where po_header_id = to_number(p_document_id);
select poh.vendor_contact_id
,poh.vendor_site_id, poh.vendor_id
, to_char(por.revision_num)
into l_vendor_contact_id
,l_vendor_site_id, l_vendor_id
, l_temp
from po_releases por, po_headers poh
where por.po_release_id = to_number(p_document_id)
and por.po_header_id = poh.po_header_id;
select vendor_contact_id, vendor_site_id
, vendor_id, to_char(null)
into l_vendor_contact_id, l_vendor_site_id
, l_vendor_id, l_temp
from po_requisition_suppliers
where requisition_supplier_id = to_number(p_document_id);
select vendor_contact_id, vendor_site_id, vendor_id, to_char(null)
into l_vendor_contact_id, l_vendor_site_id, l_vendor_id, l_temp
from po_requisition_lines_all
where requisition_line_id = to_number(p_document_id);