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.

[Home] [Help]

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 38: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;

34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
39: v_line_number fv_cfs_rep_lines.line_number%TYPE;
40: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
41: v_period_num gl_period_statuses.period_num%TYPE;
42: v_select1 VARCHAR2(32000);

Line 39: v_line_number fv_cfs_rep_lines.line_number%TYPE;

35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
39: v_line_number fv_cfs_rep_lines.line_number%TYPE;
40: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
41: v_period_num gl_period_statuses.period_num%TYPE;
42: v_select1 VARCHAR2(32000);
43: v_select2 VARCHAR2(32000);

Line 360: fv_cfs_rep_lines L

356: segment21, segment22, segment23, segment24,
357: segment25, segment26, segment27, segment28,
358: segment29, segment30
359: FROM fv_cfs_rep_line_dtl d,
360: fv_cfs_rep_lines L
361: WHERE l.report_type = v_report_type
362: AND d.line_id = l.line_id
363: AND l.set_of_books_id = v_sob
364: ORDER BY 2;

Line 693: FROM fv_cfs_rep_lines

689:
690: CURSOR fv_cfs_lines_cur IS
691: SELECT line_id, line_label, sequence_number,
692: line_number, line_type, natural_balance_type, by_recipient
693: FROM fv_cfs_rep_lines
694: WHERE set_of_books_id = v_sob
695: AND report_type = v_report_type
696: ORDER BY sequence_number;
697:

Line 909: l_temp_str fv_cfs_rep_lines.line_label%TYPE;

905:
906: l_recipient_rec l_recipient_table;
907: l_recipient_cnt BINARY_INTEGER := 1;
908: l_found BOOLEAN;
909: l_temp_str fv_cfs_rep_lines.line_label%TYPE;
910:
911: l_ignore INTEGER;
912: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
913: l_begin_balance NUMBER;

Line 1368: FROM fv_cfs_rep_lines

1364: AND sequence_id = v_sequence_id;
1365:
1366: CURSOR fv_cfs_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER) IS
1367: SELECT line_id
1368: FROM fv_cfs_rep_lines
1369: WHERE sequence_number >=
1370: (SELECT sequence_number FROM fv_cfs_rep_lines
1371: WHERE line_id = p_lineid_1 )
1372: AND sequence_number <=

Line 1370: (SELECT sequence_number FROM fv_cfs_rep_lines

1366: CURSOR fv_cfs_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER) IS
1367: SELECT line_id
1368: FROM fv_cfs_rep_lines
1369: WHERE sequence_number >=
1370: (SELECT sequence_number FROM fv_cfs_rep_lines
1371: WHERE line_id = p_lineid_1 )
1372: AND sequence_number <=
1373: (SELECT sequence_number FROM fv_cfs_rep_lines
1374: WHERE line_id = p_lineid_2 )

Line 1373: (SELECT sequence_number FROM fv_cfs_rep_lines

1369: WHERE sequence_number >=
1370: (SELECT sequence_number FROM fv_cfs_rep_lines
1371: WHERE line_id = p_lineid_1 )
1372: AND sequence_number <=
1373: (SELECT sequence_number FROM fv_cfs_rep_lines
1374: WHERE line_id = p_lineid_2 )
1375: AND report_type = v_report_type;
1376:
1377: l_line_id fv_cfs_rep_lines.line_id%TYPE;

Line 1377: l_line_id fv_cfs_rep_lines.line_id%TYPE;

1373: (SELECT sequence_number FROM fv_cfs_rep_lines
1374: WHERE line_id = p_lineid_2 )
1375: AND report_type = v_report_type;
1376:
1377: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1378: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1379: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1380: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1381: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;