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
| INSERT INTO CNL_DWH_POSE (
POSE_ID,
SUBSCRIBER_ID,
POSE_CPT_CLIENT_ID,
POSE_CONTRAT_ID,
POSE_FLG_ACTIF,
POSE_FLG_RESIL,
POSE_PRODUIT_ID,
POSE_FLG_OFFCAN_MOBILE,
POSE_FLG_OFFCSA_MOBILE,
POSE_FLG_OFFCAN_TNT,
POSE_FLG_OFFCSA_TNT,
POSE_FLG_OFF_CLEF,
POSE_FLG_PDT_FOOT,
POSE_FLG_GRATUIT,
POSE_NUM_MATERIEL,
POSE_GSM_1,
POSE_CREATION_CONTRAT_DT
)
values (
(select seq_pose.nextval from dual),
SELECT DISTINCT DWH_POSE_ABT.SUBSCRIBER_ID,
ID_CPT_CLIENT,
ID_CONTRAT,
FLG_ACTIF,
FLG_DEMANDE_RESIL,
COD_PRODUIT,
FLG_OFFCAN_MOBILE,
FLG_OFFCSA_MOBILE,
FLG_OFFCAN_TNT,
FLG_OFFCSA_TNT,
FLG_OFF_CLEF,
FLG_PDT_FOOT,
FLG_GRATUIT,
NUM_MATERIEL,
GSM_1,
DATE_CREATION_CONTRAT
FROM DWH_POSE_ABT) |
Partager