DBA Data[Home] [Help]

APPS.EDW_POA_CONTRACT_HOOK dependencies on POA_DNB_TRD_PRTNR

Line 12: from POA_DNB_TRD_PRTNR Com

8:
9: Update POA_EDW_CONTRACT_FSTG Fact
10: set (DUNS_FK, SIC_CODE_FK) =
11: (select Com.DUNS, Com.SIC_Code
12: from POA_DNB_TRD_PRTNR Com
13: where (Fact.Supplier_Site_FK = Com.Trading_Partner_PK))
14: where ((Fact.Collection_Status = 'READY') and
15: (Fact.Supplier_Site_FK IN (select Trading_Partner_PK
16: from POA_DNB_TRD_PRTNR)));

Line 16: from POA_DNB_TRD_PRTNR)));

12: from POA_DNB_TRD_PRTNR Com
13: where (Fact.Supplier_Site_FK = Com.Trading_Partner_PK))
14: where ((Fact.Collection_Status = 'READY') and
15: (Fact.Supplier_Site_FK IN (select Trading_Partner_PK
16: from POA_DNB_TRD_PRTNR)));
17: ELSE
18: EDW_OWB_COLLECTION_UTIL.write_to_log_file('DNB is disabled');
19: END IF;
20: