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
| CREATE OR REPLACE FORCE VIEW s03.efficience (periode,
chantier,
code_point,
compteur_mensuel,
jour_location,
jour_de_presence,
jour_de_pannes,
jour_incident,
jour_intemperie,
heures_par_jour,
taux_horaire,
h_par_jour_calculees,
h_par_jour_calculees2
)
AS
SELECT DISTINCT gtm_receipt.txt_receipt_period periode,
gtm_receipt.txt_building_credit chantier,
gtm_receipt.cd_box code_point,
gtm_receipt.val_unit_rent_tot compteur_mensuel,
gtm_receipt.val_day_rent_tot jour_location,
NULL jour_de_presence, NULL jour_de_pannes,
NULL jour_incident, NULL jour_intemperie,
NULL heures_par_jour, NULL taux_horaire,
NULL h_par_jour_calculees, NULL h_par_jour_calculees2
FROM gtm_receipt
WHERE gtm_receipt.typ_debit_cost = '1';
DROP SYNONYM XXX.EFFICIENCE;
CREATE SYNONYM XXX.EFFICIENCE FOR S03.EFFICIENCE;
DROP SYNONYM YYY.EFFICIENCE;
CREATE SYNONYM YYY.EFFICIENCE FOR S03.EFFICIENCE;
GRANT DELETE, INSERT, SELECT, UPDATE ON S03.EFFICIENCE TO ROLS03; |
Partager