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_AP_INV_B_C dependencies on FII_AP_INV_STG

Line 193: FII_UTIL.put_line('Truncate table FII_AP_INV_STG');

189: END IF;
190:
191: IF (g_truncate_staging = 'Y') THEN
192: if g_debug_flag = 'Y' then
193: FII_UTIL.put_line('Truncate table FII_AP_INV_STG');
194: end if;
195: truncate_table('FII_AP_INV_STG');
196: END IF;
197:

Line 195: truncate_table('FII_AP_INV_STG');

191: IF (g_truncate_staging = 'Y') THEN
192: if g_debug_flag = 'Y' then
193: FII_UTIL.put_line('Truncate table FII_AP_INV_STG');
194: end if;
195: truncate_table('FII_AP_INV_STG');
196: END IF;
197:
198: -- haritha
199: IF (g_truncate_rates = 'Y') THEN

Line 253: FROM fii_ap_inv_stg

249:
250: BEGIN
251: SELECT 1
252: INTO l_count2
253: FROM fii_ap_inv_stg
254: WHERE ROWNUM = 1;
255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN l_count2 := 0;
257: END;

Line 363: g_state := 'Populating FII_AP_Inv_STG with updated data using the FII_AP_Unpost_Headers_T table';

359: BEGIN
360:
361: IF p_phase = 1 THEN
362:
363: g_state := 'Populating FII_AP_Inv_STG with updated data using the FII_AP_Unpost_Headers_T table';
364: if g_debug_flag = 'Y' then
365: FII_UTIL.put_line(g_state);
366: FII_UTIL.start_timer;
367: end if;

