APPS.OE_SHIPPING_WF SQL Statements

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

Line: 29

          SELECT item_type_code,ato_line_id,explosion_date
          INTO  l_item_type,l_ato_line_id,l_explosion_date
          FROM  oe_order_lines_all
          WHERE line_id = to_number(itemkey);

Line: 141

            SELECT  nvl(wdd.oe_interfaced_flag, 'N')
            INTO l_if
            FROM wsh_delivery_details wdd
            WHERE wdd.source_line_id = to_number(itemkey)
            AND wdd.source_code = 'OE'
            AND released_status = 'C'  --Added for bug#6727843
            GROUP BY oe_interfaced_flag;

Line: 154

                    SELECT NVL(shipped_quantity,0)
                    INTO l_oe_shipped_quantity
                    FROM oe_order_lines
                    WHERE line_id= to_number(itemkey);

Line: 218

        SELECT line_id, top_model_line_id
               , header_id
               , order_source_id
               , orig_sys_document_ref
               , orig_sys_line_ref
               , orig_sys_shipment_ref
               , change_sequence
               , source_document_type_id
               , source_document_id
               , source_document_line_id
        INTO   l_line_id, l_top_model_line_id
               , l_header_id
               , l_order_source_id
               , l_orig_sys_document_ref
               , l_orig_sys_line_ref
               , l_orig_sys_shipment_ref
               , l_change_sequence
               , l_source_document_type_id
               , l_source_document_id
               , l_source_document_line_id
        FROM   oe_order_lines
        WHERE  line_id = to_number(itemkey);

Line: 271

           SELECT line_id, top_model_line_id
           INTO   l_line_id, l_top_model_line_id
           FROM   oe_order_lines_all
           WHERE  line_id = l_top_model_line_id
           FOR UPDATE NOWAIT;

Line: 283

           SELECT line_id
           INTO   l_line_id
           FROM   oe_order_lines_all
           WHERE  line_id = l_itemkey
           FOR UPDATE NOWAIT;

Line: 347

     insert into ont_wf_skip_log(creation_date, line_id, activity_id, user_id, responsibility_id, application_id) values (sysdate, to_number(itemkey), actid, FND_GLOBAL.user_id, FND_GLOBAL.RESP_ID, FND_GLOBAL.RESP_APPL_ID);

Line: 350

     select header_id
     into l_header_id
     from oe_order_lines_all
     where line_id = to_number(itemkey);

Line: 368

     select employee_id
     into   l_eid
     from fnd_user
     where user_id =l_user_id;

Line: 374

       select name
       into role_name
       from wf_roles
       where orig_system='FND_USR'
       and orig_system_id = l_user_id;

Line: 380

       select name
       into role_name
       from wf_roles
       where orig_system='PER'
       and orig_system_id = l_eid;

Line: 388

     select RESPONSIBILITY_NAME
     into l_resp_name
     from FND_RESPONSIBILITY_VL
     where RESPONSIBILITY_ID=l_resp_id
     and APPLICATION_ID=l_resp_appl_id;

Line: 394

     select APPLICATION_NAME
     into l_appl_name
     from fnd_application_vl
     where APPLICATION_ID = l_resp_appl_id;

Line: 402

   select 1
   into l_validate_user
   from wf_roles
   where name = l_from_role;