ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 35E2628E80D6D0E7E0630100007F0DC7 GL Calendar Y select gps.period_set_name value, gps.description from gl_period_sets gps order by gps.period_set_name US 8E2FF36EDEC879D2E0530100007F1FF2 GL Chart of Accounts (inv org related) 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 AR دليل الحسابات المتعلقة بمنظمات المخزون D Kontenplan für Bestandsorganisationen E Plan de cuentas relacionado con las organizaciones de inventario F Plan comptable relatif aux organismes d'inventaire I Piano dei conti relativo alle organizzazioni dell'inventario JA 棚卸し組織に関する勘定科目一覧表 KO 재고 조직과 관련된 계정과 목표 PTB Plano de contas relacionado às organizações de inventário RU План счетов организаций, занимающихся инвентаризацией S Kontoplan relaterade till lagerorganisationer TR Envanter organizasyonları ile ilgili hesap planı US Chart of accounts related to inventory organizations ZHS 与库存组织有关的会计科目表 8E2FF36EDF3F79D2E0530100007F1FF2 GL Period (non adjustment) 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 AR جميع فترات دفتر الأستاذ العام غير القابلة للتعديل ، تعتمد على وحدة التشغيل أو دفتر الأستاذ أو مخطط الحسابات D Alle nicht angepassten GL-Perioden, abhängig von Bedieneinheit, Ledger oder Kontenplan E Todos los periodos GL no ajustados, dependientes de la unidad operativa, el libro mayor o el plan de cuentas F Toutes les périodes de garantie non ajustées, en fonction de l'unité opérationnelle, du grand livre ou du plan comptable I Tutti i periodi GL non rettificati, a seconda dell'unità operativa, del libro mastro o del piano dei conti JA すべての非調整GL期間は、オペレーティング・ユニット、元帳または財務諸表に依存しています。 KO 운영 단위, 원장 또는 계정과 목표에 따라 모든 비 조정 GL 기간 PTB Todos os períodos sem ajuste GL, dependendo da unidade operacional, ledger ou plano de contas RU Все периоды, не подлежащие корректировке, в зависимости от операционной единицы, бухгалтерской книги или плана счетов. S Alla icke-justerade GL-perioder, beroende på operativ enhet, bokföring eller kontoplan TR Tüm ayarlanmamış GL dönemleri, işletim birimi, defter veya hesap planına bağlı olarak US All non adjustment GL periods, dependent on operating unit, ledger or chart of accounts ZHS 所有不调整的总分类账期，取决于业务单位、分类账或会计科目表。 35E2628E80D7D0E7E0630100007F0DC7 GL Period Type 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 35E2628E80D5D0E7E0630100007F0DC7 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 Y 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 :$flex$.chart_of_accounts Chart of Accounts Ledger :$flex$.chart_of_accounts Chart of Accounts Period From :$flex$.chart_of_accounts Chart of Accounts Period To :$flex$.ledger Ledger Period From :$flex$.ledger Ledger Period To :$flex$.ledger.value Ledger Period From value :$flex$.ledger.value Ledger Period To value