Line 369: INSERT INTO FII_AP_INV_STG (

365: FII_UTIL.put_line(g_state);
366: FII_UTIL.start_timer;
367: end if;
368:
369: INSERT INTO FII_AP_INV_STG (
370: AE_HEADER_ID,
371: REF_AE_HEADER_ID,
372: TEMP_LINE_NUM,
373: GL_SL_LINK_ID,

Line 395: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');

391: AND ID.sequence_id >= p_start_range
392: AND ID.sequence_id <= p_end_range;
393:
394: if g_debug_flag = 'Y' then
395: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');
396: FII_UTIL.stop_timer;
397: FII_UTIL.print_timer('Duration');
398: end if;
399:

Line 403: g_state := 'Populating FII_AP_Inv_STG with new data using the header identifier. Header range is from ' || p_start_range || ' to ' || p_end_range || '.';

399:
400:
401: ELSE --This is a Phase 2 job.
402:
403: g_state := 'Populating FII_AP_Inv_STG with new data using the header identifier. Header range is from ' || p_start_range || ' to ' || p_end_range || '.';
404: if g_debug_flag = 'Y' then
405: FII_UTIL.put_line(g_state);
406: FII_UTIL.start_timer;
407: end if;

Line 409: INSERT INTO FII_AP_INV_STG

405: FII_UTIL.put_line(g_state);
406: FII_UTIL.start_timer;
407: end if;
408:
409: INSERT INTO FII_AP_INV_STG
410: (LEDGER_ID,
411: ACCOUNT_DATE,
412: INV_CURRENCY_CODE,
413: AMOUNT_T,

Line 600: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');

596: AND xah.accounting_date >= g_start_date
597: AND ail.accounting_date >= g_start_date;
598:
599: if g_debug_flag = 'Y' then
600: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');
601: FII_UTIL.stop_timer;
602: FII_UTIL.print_timer('Duration');
603: end if;
604:

Line 794: FROM FII_AP_INV_STG stg

790: --------------------------------------------------------
791: CURSOR prim_MissingRate IS
792: SELECT DISTINCT INV_CURRENCY_CODE from_currency, decode(prim_conversion_rate,-3,
793: to_date('01/01/1999','MM/DD/RRRR'), LEAST(ACCOUNT_DATE, sysdate)) actg_dt
794: FROM FII_AP_INV_STG stg
795: WHERE stg.prim_conversion_rate < 0 ;
796:
797: CURSOR sec_MissingRate IS
798: SELECT DISTINCT INV_CURRENCY_CODE from_currency, decode(sec_conversion_rate,-3,

Line 800: FROM FII_AP_INV_STG stg

796:
797: CURSOR sec_MissingRate IS
798: SELECT DISTINCT INV_CURRENCY_CODE from_currency, decode(sec_conversion_rate,-3,
799: to_date('01/01/1999','MM/DD/RRRR'),LEAST(ACCOUNT_DATE, sysdate)) actg_dt
800: FROM FII_AP_INV_STG stg
801: WHERE stg.sec_conversion_rate < 0 ;
802:
803: CURSOR prim_MissingRate_L IS
804: SELECT DISTINCT FUNCTIONAL_CURRENCY from_currency, decode(prim_conversion_rate,-3,

Line 835: SELECT 1 INTO l_miss_rates_prim FROM FII_AP_INV_STG stg WHERE stg.prim_conversion_rate < 0;

831:
832: ELSE
833:
834: BEGIN
835: SELECT 1 INTO l_miss_rates_prim FROM FII_AP_INV_STG stg WHERE stg.prim_conversion_rate < 0;
836: EXCEPTION
837: WHEN NO_DATA_FOUND THEN l_miss_rates_prim := 0;
838: END;
839:

Line 841: SELECT 1 INTO l_miss_rates_sec FROM FII_AP_INV_STG stg WHERE stg.sec_conversion_rate < 0;

837: WHEN NO_DATA_FOUND THEN l_miss_rates_prim := 0;
838: END;
839:
840: BEGIN
841: SELECT 1 INTO l_miss_rates_sec FROM FII_AP_INV_STG stg WHERE stg.sec_conversion_rate < 0;
842: EXCEPTION
843: WHEN NO_DATA_FOUND THEN l_miss_rates_sec := 0;
844: END;
845:

Line 941: FII_UTIL.put_line('Populating FII_AP_INV_B FROM FII_AP_INV_STG table');

937:
938: if g_debug_flag = 'Y' then
939: FII_UTIL.put_line('');
940: FII_UTIL.put_line('-------------------------------------------------');
941: FII_UTIL.put_line('Populating FII_AP_INV_B FROM FII_AP_INV_STG table');
942: end if;
943:
944: g_state := 'Populating FII_AP_INV_B FROM FII_AP_INV_STG table';
945:

Line 944: g_state := 'Populating FII_AP_INV_B FROM FII_AP_INV_STG table';

940: FII_UTIL.put_line('-------------------------------------------------');
941: FII_UTIL.put_line('Populating FII_AP_INV_B FROM FII_AP_INV_STG table');
942: end if;
943:
944: g_state := 'Populating FII_AP_INV_B FROM FII_AP_INV_STG table';
945:
946: -- haritha.
947: -- Removed the where condition to check for invoice_id and other attributes
948: -- of a distribution. Instead added the invoice_distribution_id condition.

Line 953: FROM FII_AP_INV_STG

949: -- Also added the additional columns for insertion.
950:
951: MERGE /*+ use_nl(bsum) */ INTO FII_AP_INV_B BSUM
952: USING (SELECT *
953: FROM FII_AP_INV_STG
954: WHERE (nvl(prim_conversion_rate,1) > 0 OR nvl(sec_conversion_rate,1) > 0)
955: ) STG
956: ON (BSUM.Ref_AE_Header_ID = STG.Ref_AE_Header_ID
957: AND BSUM.Temp_Line_Num = STG.Temp_Line_Num

Line 1374: INSERT /+ APPEND PARALLEL(F) / INTO FII_AP_INV_STG F

1370: fii_util.put_line('');
1371: end if;
1372:
1373:
1374: INSERT /*+ APPEND PARALLEL(F) */ INTO FII_AP_INV_STG F
1375: (LEDGER_ID,
1376: ACCOUNT_DATE,
1377: INV_CURRENCY_CODE,
1378: AMOUNT_T,

Line 1603: from FII_AP_INV_STG

1599: from (
1600: select /*+ no_merge */ distinct
1601: inv_currency_code cc,
1602: account_date dt
1603: from FII_AP_INV_STG
1604: );
1605:
1606: if g_debug_flag = 'Y' then
1607: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');

Line 1753: FROM FII_AP_INV_STG stg, fii_ap_inv_rates_temp rates

1749: STG.GL_SL_Link_Table,
1750: STG.Inventory_Item_ID,
1751: STG.Purchasing_Category_ID,
1752: STG.Item_Description
1753: FROM FII_AP_INV_STG stg, fii_ap_inv_rates_temp rates
1754: where stg.account_date = rates.trx_date
1755: and stg.inv_currency_code = rates.functional_currency;
1756:
1757: if g_debug_flag = 'Y' then

Line 1893: TRUNCATE_TABLE('FII_AP_INV_STG');

1889: g_state := 'Running Initial Load, truncate staging and base summary table.';
1890: IF g_debug_flag = 'Y' then
1891: FII_UTIL.put_line('Running Initial Load, truncate staging and base summary table.');
1892: END IF;
1893: TRUNCATE_TABLE('FII_AP_INV_STG');
1894: TRUNCATE_TABLE('FII_AP_INV_B');
1895: COMMIT;
1896: END IF;
1897:

Line 1994: SELECT 1 INTO g_num FROM fii_ap_inv_stg where rownum = 1;

1990: -- exchange rates. In this case, we run in resume mode.
1991: -- If no, then program will insert records into staging table
1992: --------------------------------------------------------------------
1993: BEGIN
1994: SELECT 1 INTO g_num FROM fii_ap_inv_stg where rownum = 1;
1995: EXCEPTION
1996: WHEN NO_DATA_FOUND THEN g_num := 0;
1997: END;
1998:

Line 2100: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_INV_STG', PERCENT=> 5);

2096:
2097: INSERT_INTO_STG (p_parallel_query, p_sort_area_size, p_hash_area_size);
2098: INSERT_RATES;
2099:
2100: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_INV_STG', PERCENT=> 5);
2101:
2102: ELSE
2103:
2104: --------------------------------------------

Line 2269: g_state := 'Updating records with missing primary rates in FII_AP_INV_STG table';

2265: -- staging table
2266: ----------------------------------------------------------
2267: g_truncate_staging := 'N';
2268:
2269: g_state := 'Updating records with missing primary rates in FII_AP_INV_STG table';
2270: if g_debug_flag = 'Y' then
2271: FII_UTIL.put_line('');
2272: FII_UTIL.put_line('---------------------------------------------------------------------');
2273: FII_UTIL.put_line('Updating records with missing primary rates in FII_AP_INV_STG table ');

Line 2273: FII_UTIL.put_line('Updating records with missing primary rates in FII_AP_INV_STG table ');

2269: g_state := 'Updating records with missing primary rates in FII_AP_INV_STG table';
2270: if g_debug_flag = 'Y' then
2271: FII_UTIL.put_line('');
2272: FII_UTIL.put_line('---------------------------------------------------------------------');
2273: FII_UTIL.put_line('Updating records with missing primary rates in FII_AP_INV_STG table ');
2274: FII_UTIL.start_timer;
2275: end if;
2276:
2277: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)

Line 2278: UPDATE FII_AP_INV_STG stg

2274: FII_UTIL.start_timer;
2275: end if;
2276:
2277: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
2278: UPDATE FII_AP_INV_STG stg
2279: SET stg.PRIM_CONVERSION_RATE = DECODE(stg.inv_currency_code, g_prim_currency, 1,
2280: fii_currency.get_global_rate_primary(stg.inv_currency_code,
2281: least(stg.account_date,sysdate)))
2282: WHERE stg.PRIM_CONVERSION_RATE < 0;

Line 2293: FII_UTIL.put_line('Updating records with missing secondary rates in FII_AP_INV_STG table ');

2289: FII_UTIL.print_timer('Duration');
2290:
2291: FII_UTIL.put_line('');
2292: FII_UTIL.put_line('---------------------------------------------------------------------');
2293: FII_UTIL.put_line('Updating records with missing secondary rates in FII_AP_INV_STG table ');
2294: FII_UTIL.start_timer;
2295: end if;
2296: g_state := 'Updating records with missing secondary rates in FII_AP_INV_STG table ';
2297:

Line 2296: g_state := 'Updating records with missing secondary rates in FII_AP_INV_STG table ';

2292: FII_UTIL.put_line('---------------------------------------------------------------------');
2293: FII_UTIL.put_line('Updating records with missing secondary rates in FII_AP_INV_STG table ');
2294: FII_UTIL.start_timer;
2295: end if;
2296: g_state := 'Updating records with missing secondary rates in FII_AP_INV_STG table ';
2297:
2298: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
2299: UPDATE FII_AP_INV_STG stg
2300: SET stg.SEC_CONVERSION_RATE = decode(stg.inv_currency_code, g_sec_currency, 1,

Line 2299: UPDATE FII_AP_INV_STG stg

2295: end if;
2296: g_state := 'Updating records with missing secondary rates in FII_AP_INV_STG table ';
2297:
2298: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
2299: UPDATE FII_AP_INV_STG stg
2300: SET stg.SEC_CONVERSION_RATE = decode(stg.inv_currency_code, g_sec_currency, 1,
2301: fii_currency.get_global_rate_secondary(stg.inv_currency_code,
2302: least( stg.account_date,sysdate)))
2303: WHERE stg.SEC_CONVERSION_RATE < 0;

Line 2468: Truncate_table('FII_AP_INV_STG');

2464: -- because we can use it for debugging purpose if the program
2465: -- error out. FII_AP_INV_ID always gets truncated at the start
2466: -- of the program.
2467: ---------------------------------------------------------------
2468: Truncate_table('FII_AP_INV_STG');
2469:
2470: Truncate_table('FII_AP_SUM_WORK_JOBS');
2471:
2472: ----------------------------------------------------------------