with last_upserted as (
select r.OBJECT_ID, max(r.UPSERTED_ON) as last_update
from KIN_PNG.DW_GEO_RESERVES_FORM6_REGISTRY r
group by r.OBJECT_ID
)
 
select  f.OILFIELD_NAME, o.OBJECT_NAME, u.VALUE_FULL, c.VALUE_FULL,  r.UPSERTED_ON, g.*
from KIN_PNG.DW_GEO_RESERVES_FORM6 g, KIN_PNG.DW_GEO_RESERVES_FORM6_REGISTRY r, KIN_PNG.DW_DICT_RESERVES_CAT c, KIN_PNG.DW_DICT_TYPE_UV u, KIN_PNG.DW_OBJECT o, KIN_PNG.DW_OILFIELD f, last_upserted lu
where
g.REG_RVS_ID = r.REG_RVS_ID and
g.TYPE_UV = u.ID_CODE and
g.RESERVES_CAT = c.ID_CODE and
f.OILFIELD_ID = o.OILFIELD_ID and
lu.OBJECT_ID = r.OBJECT_ID and
lu.last_update = r.UPSERTED_ON and
r.OBJECT_ID = o.OBJECT_ID and
c.VALUE_FULL = 'AB1C1B2C2'
 
order by f.OILFIELD_NAME, o.OBJECT_ID, u.VALUE_FULL, c.VALUE_FULL asc
 

d2l0aCBsYXN0X3Vwc2VydGVkIGFzICgKc2VsZWN0IHIuT0JKRUNUX0lELCBtYXgoci5VUFNFUlRFRF9PTikgYXMgbGFzdF91cGRhdGUKZnJvbSBLSU5fUE5HLkRXX0dFT19SRVNFUlZFU19GT1JNNl9SRUdJU1RSWSByCmdyb3VwIGJ5IHIuT0JKRUNUX0lECikKCnNlbGVjdCAgZi5PSUxGSUVMRF9OQU1FLCBvLk9CSkVDVF9OQU1FLCB1LlZBTFVFX0ZVTEwsIGMuVkFMVUVfRlVMTCwgIHIuVVBTRVJURURfT04sIGcuKgpmcm9tIEtJTl9QTkcuRFdfR0VPX1JFU0VSVkVTX0ZPUk02IGcsIEtJTl9QTkcuRFdfR0VPX1JFU0VSVkVTX0ZPUk02X1JFR0lTVFJZIHIsIEtJTl9QTkcuRFdfRElDVF9SRVNFUlZFU19DQVQgYywgS0lOX1BORy5EV19ESUNUX1RZUEVfVVYgdSwgS0lOX1BORy5EV19PQkpFQ1QgbywgS0lOX1BORy5EV19PSUxGSUVMRCBmLCBsYXN0X3Vwc2VydGVkIGx1CndoZXJlCmcuUkVHX1JWU19JRCA9IHIuUkVHX1JWU19JRCBhbmQKZy5UWVBFX1VWID0gdS5JRF9DT0RFIGFuZApnLlJFU0VSVkVTX0NBVCA9IGMuSURfQ09ERSBhbmQKZi5PSUxGSUVMRF9JRCA9IG8uT0lMRklFTERfSUQgYW5kCmx1Lk9CSkVDVF9JRCA9IHIuT0JKRUNUX0lEIGFuZApsdS5sYXN0X3VwZGF0ZSA9IHIuVVBTRVJURURfT04gYW5kCnIuT0JKRUNUX0lEID0gby5PQkpFQ1RfSUQgYW5kCmMuVkFMVUVfRlVMTCA9ICdBQjFDMUIyQzInCgpvcmRlciBieSBmLk9JTEZJRUxEX05BTUUsIG8uT0JKRUNUX0lELCB1LlZBTFVFX0ZVTEwsIGMuVkFMVUVfRlVMTCBhc2MK