APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on ISC_SERVICE_BOOK_SUM2

Line 339: IF (truncate_table('ISC_SERVICE_BOOK_SUM2') = -1) THEN

335: IF (truncate_table('ISC_CURR_BOOK_SUM2') = -1) THEN
336: return(-1);
337: END IF;
338:
339: IF (truncate_table('ISC_SERVICE_BOOK_SUM2') = -1) THEN
340: return(-1);
341: END IF;
342:
343: FII_UTIL.Stop_Timer;

Line 550: INTO isc_service_book_sum2 F(

546:
547: FII_UTIL.Start_Timer;
548:
549: INSERT /*+ APPEND */
550: INTO isc_service_book_sum2 F(
551: LINE_ID,
552: SERVICE_PARENT_LINE_ID)
553: SELECT pk1, ISC_DBI_BOOK_SUM2_F_C.get_cust_product_line_id(tmp.sold_to_org_id,tmp.service_reference_line_id)
554: FROM isc_tmp_book_sum2 tmp

Line 989: INTO isc_service_book_sum2 F(

985:
986: FII_UTIL.Start_Timer;
987:
988: INSERT
989: INTO isc_service_book_sum2 F(
990: LINE_ID,
991: SERVICE_PARENT_LINE_ID)
992: SELECT pk1, ISC_DBI_BOOK_SUM2_F_C.get_cust_product_line_id(tmp.sold_to_org_id,tmp.service_reference_line_id)
993: FROM isc_tmp_book_sum2 tmp

Line 2317: IF (truncate_table('ISC_SERVICE_BOOK_SUM2') = -1) THEN

2313: IF (truncate_table('ISC_CURR_BOOK_SUM2') = -1) THEN
2314: return(-1);
2315: END IF;
2316:
2317: IF (truncate_table('ISC_SERVICE_BOOK_SUM2') = -1) THEN
2318: return(-1);
2319: END IF;
2320:
2321: FII_UTIL.Stop_Timer;

Line 2441: TABNAME => 'ISC_SERVICE_BOOK_SUM2');

2437: TABNAME => 'ISC_TMP_BOOK_SUM2');
2438: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2439: TABNAME => 'ISC_CURR_BOOK_SUM2');
2440: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2441: TABNAME => 'ISC_SERVICE_BOOK_SUM2');
2442: END IF;
2443:
2444: FII_UTIL.Stop_Timer;
2445: FII_UTIL.Print_Timer('Analyzed the temp tables in ');

Line 2621: TABNAME => 'ISC_SERVICE_BOOK_SUM2');

2617: TABNAME => 'ISC_TMP_BOOK_SUM2');
2618: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2619: TABNAME => 'ISC_CURR_BOOK_SUM2');
2620: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2621: TABNAME => 'ISC_SERVICE_BOOK_SUM2');
2622: END IF;
2623:
2624: FII_UTIL.Stop_Timer;
2625: FII_UTIL.Print_Timer('Analyzed the temp tables in ');