APPS.EDW_POA_SUP_PERF_HOOK SQL Statements

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

Line: 11

     Update POA_EDW_SUP_PERF_FSTG Fact
     set UNSPSC_FK =
         (select Com.Function
          from EdW_Item_ItemRev_LTC IRev,
              EdW_Item_ItemOrg_LTC IOrg,
               POA_DNB_ITEMS Com
          where ((Fact.Item_FK = IRev.Item_Revision_PK) and
                 (Com.Item_PK = IOrg.Item_Number_FK) and
                (IOrg.Item_Org_PK = IRev.Item_Org_FK)))
     where ((Fact.Collection_Status = 'READY') and
            (Fact.Item_FK IN (select IRev.Item_Revision_PK
                              from EdW_Item_ItemRev_LTC IRev,
                                   EdW_Item_ItemOrg_LTC IOrg,
                                   POA_DNB_ITEMS Com
                              where (Com.Item_PK = IOrg.Item_Number_FK) and
                                    (IOrg.Item_Org_PK = IRev.Item_Org_FK))));

Line: 30

     Update POA_EDW_SUP_PERF_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)));

Line: 41

     Update POA_EDW_SUP_PERF_FSTG
     set target_price_t = DECODE(price_g,
			  to_number(NULL), to_number(NULL),
			  0, to_number(NULL),
			  target_price_g * price_t / price_g)
     where collection_status = 'READY';