ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN FB01236EB0B976E2E05362FB09054D94Y select 1 from dual where 1=1 US EAA ABM Category to GL Account Imported from Concurrent Program Application: SEM Exchange (Obsolete) Source: ABM Category to GL Account Report Short Name: EAACATAC Concurrent Program 1=1 1 10 :rulesetid LOV Oracle EAA_SRS_RULESET_ID Y select ruleset_id id, name value, description description from eaa_rulesets_v where end_effective_date is null order by name asc Y US Rule Set Rule Set Identifier 2 20 :glfromdate LOV Oracle EAA_SRS_GL_PERIOD_FROM_DATE Y Y select gl.start_date id, gl.start_date value, null description from eaa_gl_periods_v gl,eaa_rulesets_v r where gl.set_of_books_id=r.set_of_books_id and r.ruleset_id=:$flex$.eaa_srs_ruleset_id and gl.closing_status in ('C','P') order by gl.start_date Y US GL from Date GL from Date 3 30 :gltodate LOV Oracle EAA_SRS_GL_PERIOD_TO_DATE Y Y select gl.end_date id, gl.end_date value, null description from eaa_gl_periods_v gl,eaa_rulesets_v r where gl.set_of_books_id=r.set_of_books_id and r.ruleset_id=:$flex$.eaa_srs_ruleset_id and trunc(gl.end_date)>=fnd_date.canonical_to_date(:$flex$.eaa_srs_gl_period_from_date) and gl.closing_status in ('C','P') order by gl.end_date US GL to Date GL to Date 4 40 :activapds LOV Oracle EAA_SRS_PERIOD_DATA_SETS Y select pds_id id, pds_id value, null description from eaa_pds_value_set_v order by value,description Y US ABM Data Set ABM Data Set 5 50 :budgetversionid LOV Oracle EAA_SRS_BUDGET_DETAILS Y select bv.budget_version_id id, b.budget_name value, b.description description from gl_budget_versions bv,gl_budgets b,eaa_rulesets_v r where b.set_of_books_id=r.set_of_books_id and r.ruleset_id=:$flex$.eaa_srs_ruleset_id and bv.budget_name=b.budget_name and bv.status='F' and exists (select 'x' from eaa_rulesets rl where rl.ruleset_id=:$flex$.eaa_srs_ruleset_id and rl.balance_type='BUDGET') order by upper(b.budget_name) US Budget Name Budget Name 6 60 :activacategorycode LOV Oracle EAA_SRS_ACTIVA_CATEGORY_CODE Y select eac.activa_category_code id, eac.activa_category_code value, el.meaning description from eaa_lookups el,eaa_activa_categories eac where el.lookup_type='ACTIVA_CATEGORY' and el.lookup_code=eac.activa_category_code order by eac.activa_category_code, el.meaning US ABM Category Code ABM Category Code