APPS.FII_AR_SALES_CREDITS_C dependencies on FII_AR_REVENUE_B

Line 343: -- Insert dummy records from the Snapshot Log for FII_AR_REVENUE_B

339: fii_util.put_line('Inserting dummy records for new posted invoice lines without sales credits');
340: fii_util.start_timer;
341: end if;
342:
343: -- Insert dummy records from the Snapshot Log for FII_AR_REVENUE_B
344: insert into fii_ar_sales_credits (
345: SALESCREDIT_PK, INVOICE_LINE_ID,
346: SALESREP_ID, SALESGROUP_ID,
347: REVENUE_PERCENT_SPLIT,

Line 357: from mlog$_fii_ar_revenue_b rev_log

353: 100,
354: g_fii_user_id, g_fii_user_id,
355: g_fii_login_id,
356: SYSDATE, SYSDATE
357: from mlog$_fii_ar_revenue_b rev_log
358: --where invoice_line_id not in (select distinct invoice_line_id from fii_ar_sales_credits)
359: where not exists (select 'X' from fii_ar_sales_credits where invoice_line_id = rev_log.invoice_line_id)
360: and dmltype$$ = 'I';
361:

Line 447: -- Initial Load of dummy records from FII_AR_REVENUE_B

443: fii_util.put_line(' ');
444: fii_util.put_line('start of third insert');
445: end if;
446:
447: -- Initial Load of dummy records from FII_AR_REVENUE_B
448: insert /*+ APPEND PARALLEL(F) */ into fii_ar_sales_CREDITS F (
449: SALESCREDIT_PK, INVOICE_LINE_ID,
450: SALESREP_ID, SALESGROUP_ID,
451: REVENUE_PERCENT_SPLIT,

Line 461: from fii_ar_revenue_b rev

457: 100,
458: g_fii_user_id, g_fii_user_id,
459: g_fii_login_id,
460: SYSDATE, SYSDATE
461: from fii_ar_revenue_b rev
462: where transaction_class <> 'ADJ'
463: and invoice_line_id is not null
464: and invoice_line_id not in (
465: select /*+ hash_aj parallel_index(b) index_ffs(b) */