DBA Data[Home] [Help]

APPS.EDW_POA_ALINES_HOOK dependencies on POA_DNB_TRD_PRTNR

Line 33: from POA_DNB_TRD_PRTNR Com

29: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Staging Tables to reference DUNS and SIC Code Dimension');
30: Update POA_EDW_ALINES_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: