Casos Pr Cticos


GPOT

Cambio de mercado

Se ha indicado desde Barcelona que cuando llegue alguna solicitud de cambio de mercado a NE o PYME se debe indicar solicitar el cambio a BackOffice México.

Cambio de mercado - Validación

Jorge Ayerve
Validar

Query amplia
SELECT S.SUPPLY_ID "CIDI",
ESTADO.STATUS_DESCRIPTION "EST. INMUEBLE",
NVL(TO_CHAR(DER.STARTING_UP_FIRST_DATE, 'DD/MM/YYYYHH:Mi:SS'), 'NO INFORMADA') "F. 1° PUESTA DER",
round(MONTHS_BETWEEN(sysdate, DER.STARTING_UP_FIRST_DATE),1)"> 6 Meses",
NVL(TO_CHAR(DER.FIRST_CAPTATION_DATE, 'DD/MM/YYYY HH:Mi:SS'),'NO INFORMADA') "F. 1° CAPTACION DER",
NVL(TO_CHAR(F.STARTING_UP_FIRST_DATE, 'DD/MM/YYYY HH:Mi:SS'),'NO INFORMADA') "F. 1° PUESTA FINCA",
NVL(TO_CHAR(S.LAST_DATE_SUSPENSION, 'DD/MM/YYYY HH:Mi:SS'),'NO INFORMADA') "F. ULTIMO CESE",
round(MONTHS_BETWEEN(sysdate, S.LAST_DATE_SUSPENSION)/12,1) "< 2 años",
NVL(F.PLUG_AND_PLAY,'NULL') "PLUG & PLAY",
USO.USE_TYPE_DESCRIPTION "USO DEL GAS",
dsm.HIGH_PRESSURE_MAINS_DISTANCE "Dist. red alta presión",
dsm.HIGH_PRESS_MAIN_IN_SERVICE_DIS "Dist. red alta pres. en serv.",
dsm.IN_SERVICE_MAINS_DISTANCE "Dist. reddistrib. en serv.",
dsm.NOT_ABANDONED_MAINS_DISTANCE "Dist. red no abonada distrib.",
CALDERA.BOILER_DESCRIPTION "CALDERA",
MERCADO.MARKET_DESCRIPTION "MERCADO"
FROM GPOT_SUPPLIES S
LEFT JOIN GCAR_SUPPLY_SECTOR SS
ON S.SUPPLY_ID = SS.SUPPLY_ID
LEFT JOIN GPOT_MASTER_MARKET MERCADO
ON S.MARKET_ID = MERCADO.MARKET_ID
LEFT JOIN GCAR_DERIVATION DERON DER.DERIVATION_ID = SS.DERIVATION_IRC_ID
LEFT JOIN GPOT_USE_TYPE USO
ON USO.USE_TYPE_ID = S.USE_TYPE_ID
LEFT JOIN GPOT_BUILDING F
ON F.BUILDING_ID = S.BUILDING_ID
LEFT JOIN GPOT_CENTRAL_BOILER_TYPE CALDERA
ON CALDERA.CENTRAL_BOILER_ID = S.CENTRAL_BOILER_ID
LEFT JOIN GPOT_SUPPLIES_STATUS ESTADO
ON ESTADO.COD_SUPPLIES_STATUS = S.COD_SUPPLIES_STATUSLEFT JOIN GPOT_DISTANCE_SUPPLIES_MAINS DSM
ON DSM.BUILDING_ID = F.BUILDING_ID
WHERE S.SUPPLY_ID IN (&CIDI);

Query básica
SELECT S.SUPPLY_ID "CIDI",
ESTADO.STATUS_DESCRIPTION "ESTADO INMUEBLE",
NVL (TO_CHAR (DER.STARTING_UP_FIRST_DATE, 'DD/MM/YYYY HH:Mi:SS'),
'NO INFORMADA')
"FECHA 1° PUESTA DER",
NVL (TO_CHAR(DER.FIRST_CAPTATION_DATE, 'DD/MM/YYYY HH:Mi:SS'),
'NO INFORMADA')
"FECHA 1° CAPTACION DER",
NVL (TO_CHAR (F.STARTING_UP_FIRST_DATE, 'DD/MM/YYYY HH:Mi:SS'),
'NO INFORMADA')
"FECHA 1° PUESTA FINCA",
NVL (TO_CHAR (S.LAST_DATE_SUSPENSION, 'DD/MM/YYYY HH:Mi:SS'),
'NO INFORMADA')
"FECHA ULTIMO CESE",
NVL(F.PLUG_AND_PLAY, 'NULL') "PLUG & PLAY",
USO.USE_TYPE_DESCRIPTION "USO DEL GAS",
CALDERA.BOILER_DESCRIPTION "CALDERA",
MERCADO.MARKET_DESCRIPTION "MERCADO"
FROM GPOT_SUPPLIES S
LEFT JOIN
GCAR_SUPPLY_SECTOR SS
ON S.SUPPLY_ID = SS.SUPPLY_ID
LEFT JOINGPOT_MASTER_MARKET MERCADO
ON S.MARKET_ID = MERCADO.MARKET_ID
LEFT JOIN
GCAR_DERIVATION DER
ON DER.DERIVATION_ID = SS.DERIVATION_IRC_ID
LEFT JOIN
GPOT_USE_TYPE USO
ON USO.USE_TYPE_ID = S.USE_TYPE_ID
LEFT JOINGPOT_BUILDING F
ON F.BUILDING_ID = S.BUILDING_ID
LEFT JOIN
GPOT_CENTRAL_BOILER_TYPE CALDERA
ON CALDERA.CENTRAL_BOILER_ID = S.CENTRAL_BOILER_ID
LEFT JOIN
GPOT_SUPPLIES_STATUS ESTADO
ON ESTADO.COD_SUPPLIES_STATUS = S.COD_SUPPLIES_STATUS
WHERE S.SUPPLY_ID IN (&CIDI);


SELECT S.SUPPLY_ID "CIDI",...