DBA Data[Home] [Help]

APPS.EDW_POA_CSTM_MSR_HOOK dependencies on POA_EDW_CSTM_MSR_FSTG

Line 11: Update POA_EDW_CSTM_MSR_FSTG Fact

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

Line 30: Update POA_EDW_CSTM_MSR_FSTG Fact

26: (IOrg.Item_Org_PK = IRev.Item_Org_FK))));
27:
28: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Staging Tables to reference DUNS and SIC Code Dimension');
29:
30: Update POA_EDW_CSTM_MSR_FSTG Fact
31: set (DUNS_FK, SIC_CODE_FK) =
32: (select Com.DUNS, Com.SIC_Code
33: from POA_DNB_TRD_PRTNR Com
34: where (Fact.Supplier_Site_FK = Com.Trading_Partner_PK))