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_LOOKUP_CODES

Line 184: from fv_lookup_codes

180: AND c_partial_or_full = 'Partial'
181: and c_alc ='ALL'
182: and c_business_activity='ALL'
183: and business_activity_code in (select lookup_code
184: from fv_lookup_codes
185: where LOOKUP_TYPE = 'FV_SF224_BUSINESS_ACTIVITY')
186: and c_gwa_reporter_category = 'ALL'
187: and GWA_REPORTER_CATEGORY_CODE in (select lookup_code
188: from fv_lookup_codes

Line 188: from fv_lookup_codes

184: from fv_lookup_codes
185: where LOOKUP_TYPE = 'FV_SF224_BUSINESS_ACTIVITY')
186: and c_gwa_reporter_category = 'ALL'
187: and GWA_REPORTER_CATEGORY_CODE in (select lookup_code
188: from fv_lookup_codes
189: where LOOKUP_TYPE = 'FV_SF224_GWA_REPORTER_CATEGORY' )
190: AND NOT EXISTS(SELECT DISTINCT c.alc_code
191: FROM fv_sf224_temp c
192: WHERE c.set_of_books_id = c_set_of_books_id

Line 207: from fv_lookup_codes

203: AND c_partial_or_full = 'Partial'
204: and c_alc ='ALL'
205: and c_business_activity ='ALL'
206: and business_activity_code in ( select lookup_code
207: from fv_lookup_codes
208: where LOOKUP_TYPE = 'FV_SF224_BUSINESS_ACTIVITY')
209: and c_gwa_reporter_category <> 'ALL'
210: and GWA_REPORTER_CATEGORY_CODE = c_gwa_reporter_category
211: AND NOT EXISTS(SELECT DISTINCT c.alc_code