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_FACTS_TRANSACTIONS dependencies on FV_TREASURY_SYMBOLS

Line 13: vp_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE ;

9: vp_retcode NUMBER ;
10: vp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE ;
11: vp_report_fiscal_yr NUMBER(4) ;
12: vp_report_qtr NUMBER(1) ;
13: vp_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE ;
14: vp_run_mode VARCHAR2(1) ;
15: vp_currency_code VARCHAR2(15) ;
16: vp_contact_fname VARCHAR2(20) ;
17: vp_contact_lname VARCHAR2(30) ;

Line 86: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;

82: -- ========================================================================
83: v_period_num gl_period_statuses.period_num%TYPE ;
84: --v_debug varchar2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
85: v_year_gtn2001 BOOLEAN ;
86: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
87: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;
88: v_acc_val_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
89: v_bal_seg_name VARCHAR2(20);
90: v_acc_seg_name VARCHAR2(20);

Line 92: v_time_frame fv_treasury_symbols.time_frame%TYPE ;

88: v_acc_val_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
89: v_bal_seg_name VARCHAR2(20);
90: v_acc_seg_name VARCHAR2(20);
91: v_fyr_segment_name VARCHAR2(20);
92: v_time_frame fv_treasury_symbols.time_frame%TYPE ;
93:
94: -- CGAC: Report financing_account from fv_treasury_symbols
95: v_financing_acct fv_treasury_symbols.financing_account%TYPE ;
96: v_cohort_seg_name VARCHAR2(20) ;

Line 94: -- CGAC: Report financing_account from fv_treasury_symbols

90: v_acc_seg_name VARCHAR2(20);
91: v_fyr_segment_name VARCHAR2(20);
92: v_time_frame fv_treasury_symbols.time_frame%TYPE ;
93:
94: -- CGAC: Report financing_account from fv_treasury_symbols
95: v_financing_acct fv_treasury_symbols.financing_account%TYPE ;
96: v_cohort_seg_name VARCHAR2(20) ;
97: v_period_name gl_period_statuses.period_name%TYPE ;
98: v_period_start_dt DATE ;

Line 95: v_financing_acct fv_treasury_symbols.financing_account%TYPE ;

91: v_fyr_segment_name VARCHAR2(20);
92: v_time_frame fv_treasury_symbols.time_frame%TYPE ;
93:
94: -- CGAC: Report financing_account from fv_treasury_symbols
95: v_financing_acct fv_treasury_symbols.financing_account%TYPE ;
96: v_cohort_seg_name VARCHAR2(20) ;
97: v_period_name gl_period_statuses.period_name%TYPE ;
98: v_period_start_dt DATE ;
99: v_period_end_dt DATE ;

Line 270: fv_treasury_symbols.Treasury_Symbol,

266: CURSOR facts_record IS
267: SELECT fv_facts_submission.rowid,
268: fv_facts_submission.Set_Of_Books_Id ,
269: fv_facts_submission.Run_Mode,
270: fv_treasury_symbols.Treasury_Symbol,
271: fv_facts_submission.rep_fyr ,
272: fv_facts_submission.rep_period_num,
273: fv_facts_submission.first_name,
274: fv_facts_submission.last_name,

Line 293: fv_treasury_symbols

289: fv_facts_submission.zip ,
290: fv_facts_submission.currency_code,
291: fv_facts_submission.treasury_symbol_id
292: FROM fv_facts_submission ,
293: fv_treasury_symbols
294: WHERE submit_flag = 'Y'
295: AND fv_treasury_symbols.set_of_books_id = sob
296: AND fv_facts_submission.set_of_books_id = sob
297: AND fv_facts_submission.treasury_symbol_id =

Line 295: AND fv_treasury_symbols.set_of_books_id = sob

