APPS.EDW_SICM_SIC_HOOK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

       Select SIC_CODE_PK from EDW_SICM_SIC_LSTG
       where Update_Fact_Flag = 'Y';

Line: 13

           Update FII_AP_HOLD_DATA_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_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))));

Line: 28

           Update FII_AP_INV_ON_HOLD_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_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))));

Line: 43

           Update FII_AP_INV_LINES_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_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))));

Line: 58

           Update FII_AP_INV_PAYMTS_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_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))));

Line: 73

           Update FII_AP_SCH_PAYMTS_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_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))));