DBA Data[Home] [Help]

APPS.EDW_SICM_DUNS_HOOK dependencies on EDW_DUNS_NUMBER_LTC

Line 9: EDW_DUNS_NUMBER_LTC DUNS,

5: CURSOR c_duns is
6: select DUNS.DUNS_NUM_PK_KEY DUNS_NUM_PK_KEY,
7: Tprt.TPartner_Loc_PK_Key TPartner_Loc_PK_Key
8: from EDW_DUNS_NUMBER_LSTG lstg,
9: EDW_DUNS_NUMBER_LTC DUNS,
10: POA_DNB_TRD_PRTNR Com,
11: EDW_TPRT_TPARTNER_LOC_LTC Tprt
12: where lstg.Update_Fact_Flag = 'Y'
13: AND lstg.DUNS_NUM_PK=DUNS.DUNS_NUM_PK