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.IGI_IAC_EXTRACT_PKG dependencies on FA_XLA_EXT_LINES_B_GT

Line 141: INSERT INTO FA_XLA_EXT_LINES_B_GT(

137:
138: --Extract Fa transaction lines object
139: v_counter := 1;
140: for k in fa_igi_lines (i.event_id,i.valuation_method) loop
141: INSERT INTO FA_XLA_EXT_LINES_B_GT(
142: EVENT_ID ,
143: LINE_NUMBER ,
144: DISTRIBUTION_TYPE_CODE ,
145: transaction_header_id ,

Line 260: delete from FA_XLA_EXT_LINES_B_GT_tmp;

256: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
257: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
258: select * from FA_XLA_EXT_HEADERS_B_GT;
259:
260: delete from FA_XLA_EXT_LINES_B_GT_tmp;
261: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
262: select * from FA_XLA_EXT_LINES_B_GT;*/
263: --Debug
264:

Line 261: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp

257: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
258: select * from FA_XLA_EXT_HEADERS_B_GT;
259:
260: delete from FA_XLA_EXT_LINES_B_GT_tmp;
261: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
262: select * from FA_XLA_EXT_LINES_B_GT;*/
263: --Debug
264:
265:

Line 262: select * from FA_XLA_EXT_LINES_B_GT;*/

258: select * from FA_XLA_EXT_HEADERS_B_GT;
259:
260: delete from FA_XLA_EXT_LINES_B_GT_tmp;
261: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
262: select * from FA_XLA_EXT_LINES_B_GT;*/
263: --Debug
264:
265:
266: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 350: from FA_XLA_EXT_LINES_B_GT where

346: --Extract IAC reference lines object
347: for i in all_events loop
348:
349: select max(line_number) +1 into v_counter
350: from FA_XLA_EXT_LINES_B_GT where
351: event_id = i.event_id ;
352:
353:
354:

Line 356: /*INSERT INTO FA_XLA_EXT_LINES_B_GT(

352:
353:
354:
355: for k in fa_igi_lines (i.event_id,i.valuation_method) loop
356: /*INSERT INTO FA_XLA_EXT_LINES_B_GT(
357: EVENT_ID ,
358: LINE_NUMBER ,
359: DISTRIBUTION_TYPE_CODE ,
360: ledger_id,

Line 379: insert into fa_xla_ext_lines_b_gt (

375: k.book_type_code,
376: k.distribution_id,
377: 1,'USD');*/
378:
379: insert into fa_xla_ext_lines_b_gt (
380: EVENT_ID ,
381: LINE_NUMBER ,
382: DISTRIBUTION_TYPE_CODE ,
383: LEDGER_ID ,

Line 432: from fa_xla_ext_lines_b_gt

428: DISTRIBUTION_ID,
429: EXPENSE_ACCOUNT_CCID,
430: TRANSACTION_HEADER_ID,
431: ADJUSTMENT_LINE_ID
432: from fa_xla_ext_lines_b_gt
433: where event_id = i.event_id
434: and rownum = 1;
435:
436: insert into igi_iac_xla_lines_gt (

Line 530: delete from FA_XLA_EXT_LINES_B_GT_tmp;

526: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
527: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
528: select * from FA_XLA_EXT_HEADERS_B_GT;
529:
530: delete from FA_XLA_EXT_LINES_B_GT_tmp;
531: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
532: select * from FA_XLA_EXT_LINES_B_GT;*/
533: --Debug
534:

Line 531: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp

527: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
528: select * from FA_XLA_EXT_HEADERS_B_GT;
529:
530: delete from FA_XLA_EXT_LINES_B_GT_tmp;
531: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
532: select * from FA_XLA_EXT_LINES_B_GT;*/
533: --Debug
534:
535: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 532: select * from FA_XLA_EXT_LINES_B_GT;*/

528: select * from FA_XLA_EXT_HEADERS_B_GT;
529:
530: delete from FA_XLA_EXT_LINES_B_GT_tmp;
531: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
532: select * from FA_XLA_EXT_LINES_B_GT;*/
533: --Debug
534:
535: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
536: p_full_path => l_path_name,

Line 663: delete from FA_XLA_EXT_LINES_B_GT_tmp;

659: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
660: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
661: select * from FA_XLA_EXT_HEADERS_B_GT;
662:
663: delete from FA_XLA_EXT_LINES_B_GT_tmp;
664: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
665: select * from FA_XLA_EXT_LINES_B_GT;*/
666: --Debug
667:

Line 664: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp

660: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
661: select * from FA_XLA_EXT_HEADERS_B_GT;
662:
663: delete from FA_XLA_EXT_LINES_B_GT_tmp;
664: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
665: select * from FA_XLA_EXT_LINES_B_GT;*/
666: --Debug
667:
668: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 665: select * from FA_XLA_EXT_LINES_B_GT;*/

661: select * from FA_XLA_EXT_HEADERS_B_GT;
662:
663: delete from FA_XLA_EXT_LINES_B_GT_tmp;
664: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
665: select * from FA_XLA_EXT_LINES_B_GT;*/
666: --Debug
667:
668: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
669: p_full_path => l_path_name,