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 509: SELECT * FROM fun_bal_lines_gt;

505: /*
506: INSERT INTO fun_bal_headers_t
507: SELECT * FROM fun_bal_headers_gt;
508: INSERT INTO fun_bal_lines_t
509: SELECT * FROM fun_bal_lines_gt;
510: INSERT INTO fun_bal_results_t
511: SELECT * FROM fun_bal_results_gt;
512: INSERT INTO fun_bal_errors_t
513: SELECT * FROM fun_bal_errors_gt;

Line 599: UPDATE fun_bal_lines_gt lines

595: 'GL_BALANCING'),
596: intercompany_column_number = get_segment_index ( headers.chart_of_accounts_id,
597: 'GL_INTERCOMPANY');
598: --Bug: 12606188
599: UPDATE fun_bal_lines_gt lines
600: SET entered_amt_dr = accounted_amt_dr,
601: entered_amt_cr = accounted_amt_cr,
602: entered_currency_code = (select gl.currency_code
603: from fun_bal_headers_gt headers, gl_ledgers gl

Line 610: from fun_bal_lines_gt lines2

606: exchange_date = null,
607: exchange_rate = null,
608: exchange_rate_type = null
609: WHERE 1 < (select count(distinct entered_currency_code)
610: from fun_bal_lines_gt lines2
611: where lines2.group_id = lines.group_id);
612:
613: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_HEADERS_GT');
614: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_LINES_GT');

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

610: from fun_bal_lines_gt lines2
611: where lines2.group_id = lines.group_id);
612:
613: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_HEADERS_GT');
614: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_LINES_GT');
615:
616: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
617: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_init.end', 'end');
618: END IF;

Line 633: SELECT * FROM fun_bal_lines_gt;

629: l_lines_count NUMBER;
630: CURSOR l_headers_cursor IS
631: SELECT * FROM fun_bal_headers_gt;
632: CURSOR l_lines_cursor IS
633: SELECT * FROM fun_bal_lines_gt;
634: BEGIN
635: OPEN l_headers_cursor;
636: FETCH l_headers_cursor BULK COLLECT INTO l_headers_tab;
637: l_headers_count := l_headers_cursor%ROWCOUNT;

Line 663: SELECT * FROM fun_bal_lines_gt;

659: l_errors_count NUMBER;
660: CURSOR l_headers_cursor IS
661: SELECT * FROM fun_bal_headers_gt;
662: CURSOR l_lines_cursor IS
663: SELECT * FROM fun_bal_lines_gt;
664: CURSOR l_results_cursor IS
665: SELECT * FROM fun_bal_results_gt;
666: CURSOR l_errors_cursor IS
667: SELECT * FROM fun_bal_errors_gt;

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

671: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
672: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_finalize.begin', 'begin');
673: END IF;
674:
675: -- Insert lines generated for Intercompany balancing from FUN_BAL_LINES_GT to FUN_BAL_RESULTS_GT
676: INSERT INTO fun_bal_results_gt results(group_id, bal_seg_val, entered_amt_dr,
677: entered_amt_cr, entered_currency_code, exchange_date, exchange_rate, exchange_rate_type,
678: accounted_amt_dr, accounted_amt_cr, ccid, balancing_type)
679: SELECT lines.group_id, lines.bal_seg_val, lines.entered_amt_dr,

Line 683: FROM fun_bal_lines_gt lines

679: SELECT lines.group_id, lines.bal_seg_val, lines.entered_amt_dr,
680: lines.entered_amt_cr, lines.entered_currency_code, lines.exchange_date, lines.exchange_rate,
681: lines.exchange_rate_type, lines.accounted_amt_dr, lines.accounted_amt_cr,
682: lines.ccid, 'E'
683: FROM fun_bal_lines_gt lines
684: WHERE lines.generated = 'Y';
685:
686: -- Bug 3167894
687: --Bug: 12887806, 13590695

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

746:
747: /* Replaced by sql below from performance review
748: INSERT INTO fun_bal_le_bsv_map_gt(group_id, ledger_id, bal_seg_val, gl_date)
749: SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date
750: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,
751: gl_ledger_configurations config
752: WHERE hdrs.group_id = lines.group_id
753: AND hdrs.ledger_id = ledger.ledger_id
754: AND ledger.configuration_id = config.configuration_id

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

773: -- Bug 3310453
774: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
775: SELECT 'FUN_BSV_INVALID', main.group_id, main.bal_seg_val
776: FROM (SELECT DISTINCT hdrs.group_id, lines.bal_seg_val, hdrs.gl_date, hdrs.ledger_id
777: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger
778: WHERE hdrs.group_id = lines.group_id
779: AND hdrs.ledger_id = ledger.ledger_id(+)
780: AND ledger.bal_seg_value_option_code = 'I') main
781: WHERE main.bal_seg_val NOT IN (SELECT vals.segment_value

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

809: INSERT INTO fun_bal_le_bsv_map_gt(group_id, ledger_id, bal_seg_val, gl_date, le_id, je_source_name, je_category_name)
810: SELECT main.group_id, main.ledger_id, main.bal_seg_val, main.gl_date, NVL(vals.legal_entity_id, -99),
811: main.je_source_name, main.je_category_name
812: FROM (SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date, hdrs.je_source_name, hdrs.je_category_name
813: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,
814: gl_ledger_configurations config
815: WHERE hdrs.status = 'OK' -- Bug 3310453
816: AND hdrs.group_id = lines.group_id
817: AND hdrs.ledger_id = ledger.ledger_id(+)

Line 933: FROM fun_bal_lines_gt lines, fun_bal_le_bsv_map_gt le_bsv_map

929: AND le_bsv_map.group_id = headers.group_id);
930:
931: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map_del
932: WHERE EXISTS (SELECT 'LE already balanced'
933: FROM fun_bal_lines_gt lines, fun_bal_le_bsv_map_gt le_bsv_map
934: WHERE le_bsv_map_del.group_id = le_bsv_map.group_id
935: AND le_bsv_map_del.le_id = le_bsv_map.le_id
936: AND le_bsv_map.group_id = lines.group_id
937: AND le_bsv_map.bal_seg_val = lines.bal_seg_val

Line 951: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

947: UPDATE fun_bal_headers_gt hdrs
948: SET (driving_dr_le_id, intercompany_mode) =
949: (SELECT MIN(le_bsv_map.le_id),
950: SUM(COUNT(DISTINCT(le_bsv_map.le_id)))
951: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines
952: WHERE hdrs.group_id = le_bsv_map.group_id
953: AND le_bsv_map.group_id = lines.group_id
954: AND le_bsv_map.bal_seg_val = lines.bal_seg_val
955: GROUP BY le_bsv_map.group_id, le_bsv_map.le_id

Line 984: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

980: (SELECT MIN(le_bsv_map.le_id),
981: DECODE(SUM(COUNT(DISTINCT(le_bsv_map.le_id))), 1,
982: DECODE(hdrs.intercompany_mode, 1, 1, 3),
983: DECODE(hdrs.intercompany_mode, 1, 2, 4))
984: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines
985: WHERE hdrs.group_id = le_bsv_map.group_id
986: AND le_bsv_map.group_id = lines.group_id
987: AND le_bsv_map.bal_seg_val = lines.bal_seg_val
988: GROUP BY le_bsv_map.group_id, le_bsv_map.le_id

Line 1081: FUN_BAL_LINES_GT LINES,

1077: -1, 'D',
1078: 0, DECODE(SIGN((( SUM(NVL(LINES.ENTERED_AMT_CR, 0)) - SUM(NVL(LINES.ENTERED_AMT_DR, 0)) )) -
1079: ( SUM(NVL(LINES.ACCOUNTED_AMT_DR, 0)) - SUM(NVL(LINES.ACCOUNTED_AMT_CR, 0)) )), 1, 'C', 'D')) TYPE
1080: FROM FUN_BAL_LE_BSV_MAP_GT LE_BSV_MAP,
1081: FUN_BAL_LINES_GT LINES,
1082: FUN_BAL_HEADERS_GT HDRS
1083: WHERE HDRS.GROUP_ID = LINES.GROUP_ID
1084: AND LINES.GROUP_ID = LE_BSV_MAP.GROUP_ID
1085: AND LINES.BAL_SEG_VAL = LE_BSV_MAP.BAL_SEG_VAL

Line 1648: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,

1644:
1645: Update fun_bal_inter_int_gt bal_inter_int
1646: set REC_BSV = (select min_bal_seg_val from (
1647: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
1648: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
1649: fun_bal_headers_gt hdrs
1650: WHERE hdrs.group_id = lines.group_id
1651: AND lines.group_id = le_bsv_map.group_id
1652: AND lines.bal_seg_val = le_bsv_map.bal_seg_val

Line 1674: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,

1670:
1671: Update fun_bal_inter_int_gt bal_inter_int
1672: set PAY_BSV = (select min_bal_seg_val from (
1673: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
1674: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
1675: fun_bal_headers_gt hdrs
1676: WHERE hdrs.group_id = lines.group_id
1677: AND lines.group_id = le_bsv_map.group_id
1678: AND lines.bal_seg_val = le_bsv_map.bal_seg_val

Line 2529: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,

2525: --bug: 9008776
2526: Update fun_bal_inter_int_gt bal_inter_int
2527: set Rec_BSV = (select min_bal_seg_val from (
2528: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
2529: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
2530: fun_bal_headers_gt hdrs
2531: WHERE hdrs.group_id = lines.group_id
2532: AND lines.group_id = le_bsv_map.group_id
2533: AND lines.bal_seg_val = le_bsv_map.bal_seg_val

Line 2553: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,

2549:
2550: Update fun_bal_inter_int_gt bal_inter_int
2551: set Pay_BSV = (select min_bal_seg_val from (
2552: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
2553: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
2554: fun_bal_headers_gt hdrs
2555: WHERE hdrs.group_id = lines.group_id
2556: AND lines.group_id = le_bsv_map.group_id
2557: AND lines.bal_seg_val = le_bsv_map.bal_seg_val

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

2860:
2861:
2862: /* 8200511 */
2863:
2864: -- Insert intercompany balancing lines into the FUN_BAL_LINES_GT table. These resulting lines
2865: -- are not yet inserted into the results table as intracompany balancing might need to be performed
2866: -- for these lines also.
2867: INSERT INTO fun_bal_lines_gt lines (group_id, bal_seg_val, entered_amt_dr,
2868: entered_amt_cr, entered_currency_code, exchange_date, exchange_rate, exchange_rate_type,

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

2863:
2864: -- Insert intercompany balancing lines into the FUN_BAL_LINES_GT table. These resulting lines
2865: -- are not yet inserted into the results table as intracompany balancing might need to be performed
2866: -- for these lines also.
2867: INSERT INTO fun_bal_lines_gt lines (group_id, bal_seg_val, entered_amt_dr,
2868: entered_amt_cr, entered_currency_code, exchange_date, exchange_rate, exchange_rate_type,
2869: accounted_amt_dr, accounted_amt_cr, ccid, generated)
2870: SELECT sum_lines.group_id,
2871: DECODE(gen.value, 'D', sum_lines.rec_bsv,

Line 2928: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines

2924: chart_of_accounts_id, bal_seg_column_number,intercompany_column_number)
2925: SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date,
2926: hdrs.je_source_name, hdrs.je_category_name, hdrs.clearing_bsv,
2927: hdrs.chart_of_accounts_id, hdrs.bal_seg_column_number, hdrs.intercompany_column_number
2928: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines
2929: WHERE hdrs.group_id = lines.group_id
2930: AND hdrs.status = 'OK';
2931:
2932:

Line 2959: index(LE_BSV_MAP,FUN_BAL_LE_BSV_MAP_GT_N1) index(LINES,FUN_BAL_LINES_GT_N1) */

2955: -- improve performance for not updating the lines of LE that uses clearing company
2956: UPDATE fun_bal_le_bsv_map_gt le_bsv_map_upd
2957: SET (driving_dr_bsv, intracompany_mode) =
2958: (SELECT /*+ leading(LE_BSV_MAP) use_nl(LINES)
2959: index(LE_BSV_MAP,FUN_BAL_LE_BSV_MAP_GT_N1) index(LINES,FUN_BAL_LINES_GT_N1) */
2960: MIN(le_bsv_map.bal_seg_val), SUM(COUNT(DISTINCT(le_bsv_map.bal_seg_val)))
2961: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines
2962: WHERE le_bsv_map.group_id = lines.group_id
2963: AND le_bsv_map.bal_seg_val = lines.bal_seg_val

Line 2961: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

2957: SET (driving_dr_bsv, intracompany_mode) =
2958: (SELECT /*+ leading(LE_BSV_MAP) use_nl(LINES)
2959: index(LE_BSV_MAP,FUN_BAL_LE_BSV_MAP_GT_N1) index(LINES,FUN_BAL_LINES_GT_N1) */
2960: MIN(le_bsv_map.bal_seg_val), SUM(COUNT(DISTINCT(le_bsv_map.bal_seg_val)))
2961: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines
2962: WHERE le_bsv_map.group_id = lines.group_id
2963: AND le_bsv_map.bal_seg_val = lines.bal_seg_val
2964: AND le_bsv_map.group_id = le_bsv_map_upd.group_id
2965: AND le_bsv_map.le_id = le_bsv_map_upd.le_id

Line 2989: index(LE_BSV_MAP,FUN_BAL_LE_BSV_MAP_GT_N1) index(LINES,FUN_BAL_LINES_GT_N1) */

2985: WHERE intracompany_mode IS NULL;
2986:
2987: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map_del
2988: WHERE EXISTS (SELECT /*+ leading(LE_BSV_MAP) use_nl(LINES)
2989: index(LE_BSV_MAP,FUN_BAL_LE_BSV_MAP_GT_N1) index(LINES,FUN_BAL_LINES_GT_N1) */
2990: 'BSV already balanced'
2991: FROM fun_bal_lines_gt lines, fun_bal_le_bsv_map_gt le_bsv_map
2992: WHERE le_bsv_map_del.group_id = le_bsv_map.group_id
2993: AND le_bsv_map_del.le_id = le_bsv_map.le_id

Line 2991: FROM fun_bal_lines_gt lines, fun_bal_le_bsv_map_gt le_bsv_map

2987: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map_del
2988: WHERE EXISTS (SELECT /*+ leading(LE_BSV_MAP) use_nl(LINES)
2989: index(LE_BSV_MAP,FUN_BAL_LE_BSV_MAP_GT_N1) index(LINES,FUN_BAL_LINES_GT_N1) */
2990: 'BSV already balanced'
2991: FROM fun_bal_lines_gt lines, fun_bal_le_bsv_map_gt le_bsv_map
2992: WHERE le_bsv_map_del.group_id = le_bsv_map.group_id
2993: AND le_bsv_map_del.le_id = le_bsv_map.le_id
2994: AND le_bsv_map_del.bal_seg_val = le_bsv_map.bal_seg_val
2995: AND le_bsv_map.group_id = lines.group_id

Line 3008: index(LE_BSV_MAP,FUN_BAL_LE_BSV_MAP_GT_N1) index(LINES,FUN_BAL_LINES_GT_N1) */

3004:
3005: UPDATE fun_bal_le_bsv_map_gt le_bsv_map_upd
3006: SET (driving_cr_bsv, intracompany_mode) =
3007: (SELECT /*+ leading(LE_BSV_MAP) use_nl(LINES)
3008: index(LE_BSV_MAP,FUN_BAL_LE_BSV_MAP_GT_N1) index(LINES,FUN_BAL_LINES_GT_N1) */
3009: MIN(le_bsv_map.bal_seg_val), DECODE(SUM(COUNT(DISTINCT(le_bsv_map.bal_seg_val))),
3010: 1, DECODE(le_bsv_map_upd.intracompany_mode, 1, 1, 3),
3011: DECODE(le_bsv_map_upd.intracompany_mode, 1, 2, 4))
3012: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

Line 3012: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

3008: index(LE_BSV_MAP,FUN_BAL_LE_BSV_MAP_GT_N1) index(LINES,FUN_BAL_LINES_GT_N1) */
3009: MIN(le_bsv_map.bal_seg_val), DECODE(SUM(COUNT(DISTINCT(le_bsv_map.bal_seg_val))),
3010: 1, DECODE(le_bsv_map_upd.intracompany_mode, 1, 1, 3),
3011: DECODE(le_bsv_map_upd.intracompany_mode, 1, 2, 4))
3012: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines
3013: WHERE le_bsv_map.group_id = lines.group_id
3014: AND le_bsv_map.bal_seg_val = lines.bal_seg_val
3015: AND le_bsv_map.group_id = le_bsv_map_upd.group_id
3016: AND le_bsv_map.le_id = le_bsv_map_upd.le_id

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

3459: 'D')) type,
3460: */
3461: DECODE(lines.accounted_amt_cr, NULL, DECODE(lines.entered_amt_cr, NULL, 'D', 'C'), 'C') type,
3462: le_bsv_map.clearing_bsv
3463: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines, fun_bal_headers_gt hdrs
3464: WHERE hdrs.group_id = lines.group_id
3465: AND lines.group_id = le_bsv_map.group_id
3466: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
3467: AND hdrs.status = 'OK'

Line 3497: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,

3493: -1, 'D',
3494: 0, DECODE(SIGN(SUM(NVL(lines.entered_amt_cr, 0)) - SUM(NVL(lines.accounted_amt_dr, 0))),
3495: 1, 'C',
3496: 'D')) type, le_bsv_map.clearing_bsv
3497: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
3498: fun_bal_headers_gt hdrs
3499: WHERE hdrs.group_id = lines.group_id
3500: AND lines.group_id = le_bsv_map.group_id
3501: AND lines.bal_seg_val = le_bsv_map.bal_seg_val