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_FACTS_FEDERAL_ACCOUNTS

Line 956: fv_facts_federal_accounts fffa,

952: --vc_acct_split_seq_num,
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

Line 4007: fv_facts_federal_accounts fffa,

4003: AND set_of_books_id = vp_set_of_books_id;
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

Line 4054: fv_facts_federal_accounts fffa,

4050: -- CGAC: Consider only those treasury symbols whose FACTS_REPORTABLE_INDICATOR is I or II or both
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