SELECT
  job_id,                                  -- JOB_ID RAW(16)
  job_name,                                -- JOB_NAME VARCHAR2(30)
  owner_name,                              -- OWNER_NAME VARCHAR2(30)
  msg_ctrl_queue,                          -- MSG_CTRL_QUEUE VARCHAR2(30)
  status_queue,                            -- STATUS_QUEUE VARCHAR2(30)
  operation,                               -- OPERATION VARCHAR2(30)
  job_mode,                                -- JOB_MODE VARCHAR2(30)
  master_id,                               -- MASTER_ID NUMBER
  state,                                   -- STATE VARCHAR2(30)
  workers,                                 -- WORKERS NUMBER
  flags,                                   -- FLAGS NUMBER
  serialnum,                               -- SERIALNUM NUMBER
  queue_tabnum                             -- QUEUE_TABNUM NUMBER
FROM
  gv$datapump_job
WHERE
  inst_id = USERENV('INSTANCE')