APPS.XDPCORE_ORU SQL Statements

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

Line: 191

   SELECT XFW.ORDER_ID,
          XFR.WORKITEM_INSTANCE_ID,
          XFR.FA_INSTANCE_ID,
          XFW.LINE_ITEM_ID
     FROM XDP_FA_RUNTIME_LIST XFR,
          XDP_FULFILL_WORKLIST XFW
    WHERE XFR.RESUBMISSION_JOB_ID = ResubJobID
      AND XFR.WORKITEM_INSTANCE_ID = XFW.WORKITEM_INSTANCE_ID;

Line: 307

 UPDATE XDP_FA_RESUBMISSION_LOG
    SET status_code         = 'IN PROGRESS',
        last_update_date    = sysdate,
        last_updated_by     = fnd_global.user_id,
        last_update_login   = fnd_global.login_id
  WHERE resubmission_job_id = l_ResubmissionJobID;

Line: 335

    UPDATE XDP_FA_RESUBMISSION_LOG
       SET status_code        = 'SUCCESS',
           completion_date    = sysdate,
           last_update_date   = sysdate,
           last_updated_by    = fnd_global.user_id,
           last_update_login  = fnd_global.login_id
    WHERE resubmission_job_id = l_ResubmissionJobID;