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_GOALS_224 dependencies on FV_ALC_BUSINESS_ACTIVITY_V

Line 158: from fv_alc_business_activity_v fv

154: c_business_activity VARCHAR2,
155: c_gwa_reporter_category VARCHAR2
156: )IS
157: select fv.agency_location_code
158: from fv_alc_business_activity_v fv
159: where set_of_books_id = c_set_of_books_id
160: and period_name = c_gl_period
161: AND c_partial_or_full = 'Partial'
162: and c_alc ='ALL'

Line 177: from fv_alc_business_activity_v fv

173: AND alc_code = fv.agency_location_code
174: AND end_period_date < v_end_date)
175: UNION
176: select agency_location_code
177: from fv_alc_business_activity_v fv
178: where set_of_books_id=c_set_of_books_id
179: and period_name = c_gl_period
180: AND c_partial_or_full = 'Partial'
181: and c_alc ='ALL'

Line 200: from fv_alc_business_activity_v fv

196: AND alc_code = fv.agency_location_code
197: AND end_period_date < v_end_date)
198: UNION
199: select agency_location_code
200: from fv_alc_business_activity_v fv
201: where set_of_books_id=c_set_of_books_id
202: and period_name = c_gl_period
203: AND c_partial_or_full = 'Partial'
204: and c_alc ='ALL'

Line 221: from fv_alc_business_activity_v fv

217: AND alc_code = fv.agency_location_code
218: AND end_period_date < v_end_date)
219: UNION
220: select agency_location_code
221: from fv_alc_business_activity_v fv
222: where set_of_books_id=c_set_of_books_id
223: and period_name = c_gl_period
224: AND c_partial_or_full = 'Partial'
225: and c_alc ='ALL'

Line 242: from fv_alc_business_activity_v fab

238: AND alc_code = fv.agency_location_code
239: AND end_period_date < v_end_date)
240: UNION
241: select distinct fab.agency_location_code
242: from fv_alc_business_activity_v fab
243: where fab.set_of_books_id=c_set_of_books_id
244: AND c_partial_or_full = 'Full'
245: and c_alc ='ALL'
246: and fab.agency_location_code not in (select agency_location_code

Line 247: from fv_alc_business_activity_v fab1

243: where fab.set_of_books_id=c_set_of_books_id
244: AND c_partial_or_full = 'Full'
245: and c_alc ='ALL'
246: and fab.agency_location_code not in (select agency_location_code
247: from fv_alc_business_activity_v fab1
248: where fab1.period_name =c_gl_period)
249: AND NOT EXISTS(SELECT DISTINCT c.alc_code
250: FROM fv_sf224_temp c
251: WHERE c.set_of_books_id = c_set_of_books_id