1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
|
INSERT INTO COSWIN.t_order_@COS7
(popo_code, popo_supplier, popo_date, popo_status, popo_currency,
popo_creator, popo_creation_date, popo_entity, popo_costcentre,
popo_account, popo_payment_due, popo_expected_date)
SELECT PORDER_.po_ref, supplier_ext.supl_cd,
(CASE
WHEN po_dt IS NULL
THEN NULL
WHEN po_dt = 0
THEN NULL
ELSE (TO_CHAR (( TO_DATE ('01-01-1900', 'DD-MM-YYYY')
+ NVL (po_dt, 0)
- 1
),
'DD/MM/YYYY'
)
)
END
),
CHR (po_status), po_curr_cd, 'supervisor',
(CASE
WHEN dt_porder IS NULL
THEN NULL
WHEN dt_porder = 0
THEN NULL
ELSE (TO_CHAR (( TO_DATE ('01-01-1900', 'DD-MM-YYYY')
+ NVL (dt_porder, 0)
- 1
),
'DD/MM/YYYY'
)
)
END
),
(CASE
WHEN po_authority IS NULL
THEN (SELECT VALUE FROM PARAMETERS WHERE code='COMP_ENT_DEFAULT')
ELSE po_authority
END
)
, po_cc, po_account, po_payment_due,
(CASE
WHEN po_dt IS NULL
THEN NULL
WHEN po_dt = 0
THEN NULL
ELSE (TO_CHAR (( TO_DATE ('01-01-1900', 'DD-MM-YYYY')
+ NVL (po_dt, 0)
- 1
),
'DD/MM/YYYY'
)
)
END
)
FROM PORDER_ INNER JOIN supplier_ext ON s_supl_po = pk_supplier_
;
COMMIT; |
Partager