APPS.EDW_SICM_INV_LINES_HOOK dependencies on FII_AP_INV_LINES_FSTG

Line 7: Update FII_AP_INV_LINES_FSTG Fact

3:
4: FUNCTION Pre_Fact_Collect(p_object_name varchar2) RETURN BOOLEAN IS
5: begin
6: -- Update DUNS
7: Update FII_AP_INV_LINES_FSTG Fact
8: set (DUNS_FK, SIC_CODE_FK) =
9: (select Com.DUNS, Com.SIC_Code
10: from POA_DNB_TRD_PRTNR Com
11: where (Fact.Supplier_FK = Com.Trading_Partner_PK))

Line 23: Update FII_AP_INV_LINES_FSTG Fact

19: (EdW_Item_ItemRev_LTC,EdW_Item_ItemOrg_LTC)
20: rather than star table (EDW_TIME_M) for updating
21: Invoice Lines Fact with UNSPC information. */
22:
23: Update FII_AP_INV_LINES_FSTG Fact
24: set UNSPSC_FK =
25: (select Com.Function
26: from EdW_Item_ItemRev_LTC IRev,
27: EdW_Item_ItemOrg_LTC IOrg,