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.FV_CFS_PKG dependencies on FV_SBR_DEFINITIONS_LINES

Line 142: c_sbr_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;

138: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
139: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
140: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
141: c_sbr_ts_value gl_code_combinations.segment1%TYPE;
142: c_sbr_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
143: c_sbr_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
144: c_sbr_prev_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
145: c_sbr_line_type_code fv_sbr_definitions_lines.sbr_line_type_code%TYPE;
146: c_sbr_natural_bal_type fv_sbr_definitions_lines.sbr_natural_balance_type%TYPE;

Line 143: c_sbr_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;

139: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
140: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
141: c_sbr_ts_value gl_code_combinations.segment1%TYPE;
142: c_sbr_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
143: c_sbr_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
144: c_sbr_prev_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
145: c_sbr_line_type_code fv_sbr_definitions_lines.sbr_line_type_code%TYPE;
146: c_sbr_natural_bal_type fv_sbr_definitions_lines.sbr_natural_balance_type%TYPE;
147: c_sbr_line_category fv_sbr_definitions_lines.sbr_fund_category%TYPE;

Line 144: c_sbr_prev_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;

140: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
141: c_sbr_ts_value gl_code_combinations.segment1%TYPE;
142: c_sbr_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
143: c_sbr_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
144: c_sbr_prev_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
145: c_sbr_line_type_code fv_sbr_definitions_lines.sbr_line_type_code%TYPE;
146: c_sbr_natural_bal_type fv_sbr_definitions_lines.sbr_natural_balance_type%TYPE;
147: c_sbr_line_category fv_sbr_definitions_lines.sbr_fund_category%TYPE;
148: -- New variable declared by pkpatel to fix Bug 1575992

Line 145: c_sbr_line_type_code fv_sbr_definitions_lines.sbr_line_type_code%TYPE;

141: c_sbr_ts_value gl_code_combinations.segment1%TYPE;
142: c_sbr_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
143: c_sbr_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
144: c_sbr_prev_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
145: c_sbr_line_type_code fv_sbr_definitions_lines.sbr_line_type_code%TYPE;
146: c_sbr_natural_bal_type fv_sbr_definitions_lines.sbr_natural_balance_type%TYPE;
147: c_sbr_line_category fv_sbr_definitions_lines.sbr_fund_category%TYPE;
148: -- New variable declared by pkpatel to fix Bug 1575992
149: c_sbr_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

Line 146: c_sbr_natural_bal_type fv_sbr_definitions_lines.sbr_natural_balance_type%TYPE;

142: c_sbr_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
143: c_sbr_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
144: c_sbr_prev_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
145: c_sbr_line_type_code fv_sbr_definitions_lines.sbr_line_type_code%TYPE;
146: c_sbr_natural_bal_type fv_sbr_definitions_lines.sbr_natural_balance_type%TYPE;
147: c_sbr_line_category fv_sbr_definitions_lines.sbr_fund_category%TYPE;
148: -- New variable declared by pkpatel to fix Bug 1575992
149: c_sbr_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
150: --

Line 147: c_sbr_line_category fv_sbr_definitions_lines.sbr_fund_category%TYPE;

143: c_sbr_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
144: c_sbr_prev_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
145: c_sbr_line_type_code fv_sbr_definitions_lines.sbr_line_type_code%TYPE;
146: c_sbr_natural_bal_type fv_sbr_definitions_lines.sbr_natural_balance_type%TYPE;
147: c_sbr_line_category fv_sbr_definitions_lines.sbr_fund_category%TYPE;
148: -- New variable declared by pkpatel to fix Bug 1575992
149: c_sbr_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
150: --
151: -- New variable declared by Narsimha.

Line 152: c_sbr_report_line_number fv_sbr_definitions_lines.sbr_report_line_number%TYPE;

148: -- New variable declared by pkpatel to fix Bug 1575992
149: c_sbr_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
150: --
151: -- New variable declared by Narsimha.
152: c_sbr_report_line_number fv_sbr_definitions_lines.sbr_report_line_number%TYPE;
153: c_sbr_gl_balance fv_sbr_definitions_lines.SBR_GL_BALANCE%TYPE;
154:
155: -- ---------- Balance Type Cursor Vaiables ---------
156: c_sbr_line_acct_id fv_sbr_definitions_accts.sbr_line_acct_id%TYPE;

Line 153: c_sbr_gl_balance fv_sbr_definitions_lines.SBR_GL_BALANCE%TYPE;

149: c_sbr_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
150: --
151: -- New variable declared by Narsimha.
152: c_sbr_report_line_number fv_sbr_definitions_lines.sbr_report_line_number%TYPE;
153: c_sbr_gl_balance fv_sbr_definitions_lines.SBR_GL_BALANCE%TYPE;
154:
155: -- ---------- Balance Type Cursor Vaiables ---------
156: c_sbr_line_acct_id fv_sbr_definitions_accts.sbr_line_acct_id%TYPE;
157: c_sbr_balance_type fv_sbr_definitions_accts.sbr_balance_type%TYPE;

