[Home] [Help]
127: x_nid_supervisor NUMBER;
128: x_nid_buyer NUMBER;
129:
130: --
131: --This cursor gets the buyer name from po_agent_id in fnd_user
132: --This cursor also gets the last_update_login from fnd_user
133: --This also gets the name for source_line_id.
134: --It fetches only the error rows from QRI.
135: --
128: x_nid_buyer NUMBER;
129:
130: --
131: --This cursor gets the buyer name from po_agent_id in fnd_user
132: --This cursor also gets the last_update_login from fnd_user
133: --This also gets the name for source_line_id.
134: --It fetches only the error rows from QRI.
135: --
136:
139: qr.plan_name, fu1.user_name, qr.organization_code,
140: count(*), qr.creation_date,
141: fu2.user_name, fu3.user_name
142: FROM
143: qa_results_interface qr, fnd_user fu1,
144: fnd_user fu2, fnd_user fu3
145: WHERE
146: qr.source_line_id IS NOT NULL AND
147: qr.process_status = 3 AND
140: count(*), qr.creation_date,
141: fu2.user_name, fu3.user_name
142: FROM
143: qa_results_interface qr, fnd_user fu1,
144: fnd_user fu2, fnd_user fu3
145: WHERE
146: qr.source_line_id IS NOT NULL AND
147: qr.process_status = 3 AND
148: qr.request_id = x_request_id AND
565: FUNCTION get_user_name(u_id IN NUMBER) RETURN VARCHAR2 IS
566: u_name VARCHAR2(30);
567: cursor c IS
568: SELECT DISTINCT fu.user_name FROM
569: fnd_user fu
570: WHERE
571: fu.user_id = u_id;
572: BEGIN
573:
748: pvc.area_code || ' ' || pvc.phone contact_phone
749: FROM po_vendors pv,
750: po_vendor_sites_all pvs,
751: po_vendor_contacts pvc
752: --, fnd_user fu
753: WHERE pvc.vendor_site_id = pvs.vendor_site_id AND
754: pvs.vendor_id = pv.vendor_id AND
755: --pvc.vendor_contact_id = fu.supplier_id AND
756: --fu.user_id = s_id
763: --
764: l_supplier_id NUMBER;
765:
766: CURSOR get_supplier_id IS
767: SELECT supplier_id from fnd_user where user_id = s_id;
768: BEGIN
769: --
770: -- bug 7383622
771: -- get the supplier id from the user id