DBA Data[Home] [Help]

APPS.EDW_SICM_SCH_PAYMTS_HOOK dependencies on POA_DNB_TRD_PRTNR

Line 10: from POA_DNB_TRD_PRTNR Com

6: -- Update DUNS
7: Update FII_AP_SCH_PAYMTS_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))
12: where (Fact.Supplier_FK IN (select Trading_Partner_PK
13: from POA_DNB_TRD_PRTNR));
14: return true;

Line 13: from POA_DNB_TRD_PRTNR));

9: (select Com.DUNS, Com.SIC_Code
10: from POA_DNB_TRD_PRTNR Com
11: where (Fact.Supplier_FK = Com.Trading_Partner_PK))
12: where (Fact.Supplier_FK IN (select Trading_Partner_PK
13: from POA_DNB_TRD_PRTNR));
14: return true;
15: end Pre_Fact_Collect;
16: END EDW_SICM_SCH_PAYMTS_HOOK;
17: