APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on ISC_DBI_CHANGE_LOG

Line 327: IF (truncate_table('ISC_DBI_CHANGE_LOG') = -1) THEN

323:
324: BIS_COLLECTION_UTILITIES.put_line('Truncating the temp table');
325: FII_UTIL.Start_Timer;
326:
327: IF (truncate_table('ISC_DBI_CHANGE_LOG') = -1) THEN
328: return(-1);
329: END IF;
330:
331: IF (truncate_table('ISC_TMP_BOOK_SUM2') = -1) THEN

Line 657: INSERT INTO isc_dbi_change_log (LINE_ID, HEADER_ID, LOG_ROWID, LAST_UPDATE_DATE)

653: -- --------------------------------------------------------
654:
655: FII_UTIL.Start_Timer;
656:
657: INSERT INTO isc_dbi_change_log (LINE_ID, HEADER_ID, LOG_ROWID, LAST_UPDATE_DATE)
658: SELECT line_id LINE_ID, header_id HEADER_ID, rowid LOG_ROWID, last_update_date LAST_UPDATE_DATE
659: FROM ont_dbi_change_log;
660:
661: FII_UTIL.Stop_Timer;

Line 662: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_CHANGE_LOG');

658: SELECT line_id LINE_ID, header_id HEADER_ID, rowid LOG_ROWID, last_update_date LAST_UPDATE_DATE
659: FROM ont_dbi_change_log;
660:
661: FII_UTIL.Stop_Timer;
662: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_CHANGE_LOG');
663:
664: COMMIT;
665:
666:

Line 669: TABNAME => 'ISC_DBI_CHANGE_LOG');

665:
666:
667: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
668: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
669: TABNAME => 'ISC_DBI_CHANGE_LOG');
670: END IF;
671:
672:
673: /* Make a copy of ont_dbi_change_log, no need to delete the duplication before the insert statement. */

Line 691: FROM isc_dbi_change_log log

687: FII_UTIL.Start_Timer;
688:
689: INSERT INTO isc_tmp_book_sum2(pk1, view_type)
690: SELECT distinct line_id, -1
691: FROM isc_dbi_change_log log
692: WHERE NOT EXISTS (select '1'
693: from oe_order_lines_all l
694: where l.line_id = log.line_id);
695: l_delete_count := sql%rowcount;

Line 811: (select /*+ no_merge cardinality (log, 1000)*/ distinct line_id from isc_dbi_change_log log) log1

807: p.adjusted_amount, null)) cost,
808: sum(decode(p.list_line_type_code, 'FREIGHT_CHARGE', decode(nvl(p.applied_flag, 'Y'), 'Y', decode(p.arithmetic_operator, 'LUMPSUM', p.operand, null), null), null)) charge_operand,
809: sum(decode(p.list_line_type_code, 'FREIGHT_CHARGE', decode(nvl(p.applied_flag, 'Y'), 'Y', decode(p.arithmetic_operator, 'LUMPSUM', null, p.adjusted_amount), null), null)) charge_adjamt
810: from oe_price_adjustments p,
811: (select /*+ no_merge cardinality (log, 1000)*/ distinct line_id from isc_dbi_change_log log) log1
812: where p.line_id = log1.line_id
813: and p.line_id is not null
814: and p.charge_type_code in ('FTEPRICE', 'FTECHARGE')
815: group by p.line_id) opa,

Line 816: (select /*+ no_merge cardinality (ilog, 1000)*/ distinct line_id, header_id from isc_dbi_change_log ilog) log,

812: where p.line_id = log1.line_id
813: and p.line_id is not null
814: and p.charge_type_code in ('FTEPRICE', 'FTECHARGE')
815: group by p.line_id) opa,
816: (select /*+ no_merge cardinality (ilog, 1000)*/ distinct line_id, header_id from isc_dbi_change_log ilog) log,
817: oe_order_lines_all l,
818: OE_ORDER_HEADERS_ALL h,
819: AR_SYSTEM_PARAMETERS_ALL aspa,
820: GL_SETS_OF_BOOKS gsb,

Line 2305: IF (truncate_table('ISC_DBI_CHANGE_LOG') = -1) THEN

2301: BIS_COLLECTION_UTILITIES.put_line(' ');
2302: BIS_COLLECTION_UTILITIES.put_line('Truncating the temp table');
2303: FII_UTIL.Start_Timer;
2304:
2305: IF (truncate_table('ISC_DBI_CHANGE_LOG') = -1) THEN
2306: return(-1);
2307: END IF;
2308:
2309: IF (truncate_table('ISC_TMP_BOOK_SUM2') = -1) THEN

Line 2754: WHERE rowid IN (select log_rowid from isc_dbi_change_log)

2750: FII_UTIL.Start_Timer;
2751:
2752:
2753: DELETE FROM ONT_DBI_CHANGE_LOG
2754: WHERE rowid IN (select log_rowid from isc_dbi_change_log)
2755: AND last_update_date < g_incre_start_date;
2756:
2757: FII_UTIL.Stop_Timer;
2758: FII_UTIL.Print_Timer('Deleted ' || sql%rowcount || ' rows from OM log table in');