APPS.EDW_POA_DIST_HOOK dependencies on POA_EDW_PO_DIST_FSTG

Line 12: Update POA_EDW_PO_DIST_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_PO_DIST_FSTG Fact
13: set UNSPSC_FK =
14: (select Com.Function
15: from EdW_Item_ItemRev_LTC IRev,
16: EdW_Item_ItemOrg_LTC IOrg,

Line 32: Update POA_EDW_PO_DIST_FSTG Fact

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