291: fv_facts_submission.treasury_symbol_id
292: FROM fv_facts_submission ,
293: fv_treasury_symbols
294: WHERE submit_flag = 'Y'
295: AND fv_treasury_symbols.set_of_books_id = sob
296: AND fv_facts_submission.set_of_books_id = sob
297: AND fv_facts_submission.treasury_symbol_id =
298: fv_treasury_symbols.treasury_symbol_id
299: AND (fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'II' OR

Line 298: fv_treasury_symbols.treasury_symbol_id

294: WHERE submit_flag = 'Y'
295: AND fv_treasury_symbols.set_of_books_id = sob
296: AND fv_facts_submission.set_of_books_id = sob
297: AND fv_facts_submission.treasury_symbol_id =
298: fv_treasury_symbols.treasury_symbol_id
299: AND (fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'II' OR
300: fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'I and II');
301:
302:

Line 299: AND (fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'II' OR

295: AND fv_treasury_symbols.set_of_books_id = sob
296: AND fv_facts_submission.set_of_books_id = sob
297: AND fv_facts_submission.treasury_symbol_id =
298: fv_treasury_symbols.treasury_symbol_id
299: AND (fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'II' OR
300: fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'I and II');
301:
302:
303: BEGIN

Line 300: fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'I and II');

296: AND fv_facts_submission.set_of_books_id = sob
297: AND fv_facts_submission.treasury_symbol_id =
298: fv_treasury_symbols.treasury_symbol_id
299: AND (fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'II' OR
300: fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'I and II');
301:
302:
303: BEGIN
304: retcode := 0;

Line 755: FROM fv_treasury_symbols

751:
752: -- CGAC: Report only those treasury symbols whose FACTS_REPORTABLE_INDICATOR is I or II or both
753: SELECT treasury_symbol_id
754: INTO v_treasury_symbol_id
755: FROM fv_treasury_symbols
756: WHERE treasury_symbol = vp_treasury_symbol
757: AND set_of_books_id = vp_set_of_books_id
758: AND (FACTS_REPORTABLE_INDICATOR like 'II' or FACTS_REPORTABLE_INDICATOR like 'I and II');
759:

Line 957: fv_treasury_symbols fts,

953: vl_years_available,
954: vc_dept_transfer
955: FROM
956: fv_facts_federal_accounts fffa,
957: fv_treasury_symbols fts,
958: fv_pya_fiscalyear_segment fpfs
959: WHERE fffa.federal_acct_symbol_id = fts.federal_acct_symbol_id
960: AND fts.treasury_symbol = vp_treasury_symbol
961: AND fts.set_of_books_id = vp_set_of_books_id

Line 1234: (p_tsymbol_id fv_treasury_symbols.treasury_symbol_id%TYPE)

1230: das_id NUMBER;
1231: das_where VARCHAR2(600);
1232:
1233: CURSOR footnote_select
1234: (p_tsymbol_id fv_treasury_symbols.treasury_symbol_id%TYPE)
1235: IS
1236: SELECT treasury_symbol_id,
1237: sgl_acct_number
1238: FROM fv_facts_temp

Line 1288: FV_TREASURY_SYMBOLS FTS

1284: v_cohort_select ||
1285: ' FROM GL_BALANCES GLB,
1286: GL_CODE_COMBINATIONS GLCC,
1287: FV_FUND_PARAMETERS FFP,
1288: FV_TREASURY_SYMBOLS FTS
1289: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1290: AND GLB.code_combination_id = GLCC.code_combination_id
1291: AND glb.actual_flag = :actual_flag
1292: AND FTS.TREASURY_SYMBOL_ID = FFP.TREASURY_SYMBOL_ID

Line 1325: FV_TREASURY_SYMBOLS FTS

1321: glb.period_net_dr - glb.period_net_cr,0)) end_amount
1322: FROM GL_BALANCES GLB,
1323: GL_CODE_COMBINATIONS GLCC,
1324: FV_FUND_PARAMETERS FFP,
1325: FV_TREASURY_SYMBOLS FTS
1326: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1327: AND FTS.SET_OF_BOOKS_ID = :set_of_books_id
1328: AND FFP.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
1329: AND FFP.SET_OF_BOOKS_ID = :set_of_books_id

Line 3863: FROM fv_treasury_symbols fts,

3859: INTO vl_resource_type,
3860: va_def_indef_val,
3861: vl_fund_category,
3862: va_reimburseable_val
3863: FROM fv_treasury_symbols fts,
3864: fv_fund_parameters ffp
3865: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
3866: AND ffp.fund_value = fund_val
3867: AND fts.treasury_symbol = vp_treasury_symbol

Line 4008: fv_treasury_symbols fts ,

4004:
4005: /*
4006: FROM fv_facts_budget_accounts ffba,
4007: fv_facts_federal_accounts fffa,
4008: fv_treasury_symbols fts ,
4009: fv_facts_bud_fed_accts ffbfa
4010: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
4011: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
4012: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id

Line 4055: fv_treasury_symbols fts ,

4051: SELECT RPAD(substr(ffba.budget_function,1,3), 3)
4052: INTO va_budget_function
4053: FROM fv_facts_budget_accounts ffba,
4054: fv_facts_federal_accounts fffa,
4055: fv_treasury_symbols fts ,
4056: fv_facts_bud_fed_accts ffbfa
4057: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
4058: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
4059: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id

Line 4103: fv_treasury_symbols fts

4099:
4100: SELECT RPAD(substr(ffp.borrowing_source_code,1,5), 5)
4101: INTO va_borrowing_source_val
4102: FROM fv_fund_parameters ffp,
4103: fv_treasury_symbols fts
4104: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
4105: AND fts.treasury_symbol = vp_treasury_symbol
4106: AND fts.set_of_books_id = vp_set_of_books_id
4107: AND ffp.set_of_books_id = vp_set_of_books_id