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; |
