APPS.EDW_DUNS_M_C dependencies on EDW_TPRT_TPARTNER_LOC_LTC

Line 100: from EDW_TPRT_TPARTNER_LOC_LTC TPRT,

96:
97: Procedure Push_EDW_DNB_TPRT IS
98: CURSOR c_vendors IS
99: select distinct Trade_Partner_FK, Name
100: from EDW_TPRT_TPARTNER_LOC_LTC TPRT,
101: POA_TPRT_INTERFACE dnb
102: where (TPRT.TPartner_Loc_PK = dnb.Trading_Partner_PK);
103:
104: CURSOR c_dnb_failure IS

Line 440: from EDW_TPRT_TPARTNER_LOC_LTC TPRT,

436: For lvendor in c_vendors loop
437: DECLARE
438: CURSOR c_vendor_site IS
439: select Trade_Partner_FK, Global_Ult_Duns
440: from EDW_TPRT_TPARTNER_LOC_LTC TPRT,
441: POA_TPRT_INTERFACE dnb
442: where ((TPRT.TPartner_Loc_PK = lvendor.Trade_Partner_FK) and
443: (dnb.Trading_Partner_PK = TPRT.Trade_Partner_FK));
444: BEGIN

Line 453: from EDW_TPRT_TPARTNER_LOC_LTC TPRT,

449: DUNS = lvsite.Global_Ult_Duns,
450: DNB_Update_Date = sysdate
451: where Trading_Partner_PK IN
452: (select Trade_Partner_FK
453: from EDW_TPRT_TPARTNER_LOC_LTC TPRT,
454: POA_TPRT_INTERFACE dnb
455: where ((poa.TRADING_PARTNER_PK = lvendor.Trade_Partner_FK) and
456: (poa.DUNS <> lvsite.Global_Ult_Duns)));
457: