APPS.EDW_POA_UNSPSC_HOOK SQL Statements

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

Line: 5

       Select Function_PK from EDW_SPSC_FUNCTION_LSTG
       where Update_Fact_Flag = 'Y';

Line: 17

           Update POA_EDW_PO_DIST_F Fact
           set (UNSPSC_FK_Key) =
               (select UNSPSC.Function_PK_Key
                from EDW_SPSC_FUNCTION_LTC UNSPSC
                where (litem.Function_PK = UNSPSC.Function_PK))
           where (Fact.Item_FK_Key IN
                  (select IRev.Item_Revision_PK_Key
                   from POA_DNB_ITEMS Com,
                        EdW_Item_ItemRev_LTC IRev,
                        EdW_Item_ItemOrg_LTC IOrg
                   where ((litem.Function_PK = Com.Function) and
                          (Com.Item_PK = IOrg.Item_Number_FK) and
                          (IOrg.Item_Org_PK = IRev.Item_Org_FK))));

Line: 32

           Update POA_EDW_RCV_TXNS_F Fact
           set (UNSPSC_FK_Key) =
               (select UNSPSC.Function_PK_Key
                from EDW_SPSC_FUNCTION_LTC UNSPSC
                where (litem.Function_PK = UNSPSC.Function_PK))
           where (Fact.Item_Revision_FK_Key IN
                  (select IRev.Item_Revision_PK_Key
                   from POA_DNB_ITEMS Com,
                        EdW_Item_ItemRev_LTC IRev,
                        EdW_Item_ItemOrg_LTC IOrg
                   where ((litem.Function_PK = Com.Function) and
                          (Com.Item_PK = IOrg.Item_Number_FK) and
                          (IOrg.Item_Org_PK = IRev.Item_Org_FK))));

Line: 47

           Update POA_EDW_ALINES_F Fact
           set (UNSPSC_FK_Key) =
               (select UNSPSC.Function_PK_Key
                from EDW_SPSC_FUNCTION_LTC UNSPSC
                where (litem.Function_PK = UNSPSC.Function_PK))
           where (Fact.Item_Revision_FK_Key IN
                  (select IRev.Item_Revision_PK_Key
                   from POA_DNB_ITEMS Com,
                        EdW_Item_ItemRev_LTC IRev,
                        EdW_Item_ItemOrg_LTC IOrg
                   where ((litem.Function_PK = Com.Function) and
                          (Com.Item_PK = IOrg.Item_Number_FK) and
                          (IOrg.Item_Org_PK = IRev.Item_Org_FK))));

Line: 63

           Update POA_EDW_CSTM_MSR_F Fact
           set (UNSPSC_FK_Key) =
               (select UNSPSC.Function_PK_Key
                from EDW_SPSC_FUNCTION_LTC UNSPSC
                where (litem.Function_PK = UNSPSC.Function_PK))
           where (Fact.Item_FK_Key IN
                  (select IRev.Item_Revision_PK_Key
                   from POA_DNB_ITEMS Com,
                        EdW_Item_ItemRev_LTC IRev,
                        EdW_Item_ItemOrg_LTC IOrg
                   where ((litem.Function_PK = Com.Function) and
                          (Com.Item_PK = IOrg.Item_Number_FK) and
                          (IOrg.Item_Org_PK = IRev.Item_Org_FK))));

Line: 79

           Update POA_EDW_SUP_PERF_F Fact
           set (UNSPSC_FK_Key) =
               (select UNSPSC.Function_PK_Key
                from EDW_SPSC_FUNCTION_LTC UNSPSC
                where (litem.Function_PK = UNSPSC.Function_PK))
           where (Fact.Item_FK_Key IN
                  (select IRev.Item_Revision_PK_Key
                   from POA_DNB_ITEMS Com,
                        EdW_Item_ItemRev_LTC IRev,
                        EdW_Item_ItemOrg_LTC IOrg
                   where ((litem.Function_PK = Com.Function) and
                          (Com.Item_PK = IOrg.Item_Number_FK) and
                          (IOrg.Item_Org_PK = IRev.Item_Org_FK))));

Line: 95

   EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updated Existing POA Facts');