DBA Data[Home] [Help]

APPS.EDW_POA_SUP_PERF_HOOK dependencies on POA_DNB_TRD_PRTNR

Line 33: from POA_DNB_TRD_PRTNR Com

29:
30: Update POA_EDW_SUP_PERF_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:
39: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating target_price_t...');
40:
41: Update POA_EDW_SUP_PERF_FSTG