DBA Data[Home] [Help]

APPS.EDW_POA_CSTM_MSR_HOOK dependencies on POA_DNB_TRD_PRTNR

Line 33: from POA_DNB_TRD_PRTNR Com

29:
30: Update POA_EDW_CSTM_MSR_FSTG Fact
31: set (DUNS_FK, SIC_CODE_FK) =
32: (select Com.DUNS, Com.SIC_Code
33: from POA_DNB_TRD_PRTNR Com
34: where (Fact.Supplier_Site_FK = Com.Trading_Partner_PK))
35: where ((Fact.Collection_Status = 'READY') and
36: (Fact.Supplier_Site_FK IN (select Trading_Partner_PK
37: from POA_DNB_TRD_PRTNR)));

Line 37: from POA_DNB_TRD_PRTNR)));

33: from POA_DNB_TRD_PRTNR Com
34: where (Fact.Supplier_Site_FK = Com.Trading_Partner_PK))
35: where ((Fact.Collection_Status = 'READY') and
36: (Fact.Supplier_Site_FK IN (select Trading_Partner_PK
37: from POA_DNB_TRD_PRTNR)));
38: ELSE
39: EDW_OWB_COLLECTION_UTIL.write_to_log_file('DNB is disabled');
40: END IF;
41: