APPS.EDW_SICM_INV_ON_HOLD_HOOK SQL Statements

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

Line: 7

  Update FII_AP_INV_ON_HOLD_FSTG Fact
  set (DUNS_FK, SIC_CODE_FK) =
      (select Com.DUNS, Com.SIC_Code
       from POA_DNB_TRD_PRTNR Com
       where (Fact.Supplier_FK = Com.Trading_Partner_PK))
  where (Fact.Supplier_FK IN (select Trading_Partner_PK
                              from POA_DNB_TRD_PRTNR));