DBA Data[Home] [Help]

APPS.FII_AR_SALES_CREDITS_C dependencies on MLOG$_FII_AR_SALES_CREDITS

Line 312: from mlog$_fii_ar_sales_credits sc_log

308: 100,
309: g_fii_user_id, g_fii_user_id,
310: g_fii_login_id,
311: SYSDATE, SYSDATE
312: from mlog$_fii_ar_sales_credits sc_log
313: --where invoice_line_id not in (select distinct invoice_line_id from fii_ar_sales_credits)
314: where not exists (select 'X' from fii_ar_sales_credits where invoice_line_id = sc_log.invoice_line_id)
315: and dmltype$$ = 'D';
316:

Line 330: from mlog$_fii_ar_sales_credits

326: -- Delete dummy records based on the Snapshot Log for FII_AR_SALES_CREDITS
327: delete from fii_ar_sales_credits
328: where salescredit_pk in
329: (select -invoice_line_id
330: from mlog$_fii_ar_sales_credits
331: where dmltype$$ = 'I'
332: and salescredit_pk > 0);
333:
334: if g_debug_flag = 'Y' then