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:

Line 84: c_sf133_report_line_number fv_sf133_definitions_lines.sf133_report_line_number%TYPE;

80: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
81:
82: -- new variabla declared by Narsimha.
83:
84: c_sf133_report_line_number fv_sf133_definitions_lines.sf133_report_line_number%TYPE;
85: --
86: -- ---------- Balance Type Cursor Vaiables ---------
87: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;
88: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;

Line 155: FROM fv_sf133_definitions_lines line,

151: line.sf133_natural_balance_type sf133_natural_balance_type,
152: line.sf133_fund_category sf133_line_category,
153: line.sf133_report_line_number sf133_report_line_number
154:
155: FROM fv_sf133_definitions_lines line,
156: FV_TREASURY_SYMBOLS FTS
157: WHERE FTS.Treasury_symbol = parm_treasury_value_r1
158: AND FTS.set_of_books_id = parm_set_of_books_id
159: AND (line.sf133_line_type_code) IN ('T', 'D', 'S', 'N')

Line 588: FROM fv_sf133_definitions_lines

584: FROM fv_sf133_definitions_cols_temp
585: WHERE (sf133_line_id)
586: IN
587: (SELECT sf133_line_id
588: FROM fv_sf133_definitions_lines
589: WHERE set_of_books_id = parm_set_of_books_id);
590: --
591: COMMIT;
592: --

Line 1189: FROM fv_sf133_definitions_lines

1185: AND sf133_fund_value = c_sf133_ts_value
1186: AND (sf133_line_id)
1187: IN
1188: (SELECT sf133_line_id
1189: FROM fv_sf133_definitions_lines
1190: WHERE set_of_books_id = parm_set_of_books_id
1191: AND sf133_line_number >
1192: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
1193: AND sf133_line_number < c_sf133_line_number);

Line 1459: fv_sf133_definitions_lines fsdl

1455: fsda.segment28,
1456: fsda.segment29,
1457: fsda.segment30
1458: FROM fv_sf133_definitions_accts fsda,
1459: fv_sf133_definitions_lines fsdl
1460: WHERE fsdl.sf133_line_id = fsda.sf133_line_id
1461: AND fsdl.set_of_books_id=p_sobid
1462: ORDER BY 2,1;
1463: