DBA Data[Home] [Help]

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))