APPS.EDW_POA_DIST_HOOK SQL Statements

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

Line: 12

     Update POA_EDW_PO_DIST_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: 32

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