APPS.EDW_SICM_SIC_HOOK dependencies on FII_AP_INV_LINES_F

Line 42: -- Updating FII_AP_INV_LINES_F

38: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
39: (dnb.SIC_CODE = Com.SIC_CODE) and
40: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
41:
42: -- Updating FII_AP_INV_LINES_F
43: Update FII_AP_INV_LINES_F Fact
44: set (SIC_CODE_FK_KEY) =
45: (select SIC.SIC_CODE_PK_KEY
46: from EDW_SICM_SIC_LTC SIC

Line 43: Update FII_AP_INV_LINES_F Fact

39: (dnb.SIC_CODE = Com.SIC_CODE) and
40: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
41:
42: -- Updating FII_AP_INV_LINES_F
43: Update FII_AP_INV_LINES_F Fact
44: set (SIC_CODE_FK_KEY) =
45: (select SIC.SIC_CODE_PK_KEY
46: from EDW_SICM_SIC_LTC SIC
47: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))