eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_AR_REVENUE_B_C dependencies on FII_AR_REVENUE_STG

Line 251: -- FII_UTIL.put_line('Truncating table FII_AR_REVENUE_STG');

247: END IF;
248:
249: IF (g_truncate_staging = 'Y') THEN
250: -- if g_debug_flag = 'Y' then
251: -- FII_UTIL.put_line('Truncating table FII_AR_REVENUE_STG');
252: -- end if;
253: truncate_table('fii_ar_revenue_stg');
254:
255: END IF;

Line 253: truncate_table('fii_ar_revenue_stg');

249: IF (g_truncate_staging = 'Y') THEN
250: -- if g_debug_flag = 'Y' then
251: -- FII_UTIL.put_line('Truncating table FII_AR_REVENUE_STG');
252: -- end if;
253: truncate_table('fii_ar_revenue_stg');
254:
255: END IF;
256:
257:

Line 360: SELECT * FROM FII_AR_REVENUE_STG b

356:
357: l_stmt:='
358: CREATE TABLE fii_ar_uni_con_rec
359: NOLOGGING storage (initial 4K next 16K MAXEXTENTS UNLIMITED) as
360: SELECT * FROM FII_AR_REVENUE_STG b
361: WHERE b.revenue_pk in
362: (SELECT b2.revenue_pk FROM FII_AR_REVENUE_STG b2
363: GROUP BY b2.revenue_pk
364: HAVING count(*)>1) ';

