[Home] [Help]
129: x_nid_supervisor NUMBER;
130: x_nid_buyer NUMBER;
131:
132: --
133: --This cursor gets the buyer name from po_agent_id in fnd_user
134: --This cursor also gets the last_update_login from fnd_user
135: --This also gets the name for source_line_id.
136: --It fetches only the error rows from QRI.
137: --
130: x_nid_buyer NUMBER;
131:
132: --
133: --This cursor gets the buyer name from po_agent_id in fnd_user
134: --This cursor also gets the last_update_login from fnd_user
135: --This also gets the name for source_line_id.
136: --It fetches only the error rows from QRI.
137: --
138:
141: qr.plan_name, fu1.user_name, qr.organization_code,
142: count(*), qr.creation_date,
143: fu2.user_name, fu3.user_name
144: FROM
145: qa_results_interface qr, fnd_user fu1,
146: fnd_user fu2, fnd_user fu3
147: WHERE
148: qr.source_line_id IS NOT NULL AND
149: qr.process_status = 3 AND
142: count(*), qr.creation_date,
143: fu2.user_name, fu3.user_name
144: FROM
145: qa_results_interface qr, fnd_user fu1,
146: fnd_user fu2, fnd_user fu3
147: WHERE
148: qr.source_line_id IS NOT NULL AND
149: qr.process_status = 3 AND
150: qr.request_id = x_request_id AND
595: -- u_name VARCHAR2(30);
596: u_name VARCHAR2(100);
597: cursor c IS
598: SELECT DISTINCT fu.user_name FROM
599: fnd_user fu
600: WHERE
601: fu.user_id = u_id;
602: BEGIN
603:
781: pvc.area_code || ' ' || pvc.phone contact_phone
782: FROM po_vendors pv,
783: po_vendor_sites_all pvs,
784: po_vendor_contacts pvc
785: --, fnd_user fu
786: WHERE pvc.vendor_site_id = pvs.vendor_site_id AND
787: pvs.vendor_id = pv.vendor_id AND
788: --pvc.vendor_contact_id = fu.supplier_id AND
789: --fu.user_id = s_id
796: --
797: l_supplier_id NUMBER;
798:
799: CURSOR get_supplier_id IS
800: SELECT supplier_id from fnd_user where user_id = s_id;
801: BEGIN
802: --
803: -- bug 7383622
804: -- get the supplier id from the user id