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_SF133_NOYEAR dependencies on FV_SF133_DEFINITIONS_LINES

Line 64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;

60: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
61:
62: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
63: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
68: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;

Line 65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;

61:
62: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
63: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
68: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
69: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;

Line 66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;

62: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
63: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
68: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
69: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;
70:

Line 67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;

63: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
68: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
69: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;
70:
71: -- New variable declared by pkpatel to fix Bug 1575992

Line 68: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;

64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
68: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
69: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;
70:
71: -- New variable declared by pkpatel to fix Bug 1575992
72: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

Line 69: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;

65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
68: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
69: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;
70:
71: -- New variable declared by pkpatel to fix Bug 1575992
72: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
73: --

Line 75: c_sf133_report_line_number fv_sf133_definitions_lines.

71: -- New variable declared by pkpatel to fix Bug 1575992
72: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
73: --
74: -- New variable declared by Narsimha.
75: c_sf133_report_line_number fv_sf133_definitions_lines.
76: sf133_report_line_number%TYPE;
77:
78: -- ---------- Balance Type Cursor Vaiables ---------
79: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;

Line 171: FROM fv_sf133_definitions_lines line,

167: line.sf133_line_type_code sf133_line_type_code,
168: line.sf133_natural_balance_type sf133_natural_balance_type,
169: line.sf133_fund_category sf133_line_category,
170: line.sf133_report_line_number sf133_report_line_number
171: FROM fv_sf133_definitions_lines line,
172: FV_TREASURY_SYMBOLS FTS
173: WHERE FTS.SET_OF_BOOKS_ID = LINE.SET_OF_BOOKS_ID
174: AND FTS.Treasury_symbol = parm_treasury_value_r1
175: AND FTS.set_of_books_id = parm_set_of_books_id

Line 662: FROM fv_sf133_definitions_lines

658: FROM fv_sf133_definitions_cols_temp
659: WHERE (sf133_line_id)
660: IN
661: (SELECT sf133_line_id
662: FROM fv_sf133_definitions_lines
663: WHERE set_of_books_id = parm_set_of_books_id);
664: --
665: COMMIT;
666: --

Line 1388: FROM fv_sf133_definitions_lines

1384: AND sf133_fund_value = c_sf133_ts_value
1385: AND (sf133_line_id)
1386: IN
1387: (SELECT sf133_line_id
1388: FROM fv_sf133_definitions_lines
1389: WHERE set_of_books_id = parm_set_of_books_id
1390: AND sf133_line_number >
1391: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
1392: AND sf133_line_number < c_sf133_line_number);

Line 1564: fv_sf133_definitions_lines fsdl

1560: fsda.segment28,
1561: fsda.segment29,
1562: fsda.segment30
1563: FROM fv_sf133_definitions_accts fsda,
1564: fv_sf133_definitions_lines fsdl
1565: WHERE fsdl.sf133_line_id = fsda.sf133_line_id
1566: AND fsdl.set_of_books_id=p_sobid
1567:
1568: ORDER BY 2,1;

Line 1889: FROM fv_sf133_definitions_lines

1885:
1886: -- Bug 9191098
1887: CURSOR fv_cfs_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER) IS
1888: SELECT sf133_line_id
1889: FROM fv_sf133_definitions_lines
1890: WHERE sf133_line_number >=
1891: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
1892: WHERE sf133_line_id = p_lineid_1 )
1893: AND sf133_line_number <=

Line 1891: (SELECT sf133_line_number FROM fv_sf133_definitions_lines

1887: CURSOR fv_cfs_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER) IS
1888: SELECT sf133_line_id
1889: FROM fv_sf133_definitions_lines
1890: WHERE sf133_line_number >=
1891: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
1892: WHERE sf133_line_id = p_lineid_1 )
1893: AND sf133_line_number <=
1894: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
1895: WHERE sf133_line_id = p_lineid_2 );

Line 1894: (SELECT sf133_line_number FROM fv_sf133_definitions_lines

1890: WHERE sf133_line_number >=
1891: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
1892: WHERE sf133_line_id = p_lineid_1 )
1893: AND sf133_line_number <=
1894: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
1895: WHERE sf133_line_id = p_lineid_2 );
1896:
1897: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1898: temp_amt_low fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;