APPS.EDW_POA_SUP_PERF_HOOK dependencies on POA_EDW_SUP_PERF_FSTG

Line 11: Update POA_EDW_SUP_PERF_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_SUP_PERF_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_SUP_PERF_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_SUP_PERF_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))

Line 41: Update POA_EDW_SUP_PERF_FSTG

37: from POA_DNB_TRD_PRTNR)));
38:
39: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating target_price_t...');
40:
41: Update POA_EDW_SUP_PERF_FSTG
42: set target_price_t = DECODE(price_g,
43: to_number(NULL), to_number(NULL),
44: 0, to_number(NULL),
45: target_price_g * price_t / price_g)