1 2 3 4 5 6 7 8 9 10 11 12 13 14
| INSERT INTO SCHEMA_BOADM.tbowrk_INF228_int_fae_dm
SELECT TPJCT.code_transaction_brut as trans_type,
TW232.code_bu as BU,
SUM(TW232.montant_net) as total_amount,
SUM(TW232.montant_brut) as montant_brut,
SUM(-TW232.montant_remise) as total_remise,
SUM(-TW232.montant_forfait) as montant_forfait,
TW232.mkt_code as mkt_code,
TW232.code_contrat as code_contrat,
TW232.is_roaming_out as is_roaming_out,
EIEM.external_id as IDS
FROM SCHEMA_BOADM.tbowrk_INF232_cdr_fae TW232,
SCHEMA_BOADM.TBO_PARAM_JUR_CODE_TRANSAC TPJCT,
SCHEMA_ARBOR.external_id_equip_map EIEM |
Partager