DBA Data[Home] [Help]

APPS.EDW_SICM_DUNS_HOOK dependencies on EDW_DUNS_NUMBER_LSTG

Line 8: from EDW_DUNS_NUMBER_LSTG lstg,

4: FUNCTION POST_DIM_COLLECT(p_object_name varchar2) RETURN BOOLEAN IS
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'