CREATE TABLE CDLRM.ALL_PARASTATIKA ( ID NUMBER, DESCRIPTION VARCHAR2(100 CHAR), CODE VARCHAR2(20 CHAR), ENABLED NUMBER, SYMPERIFORA VARCHAR2(5 CHAR), SYGKENTROTIKI_FPA VARCHAR2(2 CHAR), SYMP_PELATH VARCHAR2(5 CHAR), SYMP_APOTHIKIS_POSOTHTA VARCHAR2(5 CHAR), DEFAULT_PAR NUMBER, CRYSTAL_NAME VARCHAR2(200 CHAR), POL_MERTHTON NUMBER, SYMP_SUPL VARCHAR2(10 CHAR), ISMETASXIMATIZOMENO NUMBER DEFAULT 0, TYPOS VARCHAR2(10 CHAR) DEFAULT 'P', DEFAULT_TIMH_X INTEGER DEFAULT 1, EXEI_FPA_H_LIANIKH INTEGER DEFAULT 1, PRINTER_NAME VARCHAR2(100 CHAR), DEKADIKA NUMBER DEFAULT 2, ID_APODEIJHS NUMBER, PEL_XREOSI NUMBER, PEL_PISTOSI NUMBER, SUPL_XREOSI NUMBER, SUPL_PISTOSI NUMBER, APP_XREOSI NUMBER, APP_PISTOSI NUMBER, APOD_NAME VARCHAR2(100 BYTE), AP_PRINTER_NAME VARCHAR2(100 CHAR), DEFAULT_TROPOS_PLIROMIS INTEGER, TIMH_EISAGOGIS INTEGER DEFAULT 1, AR_ANTYTIPON NUMBER DEFAULT 1 ) / CREATE TABLE CDLRM.SUPL ( ID NUMBER, KODIKOS VARCHAR2(50 CHAR), EPONYMIA VARCHAR2(200 CHAR), EPAGGELMA VARCHAR2(100 CHAR), AFM VARCHAR2(20 CHAR), DOYID NUMBER, HM_ENARJHS DATE, KEPYO_ID NUMBER, FPA_ID NUMBER DEFAULT 0, NOMISMA_ID NUMBER, TROPOS_METAFORAS_ID NUMBER, MESO_METAFORAS_ID NUMBER, KYRIA_DNSH_ID NUMBER, DNSH_APOSTOLHS_ID NUMBER, ENERGOS NUMBER(1) DEFAULT 1, APAGOREYSH_TIMOLOGISIS NUMBER(1) DEFAULT 0, DEF_EKPTOSI NUMBER DEFAULT 0, CR_DATE DATE DEFAULT sysdate, CR_USER_ID NUMBER, LAST_UPDATE_DATE DATE, LAST_UPDATE_USERID NUMBER, NOTES_TIMOLOGISIS VARCHAR2(2000 CHAR), EMAIL VARCHAR2(100 CHAR), PHOTO VARCHAR2(200 CHAR), NOTES VARCHAR2(4000 CHAR), TYPOS_FPA VARCHAR2(10 BYTE) DEFAULT 'FPAKAN', EPAG_ID NUMBER, TROPOS_METAFORAS VARCHAR2(100 CHAR), MESO_METAFORAS VARCHAR2(200 CHAR), IS_SUPL NUMBER(1) DEFAULT 1, TREXON_YPOLOIPO NUMBER DEFAULT 0, SUM_XREOSEON NUMBER DEFAULT 0, SUM_PISTOSEON NUMBER DEFAULT 0, IS_DEFAULT_L INTEGER DEFAULT 0, INSLASTPRICE INTEGER DEFAULT 0, FREES1 VARCHAR2(500 CHAR), FREES2 VARCHAR2(500 CHAR), FREES3 VARCHAR2(500 CHAR), FREES4 VARCHAR2(500 CHAR), FREENN1 NUMBER, FREENN2 NUMBER, FREEND1 DATE, FREEND2 DATE, FREENCH1 INTEGER DEFAULT 0, FREENCH2 INTEGER DEFAULT 0, IMAGE1 VARCHAR2(500 CHAR), IMAGE2 VARCHAR2(500 CHAR), FS5 VARCHAR2(500 CHAR), FS6 VARCHAR2(500 CHAR), FS7 VARCHAR2(500 CHAR), FS8 VARCHAR2(500 CHAR), FS9 VARCHAR2(500 CHAR), FS10 VARCHAR2(500 CHAR), FN3 NUMBER DEFAULT 0, FN4 NUMBER DEFAULT 0, FN5 NUMBER DEFAULT 0, FN6 NUMBER DEFAULT 0, FN7 NUMBER DEFAULT 0, FN8 NUMBER DEFAULT 0, FN9 NUMBER DEFAULT 0, FN10 NUMBER DEFAULT 0, ETAIREIA NUMBER, MASTER_DNSH_AUTOCOMPLETE VARCHAR2(500 CHAR), MASTER_THL_AUTOCOMPLETE VARCHAR2(200 CHAR), MASTER_DOY_AUTOCOMPLETE VARCHAR2(200 CHAR), MASTER_POLH_AUTOCOMPLETE VARCHAR2(200 CHAR), MASTER_TK_AUTOCOMPLETE VARCHAR2(100 CHAR), IS_CLIENT NUMBER DEFAULT 0, USE_TROPO_PLIROMHS NUMBER DEFAULT 0, ID_TIM_POLITIKIS NUMBER ) / CREATE TABLE CDLRM.SUPL_KATASTHMATA ( ID NUMBER, DNSH VARCHAR2(400 CHAR), POLH VARCHAR2(100 CHAR), TK VARCHAR2(20 CHAR), THL1 VARCHAR2(30 CHAR), THL2 VARCHAR2(30 CHAR), FAX VARCHAR2(30 CHAR), YPEYTHINOS VARCHAR2(100 CHAR), FPA_ID NUMBER(1), IS_EDRA NUMBER(1) DEFAULT 1, IS_APOSTOLH NUMBER(1) DEFAULT 1, THL3 VARCHAR2(300 CHAR), ID_PROMHTHEYTH NUMBER, FS1 VARCHAR2(500 CHAR), FS2 VARCHAR2(500 CHAR), FS3 VARCHAR2(500 CHAR), FS4 VARCHAR2(500 CHAR), FS5 VARCHAR2(500 CHAR), FS6 VARCHAR2(500 CHAR), FS7 VARCHAR2(500 CHAR), FN1 NUMBER, FN2 NUMBER, FN3 NUMBER, FD1 DATE, FD2 DATE, FC1 INTEGER, FC2 INTEGER ) / CREATE TABLE CDLRM.P_L_M ( ID NUMBER, ID_PARASTATIKOY NUMBER, AA NUMBER, SEIRA VARCHAR2(50 CHAR), ID_PELATH NUMBER, FULL_NAME VARCHAR2(200 CHAR), EPAGELMA VARCHAR2(100 CHAR), ADDRESS VARCHAR2(200 CHAR), THL VARCHAR2(100 CHAR), FAX VARCHAR2(50 CHAR), AFM VARCHAR2(20 CHAR), DOY VARCHAR2(50 CHAR), CITY VARCHAR2(200 CHAR), CR_DATE DATE DEFAULT sysdate, SX_PARASTATIKA VARCHAR2(200 CHAR), PARAT VARCHAR2(500 CHAR), ID_MHX NUMBER, USERNAME VARCHAR2(300 CHAR), ID_TROPOY_EJOFLISIS NUMBER, AASEIRA VARCHAR2(40 CHAR), POSO_PROKATABOLHS NUMBER DEFAULT 0, PARAT2 VARCHAR2(500 CHAR), ID_APODEIJHS NUMBER, ID_METASXIM NUMBER, TABLE_MET VARCHAR2(100 CHAR), FREES1 VARCHAR2(500 CHAR), FREES2 VARCHAR2(500 CHAR), FREEN1 NUMBER, FREEN2 NUMBER, FREED1 DATE, FREED2 DATE, ID_SEIRAS NUMBER, SKOPOS_DIAKINHSHS VARCHAR2(100 CHAR), TOPOS_APOSTOLHS VARCHAR2(100 CHAR), TOPOS_PROORISMOY VARCHAR2(100 CHAR), PR_YPOLOIPO NUMBER DEFAULT 0, NEO_YPOLOIPO NUMBER DEFAULT 0, PR_DNSH VARCHAR2(300 CHAR), PR_POLHTK VARCHAR2(300 CHAR), APOSTOLI_ORA VARCHAR2(100 CHAR), PRINTTIMES INTEGER DEFAULT 0, FS10 VARCHAR2(500 CHAR), FS11 VARCHAR2(500 CHAR), FS12 VARCHAR2(500 CHAR), FS13 VARCHAR2(500 CHAR), FS14 VARCHAR2(500 CHAR), FS15 VARCHAR2(500 CHAR), FS16 VARCHAR2(500 CHAR), FS17 VARCHAR2(500 CHAR), FS18 VARCHAR2(500 CHAR), FS19 VARCHAR2(500 CHAR), FS20 VARCHAR2(500 CHAR), FN10 NUMBER DEFAULT 0, FN11 NUMBER DEFAULT 0, FN12 NUMBER DEFAULT 0, FN13 NUMBER DEFAULT 0, FN14 NUMBER DEFAULT 0, FN15 NUMBER DEFAULT 0, FC10 INTEGER DEFAULT 0, FC11 INTEGER DEFAULT 0, ETAIREIA NUMBER, FLOV1 VARCHAR2(500 CHAR), FLOV2 VARCHAR2(500 CHAR), FLOV3 VARCHAR2(500 CHAR), FLOV4 VARCHAR2(500 CHAR), FLOV5 VARCHAR2(500 CHAR), FCH12 INTEGER, FCH13 INTEGER, FCH14 INTEGER, FCH15 INTEGER, FD3 DATE, FD4 DATE, FN16 NUMBER, FN17 NUMBER, FN18 NUMBER, FN19 NUMBER, FN20 NUMBER ) / CREATE TABLE CDLRM.P_L_D ( ID NUMBER, ID_MASTER NUMBER, ID_EIDOUS NUMBER, PERIGRAFH VARCHAR2(4000 CHAR), POSOTHTA NUMBER, MM VARCHAR2(100 CHAR), TIMH NUMBER DEFAULT 0, POSOSTO_FPA NUMBER, POSOSTO_EKPTOSIS NUMBER DEFAULT 0, POSO_EKPTOSIS NUMBER DEFAULT 0, FREEN1 NUMBER DEFAULT 0, FREEN2 NUMBER DEFAULT 0, FREED1 DATE, FREED2 DATE, FREES1 VARCHAR2(1000 CHAR), FREES2 VARCHAR2(1000 CHAR), FREEN3 NUMBER DEFAULT 0, FREEN4 NUMBER DEFAULT 0, KOD_EIDOUS VARCHAR2(100 CHAR), IDFPA NUMBER ) CREATE OR REPLACE FORCE VIEW CDLRM.ANALISI_ANA_FPA_GR_L2 ( SUNOLO, AJIA_FPA_0, AJIA_FPA_1, AJIA_FPA_2, AJIA_FPA_3, AJIA_FPA, KATHARO_0, KATHARO_1, KATHARO_2, KATHARO_3, KATHARO, ID_MASTER ) AS SELECT SUM ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) AS sunolo, SUM ( DECODE ( IDFPA, 0, ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) - (ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) / (1 + pososto_fpa / 100), 2)), 0)) AS ajia_fpa_0, SUM ( DECODE ( IDFPA, 1, ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) - (ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) / (1 + pososto_fpa / 100), 2)), 0)) AS ajia_fpa_1, SUM ( DECODE ( IDFPA, 2, ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) - (ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) / (1 + pososto_fpa / 100), 2)), 0)) AS ajia_fpa_2, SUM ( DECODE ( IDFPA, 3, ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) - (ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) / (1 + pososto_fpa / 100), 2)), 0)) AS ajia_fpa_3, SUM ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) - (ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) / (1 + pososto_fpa / 100), 2))) AS ajia_fpa, SUM ( DECODE ( IDFPA, 0, ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) / (1 + pososto_fpa / 100), 2), 0)) AS katharo_0, SUM ( DECODE ( IDFPA, 1, ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) / (1 + pososto_fpa / 100), 2), 0)) AS katharo_1, SUM ( DECODE ( IDFPA, 2, ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) / (1 + pososto_fpa / 100), 2), 0)) AS katharo_2, SUM ( DECODE ( IDFPA, 3, ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) / (1 + pososto_fpa / 100), 2), 0)) AS katharo_3, SUM ( ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) / (1 + pososto_fpa / 100), 2)) AS katharo, id_master FROM p_l_d GROUP BY id_master; / CREATE TABLE CDLRM.P_X_M ( ID NUMBER, ID_PARASTATIKOY NUMBER, AA NUMBER, SEIRA VARCHAR2(50 CHAR), ID_PELATH NUMBER, FULL_NAME VARCHAR2(200 CHAR), EPAGELMA VARCHAR2(100 CHAR), ADDRESS VARCHAR2(200 CHAR), THL VARCHAR2(100 CHAR), FAX VARCHAR2(50 CHAR), AFM VARCHAR2(20 CHAR), DOY VARCHAR2(50 CHAR), CITY VARCHAR2(200 CHAR), CR_DATE DATE DEFAULT sysdate, SX_PARASTATIKA VARCHAR2(200 CHAR), PARAT VARCHAR2(500 CHAR), ID_MHX NUMBER, USERNAME VARCHAR2(300 CHAR), ID_TROPOY_EJOFLISIS NUMBER, AASEIRA VARCHAR2(40 CHAR), POSO_PROKATABOLHS NUMBER DEFAULT 0, PARAT2 VARCHAR2(500 CHAR), ID_APODEIJHS NUMBER, ID_METASXIM NUMBER, TABLE_MET VARCHAR2(100 CHAR), FREES1 VARCHAR2(500 CHAR), FREES2 VARCHAR2(500 CHAR), FREEN1 NUMBER, FREEN2 NUMBER, FREED1 DATE, FREED2 DATE, ID_SEIRAS NUMBER, SKOPOS_DIAKINHSHS VARCHAR2(100 CHAR), TOPOS_APOSTOLHS VARCHAR2(100 CHAR), TOPOS_PROORISMOY VARCHAR2(100 CHAR), PR_YPOLOIPO NUMBER DEFAULT 0, NEO_YPOLOIPO NUMBER DEFAULT 0, PR_DNSH VARCHAR2(300 CHAR), PR_POLHTK VARCHAR2(300 CHAR), APOSTOLI_ORA VARCHAR2(100 CHAR), PRINTTIMES INTEGER DEFAULT 0, FS10 VARCHAR2(500 CHAR), FS11 VARCHAR2(500 CHAR), FS13 VARCHAR2(500 CHAR), FS14 VARCHAR2(500 CHAR), FS15 VARCHAR2(500 CHAR), FS16 VARCHAR2(500 CHAR), FS17 VARCHAR2(500 CHAR), FS18 VARCHAR2(500 CHAR), FS19 VARCHAR2(500 CHAR), FS20 VARCHAR2(500 CHAR), FN10 NUMBER DEFAULT 0, FN11 NUMBER DEFAULT 0, FN12 NUMBER DEFAULT 0, FN13 NUMBER DEFAULT 0, FN14 NUMBER DEFAULT 0, FN15 NUMBER DEFAULT 0, FC10 INTEGER DEFAULT 0, FC11 INTEGER DEFAULT 0, FS12 VARCHAR2(500 CHAR), ETAIREIA NUMBER, FLOV1 VARCHAR2(500 CHAR), FLOV2 VARCHAR2(500 CHAR), FLOV3 VARCHAR2(500 CHAR), FLOV4 VARCHAR2(500 CHAR), FLOV5 VARCHAR2(500 CHAR), FCH12 INTEGER, FCH13 INTEGER, FCH14 INTEGER, FCH15 INTEGER, FD3 DATE, FD4 DATE, FN16 NUMBER, FN17 NUMBER, FN18 NUMBER, FN19 NUMBER, FN20 NUMBER ) / CREATE TABLE CDLRM.P_X_D ( ID NUMBER, ID_MASTER NUMBER, ID_EIDOUS NUMBER, PERIGRAFH VARCHAR2(4000 CHAR), POSOTHTA NUMBER, MM VARCHAR2(100 CHAR), TIMH NUMBER DEFAULT 0, POSOSTO_FPA NUMBER, POSOSTO_EKPTOSIS NUMBER DEFAULT 0, POSO_EKPTOSIS NUMBER DEFAULT 0, FREEN1 NUMBER DEFAULT 0, FREEN2 NUMBER DEFAULT 0, FREED1 DATE, FREED2 DATE, FREES1 VARCHAR2(1000 CHAR), FREES2 VARCHAR2(1000 CHAR), FREEN4 NUMBER DEFAULT 0, FREEN3 NUMBER DEFAULT 0, KOD_EIDOUS VARCHAR2(100 CHAR), IDFPA NUMBER ) / CREATE OR REPLACE FORCE VIEW CDLRM.ANALISI_ANA_FPA_GR_X2 ( KATHARO, KATHARO_0, KATHARO_1, KATHARO_2, KATHARO_3, AJIA_FPA_0, AJIA_FPA_1, AJIA_FPA_2, AJIA_FPA_3, AJIA_FPA, SUNOLO, ID_MASTER ) AS SELECT SUM ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) AS katharo, SUM ( DECODE ( IDFPA, 0, ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0), 0)) AS katharo_0, SUM ( DECODE ( IDFPA, 1, ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0), 0)) AS katharo_1, SUM ( DECODE ( IDFPA, 2, ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0), 0)) AS katharo_2, SUM ( DECODE ( IDFPA, 3, ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0), 0)) AS katharo_3, SUM ( DECODE ( IDFPA, 0, ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) * pososto_fpa / 100, 2), 0)) AS ajia_fpa_0, SUM ( DECODE ( IDFPA, 1, ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) * pososto_fpa / 100, 2), 0)) AS ajia_fpa_1, SUM ( DECODE ( IDFPA, 2, ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) * pososto_fpa / 100, 2), 0)) AS ajia_fpa_2, SUM ( DECODE ( IDFPA, 3, ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) * pososto_fpa / 100, 2), 0)) AS ajia_fpa_3, SUM ( ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) * pososto_fpa / 100, 2)) AS ajia_fpa, SUM ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) + (ROUND ( ( ROUND (NVL (timh, 0) * NVL (posothta, 1), 2) - NVL (poso_ekptosis, 0)) * pososto_fpa / 100, 2))) AS sunolo, id_master FROM p_x_d GROUP BY id_master; / CREATE TABLE CDLRM.P_X_MA ( ID NUMBER, ID_MASTER NUMBER, ID_PARASTATIKOY NUMBER, AA NUMBER, SEIRA VARCHAR2(50 CHAR), ID_PELATH NUMBER, FULL_NAME VARCHAR2(200 CHAR), EPAGELMA VARCHAR2(100 CHAR), ADDRESS VARCHAR2(200 CHAR), THL VARCHAR2(100 CHAR), FAX VARCHAR2(50 CHAR), AFM VARCHAR2(20 CHAR), DOY VARCHAR2(50 CHAR), CITY VARCHAR2(200 CHAR), CR_DATE DATE DEFAULT sysdate, SX_PARASTATIKA VARCHAR2(200 CHAR), PARAT VARCHAR2(500 CHAR), ID_MHX NUMBER, USERNAME VARCHAR2(300 CHAR), ID_TROPOY_EJOFLISIS NUMBER, AASEIRA VARCHAR2(40 CHAR), POSO_PROKATABOLHS NUMBER DEFAULT 0, PARAT2 VARCHAR2(500 CHAR), ID_APODEIJHS NUMBER, ID_METASXIM NUMBER, TABLE_MET VARCHAR2(100 CHAR), FREES1 VARCHAR2(500 CHAR), FREES2 VARCHAR2(500 CHAR), FREEN1 NUMBER, FREEN2 NUMBER, FREED1 DATE, FREED2 DATE, ID_SEIRAS NUMBER, SKOPOS_DIAKINHSHS VARCHAR2(100 CHAR), TOPOS_APOSTOLHS VARCHAR2(100 CHAR), TOPOS_PROORISMOY VARCHAR2(100 CHAR), PR_YPOLOIPO NUMBER DEFAULT 0, NEO_YPOLOIPO NUMBER DEFAULT 0, PR_DNSH VARCHAR2(300 CHAR), PR_POLHTK VARCHAR2(300 CHAR), APOSTOLI_ORA VARCHAR2(100 CHAR), PRINTTIMES INTEGER DEFAULT 0, FS12 VARCHAR2(500 CHAR), FS10 VARCHAR2(500 CHAR), FS11 VARCHAR2(500 CHAR), FS13 VARCHAR2(500 CHAR), FS14 VARCHAR2(500 CHAR), FS15 VARCHAR2(500 CHAR), FS16 VARCHAR2(500 CHAR), FS17 VARCHAR2(500 CHAR), FS18 VARCHAR2(500 CHAR), FS19 VARCHAR2(500 CHAR), FS20 VARCHAR2(500 CHAR), FN10 NUMBER DEFAULT 0, FN11 NUMBER DEFAULT 0, FN12 NUMBER DEFAULT 0, FN13 NUMBER DEFAULT 0, FN14 NUMBER DEFAULT 0, FN15 NUMBER DEFAULT 0, FC10 INTEGER DEFAULT 0, FC11 INTEGER DEFAULT 0, ETAIREIA NUMBER, FLOV1 VARCHAR2(500 CHAR), FLOV2 VARCHAR2(500 CHAR), FLOV3 VARCHAR2(500 CHAR), FLOV4 VARCHAR2(500 CHAR), FLOV5 VARCHAR2(500 CHAR), FCH12 INTEGER, FCH13 INTEGER, FCH14 INTEGER, FCH15 INTEGER, FD3 DATE, FD4 DATE, FN16 NUMBER, FN17 NUMBER, FN18 NUMBER, FN19 NUMBER, FN20 NUMBER ) / CREATE TABLE CDLRM.P_L_MA ( ID NUMBER, ID_MASTER NUMBER, ID_PARASTATIKOY NUMBER, AA NUMBER, SEIRA VARCHAR2(50 CHAR), ID_PELATH NUMBER, FULL_NAME VARCHAR2(200 CHAR), EPAGELMA VARCHAR2(100 CHAR), ADDRESS VARCHAR2(200 CHAR), THL VARCHAR2(100 CHAR), FAX VARCHAR2(50 CHAR), AFM VARCHAR2(20 CHAR), DOY VARCHAR2(50 CHAR), CITY VARCHAR2(200 CHAR), CR_DATE DATE DEFAULT sysdate, SX_PARASTATIKA VARCHAR2(200 CHAR), PARAT VARCHAR2(500 CHAR), ID_MHX NUMBER, USERNAME VARCHAR2(300 CHAR), ID_TROPOY_EJOFLISIS NUMBER, AASEIRA VARCHAR2(40 CHAR), POSO_PROKATABOLHS NUMBER DEFAULT 0, PARAT2 VARCHAR2(500 CHAR), ID_APODEIJHS NUMBER, ID_METASXIM NUMBER, TABLE_MET VARCHAR2(100 CHAR), FREES1 VARCHAR2(500 CHAR), FREES2 VARCHAR2(500 CHAR), FREEN1 NUMBER, FREEN2 NUMBER, FREED1 DATE, FREED2 DATE, ID_SEIRAS NUMBER, SKOPOS_DIAKINHSHS VARCHAR2(100 CHAR), TOPOS_APOSTOLHS VARCHAR2(100 CHAR), TOPOS_PROORISMOY VARCHAR2(100 CHAR), PR_YPOLOIPO NUMBER DEFAULT 0, NEO_YPOLOIPO NUMBER DEFAULT 0, PR_DNSH VARCHAR2(300 CHAR), PR_POLHTK VARCHAR2(300 CHAR), APOSTOLI_ORA VARCHAR2(100 CHAR), PRINTTIMES INTEGER DEFAULT 0, FS10 VARCHAR2(500 CHAR), FS11 VARCHAR2(500 CHAR), FS12 VARCHAR2(500 CHAR), FS13 VARCHAR2(500 CHAR), FS14 VARCHAR2(500 CHAR), FS15 VARCHAR2(500 CHAR), FS16 VARCHAR2(500 CHAR), FS17 VARCHAR2(500 CHAR), FS18 VARCHAR2(500 CHAR), FS19 VARCHAR2(500 CHAR), FS20 VARCHAR2(500 CHAR), FN10 NUMBER DEFAULT 0, FN11 NUMBER DEFAULT 0, FN12 NUMBER DEFAULT 0, FN13 NUMBER DEFAULT 0, FN14 NUMBER DEFAULT 0, FN15 NUMBER DEFAULT 0, FC10 INTEGER DEFAULT 0, FC11 INTEGER DEFAULT 0, ETAIREIA NUMBER, FLOV1 VARCHAR2(500 CHAR), FLOV2 VARCHAR2(500 CHAR), FLOV3 VARCHAR2(500 CHAR), FLOV4 VARCHAR2(500 CHAR), FLOV5 VARCHAR2(500 CHAR), FCH12 INTEGER, FCH13 INTEGER, FCH14 INTEGER, FCH15 INTEGER, FD3 DATE, FD4 DATE, FN16 NUMBER, FN17 NUMBER, FN18 NUMBER, FN19 NUMBER, FN20 NUMBER ) /