APPS.GMDQC0_WF_P SQL Statements

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

Line: 40

        SELECT NVL(count(*),0) into l_count
          FROM QC_SPEC_MST
         WHERE item_id = p_item_id;

Line: 97

   PROCEDURE select_role(
      /* procedure to set the required attributes and find the role associated.
       input/output parameters conform to WF standard (see WF FAQ) */
      p_itemtype      IN VARCHAR2,
      p_itemkey       IN VARCHAR2,
      p_actid         IN NUMBER,
      p_funcmode      IN VARCHAR2,
      p_resultout     OUT VARCHAR2
   )
   IS
      l_item_id    ic_item_mst.item_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,	'ITEM_ID');

Line: 136

      l_activity_name           VARCHAR2(100):='SELECT_ROLE';

Line: 145

           /* Selecting item details for the item on which the transaction has occured */
           SELECT item_no,item_desc1,item_um,item_um2,whse_item_id
             INTO l_item_no,l_item_desc1,l_item_um,l_item_um2,l_whse_item_id
             FROM ic_item_mst
            WHERE item_id = l_item_id;

Line: 151

           /* Select warehouse item details for the given item */
           SELECT item_no
            INTO  l_whse_item_no
            FROM  ic_item_mst
            WHERE item_id = l_whse_item_id;

Line: 157

           /* Selecting lot details for the transaction occured */
        IF l_lot_id <> 0 THEN
             SELECT lot_no,sublot_no
                INTO l_lot_no,l_sublot_no
                FROM ic_lots_mst
            WHERE lot_id = l_lot_id;

Line: 167

           /* Selecting Organization details from the organization mst */
           SELECT orgn_name
             INTO l_orgn_name
             FROM sy_orgn_mst
            WHERE orgn_code = l_orgn_code;

Line: 173

           /* Selecting Warehouse details from the Warehouse master mst */
           SELECT whse_name
             INTO l_whse_name
             FROM ic_whse_mst
            WHERE whse_code = l_whse_code;

Line: 179

           /* Selecting Document details from Document Master */
           SELECT doc_desc
             INTO l_doc_desc
             FROM sy_docs_mst
            WHERE doc_type = l_doc_type;

Line: 188

             SELECT receipt_num
               INTO l_doc_no
               FROM rcv_shipment_headers
              WHERE shipment_header_id = l_doc_id;

Line: 193

             SELECT recv_no
               INTO l_doc_no
               FROM po_recv_hdr
              WHERE recv_id = l_doc_id;

Line: 198

             SELECT batch_no
               INTO l_doc_no
               FROM pm_btch_hdr
              WHERE batch_id = l_doc_id;

Line: 203

             SELECT journal_no
               INTO l_doc_no
               FROM ic_jrnl_mst
              WHERE journal_id = l_doc_id;

Line: 320

         WF_CORE.CONTEXT ('gmdqc0_wf_p','select_role',p_itemtype,p_itemkey,l_role_name);

Line: 322

END select_role;