APPS.QA_SS_IMPORT_WF SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

  x_last_updated_name VARCHAR2(80);

Line: 140

     SELECT
     qr.plan_name, fu1.user_name, qr.organization_code,
       count(*), qr.creation_date,
       fu2.user_name, fu3.user_name
       FROM
       qa_results_interface qr, fnd_user fu1,
       fnd_user fu2, fnd_user fu3
       WHERE
       qr.source_line_id IS NOT NULL AND
       qr.process_status = 3 AND
       qr.request_id = x_request_id AND
       qr.source_line_id = fu1.user_id AND
       qr.last_update_login = fu2.user_id AND
       qr.po_agent_id = fu3.employee_id (+)
       GROUP BY
       qr.plan_name, fu1.user_name,
       qr.organization_code ,qr.creation_date,
       fu2.user_name, fu3.user_name;

Line: 172

        x_last_updated_name,
        x_buyer_name;

Line: 183

           (x_last_updated_name,
           itemtype,
           'FAILURE_DETECTED_TO_SUPERVISOR');

Line: 201

           x_last_updated_name,
           x_buyer_name;

Line: 224

   wf_notification.setattrtext(id, 'LAST_UPDATE_LOGIN', x_last_updated_name);

Line: 543

     SELECT qa_ss_notify_workflow_s.nextval FROM dual;

Line: 598

     SELECT DISTINCT fu.user_name FROM
       fnd_user fu
       WHERE
       fu.user_id = u_id;

Line: 622

     SELECT name FROM
       qa_plans qp
       WHERE
       qp.plan_id = p_id;

Line: 647

     SELECT organization_id FROM qa_plans
       WHERE plan_id = x_cursor_plan_id;

Line: 674

     SELECT organization_code
     FROM mtl_parameters -- org_organization_definitions
       WHERE  organization_id = x_cursor_org_id;

Line: 699

     SELECT organization_name
     FROM inv_organization_name_v -- org_organization_definitions
       WHERE  organization_id = x_cursor_org_id;

Line: 723

     SELECT DISTINCT msiv.concatenated_segments FROM
       mtl_system_items_kfv msiv
       WHERE msiv.inventory_item_id = i_id;

Line: 748

     SELECT DISTINCT po.segment1 FROM
       PO_HEADERS_TRX_V po
       WHERE po.po_header_id = p_id;

Line: 779

     SELECT pv.vendor_name,
       pvc.first_name || ' ' || pvc.last_name contact_name,
       pvc.area_code || ' ' || pvc.phone contact_phone
       FROM   po_vendors pv,
       po_vendor_sites_all pvs,
       po_vendor_contacts pvc
       --, fnd_user fu
       WHERE  pvc.vendor_site_id = pvs.vendor_site_id AND
       pvs.vendor_id = pv.vendor_id AND
       --pvc.vendor_contact_id = fu.supplier_id AND
       --fu.user_id = s_id
       pvc.vendor_contact_id = p_supplier_id
       ORDER BY pvc.phone; -- list the ones that have telephone first.

Line: 800

      SELECT supplier_id from fnd_user where user_id = s_id;