APPS.EDW_SICM_DUNS_HOOK SQL Statements

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

Line: 6

    select DUNS.DUNS_NUM_PK_KEY DUNS_NUM_PK_KEY,
	   Tprt.TPartner_Loc_PK_Key TPartner_Loc_PK_Key
    from EDW_DUNS_NUMBER_LSTG lstg,
         EDW_DUNS_NUMBER_LTC DUNS,
	 POA_DNB_TRD_PRTNR Com,
	 EDW_TPRT_TPARTNER_LOC_LTC Tprt
    where lstg.Update_Fact_Flag = 'Y'
    AND   lstg.DUNS_NUM_PK=DUNS.DUNS_NUM_PK
    AND   lstg.DUNS_NUM_PK=Com.DUNS
    AND   Tprt.Tpartner_Loc_PK = Com.TRADING_PARTNER_PK;

Line: 22

           Update FII_AP_HOLD_DATA_F Fact
	   set DUNS_FK_KEY = lduns.DUNS_NUM_PK_KEY
	   where Fact.Supplier_FK_Key = lduns.TPartner_Loc_PK_Key;

Line: 28

           Update FII_AP_INV_ON_HOLD_F Fact
	   set DUNS_FK_KEY = lduns.DUNS_NUM_PK_KEY
	   where Fact.Supplier_FK_Key = lduns.TPartner_Loc_PK_Key;

Line: 35

	   Update FII_AP_INV_LINES_F Fact
	   set DUNS_FK_KEY = lduns.DUNS_NUM_PK_KEY
	   where Fact.Supplier_FK_Key = lduns.TPartner_Loc_PK_Key;

Line: 42

	   Update FII_AP_INV_PAYMTS_F Fact
	   set DUNS_FK_KEY = lduns.DUNS_NUM_PK_KEY
	   where Fact.Supplier_FK_Key = lduns.TPartner_Loc_PK_Key;

Line: 49

	   Update FII_AP_SCH_PAYMTS_F Fact
	   set DUNS_FK_KEY = lduns.DUNS_NUM_PK_KEY
	   where Fact.Supplier_FK_Key = lduns.TPartner_Loc_PK_Key;