APPS.GMI_WF_LOT_RETEST SQL Statements

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

Line: 63

                          ( SELECT  retest_role_name,retest_role_display_name,NVL(lot_retest_note,0)
         		    FROM    sy_wf_item_roles
         		    WHERE   whse_item_id = c_whse_item_id);

Line: 67

                          ( SELECT  retest_role_name,retest_role_display_name,NVL(lot_retest_note,0)
         		    FROM    sy_wf_item_roles
         		    WHERE   item_id = c_item_id);

Line: 72

                          ( SELECT whse_item_id
                            FROM ic_item_mst
			    WHERE item_id = c_item_id);

Line: 76

      SELECT sysdate
      INTO   l_wf_start_date
      FROM   dual;

Line: 80

      SELECT USER_NAME , DESCRIPTION
      INTO   l_performer_name ,l_performer_display_name
      FROM   FND_USER
      WHERE  USER_ID = p_created_by ;

Line: 85

      SELECT item_no , item_desc1 ,item_um ,item_um2 , dualum_ind
      INTO   l_item_no ,l_item_desc1 ,l_item_um ,l_item_um2 ,l_dualum_ind
      FROM   ic_item_mst
      WHERE  item_id = p_item_id ;

Line: 178

            so default to previously-selected FND_USER values */
            WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
               itemkey => l_itemkey,
               aname => 'PERNAME',
               avalue => l_performer_name);

Line: 327

         SELECT  COUNT(*)
         INTO    l_count_lots_mst
         FROM    ic_lots_mst
         WHERE   lot_id = l_lot_id
         AND     delete_mark = 0 ;

Line: 340

               SELECT  nvl(SUM(loct_onhand),0) , nvl(SUM(loct_onhand2),0)
               INTO    l_sum_loct_onhand, l_sum_loct_onhand2
               FROM    ic_loct_inv
               WHERE   lot_id = l_lot_id;