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_CFS_REP_LINES

Line 22: v_line_id fv_cfs_rep_lines.line_id%TYPE;

18: v_bal_seg_name VARCHAR2(20);
19: v_acc_seg_name VARCHAR2(20);
20: v_acct_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
21: v_bal_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
22: v_line_id fv_cfs_rep_lines.line_id%TYPE;
23: v_line_details_id fv_cfs_rep_line_dtl.line_detail_id%TYPE;
24: v_line_type fv_cfs_rep_lines.line_type%TYPE;
25: v_line_label fv_cfs_rep_lines.line_label%TYPE;
26: v_by_recipient fv_cfs_rep_lines.by_recipient%TYPE;

Line 24: v_line_type fv_cfs_rep_lines.line_type%TYPE;

20: v_acct_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
21: v_bal_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
22: v_line_id fv_cfs_rep_lines.line_id%TYPE;
23: v_line_details_id fv_cfs_rep_line_dtl.line_detail_id%TYPE;
24: v_line_type fv_cfs_rep_lines.line_type%TYPE;
25: v_line_label fv_cfs_rep_lines.line_label%TYPE;
26: v_by_recipient fv_cfs_rep_lines.by_recipient%TYPE;
27: v_natural_balance_type fv_cfs_rep_lines.natural_balance_type%TYPE;
28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;

Line 25: v_line_label fv_cfs_rep_lines.line_label%TYPE;

21: v_bal_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
22: v_line_id fv_cfs_rep_lines.line_id%TYPE;
23: v_line_details_id fv_cfs_rep_line_dtl.line_detail_id%TYPE;
24: v_line_type fv_cfs_rep_lines.line_type%TYPE;
25: v_line_label fv_cfs_rep_lines.line_label%TYPE;
26: v_by_recipient fv_cfs_rep_lines.by_recipient%TYPE;
27: v_natural_balance_type fv_cfs_rep_lines.natural_balance_type%TYPE;
28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;
29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;

Line 26: v_by_recipient fv_cfs_rep_lines.by_recipient%TYPE;

22: v_line_id fv_cfs_rep_lines.line_id%TYPE;
23: v_line_details_id fv_cfs_rep_line_dtl.line_detail_id%TYPE;
24: v_line_type fv_cfs_rep_lines.line_type%TYPE;
25: v_line_label fv_cfs_rep_lines.line_label%TYPE;
26: v_by_recipient fv_cfs_rep_lines.by_recipient%TYPE;
27: v_natural_balance_type fv_cfs_rep_lines.natural_balance_type%TYPE;
28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;
29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;
30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;

Line 27: v_natural_balance_type fv_cfs_rep_lines.natural_balance_type%TYPE;

23: v_line_details_id fv_cfs_rep_line_dtl.line_detail_id%TYPE;
24: v_line_type fv_cfs_rep_lines.line_type%TYPE;
25: v_line_label fv_cfs_rep_lines.line_label%TYPE;
26: v_by_recipient fv_cfs_rep_lines.by_recipient%TYPE;
27: v_natural_balance_type fv_cfs_rep_lines.natural_balance_type%TYPE;
28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;
29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;
30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;
31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;

Line 42: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;

38: v_col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE;
39: v_col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE;
40: v_col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE;
41: v_col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE;
42: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
43: v_line_number fv_cfs_rep_lines.line_number%TYPE;
44: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
45: v_period_num gl_period_statuses.period_num%TYPE;
46: v_purge_ts_id fv_treasury_symbols.TREASURY_SYMBOL_ID%TYPE;

Line 43: v_line_number fv_cfs_rep_lines.line_number%TYPE;

39: v_col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE;
40: v_col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE;
41: v_col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE;
42: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
43: v_line_number fv_cfs_rep_lines.line_number%TYPE;
44: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
45: v_period_num gl_period_statuses.period_num%TYPE;
46: v_purge_ts_id fv_treasury_symbols.TREASURY_SYMBOL_ID%TYPE;
47: v_select1 VARCHAR2(32000);

Line 692: fv_cfs_rep_lines L

688: segment28 ,
689: segment29 ,
690: segment30
691: FROM fv_cfs_rep_line_dtl d,
692: fv_cfs_rep_lines L
693: WHERE l.report_type = v_report_type
694: AND d.line_id = l.line_id
695: AND l.set_of_books_id = v_sob
696: ORDER BY 2;

Line 1132: FROM fv_cfs_rep_lines

1128: line_number ,
1129: line_type ,
1130: natural_balance_type,
1131: by_recipient
1132: FROM fv_cfs_rep_lines
1133: WHERE set_of_books_id = v_sob
1134: AND report_type = v_report_type
1135: ORDER BY sequence_number;
1136:

Line 1434: l_temp_str fv_cfs_rep_lines.line_label%TYPE;

1430: TABLE OF l_recipient_rec_type INDEX BY BINARY_INTEGER;
1431: l_recipient_rec l_recipient_table;
1432: l_recipient_cnt BINARY_INTEGER := 1;
1433: l_found BOOLEAN;
1434: l_temp_str fv_cfs_rep_lines.line_label%TYPE;
1435: l_ignore INTEGER;
1436: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
1437: l_begin_balance NUMBER;
1438: l_end_balance NUMBER;

Line 1895: FROM fv_cfs_rep_lines

1891: AND sequence_id = v_sequence_id;
1892: CURSOR fv_cfs_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER)
1893: IS
1894: SELECT line_id
1895: FROM fv_cfs_rep_lines
1896: WHERE sequence_number >=
1897: (SELECT sequence_number FROM fv_cfs_rep_lines WHERE line_id = p_lineid_1
1898: )
1899: AND sequence_number <=

Line 1897: (SELECT sequence_number FROM fv_cfs_rep_lines WHERE line_id = p_lineid_1

1893: IS
1894: SELECT line_id
1895: FROM fv_cfs_rep_lines
1896: WHERE sequence_number >=
1897: (SELECT sequence_number FROM fv_cfs_rep_lines WHERE line_id = p_lineid_1
1898: )
1899: AND sequence_number <=
1900: (SELECT sequence_number FROM fv_cfs_rep_lines WHERE line_id = p_lineid_2
1901: )

Line 1900: (SELECT sequence_number FROM fv_cfs_rep_lines WHERE line_id = p_lineid_2

1896: WHERE sequence_number >=
1897: (SELECT sequence_number FROM fv_cfs_rep_lines WHERE line_id = p_lineid_1
1898: )
1899: AND sequence_number <=
1900: (SELECT sequence_number FROM fv_cfs_rep_lines WHERE line_id = p_lineid_2
1901: )
1902: AND report_type = v_report_type;
1903:
1904: l_line_id fv_cfs_rep_lines.line_id%TYPE;

Line 1904: l_line_id fv_cfs_rep_lines.line_id%TYPE;

1900: (SELECT sequence_number FROM fv_cfs_rep_lines WHERE line_id = p_lineid_2
1901: )
1902: AND report_type = v_report_type;
1903:
1904: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1905: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1906: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1907: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1908: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;