DBA Data[Home] [Help]

APPS.EDW_POA_RCV_TXNS_HOOK dependencies on POA_DNB_TRD_PRTNR

Line 36: from POA_DNB_TRD_PRTNR Com

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

Line 40: from POA_DNB_TRD_PRTNR)));

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