APPS.XDP_CANCEL_ORDER SQL Statements

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

Line: 73

         SELECT order_id
         INTO   lv_sfm_order_id
         FROM   xdp_order_headers
         WHERE  external_order_number     = to_char(l_order_number) and
	            external_order_version    = to_char(l_order_version);

Line: 79

         SELECT order_id
         INTO   lv_sfm_order_id
         FROM   xdp_order_headers
         WHERE  external_order_number     = (l_order_number) and
    	        external_order_version    IS NULL;

Line: 98

   SELECT   status_code,
            msgid,
            order_type
   INTO     lv_state,
            lv_msg_id,
            lv_order_type
   FROM     xdp_order_headers
   WHERE    order_id = lv_sfm_order_id;

Line: 357

       SELECT  'Y'
       FROM    XDP_FULFILL_WORKLIST FulfillWorklist,
               XDP_FA_RUNTIME_LIST  FARuntimeList
       WHERE   FulfillWorklist.order_id             = p_order_id
         AND   FulfillWorklist.workitem_instance_id = FARuntimeList.workitem_instance_id
         AND   FARuntimeList.status_code            IN ('IN PROGRESS', 'ERROR', 'SUCCESS',
                                                       'SUCCESS_WITH_OVERRIDE', 'CANCELED', 'ABORTED');