The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select SIC_CODE_PK from EDW_SICM_SIC_LSTG
where Update_Fact_Flag = 'Y';
Update POA_EDW_ALINES_F Fact
set (SIC_CODE_FK_KEY) =
(select SIC.SIC_CODE_PK_KEY
from EDW_SICM_SIC_LTC SIC
where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
where (Fact.Supplier_Site_FK_Key IN
(select TPartner_Loc_PK_Key
from POA_DNB_SIC_CODE Com,
POA_DNB_TRD_PRTNR dnb,
EDW_TPRT_TPARTNER_LOC_LTC TPrt
where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
(dnb.SIC_CODE = Com.SIC_CODE) and
(TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
Update POA_EDW_CONTRACT_F Fact
set (SIC_CODE_FK_KEY) =
(select SIC.SIC_CODE_PK_KEY
from EDW_SICM_SIC_LTC SIC
where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
where (Fact.Supplier_Site_FK_Key IN
(select TPartner_Loc_PK_Key
from POA_DNB_SIC_CODE Com,
POA_DNB_TRD_PRTNR dnb,
EDW_TPRT_TPARTNER_LOC_LTC TPrt
where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
(dnb.SIC_CODE = Com.SIC_CODE) and
(TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
Update POA_EDW_CSTM_MSR_F Fact
set (SIC_CODE_FK_KEY) =
(select SIC.SIC_CODE_PK_KEY
from EDW_SICM_SIC_LTC SIC
where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
where (Fact.Supplier_Site_FK_Key IN
(select TPartner_Loc_PK_Key
from POA_DNB_SIC_CODE Com,
POA_DNB_TRD_PRTNR dnb,
EDW_TPRT_TPARTNER_LOC_LTC TPrt
where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
(dnb.SIC_CODE = Com.SIC_CODE) and
(TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
Update POA_EDW_PO_DIST_F Fact
set (SIC_CODE_FK_KEY) =
(select SIC.SIC_CODE_PK_KEY
from EDW_SICM_SIC_LTC SIC
where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
where (Fact.Supplier_Site_FK_Key IN
(select TPartner_Loc_PK_Key
from POA_DNB_SIC_CODE Com,
POA_DNB_TRD_PRTNR dnb,
EDW_TPRT_TPARTNER_LOC_LTC TPrt
where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
(dnb.SIC_CODE = Com.SIC_CODE) and
(TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
Update POA_EDW_RCV_TXNS_F Fact
set (SIC_CODE_FK_KEY) =
(select SIC.SIC_CODE_PK_KEY
from EDW_SICM_SIC_LTC SIC
where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
where (Fact.Supplier_Site_FK_Key IN
(select TPartner_Loc_PK_Key
from POA_DNB_SIC_CODE Com,
POA_DNB_TRD_PRTNR dnb,
EDW_TPRT_TPARTNER_LOC_LTC TPrt
where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
(dnb.SIC_CODE = Com.SIC_CODE) and
(TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
Update POA_EDW_SUP_PERF_F Fact
set (SIC_CODE_FK_KEY) =
(select SIC.SIC_CODE_PK_KEY
from EDW_SICM_SIC_LTC SIC
where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
where (Fact.Supplier_Site_FK_Key IN
(select TPartner_Loc_PK_Key
from POA_DNB_SIC_CODE Com,
POA_DNB_TRD_PRTNR dnb,
EDW_TPRT_TPARTNER_LOC_LTC TPrt
where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
(dnb.SIC_CODE = Com.SIC_CODE) and
(TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updated POA Facts');