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_INTER_INT_GT

Line 70: DELETE FROM fun_bal_inter_int_gt;

66:
67: DELETE FROM fun_bal_results_gt;
68: DELETE FROM fun_bal_errors_gt;
69: DELETE FROM fun_bal_le_bsv_map_gt;
70: DELETE FROM fun_bal_inter_int_gt;
71: DELETE FROM fun_bal_intra_int_gt;
72: /* Using delete rather than truncate as shown in the code below. The reason is that truncate (or any DDL operations)
73: perform an implicit commit => need to use autonomous transaction to perform such operation. However, we would
74: like to make sure the calling program does not see the rows that gets deleted, therefore truncate is not used.

Line 81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);

77: cur_hdl := dbms_sql.open_cursor;
78: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
79: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
80: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);

Line 120: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||

116: LOOP
117: FETCH bal_seg_val_cur INTO l_bal_seg_column_name;
118: EXIT WHEN bal_seg_val_cur%NOTFOUND;
119: cur_hdl := dbms_sql.open_cursor;
120: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||
121: ' SET rec_bsv = ' ||
122: ' (SELECT ' || l_bal_seg_column_name ||
123: ' FROM gl_code_combinations ' ||
124: ' WHERE code_combination_id = inter_int.rec_acct ' ||

Line 132: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||

128: rows_processed := dbms_sql.execute(cur_hdl);
129: dbms_sql.close_cursor(cur_hdl); -- close cursor
130:
131: cur_hdl := dbms_sql.open_cursor;
132: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||
133: ' SET pay_bsv = ' ||
134: ' (SELECT ' || l_bal_seg_column_name ||
135: ' FROM gl_code_combinations ' ||
136: ' WHERE code_combination_id = inter_int.pay_acct ' ||

Line 738: SELECT * FROM fun_bal_inter_int_gt;

734: l_inter_int_tab inter_int_tab_type;
735: CURSOR l_le_bsv_map_cursor IS
736: SELECT * FROM fun_bal_le_bsv_map_gt;
737: CURSOR l_inter_int_cursor IS
738: SELECT * FROM fun_bal_inter_int_gt;
739: l_le_bsv_map_count NUMBER;
740: l_inter_int_count NUMBER;
741:
742: BEGIN

Line 1571: --inserting the lines of 1:1 into fun_bal_inter_int_gt #9392684

1567: and driving_cr_le_bsv <> line_le_bsv
1568: and TYPE = 'C';
1569:
1570:
1571: --inserting the lines of 1:1 into fun_bal_inter_int_gt #9392684
1572: INSERT into fun_bal_inter_int_gt
1573: (Select * from fun_bal_inter_int2_gt
1574: where driving_cr_le_bsv<>'Many'
1575: and driving_dr_le_bsv<>'Many') ;

Line 1572: INSERT into fun_bal_inter_int_gt

1568: and TYPE = 'C';
1569:
1570:
1571: --inserting the lines of 1:1 into fun_bal_inter_int_gt #9392684
1572: INSERT into fun_bal_inter_int_gt
1573: (Select * from fun_bal_inter_int2_gt
1574: where driving_cr_le_bsv<>'Many'
1575: and driving_dr_le_bsv<>'Many') ;
1576: --inserting the lines of M:M into fun_bal_gt by summarizing at LE level #9392684

Line 1578: INTO fun_bal_inter_int_gt

1574: where driving_cr_le_bsv<>'Many'
1575: and driving_dr_le_bsv<>'Many') ;
1576: --inserting the lines of M:M into fun_bal_gt by summarizing at LE level #9392684
1577: INSERT
1578: INTO fun_bal_inter_int_gt
1579: (
1580: group_id,
1581: ledger_id,
1582: gl_date,

Line 1645: Update fun_bal_inter_int_gt bal_inter_int

1641: AND SUM(DECODE(upd1.exchange_rate, NULL, NVL(upd1.entered_amt_cr, 0), 0)) <> SUM(DECODE(upd1.exchange_rate, NULL, NVL(upd1.entered_amt_dr, 0), 0)));
1642:
1643: --Bug:11883614
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

Line 1671: Update fun_bal_inter_int_gt bal_inter_int

1667:
1668: where bal_inter_int.driving_dr_le_bsv='Many'
1669: AND bal_inter_int.driving_cr_le_bsv='Many';
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

Line 1697: Update fun_bal_inter_int_gt bal_inter_int

1693: where bal_inter_int.driving_dr_le_bsv='Many'
1694: AND bal_inter_int.driving_cr_le_bsv='Many';
1695:
1696:
1697: Update fun_bal_inter_int_gt bal_inter_int
1698: set driving_cr_le_bsv = REC_BSV,
1699: driving_dr_le_bsv = PAY_BSV ,
1700: LINE_LE_BSV = decode(TYPE, 'D',PAY_BSV,REC_BSV)
1701: where driving_dr_le_bsv='Many'

Line 1707: --inserting lines into fun_bal_inter_int_gt for the 1:M and M:1 case by redistributing amounts #9392684

1703: and group_id in (select group_id from fun_bal_headers_gt where intercompany_mode IN (1,2,3));
1704:
1705: --End Bug:11883614
1706:
1707: --inserting lines into fun_bal_inter_int_gt for the 1:M and M:1 case by redistributing amounts #9392684
1708: INSERT into fun_bal_inter_int_gt (GROUP_ID,
1709: LEDGER_ID,
1710: GL_DATE,
1711: STATUS,

Line 1708: INSERT into fun_bal_inter_int_gt (GROUP_ID,

1704:
1705: --End Bug:11883614
1706:
1707: --inserting lines into fun_bal_inter_int_gt for the 1:M and M:1 case by redistributing amounts #9392684
1708: INSERT into fun_bal_inter_int_gt (GROUP_ID,
1709: LEDGER_ID,
1710: GL_DATE,
1711: STATUS,
1712: DRIVING_DR_LE_ID,

Line 1797: UPDATE fun_bal_inter_int_gt inter_int

1793: -- 4) From LE => To LE
1794: -- 4) From LE => To All Others
1795:
1796: -- For 1:1, search from rule 1 and progress through to rule 5 if not found
1797: UPDATE fun_bal_inter_int_gt inter_int
1798: SET rec_acct =
1799: (SELECT ccid
1800: FROM fun_inter_accounts accts
1801: WHERE inter_int.ledger_id = accts.ledger_id

Line 1840: UPDATE fun_bal_inter_int_gt inter_int

1836: AND driving_dr_le_bsv <> 'Many'
1837: AND driving_cr_le_bsv <> 'Many';
1838:
1839: -- For 1:M, search for rule 2
1840: UPDATE fun_bal_inter_int_gt inter_int
1841: SET rec_acct =
1842: (SELECT ccid
1843: FROM fun_inter_accounts accts
1844: WHERE inter_int.ledger_id = accts.ledger_id

Line 1876: UPDATE fun_bal_inter_int_gt inter_int

1872: WHERE inter_int.intercompany_mode IN (1,2,3)
1873: AND inter_int.rec_acct IS NULL;
1874:
1875: -- For M:1, search from rule 3 and progress through to rule 5 if not found
1876: UPDATE fun_bal_inter_int_gt inter_int
1877: SET rec_acct =
1878: (SELECT ccid
1879: FROM fun_inter_accounts accts
1880: WHERE inter_int.ledger_id = accts.ledger_id

Line 1914: UPDATE fun_bal_inter_int_gt inter_int

1910:
1911: -- The above will take care of rules 1 to 3.
1912: -- The account has not been found, the following will deal with rule 4
1913: -- ie it looks at specific LE without checking for the BSV
1914: UPDATE fun_bal_inter_int_gt inter_int
1915: SET rec_acct =
1916: (SELECT ccid
1917: FROM fun_inter_accounts accts
1918: WHERE inter_int.ledger_id = accts.ledger_id

Line 1946: Update Fun_bal_inter_int_gt Inter_int

1942:
1943: -- Update receivables account for other LE if no account specified for specific LE
1944: -- This will handle rule 5
1945: --Bug: 9183927
1946: Update Fun_bal_inter_int_gt Inter_int
1947: Set Rec_acct = (Select Ccid
1948: From fun_inter_accounts Accts
1949: Where Inter_int.Ledger_id = Accts.Ledger_id
1950: And Inter_int.Rec_acct Is Null

Line 1974: Update Fun_bal_inter_int_gt Inter_int

1970: And Trunc(Nvl(Accts.End_date, Inter_int.Gl_date))))
1971: Where Inter_int.Rec_acct Is Null ;
1972:
1973:
1974: Update Fun_bal_inter_int_gt Inter_int
1975: Set Rec_acct = (Select Ccid
1976: From fun_inter_accounts Accts
1977: Where Inter_int.Ledger_id = Accts.Ledger_id
1978: And Inter_int.Rec_acct Is Null

Line 1997: UPDATE fun_bal_inter_int_gt inter_int

1993: Where Inter_int.Rec_acct Is Null ;
1994:
1995: --ER: 8588074
1996: --Bug: 9183927
1997: UPDATE fun_bal_inter_int_gt inter_int
1998: SET rec_acct = (SELECT dr_ccid
1999: FROM fun_balance_accounts accts
2000: WHERE
2001: 'OTHER1234567890123456789012345' = accts.cr_bsv

Line 2070: UPDATE fun_bal_inter_int_gt inter_int

2066: ---- end ER: 8588074
2067:
2068: -- Update payables account for specific LE
2069: -- 1:1 mapping to begin with
2070: UPDATE fun_bal_inter_int_gt inter_int
2071: SET pay_acct =
2072: (SELECT ccid
2073: FROM fun_inter_accounts accts
2074: WHERE inter_int.ledger_id = accts.ledger_id

Line 2112: UPDATE fun_bal_inter_int_gt inter_int

2108: AND driving_cr_le_bsv <> 'Many'
2109: AND driving_dr_le_bsv <> 'Many';
2110:
2111: -- 1:M - next
2112: UPDATE fun_bal_inter_int_gt inter_int
2113: SET pay_acct =
2114: (SELECT ccid
2115: FROM fun_inter_accounts accts
2116: WHERE inter_int.ledger_id = accts.ledger_id

Line 2147: UPDATE fun_bal_inter_int_gt inter_int

2143: WHERE inter_int.intercompany_mode IN (1,2,3)
2144: AND inter_int.pay_acct IS NULL;
2145:
2146: -- M:1 - next
2147: UPDATE fun_bal_inter_int_gt inter_int
2148: SET pay_acct =
2149: (SELECT ccid
2150: FROM fun_inter_accounts accts
2151: WHERE inter_int.ledger_id = accts.ledger_id

Line 2183: UPDATE fun_bal_inter_int_gt inter_int

2179: AND inter_int.pay_acct IS NULL ;
2180:
2181: -- If the payables account was not found, look for an account as per rule 4
2182: -- ie from le to te
2183: UPDATE fun_bal_inter_int_gt inter_int
2184: SET pay_acct =
2185: (SELECT ccid
2186: FROM fun_inter_accounts accts
2187: WHERE inter_int.ledger_id = accts.ledger_id

Line 2215: UPDATE fun_bal_inter_int_gt inter_int

2211:
2212: -- Update payables account for other LE if no account specified for specific LE
2213: -- This will deal with rule 5, From LE to All Others
2214: --Bug: 9183927
2215: UPDATE fun_bal_inter_int_gt inter_int
2216: SET pay_acct =
2217: (SELECT ccid
2218: FROM fun_inter_accounts accts
2219: WHERE inter_int.ledger_id = accts.ledger_id

Line 2244: UPDATE fun_bal_inter_int_gt inter_int

2240: AND (TRUNC(inter_int.gl_date) BETWEEN TRUNC(NVL(accts.start_date, inter_int.gl_date)) AND
2241: TRUNC(NVL(accts.end_date, inter_int.gl_date))))
2242: WHERE inter_int.pay_acct IS NULL;
2243:
2244: UPDATE fun_bal_inter_int_gt inter_int
2245: SET pay_acct =
2246: (SELECT ccid
2247: FROM fun_inter_accounts accts
2248: WHERE inter_int.ledger_id = accts.ledger_id

Line 2268: UPDATE fun_bal_inter_int_gt inter_int

2264: TRUNC(NVL(accts.end_date, inter_int.gl_date))))
2265: WHERE inter_int.pay_acct IS NULL;
2266: -- ER: 8588074
2267: --Bug: 9183927
2268: UPDATE fun_bal_inter_int_gt inter_int
2269: SET pay_acct = (SELECT cr_ccid
2270: FROM fun_balance_accounts accts
2271: WHERE
2272: 'OTHER1234567890123456789012345' = accts.cr_bsv

Line 2337: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_INTER_INT_GT');

2333: AND opts.status_flag = 'Y')))) template_id
2334: From Dual))
2335: WHERE inter_int.pay_acct IS NULL and fun_trx_pvt.get_inter_intra()='Y';
2336: --- END ER: 8588074
2337: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_INTER_INT_GT');
2338:
2339: UPDATE fun_bal_inter_int_gt inter_int
2340: SET rec_acct = -1
2341: WHERE rec_acct IS NULL AND

Line 2339: UPDATE fun_bal_inter_int_gt inter_int

2335: WHERE inter_int.pay_acct IS NULL and fun_trx_pvt.get_inter_intra()='Y';
2336: --- END ER: 8588074
2337: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_INTER_INT_GT');
2338:
2339: UPDATE fun_bal_inter_int_gt inter_int
2340: SET rec_acct = -1
2341: WHERE rec_acct IS NULL AND
2342: EXISTS (SELECT 'Receivables Accounts exist but not defaulted'
2343: FROM fun_inter_accounts accts

Line 2368: UPDATE fun_bal_inter_int_gt inter_int

2364: NULL) = accts.to_le_id
2365: OR
2366: accts.to_le_id = -99));
2367:
2368: UPDATE fun_bal_inter_int_gt inter_int
2369: SET pay_acct = -1
2370: WHERE pay_acct IS NULL AND
2371: EXISTS (SELECT 'Payables Accounts exist but not defaulted'
2372: FROM fun_inter_accounts accts

Line 2424: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

2420: DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), 'R',
2421: get_ccid_concat_disp(DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), hdrs.chart_of_accounts_id,
2422: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv, bal_seg_column_number, intercompany_column_number),
2423: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
2424: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
2425: WHERE inter_int.group_id = hdrs.group_id AND
2426: ((inter_int.intercompany_mode = 1 AND
2427: inter_int.type = 'C')
2428: OR

Line 2473: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

2469: DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), 'P',
2470: get_ccid_concat_disp(DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), hdrs.chart_of_accounts_id,
2471: inter_int.driving_cr_le_bsv, inter_int.driving_dr_le_bsv, bal_seg_column_number, intercompany_column_number),
2472: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
2473: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
2474: WHERE inter_int.group_id = hdrs.group_id AND
2475: ((inter_int.intercompany_mode = 1 AND
2476: inter_int.type = 'D')
2477: OR

Line 2516: DELETE FROM fun_bal_inter_int_gt inter_int

2512: 'FUN_INTER_PAY_NOT_VALID',
2513: 'FUN_INTER_REC_NOT_VALID'))
2514: AND headers.status = 'OK';
2515:
2516: DELETE FROM fun_bal_inter_int_gt inter_int
2517: WHERE EXISTS (SELECT group_id
2518: FROM fun_bal_headers_gt headers
2519: WHERE headers.status = 'ERROR'
2520: AND inter_int.group_id = headers.group_id);

Line 2526: Update fun_bal_inter_int_gt bal_inter_int

2522: --Enhancement 7520196 Start
2523: -- Update the Payable and receivable BSV with the minimum unbalanced bsv
2524: -- for each of the transacting Legal Entity.
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

Line 2550: Update fun_bal_inter_int_gt bal_inter_int

2546: and min_bsv.group_id = bal_inter_int.group_id
2547: and bal_inter_int.status = 'OK')
2548: where REC_BSV IS NULL;
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

Line 2577: Update fun_bal_inter_int_gt bal_inter_int

2573:
2574: -- Switch the Intercompany and Balancing segment value for the
2575: -- Payables and Receivables accounts. And update the table with
2576: -- the new account numbers.
2577: Update fun_bal_inter_int_gt bal_inter_int
2578: Set (REC_ACCT, PAY_ACCT) =
2579: (select get_ccid (bal_inter_int.REC_ACCT,
2580: hdrs.CHART_OF_ACCOUNTS_ID,
2581: bal_inter_int.REC_BSV,

Line 2623: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

2619: DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), 'R',
2620: get_ccid_concat_disp(DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), hdrs.chart_of_accounts_id,
2621: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv, bal_seg_column_number, intercompany_column_number),
2622: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
2623: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
2624: WHERE inter_int.group_id = hdrs.group_id AND
2625: ((inter_int.intercompany_mode = 1 AND
2626: inter_int.type = 'C')
2627: OR

Line 2672: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

2668: DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), 'P',
2669: get_ccid_concat_disp(DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), hdrs.chart_of_accounts_id,
2670: inter_int.driving_cr_le_bsv, inter_int.driving_dr_le_bsv, bal_seg_column_number, intercompany_column_number),
2671: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
2672: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
2673: WHERE inter_int.group_id = hdrs.group_id AND
2674: ((inter_int.intercompany_mode = 1 AND
2675: inter_int.type = 'D')
2676: OR

Line 2715: DELETE FROM fun_bal_inter_int_gt inter_int

2711: 'FUN_INTER_PAY_NOT_VALID',
2712: 'FUN_INTER_REC_NOT_VALID'))
2713: AND headers.status = 'OK';
2714:
2715: DELETE FROM fun_bal_inter_int_gt inter_int
2716: WHERE EXISTS (SELECT group_id
2717: FROM fun_bal_headers_gt headers
2718: WHERE headers.status = 'ERROR'
2719: AND inter_int.group_id = headers.group_id);

Line 2766: FROM FUN_BAL_INTER_INT_GT BAL_INTER_INT

2762: SYSDATE,
2763: fnd_global.login_id,
2764: BAL_INTER_INT.REC_BSV,
2765: BAL_INTER_INT.PAY_BSV
2766: FROM FUN_BAL_INTER_INT_GT BAL_INTER_INT
2767: WHERE BAL_INTER_INT.STATUS = 'OK'
2768: AND BAL_INTER_INT.REC_ACCT IS NOT NULL
2769: AND BAL_INTER_INT.PAY_BSV IS NOT NULL
2770: AND BAL_INTER_INT.REC_BSV IS NOT NULL

Line 2834: FROM FUN_BAL_INTER_INT_GT BAL_INTER_INT

2830: SYSDATE,
2831: fnd_global.login_id,
2832: BAL_INTER_INT.PAY_BSV,
2833: BAL_INTER_INT.REC_BSV
2834: FROM FUN_BAL_INTER_INT_GT BAL_INTER_INT
2835: WHERE BAL_INTER_INT.STATUS = 'OK'
2836: AND BAL_INTER_INT.PAY_ACCT IS NOT NULL
2837: AND BAL_INTER_INT.PAY_BSV IS NOT NULL
2838: AND BAL_INTER_INT.REC_BSV IS NOT NULL

Line 2890: FROM fun_bal_inter_int_gt sum_lines, fun_bal_generate_lines gen

2886: 'D', sum_lines.accounted_amt_dr),
2887: NULL),
2888: DECODE(gen.value, 'C', sum_lines.pay_acct, 'D', sum_lines.rec_acct, NULL),
2889: 'Y'
2890: FROM fun_bal_inter_int_gt sum_lines, fun_bal_generate_lines gen
2891: WHERE gen.value = DECODE(sum_lines.intercompany_mode,
2892: 1, DECODE(sum_lines.type, gen.value, 'X', gen.value),
2893: 2, DECODE(sum_lines.le_id, sum_lines.driving_dr_le_id, 'X', gen.value),
2894: 3, DECODE(sum_lines.le_id, sum_lines.driving_cr_le_id, 'X', gen.value),