APPS.EDW_POA_ALINES_HOOK SQL Statements

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

Line: 11

      Update POA_EDW_ALINES_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_Revision_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_Revision_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_ALINES_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)));