[Home] [Help]
240: truncate_table('fii_ar_revenue_jobs');
241:
242: IF (g_truncate_id = 'Y') THEN
243: -- if g_debug_flag = 'Y' then
244: -- FII_UTIL.put_line('Truncating table FII_AR_REVENUE_ID');
245: -- end if;
246: truncate_table('fii_ar_revenue_id');
247: END IF;
248:
242: IF (g_truncate_id = 'Y') THEN
243: -- if g_debug_flag = 'Y' then
244: -- FII_UTIL.put_line('Truncating table FII_AR_REVENUE_ID');
245: -- end if;
246: truncate_table('fii_ar_revenue_id');
247: END IF;
248:
249: IF (g_truncate_staging = 'Y') THEN
250: -- if g_debug_flag = 'Y' then
574: sh.booked_date)), to_date(null)) REV_BOOKED_DATE,
575: decode(ctl.interface_line_context, 'ORDER ENTRY',ctl.interface_line_attribute6,
576: null) CHILD_ORDER_LINE_ID
577: FROM
578: fii_ar_revenue_id fpk,
579: ra_customer_trx_lines_all ctl,
580: ra_customer_trx_all ct,
581: ra_cust_trx_types_all ctt,
582: ra_cust_trx_line_gl_dist_all ctlgd,
851: -- decode(sh.booked_flag, 'Y', trunc(sh.booked_date), to_date(null)) REV_BOOKED_DATE
852: to_date(null) REV_BOOKED_DATE,
853: null CHILD_ORDER_LINE_ID
854: FROM
855: fii_ar_revenue_id fpk,
856: ar_adjustments_all adj,
857: ar_distributions_all ad,
858: gl_code_combinations gcc,
859: fii_gl_ccid_dimensions ccdim,
1161: ctt.type x_type,
1162: decode(ctl.interface_line_context, 'ORDER ENTRY',ctl.interface_line_attribute6,
1163: null) x_child_order_line_id,
1164: AC.Fin_Cat_Type_Code x_fin_cat_type_code
1165: from fii_ar_revenue_id fpk,
1166: ra_customer_trx_lines_all ctl,
1167: ra_customer_trx_all ct,
1168: ra_cust_trx_types_all ctt,
1169: ra_cust_trx_line_gl_dist_all ctlgd,
1405:
1406: /* DELETE FROM FII_AR_REVENUE_B f
1407: WHERE f.UPDATE_SEQUENCE <> seq_id
1408: AND f.TRANSACTION_CLASS <> 'ADJ'
1409: AND f.INVOICE_LINE_ID IN (SELECT fpk.primary_key1 FROM FII_AR_REVENUE_ID fpk
1410: WHERE fpk.view_type_id = 4);
1411:
1412:
1413: COMMIT;
1768: -- adjustments which has been updated
1769: -- ----------------------------------------
1770:
1771: l_stmt := '
1772: INSERT INTO FII_AR_REVENUE_ID (
1773: view_type_id,
1774: primary_key1)
1775: SELECT --+ ORDERED USE_NL(ADJ)
1776: 7,
1805: end if;
1806:
1807:
1808: l_stmt := '
1809: INSERT INTO FII_AR_REVENUE_ID (
1810: view_type_id,
1811: primary_key1)
1812: SELECT
1813: 7,
1846: -- For ra_customer_trx_lines_all.
1847: -- -----------------------------------------
1848:
1849: l_stmt := '
1850: INSERT INTO FII_AR_REVENUE_ID (
1851: view_type_id,
1852: primary_key1)
1853: SELECT
1854: 8,
1913: -- This logic has been moved to procedure MAIN
1914: -- g_gl_to_date := ADD_MONTHS(sysdate, 1);
1915: -- l_gl_to := to_char(g_gl_to_date, 'YYYY/MM/DD HH24:MI:SS');
1916:
1917: l_stmt := 'INSERT INTO FII_AR_REVENUE_ID (
1918: view_type_id,
1919: primary_key1)
1920: SELECT /*+ INDEX(aeh, xla_ae_headers_N5) */
1921: dup.view_type_id,
1950: fii_util.print_timer('Duration');
1951: end if;
1952:
1953: ELSE
1954: l_stmt := 'INSERT INTO FII_AR_REVENUE_ID (
1955: view_type_id,
1956: primary_key1)
1957: SELECT /*+ INDEX(aeh, xla_ae_headers_N5) */
1958: dup.view_type_id,
2115: end if;
2116: end if;
2117:
2118: l_stmt := '
2119: INSERT /*+ APPEND PARALLEL(F) */ INTO FII_AR_REVENUE_ID F
2120: (
2121: view_type_id,
2122: job_num,
2123: primary_key1
2173: COMMIT;
2174:
2175: FND_STATS.gather_table_stats
2176: (ownname => g_fii_schema,
2177: tabname => 'FII_AR_REVENUE_ID');
2178:
2179: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
2180:
2181: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');
2587: fii_util.start_timer;
2588: end if;
2589:
2590:
2591: insert into fii_ar_revenue_id (
2592: view_type_id,
2593: job_num,
2594: primary_key1)
2595: select
2597: l_curr_job_num + ceil(rownum / l_batch_size(l_view_type_id)) - 1,
2598: primary_key1
2599: from (select distinct
2600: primary_key1
2601: from fii_ar_revenue_id
2602: where view_type_id = l_view_type_id + 4) t;
2603:
2604:
2605: l_count := nvl(SQL%ROWCOUNT,0);