XXPRIMAVERA_OUT.XXEA_PRIMAVERA_IMPORT_V

gistfile1.txt

  SELECT TASK.PROJ_ID,
    PROJECT.PROJ_SHORT_NAME ,
    TASK.TASK_ID ,
    TASK.TASK_CODE ,
    TASK.TASK_NAME ,
    udfvalue.udf_text description,
    TASK.TARGET_START_DATE ,
    TASK.TARGET_END_DATE ,
    TASK.CLNDR_ID ,
    -1 ,
    NVL(TASK.CREATE_DATE,SYSDATE) ,
    -1 ,
    SYSDATE ,
    -1 ,
    -1 ,
    -1 ,
    SYSDATE ,
    TASK.ACT_START_DATE ,
    TASK.ACT_END_DATE,
    TASK.STATUS_CODE TASK_STATUS_CODE,
    TASK.TASK_TYPE,
    TASK.EARLY_START_DATE,
    TASK.EARLY_END_DATE,
	PROJECT.LAST_RECALC_DATE,
    PROJECT.PX_NEXT_DATE,
	PROJECT.LAST_SCHEDULE_DATE
  FROM
    XXPRIMAVERA_OUT.PROJECT PROJECT,
    XXPRIMAVERA_OUT.TASK TASK,
    XXPRIMAVERA_OUT.PROJPCAT PROJPCAT,
    XXPRIMAVERA_OUT.PCATVAL PCATVAL,
    XXPRIMAVERA_OUT.PCATTYPE PCATTYPE,
    XXPRIMAVERA_OUT.udfvalue udfvalue,
    XXPRIMAVERA_OUT.udftype udftype
  WHERE TASK.PROJ_ID = PROJECT.PROJ_ID
  and PROJECT.proj_id=projpcat.proj_id
  and projpcat.proj_catg_id=pcatval.proj_catg_id
  and pcatval.proj_catg_type_id=pcattype.proj_catg_type_id
  and pcattype.proj_catg_type='Pripravljen za EBS'
  and pcatval.proj_catg_short_name='D'
  and TASK.delete_date is null
  and PROJECT.delete_date is NULL
  and udfvalue.udf_type_id = udftype.udf_type_id
  and udf_type_label = 'Description'
  and udfvalue.fk_id = task.task_id
  AND NOT EXISTS
  (SELECT 1
  FROM XXEA_PRIMA_TASK_ACTV_CODES_V ptac
  WHERE UPPER(PTAC.ACTV_CODE_TYPE) = 'VRSTA AKTIVNOSTI'
  AND PTAC.TASK_ID                 = TASK.TASK_ID
  AND ptac.ACTV_CODE_SHORT_NAME   IN ('D','K','KD','O','Z','ZD')
  );