APPS.OE_WF_UPGRADE_UTIL SQL Statements

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

Line: 313

		    update oe_order_lines_all
		    set flow_status_code = decode(source_type_code, 'EXTERNAL', 'SHIPPED', 'SHIPPED')
		    where line_id = to_number(itemkey);

Line: 318

              update oe_order_lines_all
              set flow_status_code = decode(source_type_code, 'EXTERNAL', 'AWAITING_RECEIPT', 'AWAITING_SHIPPING')
              where line_id = to_number(itemkey);

Line: 397

		select source_type_code
		into   l_source_type_code
		from   oe_order_lines_all
		where  line_id = to_number(itemkey);

Line: 479

		    update oe_order_lines_all
		    set flow_status_code = 'RETURNED'
		    where line_id = to_number(itemkey);

Line: 484

              update oe_order_lines_all
              set flow_status_code = 'AWAITING_RETURN'
              where line_id = to_number(itemkey);

Line: 565

          Select shipped_quantity,fulfilled_quantity
		into l_shipped_quantity,l_fulfilled_quantity
		from oe_order_lines_all
		where line_id = to_number(itemkey);

Line: 655

		    update oe_order_lines_all
		    set flow_status_code = 'INVOICED'
		    where line_id = to_number(itemkey);

Line: 663

              update oe_order_lines_all
              set flow_status_code = 'INVOICED_PARTIAL'
              where line_id = to_number(itemkey);

Line: 924

             update oe_order_lines_all
		   set flow_status_code = 'SCHEDULED'
		   where line_id = to_number(itemkey);

Line: 1031

              SELECT item_type_code, ato_line_id
              INTO   l_item_type_code, l_ato_line_id
              FROM   OE_ORDER_LINES_ALL
              WHERE  line_id = to_number(itemkey);

Line: 1040

                update oe_order_lines_all
                set flow_status_code =  'BOOKED'
                where line_id = to_number(itemkey);

Line: 1044

                update oe_order_lines_all
                set flow_status_code =  'PRODUCTION_COMPLETE'
                where line_id = to_number(itemkey);

Line: 1121

                  We do not need to update flow status here.
                  A check later will do it. ex: chk_mfg_release_status
                  will update the status.
----------------------------------------------------------------------- */

PROCEDURE IS_LINE_PAST_MFG_RELEASE(
	itemtype  in varchar2,
	itemkey   in varchar2,
	actid     in number,
	funcmode  in varchar2,
	resultout in out nocopy varchar2 /* file.sql.39 change */
)
IS
l_mfg_release_status NUMBER;

Line: 1158

             SELECT ato_line_id,shipped_quantity
             INTO   l_ato_line_id,l_shipped_quantity
             FROM oe_order_lines_all
             WHERE line_id = to_number(itemkey);

Line: 1186

          SELECT ato_line_id
          INTO   l_ato_line_id
          FROM   OE_ORDER_LINES_ALL
          WHERE  line_id = to_number(itemkey);

Line: 1279

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

Line: 1474

             select source_type_code
             into l_source_type
             from oe_order_lines_all
             where line_id = to_number(itemkey);