Line 362: (SELECT b2.revenue_pk FROM FII_AR_REVENUE_STG b2

358: CREATE TABLE fii_ar_uni_con_rec
359: NOLOGGING storage (initial 4K next 16K MAXEXTENTS UNLIMITED) as
360: SELECT * FROM FII_AR_REVENUE_STG b
361: WHERE b.revenue_pk in
362: (SELECT b2.revenue_pk FROM FII_AR_REVENUE_STG b2
363: GROUP BY b2.revenue_pk
364: HAVING count(*)>1) ';
365:
366: fii_util.put_line('');

Line 424: INSERT INTO FII_AR_REVENUE_STG (

420:
421:
422: IF (p_view_type_id = 4) THEN
423:
424: INSERT INTO FII_AR_REVENUE_STG (
425: REVENUE_PK,
426: GL_DATE_ID,
427: GL_DATE,
428: INVENTORY_ITEM_ID,

Line 686: INSERT INTO FII_AR_REVENUE_STG (

682: ctl.interface_line_attribute6;
683:
684: ELSIF (p_view_type_id = 3) THEN
685:
686: INSERT INTO FII_AR_REVENUE_STG (
687: REVENUE_PK,
688: GL_DATE_ID,
689: GL_DATE,
690: INVENTORY_ITEM_ID,

Line 994: INSERT /+ APPEND PARALLEL(F) / INTO FII_AR_REVENUE_STG F (

990: end if;
991:
992: IF (p_view_type_id = 4) THEN
993: -- Bug 4942753: Per Lester's suggestion, reordered the XLA tables
994: INSERT /*+ APPEND PARALLEL(F) */ INTO FII_AR_REVENUE_STG F (
995: REVENUE_PK,
996: GL_DATE_ID,
997: GL_DATE,
998: INVENTORY_ITEM_ID,

Line 1292: USING (SELECT /+ cardinality(stg,1) / * FROM FII_AR_REVENUE_STG stg

1288: fii_util.put_line('');
1289: end if;
1290:
1291: MERGE INTO FII_AR_REVENUE_B f
1292: USING (SELECT /*+ cardinality(stg,1) */ * FROM FII_AR_REVENUE_STG stg
1293: WHERE prim_conversion_rate > 0
1294: OR sec_conversion_rate > 0) stg
1295: ON ( stg.revenue_pk = f.revenue_pk)
1296: WHEN MATCHED THEN

Line 1461: FROM FII_AR_REVENUE_STG

1457: CURSOR c1 IS SELECT DISTINCT TRANSACTION_CURRENCY,
1458: decode( prim_conversion_rate,
1459: -3, to_date( '01/01/1999', 'MM/DD/YYYY' ),
1460: trunc(least(EXCHANGE_DATE,sysdate))) EXCHANGE_DATE
1461: FROM FII_AR_REVENUE_STG
1462: WHERE prim_conversion_rate < 0;
1463:
1464: CURSOR c2 IS SELECT DISTINCT TRANSACTION_CURRENCY,
1465: decode( sec_conversion_RATE,

Line 1468: FROM FII_AR_REVENUE_STG

1464: CURSOR c2 IS SELECT DISTINCT TRANSACTION_CURRENCY,
1465: decode( sec_conversion_RATE,
1466: -3, to_date( '01/01/1999', 'MM/DD/YYYY' ),
1467: trunc(least(EXCHANGE_DATE,sysdate))) EXCHANGE_DATE
1468: FROM FII_AR_REVENUE_STG
1469: WHERE sec_conversion_RATE < 0;
1470:
1471: CURSOR c3 IS SELECT DISTINCT FUNCTIONAL_CURRENCY,
1472: decode( prim_conversion_rate,

Line 1519: FROM FII_AR_REVENUE_STG

1515: -- Bug 4942753: Change to return 1 if any row exists
1516: BEGIN
1517: SELECT 1
1518: INTO l_miss_rates
1519: FROM FII_AR_REVENUE_STG
1520: WHERE ((prim_conversion_rate < 0) OR (sec_conversion_rate < 0))
1521: AND ROWNUM = 1;
1522: EXCEPTION
1523: WHEN NO_DATA_FOUND THEN

Line 1591: FROM FII_AR_REVENUE_STG

1587: -- Bug 4942753: Change to return 1 if any row exists
1588: BEGIN
1589: SELECT 1
1590: INTO l_miss_rates_prim
1591: FROM FII_AR_REVENUE_STG
1592: WHERE prim_conversion_rate < 0
1593: AND ROWNUM = 1;
1594: EXCEPTION
1595: WHEN NO_DATA_FOUND THEN

Line 1603: FROM FII_AR_REVENUE_STG

1599: -- Bug 4942753: Change to return 1 if any row exists
1600: BEGIN
1601: SELECT 1
1602: INTO l_miss_rates_sec
1603: FROM FII_AR_REVENUE_STG
1604: WHERE sec_conversion_rate < 0
1605: AND ROWNUM = 1;
1606: EXCEPTION
1607: WHEN NO_DATA_FOUND THEN

Line 2131: from FII_AR_REVENUE_STG A

2127: lid
2128: from (
2129: select /*+ no_merge PARALLEL(A) */
2130: a.invoice_line_id lid
2131: from FII_AR_REVENUE_STG A
2132: union all
2133: select /*+ ordered parallel(b) parallel(y)
2134: pq_distibute(y, none, broadcast) */
2135: decode(y.a,

Line 2233: FROM fii_ar_revenue_stg

2229: -- Bug 4942753: Change to return 1 if any row exists
2230: BEGIN
2231: SELECT 1
2232: INTO l_count2
2233: FROM fii_ar_revenue_stg
2234: WHERE ROWNUM = 1;
2235: EXCEPTION
2236: WHEN NO_DATA_FOUND THEN
2237: l_count2 := 0;

Line 2307: FROM fii_ar_revenue_stg

2303: -- Bug 4942753: Change to return 1 if any row exists
2304: BEGIN
2305: SELECT 1
2306: INTO l_count2
2307: FROM fii_ar_revenue_stg
2308: WHERE ROWNUM = 1;
2309: EXCEPTION
2310: WHEN NO_DATA_FOUND THEN
2311: l_count2 := 0;

Line 3125: INSERT /+ APPEND PARALLEL(F) / INTO FII_AR_REVENUE_STG F (

3121: end if;
3122:
3123: -- Bug 4942753: Per Lester's suggestion, reordered the XLA tables and
3124: -- add date filters on the transaction tables adj and ctlgd
3125: INSERT /*+ APPEND PARALLEL(F) */ INTO FII_AR_REVENUE_STG F (
3126: REVENUE_PK,
3127: GL_DATE_ID,
3128: GL_DATE,
3129: INVENTORY_ITEM_ID,

Line 3475: from FII_AR_REVENUE_STG stg

3471: from (
3472: select /*+ no_merge parallel(stg) */ distinct
3473: FUNCTIONAL_CURRENCY cc,
3474: TRUNC(GL_DATE) dt
3475: from FII_AR_REVENUE_STG stg
3476: );
3477:
3478: if g_debug_flag = 'Y' then
3479: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows into rates table');

Line 3602: FROM fii_ar_revenue_rates_temp rates, FII_AR_REVENUE_STG stg

3598: stg.invoice_date,
3599: stg.fin_cat_type_code,
3600: stg.REV_BOOKED_DATE,
3601: stg.CHILD_ORDER_LINE_ID
3602: FROM fii_ar_revenue_rates_temp rates, FII_AR_REVENUE_STG stg
3603: where TRUNC(stg.GL_DATE) = rates.trx_date
3604: and stg.functional_currency = rates.functional_currency;
3605:
3606: if g_debug_flag = 'Y' then

Line 3906: TRUNCATE_TABLE('FII_AR_REVENUE_STG');

3902: fii_util.put_line('');
3903: FII_UTIL.put_line('Running Initial Load, truncate staging and base summary tables.');
3904: END IF;
3905: -- DEBUG
3906: TRUNCATE_TABLE('FII_AR_REVENUE_STG');
3907: TRUNCATE_TABLE('FII_AR_REVENUE_B');
3908: TRUNCATE_TABLE('FII_AR_REV_ACCTS');
3909: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_REVENUE_B_I');
3910: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_REVENUE_B_L');

Line 4224: FROM fii_ar_revenue_stg

4220: -- Bug 4942753: Change to return 1 if any row exists
4221: BEGIN
4222: SELECT 1
4223: INTO l_stg_count
4224: FROM fii_ar_revenue_stg
4225: WHERE rownum = 1;
4226: EXCEPTION
4227: WHEN NO_DATA_FOUND THEN
4228: l_stg_count := 0;

Line 4302: tabname => 'FII_AR_REVENUE_STG');

4298:
4299: -- perf tune
4300: FND_STATS.gather_table_stats
4301: (ownname => g_fii_schema,
4302: tabname => 'FII_AR_REVENUE_STG');
4303:
4304: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
4305:
4306: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');

Line 4497: Update FII_AR_REVENUE_STG stg

4493:
4494: FII_UTIL.start_timer;
4495: end if;
4496:
4497: Update FII_AR_REVENUE_STG stg
4498: SET prim_conversion_rate =
4499: fii_currency.get_global_rate_primary(stg.functional_currency, least(stg.exchange_date, sysdate))
4500: WHERE stg.prim_conversion_rate < 0;
4501: -- commit;

Line 4511: Update FII_AR_REVENUE_STG stg

4507: FII_UTIL.start_timer;
4508: end if;
4509: commit;
4510:
4511: Update FII_AR_REVENUE_STG stg
4512: SET sec_conversion_rate =
4513: fii_currency.get_global_rate_secondary(stg.functional_currency, least(stg.exchange_date, sysdate))
4514: WHERE stg.sec_conversion_rate < 0;
4515: -- commit;

Line 4539: tabname => 'FII_AR_REVENUE_STG');

4535: fii_util.put_line('Anayzing staging table before checking missing rates.');
4536: end if;
4537:
4538: FND_STATS.gather_table_stats (ownname => g_fii_schema,
4539: tabname => 'FII_AR_REVENUE_STG');
4540:
4541: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
4542:
4543: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');

Line 4592: FROM FII_AR_REVENUE_STG b2

4588: fii_util.put_line('Checking for duplicate records in staging table.');
4589: end if;
4590: SELECT count(*) INTO l_dup
4591: from (SELECT 1
4592: FROM FII_AR_REVENUE_STG b2
4593: GROUP BY b2.revenue_pk
4594: HAVING count(*)>1
4595: );
4596: IF l_dup > 0 THEN

Line 5001: -- tabname => 'FII_AR_REVENUE_STG');

4997: end if;
4998: l_count := POPULATE_STG(l_num_parameter1,l_num_parameter2);
4999: -- FND_STATS.gather_table_stats
5000: -- (ownname => g_fii_schema,
5001: -- tabname => 'FII_AR_REVENUE_STG');
5002: ELSE
5003: g_errbuf := '
5004: ---------------------------------
5005: Error in Procedure: WORKER