SELECT
ao.ABO_ID,
ao.SPR_OBORYD_ID,
ao.LSA_ID,
ao.GP_ID,
ao.KGP,
ao.KOLVO,
ao.KOLVO_VIDKL,
ao.KOLVO_VIDR,
ao.KOLVO_DEMONT,
ao.DATA_VCTANOVLENYA,
ao.DATA_VUGOTOVLENYA,
ao.ZAVOD_NOM,
ao.DATA_ZAKRUTYA,
ao.DATA_POVIRKU,
ao.DATA_NA_POVIRKY,
ao.DATA_PICLYA_POVIRKU,
ao.DATA_NACT_POVIRKU,
ao.IS_VIDKL,
ao.DATA_VIDKL,
ao.AKT_VIDKL_NOM,
ao.PLOMBA_VIDKL,
ao.SPR_XARAKTER_VIDKL_ID,
ao.PRUCHUNA_VIDKL,
ao.DATA_VKL,
ao.N_DOZVIL_VKL,
ao.DATA_DUMOXODA,
ao.DATA_NACT_DUMOXODA,
ao.DATA_PTO,
ao.DATA_NACT_PTO,
ao.DATA_AKTA,
ao.PRUM,
ao.SPR_USER_ID,
ao.OPER_DATA,
ao.IS_ADC,
ao.oper_type,
ao.EDIT_TYPE,
ao.EDIT_USER_ID,
ao.EDIT_DATE,
ao.ABO_OPER_ID,
ao.VKL_VUKL_ID,
ao.ABO_OBORYD_ID
FROM
ABO_OBORYD ao
left outer join spr_oboryd so on AO.spr_oboryd_id=so.spr_oboryd_id
where
-- відключене обладнання
:is_vidkl_oboryd in(-1,ao.is_vidkl) and
-- Обладнання
:spr_oboryd_id_in in (-1,ao.spr_oboryd_id) and
-- типи обладнання
:spr_oboryd_type_id_in in (-1,so.spr_oboryd_type_id) and
-- строки повірки димоходів
ao.DATA_NACT_DUMOXODA BETWEEN  ND_S and ND_E and
-- строки пто
ao.DATA_NACT_PTO BETWEEN NPTO_S and NPTO_E
order by ABO_ID,ao.SPR_OBORYD_ID
-----------------------------------------------
UPDATE ABO_OBORYD
SET
ABO_ID = :ABO_ID,
SPR_OBORYD_ID = :SPR_OBORYD_ID,
LSA_ID = :LSA_ID,
GP_ID = :GP_ID,
KGP = :KGP,
KOLVO = :KOLVO,
KOLVO_VIDKL = :KOLVO_VIDKL,
KOLVO_VIDR = :KOLVO_VIDR,
KOLVO_DEMONT = :KOLVO_DEMONT,
DATA_VCTANOVLENYA = ATA_VCTANOVLENYA,
DATA_VUGOTOVLENYA = ATA_VUGOTOVLENYA,
ZAVOD_NOM = :ZAVOD_NOM,
DATA_ZAKRUTYA = ATA_ZAKRUTYA,
DATA_POVIRKU = ATA_POVIRKU,
DATA_NA_POVIRKY = ATA_NA_POVIRKY,
DATA_PICLYA_POVIRKU = ATA_PICLYA_POVIRKU,
DATA_NACT_POVIRKU = ATA_NACT_POVIRKU,
IS_VIDKL = :IS_VIDKL,
DATA_VIDKL = ATA_VIDKL,
AKT_VIDKL_NOM = :AKT_VIDKL_NOM,
PLOMBA_VIDKL =  LOMBA_VIDKL,
SPR_XARAKTER_VIDKL_ID = :SPR_XARAKTER_VIDKL_ID,
PRUCHUNA_VIDKL = RUCHUNA_VIDKL,
DATA_VKL = ATA_VKL,
N_DOZVIL_VKL = :N_DOZVIL_VKL,
DATA_DUMOXODA = ATA_DUMOXODA,
DATA_NACT_DUMOXODA = ATA_NACT_DUMOXODA,
DATA_PTO = ATA_PTO,
DATA_NACT_PTO = ATA_NACT_PTO,
DATA_AKTA = ATA_AKTA,
PRUM = RUM,
SPR_USER_ID = :SPR_USER_ID,
OPER_DATA =  PER_DATA,
IS_ADC = :IS_ADC,
OPER_TYPE = PER_TYPE,
EDIT_TYPE = :EDIT_TYPE,
EDIT_USER_ID = :EDIT_USER_ID,
EDIT_DATE = :EDIT_DATE,
ABO_OPER_ID = :ABO_OPER_ID,
VKL_VUKL_ID = :VKL_VUKL_ID
WHERE
ABO_OBORYD_ID = LD_ABO_OBORYD_ID
|
