DBA Data[Home] [Help]

APPS.EDW_POA_RCV_TXNS_HOOK dependencies on POA_EDW_RCV_TXNS_FSTG

Line 12: Update POA_EDW_RCV_TXNS_FSTG Fact

8:
9: IF (fnd_profile.value('POA_DNB_HOOKS') = 'N') THEN
10: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Staging Table to reference UNSPSC Dimension');
11:
12: Update POA_EDW_RCV_TXNS_FSTG Fact
13: set UNSPSC_FK =
14: (select Com.Function
15: from EdW_Item_ItemRev_LTC IRev,
16: EdW_Item_ItemOrg_LTC IOrg,

Line 33: Update POA_EDW_RCV_TXNS_FSTG Fact

29:
30: -- Update DUNS
31: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Staging Tables to reference DUNS and SIC Code Dimension');
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))