APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on ISC_CURR_BOOK_SUM2

Line 335: IF (truncate_table('ISC_CURR_BOOK_SUM2') = -1) THEN

331: IF (truncate_table('ISC_TMP_BOOK_SUM2') = -1) THEN
332: return(-1);
333: END IF;
334:
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

Line 521: INTO isc_curr_book_sum2 F(

517:
518: FII_UTIL.Start_Timer;
519:
520: INSERT /*+ APPEND */
521: INTO isc_curr_book_sum2 F(
522: FROM_CURRENCY,
523: TO_CURRENCY1,
524: TO_CURRENCY3,
525: CONVERSION_DATE,

Line 958: INTO isc_curr_book_sum2 F(

954:
955: FII_UTIL.Start_Timer;
956:
957: INSERT
958: INTO isc_curr_book_sum2 F(
959: FROM_CURRENCY,
960: TO_CURRENCY1,
961: TO_CURRENCY3,
962: CONVERSION_DATE,

Line 1346: FROM isc_curr_book_sum2 tmp

1342: from_currency,
1343: to_currency1 TO_CURRENCY,
1344: conversion_type RATE_TYPE,
1345: decode(rate1, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') STATUS
1346: FROM isc_curr_book_sum2 tmp
1347: WHERE rate1 < 0
1348: AND upper(conversion_type) <> 'USER'
1349: UNION
1350: SELECT distinct decode(rate2, -3, to_date('01/01/1999','MM/DD/RRRR'), conversion_date) CURR_CONV_DATE,

Line 1355: FROM isc_curr_book_sum2 tmp

1351: to_currency3 FROM_CURRENCY,
1352: g_global_currency TO_CURRENCY,
1353: g_global_rate_type RATE_TYPE,
1354: decode(rate2, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') STATUS
1355: FROM isc_curr_book_sum2 tmp
1356: WHERE rate2 < 0
1357: UNION
1358: SELECT distinct decode(rate3, -3, to_date('01/01/1999','MM/DD/RRRR'), conversion_date) CURR_CONV_DATE,
1359: from_currency,

Line 1363: FROM isc_curr_book_sum2 tmp

1359: from_currency,
1360: to_currency3,
1361: g_global_rate_type RATE_TYPE,
1362: decode(rate3, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') STATUS
1363: FROM isc_curr_book_sum2 tmp
1364: WHERE rate3 < 0
1365: UNION
1366: SELECT distinct decode(rate4, -3, to_date('01/01/1999','MM/DD/RRRR'), conversion_date) CURR_CONV_DATE,
1367: to_currency3 FROM_CURRENCY,

Line 1371: FROM isc_curr_book_sum2 tmp

1367: to_currency3 FROM_CURRENCY,
1368: g_sec_global_currency TO_CURRENCY,
1369: g_sec_global_rate_type RATE_TYPE,
1370: decode(rate4, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') STATUS
1371: FROM isc_curr_book_sum2 tmp
1372: WHERE rate4 < 0
1373: AND l_sec_curr_def = 'Y';
1374:
1375: l_record Missing_Currency_Conversion%ROWTYPE;

Line 2313: IF (truncate_table('ISC_CURR_BOOK_SUM2') = -1) THEN

2309: IF (truncate_table('ISC_TMP_BOOK_SUM2') = -1) THEN
2310: return(-1);
2311: END IF;
2312:
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

Line 2439: TABNAME => 'ISC_CURR_BOOK_SUM2');

2435: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2436: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
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:

Line 2619: TABNAME => 'ISC_CURR_BOOK_SUM2');

2615: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2616: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
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: