APPS.EDW_POA_DIST_HOOK dependencies on POA_DNB_TRD_PRTNR

Line 35: from POA_DNB_TRD_PRTNR Com

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

Line 39: from POA_DNB_TRD_PRTNR)));

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