APPS.XDPCORE SQL Statements

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

Line: 116

    SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL)
      INTO itemkey
      FROM dual;

Line: 175

    SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL)
      INTO itemkey
      FROM dual;

Line: 235

    SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL)
      INTO itemkey
      FROM dual;

Line: 288

    SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL)
      INTO itemkey
      FROM dual;

Line: 664

 UPDATE xdp_order_headers
  SET state             = 'WAIT',
      last_update_date  = sysdate,
      last_updated_by   = fnd_global.user_id,
      last_update_login = fnd_global.login_id
 WHERE order_id = l_orderid
   AND state    = 'PREPROCESS';

Line: 672

 UPDATE xdp_order_line_items
  SET state = 'WAIT',
      last_update_date  = sysdate,
      last_updated_by   = fnd_global.user_id,
      last_update_login = fnd_global.login_id
 WHERE order_id = l_orderid
   AND state    = 'PREPROCESS';

Line: 1357

       SELECT fr.workitem_instance_id ,
              fr.fulfillment_action_id,
              fr.fa_instance_id
         FROM xdp_fa_runtime_list fr
        WHERE fr.fe_id = p_fe_id
          AND fr.status_code IN ('SUCCESS','SUCCESS_WITH_OVERRIDE')
          AND fr.completion_date >= p_start_date
          AND fr.completion_date <= NVL(p_end_date , sysdate)
          AND fr.resubmission_job_id IS NULL ;

Line: 1413

       SELECT channel_name,
              adapter_status ,
              seq_in_fe
         FROM xdp_adapter_reg
        WHERE fe_id = p_fe_id
          AND usage_code = p_usage_code
          AND rownum = channel_count
        ORDER BY seq_in_fe ;

Line: 1430

          SELECT count(*)
            INTO l_current_channels
            FROM xdp_adapter_reg
           WHERE fe_id      = p_fe_id
             AND usage_code = p_usage_code ;