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_FACTS2_DERIVE_BALANCES dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 138: --* : fv_facts_ussgl_accounts SELECT *--

134: --* : fv_utility.log_mesg *--
135: --* Tables Used : fnd_flex_value_hierarchies SELECT *--
136: --* : fnd_flex_values_vl SELECT *--
137: --* : fv_facts_attributes SELECT *--
138: --* : fv_facts_ussgl_accounts SELECT *--
139: --* : fv_factsii_accounts_gt INSERT *--
140: --* Logic : 1. Get all the FACTSII accounts from table fv_facts_ussgl_accounts *--
141: --* : and select only those accounts from table fv_facts_attributes *--
142: --* : where the following attributes are set to Y. public_law_code, *--

Line 140: --* Logic : 1. Get all the FACTSII accounts from table fv_facts_ussgl_accounts *--

136: --* : fnd_flex_values_vl SELECT *--
137: --* : fv_facts_attributes SELECT *--
138: --* : fv_facts_ussgl_accounts SELECT *--
139: --* : fv_factsii_accounts_gt INSERT *--
140: --* Logic : 1. Get all the FACTSII accounts from table fv_facts_ussgl_accounts *--
141: --* : and select only those accounts from table fv_facts_attributes *--
142: --* : where the following attributes are set to Y. public_law_code, *--
143: --* : advance_flag and transfer_flag *--
144: --* : 2. Insert that account into table fv_factsii_accounts_gt *--

Line 205: fv_facts_ussgl_accounts fsgl

201: fa.public_law_code,
202: fa.advance_flag,
203: fa.transfer_flag
204: FROM fv_facts_attributes fa,
205: fv_facts_ussgl_accounts fsgl
206: WHERE fa.set_of_books_id = p_ledger_id
207: AND fsgl.reporting_type in (2,3)
208: AND fsgl.ussgl_account = fa.ussgl_acct_number
209: AND (fa.public_law_code = 'Y' OR