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.FUN_BAL_PKG dependencies on FUN_BAL_LINES_GT

Line 457: SELECT * FROM fun_bal_lines_gt;

453: /*
454: INSERT INTO fun_bal_headers_t
455: SELECT * FROM fun_bal_headers_gt;
456: INSERT INTO fun_bal_lines_t
457: SELECT * FROM fun_bal_lines_gt;
458: INSERT INTO fun_bal_results_t
459: SELECT * FROM fun_bal_results_gt;
460: INSERT INTO fun_bal_errors_t
461: SELECT * FROM fun_bal_errors_gt;

Line 548: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_LINES_GT');

544: intercompany_column_number = get_segment_index ( headers.chart_of_accounts_id,
545: 'GL_INTERCOMPANY');
546:
547: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_HEADERS_GT');
548: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_LINES_GT');
549:
550: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_init.end', 'end');
552: END IF;

Line 567: SELECT * FROM fun_bal_lines_gt;

563: l_lines_count NUMBER;
564: CURSOR l_headers_cursor IS
565: SELECT * FROM fun_bal_headers_gt;
566: CURSOR l_lines_cursor IS
567: SELECT * FROM fun_bal_lines_gt;
568: BEGIN
569: OPEN l_headers_cursor;
570: FETCH l_headers_cursor BULK COLLECT INTO l_headers_tab;
571: l_headers_count := l_headers_cursor%ROWCOUNT;

Line 597: SELECT * FROM fun_bal_lines_gt;

593: l_errors_count NUMBER;
594: CURSOR l_headers_cursor IS
595: SELECT * FROM fun_bal_headers_gt;
596: CURSOR l_lines_cursor IS
597: SELECT * FROM fun_bal_lines_gt;
598: CURSOR l_results_cursor IS
599: SELECT * FROM fun_bal_results_gt;
600: CURSOR l_errors_cursor IS
601: SELECT * FROM fun_bal_errors_gt;

Line 609: -- Insert lines generated for Intercompany balancing from FUN_BAL_LINES_GT to FUN_BAL_RESULTS_GT

605: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
606: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_finalize.begin', 'begin');
607: END IF;
608:
609: -- Insert lines generated for Intercompany balancing from FUN_BAL_LINES_GT to FUN_BAL_RESULTS_GT
610: INSERT INTO fun_bal_results_gt results(group_id, bal_seg_val, entered_amt_dr,
611: entered_amt_cr, entered_currency_code, exchange_date, exchange_rate, exchange_rate_type,
612: accounted_amt_dr, accounted_amt_cr, ccid, balancing_type)
613: SELECT lines.group_id, lines.bal_seg_val, lines.entered_amt_dr,

Line 617: FROM fun_bal_lines_gt lines

613: SELECT lines.group_id, lines.bal_seg_val, lines.entered_amt_dr,
614: lines.entered_amt_cr, lines.entered_currency_code, lines.exchange_date, lines.exchange_rate,
615: lines.exchange_rate_type, lines.accounted_amt_dr, lines.accounted_amt_cr,
616: lines.ccid, 'E'
617: FROM fun_bal_lines_gt lines
618: WHERE lines.generated = 'Y';
619:
620: -- Bug 3167894
621: UPDATE fun_bal_results_gt results

Line 680: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,

676:
677: /* Replaced by sql below from performance review
678: INSERT INTO fun_bal_le_bsv_map_gt(group_id, ledger_id, bal_seg_val, gl_date)
679: SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date
680: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,
681: gl_ledger_configurations config
682: WHERE hdrs.group_id = lines.group_id
683: AND hdrs.ledger_id = ledger.ledger_id
684: AND ledger.configuration_id = config.configuration_id

Line 707: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger

703: -- Bug 3310453
704: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
705: SELECT 'FUN_BSV_INVALID', main.group_id, main.bal_seg_val
706: FROM (SELECT DISTINCT hdrs.group_id, lines.bal_seg_val, hdrs.gl_date, hdrs.ledger_id
707: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger
708: WHERE hdrs.group_id = lines.group_id
709: AND hdrs.ledger_id = ledger.ledger_id(+)
710: AND ledger.bal_seg_value_option_code = 'I') main
711: WHERE main.bal_seg_val NOT IN (SELECT vals.segment_value

Line 739: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,

735:
736: INSERT INTO fun_bal_le_bsv_map_gt(group_id, ledger_id, bal_seg_val, gl_date, le_id)
737: SELECT main.group_id, main.ledger_id, main.bal_seg_val, main.gl_date, NVL(vals.legal_entity_id, -99)
738: FROM (SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date
739: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,
740: gl_ledger_configurations config
741: WHERE hdrs.status = 'OK' -- Bug 3310453
742: AND hdrs.group_id = lines.group_id
743: AND hdrs.ledger_id = ledger.ledger_id(+)

Line 860: FROM fun_bal_lines_gt lines, fun_bal_le_bsv_map_gt le_bsv_map

856: AND le_bsv_map.group_id = headers.group_id);
857:
858: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map_del
859: WHERE EXISTS (SELECT 'LE already balanced'
860: FROM fun_bal_lines_gt lines, fun_bal_le_bsv_map_gt le_bsv_map
861: WHERE le_bsv_map_del.group_id = le_bsv_map.group_id
862: AND le_bsv_map_del.le_id = le_bsv_map.le_id
863: AND le_bsv_map.group_id = lines.group_id
864: AND le_bsv_map.bal_seg_val = lines.bal_seg_val

Line 878: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

874: UPDATE fun_bal_headers_gt hdrs
875: SET (driving_dr_le_id, intercompany_mode) =
876: (SELECT MIN(le_bsv_map.le_id),
877: SUM(COUNT(DISTINCT(le_bsv_map.le_id)))
878: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines
879: WHERE hdrs.group_id = le_bsv_map.group_id
880: AND le_bsv_map.group_id = lines.group_id
881: AND le_bsv_map.bal_seg_val = lines.bal_seg_val
882: GROUP BY le_bsv_map.group_id, le_bsv_map.le_id

Line 911: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

907: (SELECT MIN(le_bsv_map.le_id),
908: DECODE(SUM(COUNT(DISTINCT(le_bsv_map.le_id))), 1,
909: DECODE(hdrs.intercompany_mode, 1, 1, 3),
910: DECODE(hdrs.intercompany_mode, 1, 2, 4))
911: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines
912: WHERE hdrs.group_id = le_bsv_map.group_id
913: AND le_bsv_map.group_id = lines.group_id
914: AND le_bsv_map.bal_seg_val = lines.bal_seg_val
915: GROUP BY le_bsv_map.group_id, le_bsv_map.le_id

Line 960: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,

956: -1, 'D',
957: 0, DECODE(SIGN(SUM(NVL(lines.entered_amt_cr, 0)) - SUM(NVL(lines.accounted_amt_dr, 0))),
958: 1, 'C',
959: 'D')) type
960: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
961: fun_bal_headers_gt hdrs
962: WHERE hdrs.group_id = lines.group_id
963: AND lines.group_id = le_bsv_map.group_id
964: AND lines.bal_seg_val = le_bsv_map.bal_seg_val

Line 1571: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,

1567:
1568: Update fun_bal_inter_int_gt bal_inter_int
1569: set Rec_BSV = (select min_bal_seg_val from (
1570: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
1571: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
1572: fun_bal_headers_gt hdrs
1573: WHERE hdrs.group_id = lines.group_id
1574: AND lines.group_id = le_bsv_map.group_id
1575: AND lines.bal_seg_val = le_bsv_map.bal_seg_val

Line 1595: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,

1591:
1592: Update fun_bal_inter_int_gt bal_inter_int
1593: set Pay_BSV = (select min_bal_seg_val from (
1594: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
1595: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
1596: fun_bal_headers_gt hdrs
1597: WHERE hdrs.group_id = lines.group_id
1598: AND lines.group_id = le_bsv_map.group_id
1599: AND lines.bal_seg_val = le_bsv_map.bal_seg_val

Line 1904: -- Insert intercompany balancing lines into the FUN_BAL_LINES_GT table. These resulting lines

1900:
1901:
1902: /* 8200511 */
1903:
1904: -- Insert intercompany balancing lines into the FUN_BAL_LINES_GT table. These resulting lines
1905: -- are not yet inserted into the results table as intracompany balancing might need to be performed
1906: -- for these lines also.
1907: INSERT INTO fun_bal_lines_gt lines (group_id, bal_seg_val, entered_amt_dr,
1908: entered_amt_cr, entered_currency_code, exchange_date, exchange_rate, exchange_rate_type,

Line 1907: INSERT INTO fun_bal_lines_gt lines (group_id, bal_seg_val, entered_amt_dr,

1903:
1904: -- Insert intercompany balancing lines into the FUN_BAL_LINES_GT table. These resulting lines
1905: -- are not yet inserted into the results table as intracompany balancing might need to be performed
1906: -- for these lines also.
1907: INSERT INTO fun_bal_lines_gt lines (group_id, bal_seg_val, entered_amt_dr,
1908: entered_amt_cr, entered_currency_code, exchange_date, exchange_rate, exchange_rate_type,
1909: accounted_amt_dr, accounted_amt_cr, ccid, generated)
1910: SELECT sum_lines.group_id,
1911: DECODE(gen.value, 'D', sum_lines.rec_bsv,

Line 1968: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines

1964: chart_of_accounts_id, bal_seg_column_number,intercompany_column_number)
1965: SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date,
1966: hdrs.je_source_name, hdrs.je_category_name, hdrs.clearing_bsv,
1967: hdrs.chart_of_accounts_id, hdrs.bal_seg_column_number, hdrs.intercompany_column_number
1968: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines
1969: WHERE hdrs.group_id = lines.group_id
1970: AND hdrs.status = 'OK';
1971:
1972:

Line 1999: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

1995: -- improve performance for not updating the lines of LE that uses clearing company
1996: UPDATE fun_bal_le_bsv_map_gt le_bsv_map_upd
1997: SET (driving_dr_bsv, intracompany_mode) =
1998: (SELECT MIN(le_bsv_map.bal_seg_val), SUM(COUNT(DISTINCT(le_bsv_map.bal_seg_val)))
1999: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines
2000: WHERE le_bsv_map.group_id = lines.group_id
2001: AND le_bsv_map.bal_seg_val = lines.bal_seg_val
2002: AND le_bsv_map.group_id = le_bsv_map_upd.group_id
2003: AND le_bsv_map.le_id = le_bsv_map_upd.le_id

Line 2026: FROM fun_bal_lines_gt lines, fun_bal_le_bsv_map_gt le_bsv_map

2022: WHERE intracompany_mode IS NULL;
2023:
2024: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map_del
2025: WHERE EXISTS (SELECT 'BSV already balanced'
2026: FROM fun_bal_lines_gt lines, fun_bal_le_bsv_map_gt le_bsv_map
2027: WHERE le_bsv_map_del.group_id = le_bsv_map.group_id
2028: AND le_bsv_map_del.le_id = le_bsv_map.le_id
2029: AND le_bsv_map_del.bal_seg_val = le_bsv_map.bal_seg_val
2030: AND le_bsv_map.group_id = lines.group_id

Line 2044: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

2040: SET (driving_cr_bsv, intracompany_mode) =
2041: (SELECT MIN(le_bsv_map.bal_seg_val), DECODE(SUM(COUNT(DISTINCT(le_bsv_map.bal_seg_val))),
2042: 1, DECODE(le_bsv_map_upd.intracompany_mode, 1, 1, 3),
2043: DECODE(le_bsv_map_upd.intracompany_mode, 1, 2, 4))
2044: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines
2045: WHERE le_bsv_map.group_id = lines.group_id
2046: AND le_bsv_map.bal_seg_val = lines.bal_seg_val
2047: AND le_bsv_map.group_id = le_bsv_map_upd.group_id
2048: AND le_bsv_map.le_id = le_bsv_map_upd.le_id

Line 2494: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines, fun_bal_headers_gt hdrs

2490: 'D')) type,
2491: */
2492: DECODE(lines.accounted_amt_cr, NULL, DECODE(lines.entered_amt_cr, NULL, 'D', 'C'), 'C') type,
2493: le_bsv_map.clearing_bsv
2494: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines, fun_bal_headers_gt hdrs
2495: WHERE hdrs.group_id = lines.group_id
2496: AND lines.group_id = le_bsv_map.group_id
2497: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
2498: AND hdrs.status = 'OK'

Line 2526: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,

2522: -1, 'D',
2523: 0, DECODE(SIGN(SUM(NVL(lines.entered_amt_cr, 0)) - SUM(NVL(lines.accounted_amt_dr, 0))),
2524: 1, 'C',
2525: 'D')) type, le_bsv_map.clearing_bsv
2526: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
2527: fun_bal_headers_gt hdrs
2528: WHERE hdrs.group_id = lines.group_id
2529: AND lines.group_id = le_bsv_map.group_id
2530: AND lines.bal_seg_val = le_bsv_map.bal_seg_val