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

Line 72: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;

68: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
69: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
70: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
71: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
72: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
73: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
74: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
75: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
76: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;

Line 73: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;

69: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
70: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
71: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
72: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
73: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
74: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
75: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
76: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
77: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;

Line 74: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;

70: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
71: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
72: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
73: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
74: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
75: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
76: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
77: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;
78:

Line 75: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;

71: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
72: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
73: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
74: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
75: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
76: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
77: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;
78:
79: -- New variable declared by pkpatel to fix Bug 1575992

Line 76: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;

72: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
73: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
74: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
75: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
76: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
77: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;
78:
79: -- New variable declared by pkpatel to fix Bug 1575992
80: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

Line 77: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;

73: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
74: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
75: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
76: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
77: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;
78:
79: -- New variable declared by pkpatel to fix Bug 1575992
80: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
81: --sf133 begin

Line 146: c_sf133_report_line_number fv_sf133_definitions_lines.sf133_report_line_number%TYPE;

142: l_federal_acct_symbol_id number(15);
143:
144: -- new variabla declared by Narsimha.
145:
146: c_sf133_report_line_number fv_sf133_definitions_lines.sf133_report_line_number%TYPE;
147: --
148: -- ---------- Balance Type Cursor Vaiables ---------
149: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;
150: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;

Line 237: FROM fv_sf133_definitions_lines line,

233: line.sf133_line_type_code sf133_line_type_code,
234: line.sf133_natural_balance_type sf133_natural_balance_type,
235: line.sf133_fund_category sf133_line_category,
236: line.sf133_report_line_number sf133_report_line_number
237: FROM fv_sf133_definitions_lines line,
238: FV_TREASURY_SYMBOLS FTS
239: WHERE FTS.Treasury_symbol = parm_treasury_value_r1
240: AND FTS.set_of_books_id = parm_set_of_books_id
241: AND (line.sf133_line_type_code) IN ('T', 'D', 'D2')

Line 759: FROM fv_sf133_definitions_lines

755: FROM fv_sf133_definitions_cols_temp
756: WHERE (sf133_line_id)
757: IN
758: (SELECT sf133_line_id
759: FROM fv_sf133_definitions_lines
760: WHERE set_of_books_id = parm_set_of_books_id);
761: --
762: COMMIT;
763: --

Line 1674: FROM fv_sf133_definitions_lines

1670: AND sf133_fund_value = c_sf133_ts_value
1671: AND (sf133_line_id)
1672: IN
1673: (SELECT sf133_line_id
1674: FROM fv_sf133_definitions_lines
1675: WHERE set_of_books_id = parm_set_of_books_id
1676: AND sf133_line_number >
1677: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
1678: AND sf133_line_number < c_sf133_line_number);

Line 1957: fv_sf133_definitions_lines fsdl

1953: fsda.segment28,
1954: fsda.segment29,
1955: fsda.segment30
1956: FROM fv_sf133_definitions_accts fsda,
1957: fv_sf133_definitions_lines fsdl
1958: WHERE fsdl.sf133_line_id = fsda.sf133_line_id
1959: AND fsdl.set_of_books_id=p_sobid
1960: ORDER BY 2,1;
1961:

Line 2275: FROM fv_sf133_definitions_lines

2271:
2272: -- Bug 9183877
2273: CURSOR fv_cfs_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER) IS
2274: SELECT sf133_line_id
2275: FROM fv_sf133_definitions_lines
2276: WHERE sf133_line_number >=
2277: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
2278: WHERE sf133_line_id = p_lineid_1 )
2279: AND sf133_line_number <=

Line 2277: (SELECT sf133_line_number FROM fv_sf133_definitions_lines

2273: CURSOR fv_cfs_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER) IS
2274: SELECT sf133_line_id
2275: FROM fv_sf133_definitions_lines
2276: WHERE sf133_line_number >=
2277: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
2278: WHERE sf133_line_id = p_lineid_1 )
2279: AND sf133_line_number <=
2280: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
2281: WHERE sf133_line_id = p_lineid_2 );

Line 2280: (SELECT sf133_line_number FROM fv_sf133_definitions_lines

2276: WHERE sf133_line_number >=
2277: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
2278: WHERE sf133_line_id = p_lineid_1 )
2279: AND sf133_line_number <=
2280: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
2281: WHERE sf133_line_id = p_lineid_2 );
2282:
2283: l_line_id fv_cfs_rep_lines.line_id%TYPE;
2284: temp_amt_low fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;