APPS.EDW_POA_DUNS_HOOK SQL Statements

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

Line: 6

       Select DUNS_NUM_PK from EDW_DUNS_NUMBER_LSTG
       where Update_Fact_Flag = 'Y';

Line: 18

           Update POA_EDW_ALINES_F Fact
           set (DUNS_FK_KEY) =
                (select DUNS.DUNS_NUM_PK_KEY
                 from EDW_DUNS_NUMBER_LTC DUNS
                 where (lduns.DUNS_NUM_PK  = DUNS.DUNS_NUM_PK))
           where (Fact.Supplier_Site_FK_Key IN
                  (select TPartner_Loc_PK_Key
                   from POA_DNB_TRD_PRTNR Com,
                        EDW_TPRT_TPARTNER_LOC_LTC TPrt
                   where ((lduns.DUNS_NUM_PK  = Com.DUNS) and
                          (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));

Line: 32

           Update POA_EDW_CONTRACT_F Fact
           set (DUNS_FK_KEY) =
                (select DUNS.DUNS_NUM_PK_KEY
                 from EDW_DUNS_NUMBER_LTC DUNS
                 where (lduns.DUNS_NUM_PK  = DUNS.DUNS_NUM_PK))
           where (Fact.Supplier_Site_FK_Key IN
                  (select TPartner_Loc_PK_Key
                   from POA_DNB_TRD_PRTNR Com,
                        EDW_TPRT_TPARTNER_LOC_LTC TPrt
                   where ((lduns.DUNS_NUM_PK  = Com.DUNS) and
                          (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));

Line: 45

           Update POA_EDW_CSTM_MSR_F Fact
           set (DUNS_FK_KEY) =
                (select DUNS.DUNS_NUM_PK_KEY
                 from EDW_DUNS_NUMBER_LTC DUNS
                 where (lduns.DUNS_NUM_PK  = DUNS.DUNS_NUM_PK))
           where (Fact.Supplier_Site_FK_Key IN
                  (select TPartner_Loc_PK_Key
                   from POA_DNB_TRD_PRTNR Com,
                        EDW_TPRT_TPARTNER_LOC_LTC TPrt
                   where ((lduns.DUNS_NUM_PK  = Com.DUNS) and
                          (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));

Line: 58

           Update POA_EDW_PO_DIST_F Fact
           set (DUNS_FK_KEY) =
                (select DUNS.DUNS_NUM_PK_KEY
                 from EDW_DUNS_NUMBER_LTC DUNS
                 where (lduns.DUNS_NUM_PK  = DUNS.DUNS_NUM_PK))
           where (Fact.Supplier_Site_FK_Key IN
                  (select TPartner_Loc_PK_Key
                   from POA_DNB_TRD_PRTNR Com,
                        EDW_TPRT_TPARTNER_LOC_LTC TPrt
                   where ((lduns.DUNS_NUM_PK  = Com.DUNS) and
                          (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));

Line: 71

           Update POA_EDW_RCV_TXNS_F Fact
           set (DUNS_FK_KEY) =
                (select DUNS.DUNS_NUM_PK_KEY
                 from EDW_DUNS_NUMBER_LTC DUNS
                 where (lduns.DUNS_NUM_PK  = DUNS.DUNS_NUM_PK))
           where (Fact.Supplier_Site_FK_Key IN
                  (select TPartner_Loc_PK_Key
                   from POA_DNB_TRD_PRTNR Com,
                        EDW_TPRT_TPARTNER_LOC_LTC TPrt
                   where ((lduns.DUNS_NUM_PK  = Com.DUNS) and
                          (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));

Line: 84

           Update POA_EDW_SUP_PERF_F Fact
           set (DUNS_FK_KEY) =
                (select DUNS.DUNS_NUM_PK_KEY
                 from EDW_DUNS_NUMBER_LTC DUNS
                 where (lduns.DUNS_NUM_PK  = DUNS.DUNS_NUM_PK))
           where (Fact.Supplier_Site_FK_Key IN
                  (select TPartner_Loc_PK_Key
                   from POA_DNB_TRD_PRTNR Com,
                        EDW_TPRT_TPARTNER_LOC_LTC TPrt
                   where ((lduns.DUNS_NUM_PK  = Com.DUNS) and
                          (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));

Line: 97

   EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updated POA Facts');