ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 35E2628E80D5D0E7E0630100007F0DC7Y select gp.period_set_name calendar, gps.description calendar_description, xxen_util.yes(gps.security_flag) enable_security, gp.entered_period_name, gpt.user_period_type type, gp.period_year year, gp.quarter_num quarter, gp.period_num, gp.start_date, gp.end_date, gp.period_name, xxen_util.yes(gp.adjustment_period_flag) adjustment_period, xxen_util.meaning((select 'Y' from gl_period_statuses gps where gp.period_type=gps.period_type and gp.period_name=gps.period_name and gps.closing_status in ('O','W','C','P') and rownum=1),'YES_NO',0) used, gpt.number_per_fiscal_year periods_per_year, decode(gpt.year_type_in_name,'C','Calendar','F','Fiscal') year_type, xxen_util.user_name(gp.created_by) created_by, xxen_util.client_time(gp.creation_date) creation_date, xxen_util.user_name(gp.last_updated_by) last_updated_by, xxen_util.client_time(gp.last_update_date) last_update_date, gp.period_type from gl_period_sets gps, gl_periods gp, gl_period_types gpt where 1=1 and gps.period_set_name=gp.period_set_name and gp.period_type=gpt.period_type order by gp.period_set_name, gpt.user_period_type, gp.period_year desc, gp.period_num desc US GL Periods Geleral ledger calendars and accounting periods Enginatics 1=1 1 10 1=1 gp.start_date>=( select min(gp.start_date) from gl_periods gp where gp.period_name=:period_from and gp.period_set_name in ( select gl.period_set_name from gl_ledgers gl where (:ledger is null or gl.name=:ledger) and (:chart_of_accounts is null or gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:chart_of_accounts)) ) ) LOV GL Period (non adjustment) 8E2FF36EDF3F79D2E0530100007F1FF2 Y select distinct gp.period_name value, ( select xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_period_statuses gps where gp.period_name=gps.period_name and gps.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=:$flex$.ledger.value) and gps.application_id=101 ) description, min(gp.start_date) over (partition by gp.period_name) min_start_date from gl_periods gp where gp.adjustment_period_flag='N' and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger.value,gl.name)='Y') and (:$flex$.chart_of_accounts is null or gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y')) ) order by min_start_date desc, gp.period_name US Period From 2 20 1=1 gp.end_date<=( select max(gp.end_date) from gl_periods gp where gp.period_name=:period_to and gp.period_set_name in ( select gl.period_set_name from gl_ledgers gl where (:ledger is null or gl.name=:ledger) and (:chart_of_accounts is null or gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:chart_of_accounts)) )) LOV GL Period (non adjustment) 8E2FF36EDF3F79D2E0530100007F1FF2 Y select distinct gp.period_name value, ( select xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_period_statuses gps where gp.period_name=gps.period_name and gps.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=:$flex$.ledger.value) and gps.application_id=101 ) description, min(gp.start_date) over (partition by gp.period_name) min_start_date from gl_periods gp where gp.adjustment_period_flag='N' and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger.value,gl.name)='Y') and (:$flex$.chart_of_accounts is null or gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y')) ) order by min_start_date desc, gp.period_name US Period To 3 25 1=1 gp.period_set_name=:calendar LOV GL Calendar 35E2628E80D6D0E7E0630100007F0DC7 Y select gps.period_set_name value, gps.description from gl_period_sets gps order by gps.period_set_name US Calendar 4 30 1=1 gp.period_type=:period_type LOV GL Period Type 35E2628E80D7D0E7E0630100007F0DC7 Y select gpt.period_type id, gpt.user_period_type value, gpt.description from gl_period_types gpt order by gpt.user_period_type US Period Type 5 90 1=1 (gp.period_set_name, gp.period_type) in (select gl.period_set_name, gl.accounted_period_type from gl_ledgers gl where gl.ledger_id=:ledger_id) LOV custom Y select gl.ledger_id id, gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name US Ledger 6 100 1=1 (gp.period_set_name, gp.period_type) in (select gl.period_set_name, gl.accounted_period_type from gl_ledgers gl where gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:chart_of_accounts) ) LOV GL Chart of Accounts (inv org related) 8E2FF36EDEC879D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate + 1) > sysdate) order by fifsv.id_flex_structure_name US Chart of Accounts