Line 241: FROM fv_sbr_definitions_lines line

237: line.sbr_fund_category sbr_line_category ,
238: line.sbr_report_line_number sbr_report_line_number ,
239: line.sbr_line_label sbr_line_label ,
240: line.sbr_gl_balance sbr_gl_balance
241: FROM fv_sbr_definitions_lines line
242: WHERE line.set_of_books_id = v_sob
243: AND (line.sbr_line_type_code) IN ('T', 'D', 'D2', 'S') -- To handle subtotals
244: ORDER BY line.sbr_line_number;
245: --

Line 407: FROM fv_sbr_definitions_lines

403: IF UPPER(v_report_type)='SBR' THEN
404:
405: -- Check whether the SBR setup is done or not
406: SELECT count(*) into l_count
407: FROM fv_sbr_definitions_lines
408: WHERE set_of_books_id = p_set_of_books_id;
409:
410: SELECT count(*) into l_count_acct
411: FROM fv_sbr_definitions_accts

Line 732: fv_sbr_definitions_lines l

728: segment28 ,
729: segment29 ,
730: segment30
731: FROM fv_sbr_definitions_accts d,
732: fv_sbr_definitions_lines l
733: WHERE d.sbr_line_id = l.sbr_line_id
734: AND l.set_of_books_id = v_sob
735: ORDER BY 2;
736:

Line 2173: FROM fv_sbr_definitions_lines

2169: -- Bug 9191098
2170: CURSOR fv_sbr_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER)
2171: IS
2172: SELECT sbr_line_id
2173: FROM fv_sbr_definitions_lines
2174: WHERE sbr_line_number >=
2175: (SELECT sbr_line_number
2176: FROM fv_sbr_definitions_lines
2177: WHERE sbr_line_id = p_lineid_1

Line 2176: FROM fv_sbr_definitions_lines

2172: SELECT sbr_line_id
2173: FROM fv_sbr_definitions_lines
2174: WHERE sbr_line_number >=
2175: (SELECT sbr_line_number
2176: FROM fv_sbr_definitions_lines
2177: WHERE sbr_line_id = p_lineid_1
2178: )
2179: AND sbr_line_number <=
2180: (SELECT sbr_line_number

Line 2181: FROM fv_sbr_definitions_lines

2177: WHERE sbr_line_id = p_lineid_1
2178: )
2179: AND sbr_line_number <=
2180: (SELECT sbr_line_number
2181: FROM fv_sbr_definitions_lines
2182: WHERE sbr_line_id = p_lineid_2
2183: );
2184:
2185: l_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;

Line 2185: l_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;

2181: FROM fv_sbr_definitions_lines
2182: WHERE sbr_line_id = p_lineid_2
2183: );
2184:
2185: l_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
2186: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2187: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2188: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2189: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 2770: FROM fv_sbr_definitions_lines line

2766: v_period_fiscal_year,
2767: v_period_num ,
2768: v_report_type,
2769: v_sob
2770: FROM fv_sbr_definitions_lines line
2771: WHERE line.set_of_books_id = v_sob
2772: AND line.sbr_line_type_code IN ('L','F')
2773: ORDER BY line.sbr_line_number;
2774:

Line 3552: FROM fv_sbr_definitions_lines

3548: DELETE
3549: FROM fv_cfs_rep_temp
3550: WHERE (line_id) IN
3551: (SELECT sbr_line_id
3552: FROM fv_sbr_definitions_lines
3553: WHERE set_of_books_id = v_sob
3554: )
3555: and upper(reporty_type) <> 'SBR';
3556: --

Line 3609: fv_sbr_definitions_lines fsdl ,

3605: ' SELECT SUM(NVL(DECODE(:cv_balance_type,
3606: ''B'', ROUND(NVL(fctbal.begin_balance,0),2),
3607: ''E'', ROUND(NVL(fctbal.balance_amount,0))),0) )
3608: FROM fv_sbr_definitions_accts dets,
3609: fv_sbr_definitions_lines fsdl ,
3610: fv_sbr_ccids_gt fvcc,
3611: fv_facts1_period_attributes fctbal
3612: WHERE dets.sbr_line_id = :cv_line_id
3613: AND fsdl.sbr_line_id=dets.sbr_line_id

Line 3690: fv_sbr_definitions_lines fsdl ,

3686: NVL(glbal.begin_balance_cr,0)) +
3687: (NVL(glbal.period_net_dr,0) -
3688: NVL(glbal.period_net_cr,0))),0),2)),0)
3689: FROM fv_sbr_definitions_accts dets,
3690: fv_sbr_definitions_lines fsdl ,
3691: gl_code_combinations glc,
3692: gl_code_combinations glc1,
3693: gl_balances glbal
3694: WHERE dets.sbr_line_id = :cv_line_id