APPS.EDW_POA_CONTRACT_HOOK SQL Statements

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

Line: 9

     Update POA_EDW_CONTRACT_FSTG Fact
     set (DUNS_FK, SIC_CODE_FK) =
         (select Com.DUNS, Com.SIC_Code
          from POA_DNB_TRD_PRTNR Com
          where (Fact.Supplier_Site_FK = Com.Trading_Partner_PK))
     where ((Fact.Collection_Status = 'READY') and
            (Fact.Supplier_Site_FK IN (select Trading_Partner_PK
                                       from POA_DNB_TRD_PRTNR)));