ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 所有不调整的总分类账期，取决于业务单位、分类账或会计科目表。 BE6F96BE99320218E053BB6B6358D5EF select y.application_name, y.period_name, y.ledger, y.operating_unit, y.organization_code, y.organization_name, decode(y.application_id,401,nvl2(oap.acct_period_id,xxen_util.meaning(nvl2(oap.period_close_date,decode(oap.open_flag,'P',2,'N',decode(oap.summarized_flag,'N',65,66),4),3),'MTL_ACCT_PERIOD_STATUS',700),null),y.status) status, xxen_util.yes(oap.summarized_flag) summarized, xxen_util.user_name(decode(y.application_id,401,oap.created_by,y.created_by)) created_by, xxen_util.client_time(decode(y.application_id,401,oap.creation_date,y.creation_date)) creation_date, xxen_util.user_name(decode(y.application_id,401,oap.last_updated_by,y.last_updated_by)) last_updated_by, xxen_util.client_time(decode(y.application_id,401,oap.last_update_date,y.last_update_date)) last_update_date from ( select x.*, ood.organization_id, ood.organization_code, ood.organization_name, xxen_util.meaning(gps.closing_status,case when gps.application_id in (200,275) then 'CLOSING STATUS' else 'CLOSING_STATUS' end,case when gps.application_id in (200,275,222) then gps.application_id else 101 end) status, gps.created_by, gps.creation_date, gps.last_updated_by, gps.last_update_date from ( select fav.application_name, gl.name ledger, hou.name operating_unit, gp.period_name, fav.application_id, gl.ledger_id, decode(fav.application_id,401,hou.organization_id) inv_ou_id, gp.start_date, gp.period_year*10000+gp.period_num effective_period_num from fnd_application_vl fav, gl_ledgers gl, hr_operating_units hou, gl_periods gp where 1=1 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 fav.application_id in (222,8405,8721,283,201,200,101,275,540,401) and gl.ledger_id=hou.set_of_books_id and gl.period_set_name=gp.period_set_name and gl.accounted_period_type=gp.period_type and (gp.adjustment_period_flag='N' or fav.application_id=101) ) x, gl_period_statuses gps, org_organization_definitions ood where 2=2 and x.application_id=gps.application_id(+) and x.ledger_id=gps.ledger_id(+) and x.period_name=gps.period_name(+) and x.inv_ou_id=ood.operating_unit(+) and nvl(ood.disable_date(+),sysdate)>=sysdate ) y, org_acct_periods oap where 3=3 and y.organization_id=oap.organization_id(+) and y.period_name=oap.period_name(+) order by y.application_name, y.start_date desc, y.effective_period_num desc, y.ledger, y.operating_unit, y.organization_code Y US GL Period Status Accounting period status of all application modules for all or a selected list of ledgers, operating units and inventory organizations. To see if an accounting period should be opened, use the CAC Accounting Period Status report, as it has more reporting options and features. Enginatics 1=1 2=2 3=3 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 select gp.period_name value from gl_periods gp where sysdate>=gp.start_date and sysdate<gp.end_date+1 and gp.adjustment_period_flag='N' and gp.period_set_name in ( select gl.period_set_name from gl_ledgers gl where (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,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')) ) and rownum=1 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 :$flex$.period_from US Period To 3 90 1=1 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 4 100 1=1 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 select fifsv.id_flex_structure_name 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)>=sysdate) and fifsv.id_flex_num in (select oav.chart_of_accounts_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) US Chart of Accounts 5 110 1=1 fav.application_id=:application_id LOV custom Y select fav.application_id id, fav.application_name value, fav.application_short_name description from fnd_application_vl fav where fav.application_id in (222,8405,8721,283,201,200,101,275,540,401) order by fav.application_name US Application :$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 :$flex$.period_from Period From Period To