DBA Data[Home] [Help]

APPS.EDW_SICM_SIC_HOOK dependencies on FII_AP_INV_PAYMTS_F

Line 57: -- Updating FII_AP_INV_PAYMTS_F

53: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
54: (dnb.SIC_CODE = Com.SIC_CODE) and
55: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
56:
57: -- Updating FII_AP_INV_PAYMTS_F
58: Update FII_AP_INV_PAYMTS_F Fact
59: set (SIC_CODE_FK_KEY) =
60: (select SIC.SIC_CODE_PK_KEY
61: from EDW_SICM_SIC_LTC SIC

Line 58: Update FII_AP_INV_PAYMTS_F Fact

54: (dnb.SIC_CODE = Com.SIC_CODE) and
55: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
56:
57: -- Updating FII_AP_INV_PAYMTS_F
58: Update FII_AP_INV_PAYMTS_F Fact
59: set (SIC_CODE_FK_KEY) =
60: (select SIC.SIC_CODE_PK_KEY
61: from EDW_SICM_SIC_LTC SIC
62: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))