APPS.EDW_POA_CONTRACT_HOOK dependencies on POA_EDW_CONTRACT_FSTG
Line 9: Update POA_EDW_CONTRACT_FSTG Fact
5: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering Contract Pre Fact Hook Procedure');
6: IF (fnd_profile.value('POA_DNB_HOOKS') = 'N') THEN
7: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Staging Table to reference DUNS and SIC Code Dimension');
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))