ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A2F65F6FEBACA045E053BB6B6358B0E3 CST Functional Area Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav where fav.application_short_name in ('SQLAP','SQLGL','AR','INV','OKL','PO','PA') order by fav.application_name AR معلمة للحصول على اسم التطبيق لتقرير إغلاق فترة محاسبة CAC. D Parameter, um den Anwendungsnamen für den CAC Accounting Period Close Report zu erhalten. E Parámetro para obtener el nombre de la aplicación para el informe de cierre del período contable de CAC. F Paramètre permettant d'obtenir le nom de l'application pour le rapport de clôture de l'exercice comptable de la CAC. I Parametro per ottenere il nome dell'applicazione per il rapporto di chiusura del periodo contabile CAC. JA CAC会計期間終了レポートのアプリケーション名を取得するためのパラメータです。 KO CAC 회계 기간 마감 보고서에 대한 애플리케이션 이름을 가져 오는 매개 변수입니다. PTB Parâmetro para obter o nome do aplicativo para o relatório de encerramento do período contábil do CAC. RU Параметр для получения названия приложения для отчета о закрытии учетного периода CAC. S Parameter för att få applikationsnamnet för CAC Accounting Period Close Report. TR CAC Hesap Dönemi Kapanış Raporu için uygulama adını alma parametresi. US Parameter to get the application name for the CAC Accounting Period Close Report. ZHS 参数获取CAC会计期间结算报告的申请名称。 8E2FF36EDEC979D2E0530100007F1FF2 CST Report Period Options Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='CLOSING_STATUS' and flvv.lookup_code in ('C','N','O') and flvv.view_application_id=101 union select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='AUTHORIZATION STATUS' and flvv.lookup_code='ALL' and flvv.view_application_id=201 AR خيارات حالة الفترة للتقرير D Zeitraum Status Optionen zum Melden E Estado del período Opciones para informar F Statut de la période Options de rapport I Stato del periodo Opzioni da segnalare JA 報告する期間ステータスオプション KO 보고 할 기간 상태 옵션 PTB Opções de status do período a relatar RU Статус периода Опции для отчета S Periodstatusalternativ att rapportera TR Dönem Durum Raporlama seçenekleri US Period Status Options to report ZHS 期间状态报告选项 8E2FF36EDF3A79D2E0530100007F1FF2 GL Ledger (inv org related) Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') 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, gl.name AR جميع دفاتر الأستاذ المتعلقة بجميع منظمات المخزون النشطة D Alle Ledger, die sich auf alle aktiven Inventarorganisationen beziehen E Todos los libros de contabilidad relacionados con todas las organizaciones de inventario activas F Tous les grands livres relatifs à tous les organismes d'inventaire actifs I Tutti i libri contabili relativi a tutte le organizzazioni di inventario attive JA すべてのアクティブな在庫組織に関連するすべての台帳 KO 모든 활성 재고 조직과 관련된 모든 원장 PTB Todos os livros contábeis relacionados a todas as organizações de inventário ativas RU Все бухгалтерские книги, относящиеся ко всем организациям, занимающимся активным инвентаризацией. S Alla huvudböcker relaterade till alla aktiva lagerorganisationer TR Tüm aktif envanter organizasyonlarıyla ilgili tüm defterler US All ledgers related to all active inventory organizations ZHS 与所有现行清单组织有关的所有分类账 A6A156EB170F798DE053BB6B635840AB HR Hierarchy Name Y select pos.name value, pbg.name description from per_organization_structures pos, per_business_groups pbg where pos.business_group_id=pbg.business_group_id(+) order by pos.name US 9B9627743E84607DE053BB6B635805FB INV Operating Unit Y select haouv.name value, 'Operating Unit' description from hr_all_organization_units_vl haouv where haouv.organization_id in ( select to_number(hoi.org_information3) from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where mp.organization_id<>mp.master_organization_id and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.organization_id=haou.organization_id and nvl(haou.date_to,sysdate)>=sysdate ) order by 1 AR جميع وحدات التشغيل المرتبطة بمؤسسة مخزون غير رئيسية نشطة D Alle Betriebseinheiten, die mit einer aktiven Nicht-Master-Inventarisierungsorganisation verbunden sind E Todas las unidades operativas relacionadas con una organización de inventario no maestra activa F Toutes les unités opérationnelles liées à un organisme d'inventaire non maître actif I Tutte le unità operative legate a un'organizzazione di inventario non master attiva JA アクティブな非マスターインベントリ組織に関連するすべてのオペレーティング・ユニット KO 활성 비 마스터 재고 조직과 관련된 모든 운영 단위 PTB Todas as unidades operacionais relacionadas a uma organização ativa de inventário não-mestre RU Все операционные единицы, относящиеся к действующей организации, не являющейся ведущим поставщиком инвентарных запасов. S Alla operativa enheter relaterade till en aktiv organisation som inte är huvudlager TR Etkin bir ana envanter organizasyonu ile ilgili tüm işletim birimleri US All operating units related to an active non master inventory organization ZHS 与在用的非总清单组织有关的所有业务单位： 8E2FF36EDF2279D2E0530100007F1FF2 INV Period Y select distinct oap.period_name value, max(oap.period_year||'-'||oap.period_num||', '||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)||' ('||oap.period_start_date||' - '||oap.schedule_close_date||')') over (partition by oap.period_name) description, max(oap.period_start_date) over (partition by oap.period_name) period_start_date, max(oap.effective_period_num) over (partition by oap.period_name) effective_period_num from gl_ledgers gl, org_organization_definitions ood, mtl_parameters mp, (select oap.period_year*10000+oap.period_num effective_period_num, oap.* from org_acct_periods oap) oap where oap.period_start_date<=sysdate and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') and ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and gl.period_set_name=oap.period_set_name and gl.ledger_id=ood.set_of_books_id and ood.organization_id=oap.organization_id order by period_start_date desc, effective_period_num desc, oap.period_name AR فترات دفتر الأستاذ العام السابقة للمخزون (تعتمد على دفتر الأستاذ و / أو معلمة رمز المؤسسة) للمؤسسات غير الرئيسية D Vergangene Bestands-GL-Perioden (abhängig von Ledger- und/oder Organisationscode-Parameter) für Nicht-Master-Organisationen E Períodos GL de inventario pasados (dependientes de los parámetros del libro mayor y/o del código de organización) para organizaciones no maestras F Périodes passées de GL d'inventaire (dépendant du grand livre et/ou du code d'organisation) pour les organisations non maîtresses I Periodi GL di inventario passati (dipendente dal parametro del ledger e/o del codice dell'organizzazione) per organizzazioni non master JA 非マスター組織の過去のインベントリGL期間（元帳および/または組織コードパラメータに依存する）。 KO 비 마스터 조직에 대한 과거 재고 GL 기간 (원장 및 / 또는 조직 코드 매개 변수에 따라 다름) PTB Períodos GL de inventário anteriores (ledger e/ou código de organização dependente do parâmetro) para organizações não-mestras RU Прошлые инвентаризационные GL-периоды (зависящие от бухгалтерской книги и/или параметра организационного кода) для неосновных организаций S Tidigare lager GL-perioder (storbok och / eller organisationskodparameter beroende) för icke-huvudorganisationer TR Ana olmayan kuruluşlar için geçmiş envanter GL dönemleri (genel muhasebe ve / veya kuruluş kodu parametresine bağlı) US Past inventory GL periods (ledger and/or organization code parameter dependent) for non master organizations ZHS 非主组织的过去库存GL期(分类账和/或组织代码参数而定) A332C526DD0AC97BE053BB6B6358CCF8 select fav.application_name Functional_Area, -- ===================================================================== -- Inventory Calendar Periods which are open or closed -- ===================================================================== oap.period_name Period_Name, nvl(gl.short_name, gl.name) Ledger, haou2.name Operating_Unit, mp.organization_code Org_Code, haou.name Organization_Name, -- Revision for version 1.7 ml.meaning Period_Status, fl2.meaning Summarized_Flag, -- Revision for version 1.1 opm_status.period_status_tl OPM_Period_Status, coalesce( (select max(hoh.organization_hierarchy_name) organization_hierarchy_name from hrfv_organization_hierarchies hoh where hoh.organization_hierarchy_name= '&p_hierarchy_name' and (mp.organization_id = hoh.child_organization_id or mp.organization_id = hoh.parent_organization_id) ), (select max(hoh.organization_hierarchy_name) organization_hierarchy_name from hrfv_organization_hierarchies hoh where regexp_like(hoh.organization_hierarchy_name,'&p_name_open|&p_name_close|&p_name_period','i') and (mp.organization_id = hoh.child_organization_id or mp.organization_id = hoh.parent_organization_id) ) ) hierarchy_name, -- Revision for version 1.12 xxen_util.user_name(oap.created_by) created_by, xxen_util.client_time(oap.creation_date) creation_date, xxen_util.user_name(oap.last_updated_by) last_updated_by, xxen_util.client_time(oap.last_update_date) last_update_date -- End revision for version 1.12 from org_acct_periods oap, mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units_vl haou, hr_all_organization_units_vl haou2, gl_ledgers gl, -- Revision for version 1.7 mfg_lookups ml, fnd_application_vl fav, -- Revision for version 1.8 fnd_product_installations fpi, fnd_lookups fl2, -- Revision for version 1.10 (select flvv.lookup_code, flvv.meaning from fnd_lookup_values_vl flvv where flvv.lookup_type = 'CLOSING_STATUS' and flvv.lookup_code in ('C','N','O') and flvv.view_application_id = 101 union select flvv2.lookup_code, flvv2.meaning from fnd_lookup_values_vl flvv2 where flvv2.lookup_type = 'AUTHORIZATION STATUS' and flvv2.lookup_code = 'ALL' and flvv2.view_application_id = 201 ) period_status, (select hoi.organization_id, gps.period_code, gps.start_date, gps.period_status, flvv.meaning period_status_tl from mtl_parameters mp2, gmf_fiscal_policies gfp, gmf_period_statuses gps, -- Revision for version 1.7 and 1.10 fnd_lookup_values_vl flvv, hr_organization_information hoi, hr_all_organization_units haou -- inv_organization_id where hoi.org_information_context = 'Accounting Information' and hoi.organization_id = haou.organization_id -- this gets the organization name and gfp.legal_entity_id = to_number(hoi.org_information2) and gps.legal_entity_id = gfp.legal_entity_id and gps.cost_type_id = gfp.cost_type_id and hoi.organization_id = mp2.organization_id and flvv.lookup_type = 'CLOSING_STATUS' and flvv.view_application_id = 101 -- don't want duplicate rows and flvv.lookup_code = gps.period_status and mp2.process_enabled_flag = 'Y') opm_status where mp.organization_id = oap.organization_id -- Revision for version 1.7 and fav.application_id = 401 -- Inventory -- Revision for version 1.8, only report installed applications and fav.application_id = fpi.application_id and fpi.status <> 'N' -- Inactive -- =================================================================== -- Lookup values -- =================================================================== and 5=5 -- p_report_period_option and fl2.lookup_type = 'YES_NO' and fl2.lookup_code = nvl(oap.summarized_flag, 'N') and ml.lookup_type = 'MTL_ACCT_PERIOD_STATUS' and ml.lookup_code = decode((oap.open_flag||'-'||nvl(oap.summarized_flag,'N')), 'N'||'-'||'N', 65, -- Closed not Summarized 'N'||'-'||'Y', 66, -- Closed 'P'||'-'||'N', 2, -- Processing 'P'||'-'||'Y', 2, -- Processing 'Y'||'-'||'N', 3, -- Open 'Y'||'-'||'Y', 3, -- Open 'N'||'-'||'E', 4, -- Error 'Y'||'-'||'E', 4, -- Error 3) -- =================================================================== -- Using the base tables to avoid org_organization_definitions -- and hr_operating_units -- =================================================================== and hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and hoi.organization_id = haou.organization_id -- this gets the organization name -- avoid selecting disabled inventory organizations and sysdate < nvl(haou.date_to, sysdate + 1) -- avoid selecting item master orgs and mp.master_organization_id <> mp.organization_id and haou2.organization_id = to_number(hoi.org_information3) -- this gets the operating unit id and gl.ledger_id = to_number(hoi.org_information1) -- this gets the ledger id and 1=1 -- p_ledger, p_operating_unit, p_functional_area, p_period_name and oap.organization_id = opm_status.organization_id(+) and oap.period_start_date = opm_status.start_date(+) --Report Option Logic -- Revision for version 1.10 and ((oap.open_flag = decode(period_status.lookup_code, 'O', 'Y', 'C', 'N', 'N', 'X', oap.open_flag)) or (nvl(opm_status.period_status, 'Z') = decode(period_status.lookup_code, 'O', 'Y', 'C', 'C', 'N', 'X', opm_status.period_status)) or (nvl(opm_status.period_status, 'Z') = decode(period_status.lookup_code, 'O', 'F', 'X')) -- Revision for version 1.4 or (nvl(oap.summarized_flag,'N') = decode(period_status.lookup_code, 'O', 'N', 'C', 'Y', 'N', 'X', nvl(oap.summarized_flag,'N'))) ) -- Period Statuses -- 0 - Open -- C - Closed -- N - Never Opened -- ALL - All Period Statuses -- ===================================================================== -- Show accounting periods which should be open but was never opened. -- If an inventory accounting period was never opened it will not exist -- in the inventory period calendar, will not be in org_acct_periods. -- ===================================================================== union all select fav.application_name Functional_Area, gp.period_name Period_Name, nvl(gl.short_name, gl.name) Ledger, haou2.name Operating_Unit, mp.organization_code Org_Code, haou.name Organization_Name, -- Revision for version 1.7 flvv.meaning Period_Status, -- 'Never Opened' '' Summarized_Flag, -- Revision for version 1.1 '' OPM_Period_Status, coalesce( (select max(hoh.organization_hierarchy_name) organization_hierarchy_name from hrfv_organization_hierarchies hoh where hoh.organization_hierarchy_name= '&p_hierarchy_name' and (mp.organization_id = hoh.child_organization_id or mp.organization_id = hoh.parent_organization_id) ), (select max(hoh.organization_hierarchy_name) organization_hierarchy_name from hrfv_organization_hierarchies hoh where regexp_like(hoh.organization_hierarchy_name,'&p_name_open|&p_name_close|&p_name_period','i') and (mp.organization_id = hoh.child_organization_id or mp.organization_id = hoh.parent_organization_id) ) ) hierarchy_name, -- Revision for version 1.12 to_number(null) created_by, to_date(null) creation_date, to_number(null) last_updated_by, to_date(null) last_update_date -- End revision for version 1.12 from gl_periods gp, mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units_vl haou, hr_all_organization_units_vl haou2, gl_ledgers gl, -- Revision for version 1.7 and 1.10 fnd_lookup_values_vl flvv, (select flvv.lookup_code, flvv.meaning from fnd_lookup_values_vl flvv where flvv.lookup_type = 'CLOSING_STATUS' and flvv.lookup_code in ('C','N','O') and flvv.view_application_id = 101 union select flvv2.lookup_code, flvv2.meaning from fnd_lookup_values_vl flvv2 where flvv2.lookup_type = 'AUTHORIZATION STATUS' and flvv2.lookup_code = 'ALL' and flvv2.view_application_id = 201 ) period_status, fnd_application_vl fav, -- Revision for version 1.8 fnd_product_installations fpi where gp.period_set_name = gl.period_set_name -- Revision for version 1.7 and fav.application_id = 401 -- Inventory -- Revision for version 1.8, only report installed applications and fav.application_id = fpi.application_id and fpi.status <> 'N' -- Inactive -- =================================================================== -- Using base tables to avoid org_organization_definitions -- and hr_operating_units -- =================================================================== and hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and hoi.organization_id = haou.organization_id -- this gets the organization name -- avoid selecting disabled inventory organizations and sysdate < nvl(haou.date_to, sysdate + 1) -- avoid selecting item master orgs and mp.master_organization_id <> mp.organization_id -- avoid selecting inventory orgs created after the period end date -- for reporting against prior accounting periods and gp.end_date >= mp.creation_date and haou2.organization_id = to_number(hoi.org_information3) -- this gets the operating unit id and gl.ledger_id = to_number(hoi.org_information1) -- this gets the ledger id and 2=2 -- p_ledger, p_operating_unit, p_functional_area, p_period_name -- =================================================================== -- Lookup values -- =================================================================== and 5=5 -- p_report_period_option and flvv.lookup_type = 'CLOSING_STATUS' and flvv.view_application_id = 101 -- don't want duplicate rows and flvv.lookup_code = 'N' -- Never Opened -- =================================================================== -- Check to see if the accounting period already exists in the -- inventory calendar, in org_acct_periods -- =================================================================== and not exists (select 'x' from org_acct_periods oap where oap.organization_id = mp.organization_id and 3=3) -- p_period_name --Report Option Logic -- Revision for version 1.10 and 'Y' = decode(period_status.lookup_code, 'N','Y','ALL','Y','N') -- Period Statuses -- 0 - Open -- C - Closed -- N - Never Opened -- ALL - All Period Statuses -- ===================================================================== -- General Ledger, Lease Management, Payables, Projects, Purchasing, Receivables -- ===================================================================== union all select fav.application_name Functional_Area, gps.period_name Period_Name, nvl(gl.short_name, gl.name) Ledger, haou.name Operating_Unit, '' Org_Code, '' Organization_Name, -- Revision for version 1.7 flvv.meaning Period_Status, '' Summarized_Flag, -- Revision for version 1.1 '' OPM_Period_Status, '' Hierarchy_Name, -- Revision for version 1.12 case when gps.closing_status = 'N' then null else xxen_util.user_name(gps.created_by) end created_by, case when gps.closing_status = 'N' then null else xxen_util.client_time(gps.creation_date) end creation_date, case when gps.closing_status = 'N' then null else xxen_util.user_name(gps.last_updated_by) end last_updated_by, case when gps.closing_status = 'N' then null else xxen_util.client_time(gps.last_update_date) end last_update_date -- End revision for version 1.12 from gl_period_statuses gps, -- Revision for version 1.7 and 1.10 fnd_lookup_values_vl flvv, (select flvv.lookup_code, flvv.meaning from fnd_lookup_values_vl flvv where flvv.lookup_type = 'CLOSING_STATUS' and flvv.lookup_code in ('C','N','O') and flvv.view_application_id = 101 union select flvv2.lookup_code, flvv2.meaning from fnd_lookup_values_vl flvv2 where flvv2.lookup_type = 'AUTHORIZATION STATUS' and flvv2.lookup_code = 'ALL' and flvv2.view_application_id = 201 ) period_status, fnd_application_vl fav, -- Revision for version 1.8 fnd_product_installations fpi, hr_organization_information hoi, hr_all_organization_units_vl haou, gl_ledgers gl where gps.application_id = fav.application_id and fav.application_short_name in ('SQLAP','SQLGL','AR','OKL','PO','PA') -- Revision for version 1.8, only report installed applications and fav.application_id = fpi.application_id and fpi.status <> 'N' -- Inactive -- =================================================================== -- Lookup values -- =================================================================== and 5=5 -- p_report_period_option and flvv.lookup_type = 'CLOSING_STATUS' and flvv.lookup_code = gps.closing_status and flvv.view_application_id = 101 -- don't want duplicate rows -- =================================================================== -- Using the base hr organization tables -- =================================================================== and gl.ledger_id = gps.ledger_id and hoi.org_information_context = 'Operating Unit Information' and hoi.organization_id = haou.organization_id -- this gets the operating unit id and gl.ledger_id = to_number(hoi.org_information3) -- this joins OU to GL and 4=4 -- p_ledger, p_operating_unit, p_functional_area, p_period_name --Report Option Logic -- Revision for version 1.10 and gps.closing_status = decode(period_status.lookup_code, 'O', 'O', 'C', 'C', 'N', 'N', 'ALL', gps.closing_status, 'X') -- order by Functional_Area, Period, Ledger, Operating_Unit, Org_Code order by 1,2,3,4,5 Y D CAC Accounting Period Status Bericht zur Anzeige des Buchhaltungsperiodenstatus für Hauptbuch, Inventar, Leasingmanagement, Verbindlichkeiten, Projekte, Einkauf und Forderungen. Sie können alle Status (offen oder geschlossen oder nie geöffnet), geschlossene, offene oder nie geöffnete Perioden wählen. Und dieser Bericht zeigt auch den Status des Prozessfertigungskostenkalenders an. Hinweis: Dieser Bericht sucht automatisch nach Hierarchien, die mit den Oracle-Programmen "Open Period Control" und "Close Period Control" verwendet werden könnten. Es wird nach den übersetzten Werten von "Close", "Open" und "Period" im Hierarchienamen gesucht. /* +=============================================================================+ -- | SQL-Code Copyright 2011-2020 Douglas Volz Consulting, Inc. | -- | Alle Rechte vorbehalten. | -- | | Die Erlaubnis zur Verwendung dieses Codes wird erteilt, sofern der ursprüngliche Autor | -- | | anerkannt wird. Diese | -- | Erlaubnis beinhaltet keine ausdrücklichen oder sonstigen Garantien. | | | Erlaubnis. | -- +=============================================================================+ -- | -- | Originalautor: Douglas Volz (doug@volzconsulting.com) -- | -- | | Programmname: xxx_period_status_rept.sql -- | -- | Parameter: -- | p_functional_area -- Sachgebiet, das Sie melden möchten, funktioniert mit null, -- | oder gültigen Sachgebieten. Die Namen der -- | Sachgebiete sind: General Ledger, Inventory, Lease -- | Management, Payables, Projects, Purchasing und Receivables. -- | p_operating_unit -- Betriebseinheit, über die Sie berichten möchten, lassen Sie das Feld für alle -- | Betriebseinheiten (optional) -- | p_ledger -- Hauptbuch, über das Sie berichten möchten, für alle leer lassen -- | ledger (optional) -- | p_period_name -- Die gewünschte Buchhaltungsperiode, über die Sie berichten möchten -- | p_report_period_option -- Parameter, der verwendet wird, um die Periode Öffnen und Periode Schließen zu kombinieren -- | Berichte. Für Englisch ist die Liste der Werteauswahlen: -- | Closed, Open, Never Opened oder All Statuses -- | Version Geändert am Geändert von Beschreibung -- | ======= =========== =============== ========================================= -- | 1.0 19. Jan. 2015 Douglas Volz Kombinierte die xxx_period_open_status_rept.sql -- | Apps Associates und xxx_period_close_status_rept.sql in -- | einen Bericht. Ursprünglich geschrieben in 2006 und 2011. -- | 1.7 10 Apr 2020 Douglas Volz Hat die folgenden mehrsprachigen Änderungen vorgenommen: -- | Geändert fnd_application zu fnd_application_vl -- | Geändert hr_all_organization_units zu hr_all_organization_units_vl -- | 1.8 7. Mai 2020 Douglas Volz fnd_product_installations hinzugefügt, um nur -- | installierte Anwendungen. -- | 1.9 26. Mai 2020 Douglas Volz Nachschlagewerte und Parameter für die -- | organization_hierarchy_name Unterabfrage hinzugefügt. -- | 1.10 28. Mai 2020 Douglas Volz Für die Sprachübersetzung, ersetzt benutzerdefinierte Report -- | Optionen LOV mit zusammengesetzten Oracle-Lookup-Werten. -- +=============================================================================+*/ E CAC Accounting Period Status Informe para mostrar el estado del período contable para el Libro Mayor, el Inventario, la Gestión de Arrendamientos, las Cuentas a Pagar, los Proyectos, las Compras y las Cuentas a Cobrar. Puede elegir todos los estados (abierto o cerrado o nunca abierto), períodos cerrados, abiertos o nunca abiertos. Y este informe también mostrará el estado del calendario de costes de fabricación del proceso. Nota: este informe busca automáticamente las jerarquías que podrían utilizarse con los programas de Oracle de Control de Períodos Abiertos y Control de Períodos Cerrados. Busca los valores traducidos de "Cerrar", "Abrir" y "Periodo" en el Nombre de la Jerarquía. /* +=============================================================================+ -- | Código SQL Copyright 2011-2020 Douglas Volz Consulting, Inc. | | Todos los derechos reservados. | -- | Se permite el uso de este código siempre y cuando se reconozca al autor original | -- --. -- | reconocido. Este permiso no incluye ninguna garantía, expresa o de otro tipo. -- -- Permiso de uso de este código. | -- +=============================================================================+ -- | -- | Autor original: Douglas Volz (doug@volzconsulting.com) -- | -- -- Nombre del programa: xxx_period_status_rept.sql -- | -- | Parámetros: -- | p_área_funcional -- área funcional que se desea reportar, funciona con null, -- | o áreas funcionales válidas. Los nombres de las -- | áreas funcionales son: Libro Mayor, Inventario, Arrendamiento -- | Gestión, Cuentas por pagar, Proyectos, Compras y Cuentas por cobrar. -- | p_operating_unit -- Unidad operativa que desea reportar, dejar en blanco para todas -- | unidades operativas (opcional) -- | p_ledger -- Libro mayor que desea reportar, dejar en blanco para todos -- | libros mayores (opcional) -- | p_period_name -- El período contable sobre el que desea informar -- | p_report_period_option -- Parámetro utilizado para combinar el periodo abierto y el periodo cerrado -- | informes. Para el inglés, la lista de opciones de valores son: -- | Cerrado, Abierto, Nunca Abierto o Todos los Estados -- | Versión Modificada en Modificado por Descripción -- | ======= =========== =============== ========================================= -- | 1.0 19 Ene 2015 Douglas Volz Combinó el xxx_period_open_status_rept.sql -- | Apps Associates y xxx_period_close_status_rept.sql en -- | un solo informe. Originalmente escrito en 2006 y 2011. -- | 1.7 10 Abr 2020 Douglas Volz Realizó los siguientes cambios multilingües: -- Cambió fnd_application por fnd_application_vl -- Se ha cambiado hr_all_organization_units por hr_all_organization_units_vl -- | 1.8 7 de mayo de 2020 Douglas Volz Se ha añadido fnd_product_installations para informar únicamente de -- | aplicaciones instaladas. -- | 1.9 26 de mayo de 2020 Douglas Volz Añadidos valores de búsqueda y parámetros para la -- | subconsulta organization_hierarchy_name. -- | 1.10 28 de mayo de 2020 Douglas Volz Para la traducción de idiomas, se ha sustituido el informe personalizado -- | Opciones LOV con valores de búsqueda compuestos de Oracle. -- +=============================================================================+*/ F CAC Accounting Period Status Rapport indiquant l'état de la période comptable pour le grand livre, l'inventaire, la gestion des baux, les dettes, les projets, les achats et les créances. Vous pouvez choisir tous les statuts (ouvert ou fermé ou jamais ouvert), les périodes fermées, ouvertes ou jamais ouvertes. Et ce rapport affichera également le statut du calendrier des coûts de fabrication des processus. Remarque : ce rapport recherche automatiquement les hiérarchies qui pourraient être utilisées avec les programmes Oracle Open Period Control et Close Period Control. Recherche des valeurs traduites de "Fermer", "Ouvrir" et "Période" dans le nom de la hiérarchie. /* +=============================================================================+ | SQL Code Copyright 2011-2020 Douglas Volz Consulting, Inc. | | Tous droits réservés. | -- | L'autorisation d'utiliser ce code est accordée à condition que l'auteur original soit | -- | reconnu. Aucune garantie, expresse ou autre, n'est incluse dans ce | -- | permission. | -- +=============================================================================+ -- | -- | Auteur original : Douglas Volz (doug@volzconsulting.com) -- | | Nom du programme : xxx_period_status_rept.sql -- | -- | Paramètres : -- | p_functional_area -- domaine fonctionnel que vous souhaitez signaler, fonctionne avec null, | ou des domaines fonctionnels valables. Les noms des -- | domaines fonctionnels sont : Grand livre, inventaire, location -- | Gestion, dettes, projets, achats et créances. -- | p_operating_unit -- Unité opérationnelle que vous souhaitez signaler, laissez vide pour tous | unités d'exploitation (facultatif) -- | p_ledger -- grand livre général que vous souhaitez déclarer, laissez vide pour tous -- | grands livres (facultatif) -- | p_period_name -- L'exercice comptable souhaité que vous souhaitez déclarer | p_report_period_option -- Paramètre utilisé pour combiner la période d'ouverture et la période de fermeture -- | rapports. Pour l'anglais, la liste des choix de valeurs est : -- | Closed, Open, Never Opened ou All Statuses -- | Version modifiée le Modifié par la description -- | ======= =========== =============== ========================================= | 1,0 19 janvier 2015 Douglas Volz a combiné le xxx_period_open_status_rept.sql | Apps Associates et xxx_period_close_status_rept.sql dans -- | un rapport. Rédigé à l'origine en 2006 et 2011. -- | 1.7 10 avr 2020 Douglas Volz a effectué les changements multilingues suivants : -- | a changé fnd_application en fnd_application_vl -- | Changement de hr_all_organization_units en hr_all_organization_units_vl | 1.8 7 mai 2020 Douglas Volz a ajouté fnd_product_installations au seul rapport -- | applications installées. -- | 1,9 26 mai 2020 Douglas Volz a ajouté les valeurs et paramètres de recherche pour les -- | sous-requête nom_hierarchie_organisation. -- | 1.10 28 mai 2020 Douglas Volz Pour la traduction, a remplacé le rapport personnalisé | Options LOV avec valeurs de recherche composées d'Oracle. -- +=============================================================================+*/ I CAC Accounting Period Status Report per mostrare lo stato del periodo contabile per General Ledger, Inventory, Lease Management, Payables, Projects, Purchasing e Receivables. È possibile scegliere tutti gli stati (aperto o chiuso o mai aperto), periodi chiusi, aperti o mai aperti. E questo rapporto mostrerà anche lo stato del calendario dei costi di produzione del processo. Nota: questo rapporto cerca automaticamente le gerarchie che potrebbero essere usate con i programmi Oracle Controllo Periodo Aperto e Controllo Periodo Chiuso. Cerca i valori tradotti di "Close", "Open" e "Period" nel nome della gerarchia. /* +=============================================================================+ -- Codice SQL Copyright 2011-2020 Douglas Volz Consulting, Inc. | -- | Tutti i diritti riservati. | -- | Il permesso di usare questo codice è concesso a condizione che l'autore originale sia | -- | | riconosciuto. Nessuna garanzia, espressa o di altro tipo, è inclusa in questa | -- -- | permesso. | -- +=============================================================================+ -- | -- | Autore originale: Douglas Volz (doug@volzconsulting.com) -- | -- | Nome del programma: xxx_period_status_rept.sql -- | -- | Parametri: -- | p_functional_area -- area funzionale che vuoi segnalare, funziona con null, -- | o aree funzionali valide. I nomi delle -- | aree funzionali sono: Contabilità generale, Inventario, Locazione -- | Gestione, Debiti, Progetti, Acquisti e Crediti. -- | p_operating_unit -- Unità operativa che volete segnalare, lasciate vuoto per tutte -- | unità operative (opzionale) -- | p_ledger -- libro mastro che volete segnalare, lasciate vuoto per tutti -- | ledger (opzionale) -- | p_period_name -- Il periodo contabile che vuoi riportare -- | p_report_period_option -- Parametro usato per combinare il Periodo aperto e il Periodo chiuso -- | report. Per l'inglese, la lista delle scelte di valore sono: -- | Closed, Open, Never Opened o All Status -- | Version Modified on Modified by Descrizione -- | ======= =========== =============== ========================================= -- | 1.0 19 Jan 2015 Douglas Volz Ha combinato il xxx_period_open_status_rept.sql -- | Apps Associates e xxx_period_close_status_rept.sql in -- in un unico rapporto. Originariamente scritto nel 2006 e nel 2011. -- | 1.7 10 Apr 2020 Douglas Volz Ha apportato le seguenti modifiche multilingue: -- | Cambiato fnd_application in fnd_application_vl -- | Cambiato hr_all_organization_units in hr_all_organization_units_vl -- | 1.8 7 Maggio 2020 Douglas Volz Aggiunto fnd_product_installations per riportare solo -- | applicazioni installate. -- | 1.9 26 maggio 2020 Douglas Volz Aggiunti valori di ricerca e parametri per il parametro -- | subquery organization_hierarchy_name. -- | 1.10 28 maggio 2020 Douglas Volz Per la traduzione delle lingue, sostituito il Report personalizzato -- | Opzioni LOV con valori di ricerca composti Oracle. -- +=============================================================================+*/ JA CAC Accounting Period Status 総勘定元帳、在庫、リース管理、支払い、プロジェクト、購買、売掛の会計期間のステータスを表示するレポートです。 すべてのステータス（オープンまたはクローズド、または決してオープンしない）、クローズド、オープン、または決してオープンしない期間を選択することができます。 そして、このレポートはまた、プロセス製造コストカレンダーのステータスを表示します。 注：このレポートは、Open Period ControlとClose Period ControlのOracleプログラムで使用される可能性のある階層を自動的に探します。 階層名の「Close」、「Open」、「Period」の翻訳された値を探します。 /* +=============================================================================+ -- SQL Code Copyright 2011-2020 Douglas Volz Consulting, Inc. | | --｜このコードの使用を許可するには、原著作者が｜原著作者であることが条件となります。 -- : - - 認められています。本製品には、明示的であるか否かにかかわらず、いかなる保証も含まれていません。 -- --｜permission. | -- +=============================================================================+ -- | -- --｜原著者。ダグラス・ヴォルツ (doug@volzconsulting.com) -- | --｜プログラム名：xxx_period_status_rept.sql -- | -- | パラメータ。 -- | p_functional_area -- 報告したい機能領域。 -- または有効な機能領域を指定します。 の名前は -- --｜機能分野は以下の通りです。 総勘定元帳、在庫、リース --｜管理、買掛金、プロジェクト、購買、債権。 -- | p_operating_unit -- 報告したいオペレーティング・ユニット、すべて空白のままにしておきます。 -- 操作ユニット(オプション) -- | p_ledger -- 報告したい総勘定元帳、すべて空白のままにしておきます。 --｜元帳（オプション -- | p_period_name -- 報告したい会計期間を指定します。 | p_report_period_option -- 開いている期間と閉じている期間を組み合わせるために使用するパラメータ --｜レポート。 英語の場合、値の選択肢のリストは以下の通りです。 -- 閉じている、開いている、開いていない、またはすべてのステータス -- 説明文で変更されています。 -- | ======= =========== =============== ========================================= --｜1.0 2015年1月19日 ダグラス・ヴォルツ xxx_period_open_status_rept.sqlを組み合わせてみました。 --｜Apps Associatesとxxx_period_close_status_rept.sqlを連携させて、「xxx_period_close_status_rept.sql」を作成しました。 --｜1つのレポート。 原文は2006年と2011年に書かれたものです。 -- | 1.7 10 Apr 2020 Douglas Volz 以下のような多言語の変更を行いました。 -- | fnd_application を fnd_application_vl に変更しました。 -- 1.8 1.8 2020年5月7日 Douglas Volz fnd_product_installations をレポートのみに追加しました。 -- |インストールされているアプリケーション。 -- 1.9 1.9 26 May 2020 Douglas Volz -- | organization_hierarchy_name サブクエリ。 -- | 1.10 28 May 2020 Douglas Volz 言語翻訳のために、カスタムレポートを置き換えました。 --｜複合的なOracleルックアップ値を持つLOVオプション。 -- +=============================================================================+*/ KO CAC Accounting Period Status General Ledger, Inventory, Lease Management, Payables, Projects, Purchasing 및 Receivables에 대한 회계 기간 상태를 표시하는 보고서입니다. 모든 상태 (개설 또는 마감 또는 개설 안 함), 마감, 개설 또는 개설 안 함 기간을 선택할 수 있습니다. 또한이 보고서에는 프로세스 제조 원가 달력 상태도 표시됩니다. 주 :이 보고서는 개설 기간 통제 및 마감 기간 통제 Oracle 프로그램에서 사용할 수있는 계층을 자동으로 찾습니다. 계층 이름에서 "Close", "Open"및 "Period"의 번역 된 값을 찾습니다. / * + ============================================= ============================= + -| SQL 코드 저작권 2011-2020 Douglas Volz Consulting, Inc. | -| 판권 소유. | -| 이 코드를 사용할 수있는 권한은 원래 작성자가 | -| 인정. 여기에는 명시 적 또는 기타 어떠한 보증도 포함되지 않습니다. -| 허가. | -+ ============================================= ============================= + -| -| 원저자 : Douglas Volz (doug@volzconsulting.com) -| -| 프로그램 이름 : xxx_period_status_rept.sql -| -| 매개 변수 : -| p_functional_area-보고하려는 기능 영역, null과 함께 작동, -| 또는 유효한 기능 영역. 의 이름 -| 기능 영역 : General Ledger, Inventory, Lease -| 관리, 미지급금, 프로젝트, 구매 및 미수금. -| p_operating_unit-보고 할 운영 단위, 모두 비워 둡니다. -| 운영 단위 (선택 사항) -| p_ledger-보고하려는 총계정 원장, 모두 비워 둡니다. -| 원장 (선택 사항) -| p_period_name-보고 할 원하는 회계 기간 -| p_report_period_option-기간 개설 및 기간 마감을 결합하는 데 사용되는 매개 변수 -| 보고서. 영어의 경우 값 선택 목록은 다음과 같습니다. -| 닫힘, 열림, 열지 않음 또는 모든 상태 -| 수정 된 버전 설명에 의해 수정 됨 -| ======= =========== =============================== ======================== -| 1.0 2015 년 1 월 19 일 Douglas Volz는 xxx_period_open_status_rept.sql을 결합했습니다. -| Apps Associates 및 xxx_period_close_status_rept.sql을 -| 하나의 보고서. 2006 년과 2011 년에 처음 작성되었습니다. -| 1.7 2020 년 4 월 10 일 Douglas Volz는 다음과 같은 다국어 변경 사항을 적용했습니다. -| fnd_application을 fnd_application_vl로 변경했습니다. -| hr_all_organization_units를 hr_all_organization_units_vl로 변경했습니다. -| 1.8 2020 년 5 월 7 일 Douglas Volz보고 전용 fnd_product_installations 추가 -| 설치된 응용 프로그램. -| 1.9 2020 년 5 월 26 일 Douglas Volz에 대한 조회 값 및 매개 변수 추가 -| organization_hierarchy_name 하위 쿼리입니다. -| 1.10 2020 년 5 월 28 일 Douglas Volz 언어 번역 용, 맞춤 보고서 대체 -| 복합 Oracle 룩업 값이있는 옵션 LOV. -+ ============================================== ============================= + * / PTB CAC Accounting Period Status Relatório para mostrar o status do período contábil do Razão, Inventário, Gerenciamento de Arrendamento, Contas a Pagar, Projetos, Compras e Contas a Receber. Você pode escolher Todos os status (abertos ou fechados ou nunca abertos), Períodos Fechados, Abertos ou Nunca Abertos. E este relatório também exibirá o status do calendário de custos de fabricação do processo. Nota: este relatório procura automaticamente as hierarquias que podem ser usadas com os programas Controle de Período Aberto e Controle de Período Fechado Oracle. Procura os valores traduzidos de "Fechado", "Aberto" e "Período" no nome da Hierarquia. /* +=============================================================================+ | Código SQL Copyright 2011-2020 Douglas Volz Consulting, Inc. | | Todos os direitos reservados. | | A permissão para usar este código é concedida desde que o autor original seja | | reconhecido. Nenhuma garantia, expressa ou não, está incluída nisto |. | permissão. | -- +=============================================================================+ -- | Autor original: Douglas Volz (doug@volzconsulting.com) | Nome do programa: xxx_period_status_rept.sql | Parâmetros: -- | p_área_funcional -- área funcional que você deseja relatar, funciona com nulo, | ou áreas funcionais válidas. Os nomes das | áreas funcionais são: General Ledger, Inventário, Arrendamento | Administração, Contas a Pagar, Projetos, Compras e Contas a Receber. | p_unidade_operacional -- Unidade Operacional que você deseja relatar, deixe em branco para todos | unidades operacionais (opcional) | p_ledger -- livro razão geral que você deseja relatar, deixe em branco para todos | ledgers (opcional) | p_nome_do_período -- O período contábil desejado que você deseja relatar | p_report_period_option -- Parâmetro usado para combinar o Período Aberto e o Período Fechado | relatórios. Para o inglês, a lista de opções de valores são: | Fechado, Aberto, Nunca Aberto ou Todos os Status | Versão Modificada em Modificada por Descrição -- | ======= =========== =============== ========================================= | 1.0 19 jan 2015 Douglas Volz Combinado o xxx_period_open_status_rept.sql | Apps Associates e xxx_period_close_status_rept.sql em | um relatório. Originalmente escrito em 2006 e 2011. | 1.7 10 Abr 2020 Douglas Volz Fez as seguintes mudanças em vários idiomas: -- | Mudou fnd_application para fnd_application_vl | Alterado hr_all_organization_units para hr_all_organization_units_vl | 1.8 7 maio 2020 Douglas Volz Adicionado fnd_product_installations a apenas relatório | aplicações instaladas. | 1,9 26 de maio de 2020 Douglas Volz Acrescentou valores e parâmetros de pesquisa para o | organização_hierarchy_name subquerarchy. | 1.10 28 de maio de 2020 Douglas Volz Para tradução de idiomas, substituiu o relatório personalizado | Opções LOV com valores compostos de busca Oracle. -- +=============================================================================+*/ S CAC Accounting Period Status Rapportera för att visa redovisningsperiodens status för huvudbok, lager, leasinghantering, skulder, projekt, inköp och fordringar. Du kan välja alla statuser (öppna eller stängda eller aldrig öppnade), stängda, öppna eller aldrig öppnade perioder. Och den här rapporten kommer också att visa kalenderstatus för tillverkningskostnad för process. Obs! Den här rapporten letar automatiskt efter hierarkier som kan användas med Open Period Control och Close Period Control Oracle-programmen. Letar efter de översatta värdena för "Stäng", "Öppna" och "Period" i hierarkinamnet. / * + ================================================== ================================ + - | SQL-kod Copyright 2011-2020 Douglas Volz Consulting, Inc. | - | Alla rättigheter förbehållna. | - | Tillstånd att använda den här koden beviljas förutsatt att den ursprungliga författaren är | - | erkänd. Inga garantier, uttryckliga eller på annat sätt ingår i detta | - | lov. | - + ================================================= ================================ + - | - | Ursprunglig författare: Douglas Volz (doug@volzconsulting.com) - | - | Programnamn: xxx_period_status_rept.sql - | - | Parametrar: - | p_functional_area - funktionsområde du vill rapportera, fungerar med null, - | eller giltiga funktionsområden. Namnen på - | funktionella områden är: huvudbok, inventering, leasing - | Förvaltning, skulder, projekt, inköp och fordringar. - | p_operating_unit - Operationsenhet som du vill rapportera, lämna tom för alla - | manöverenheter (tillval) - | p_ledger - huvudbok som du vill rapportera, lämna tomt för alla - | ledgers (valfritt) - | p_period_name - Den önskade bokföringsperioden du vill rapportera - | p_report_period_option - Parameter som används för att kombinera perioden öppen och periodstängning - | rapporter. För engelska är listan över värdeval: - | Stängd, öppen, aldrig öppnad eller alla statyer - | Version modifierad på modifierad av beskrivning - | ===================================================== ========================== - | 1.0 19 jan 2015 Douglas Volz Kombinerade xxx_period_open_status_rept.sql - | Apps Associates och xxx_period_close_status_rept.sql in - | en rapport. Ursprungligen skriven 2006 och 2011. - | 1.7 10 apr 2020 Douglas Volz Gjorde följande flerspråkiga ändringar: - | Ändrat fnd_application till fnd_application_vl - | Ändrade hr_all_organization_units till hr_all_organization_units_vl - | 1.8 7 maj 2020 Douglas Volz lade till fnd_product_installations för att bara rapportera - | installerade applikationer. - | 1.9 26 maj 2020 Douglas Volz Lade till uppslagsvärden och parametrar för - | underfråga organisation_hierarki_namn. - | 1.10 28 maj 2020 Douglas Volz För språköversättning, ersatt anpassad rapport - | Alternativ LOV med sammansatta Oracle-uppslagsvärden. - + ================================================== ================================ + * / TR CAC Accounting Period Status Genel Muhasebe, Envanter, Kira Yönetimi, Borçlar, Projeler, Satın Alma ve Alacaklar için muhasebe dönemi durumunu gösteren rapor. Tüm Durumlar (açık veya kapalı veya hiç açılmamış), Kapalı, Açık veya Asla Açılmamış dönemleri seçebilirsiniz. Bu rapor aynı zamanda proses üretim maliyet takvimi durumunu da gösterecektir. Not: Bu rapor, Açık Dönem Kontrolü ve Kapanış Dönemi Kontrolü Oracle programlarıyla kullanılabilecek hiyerarşileri otomatik olarak arar. Hiyerarşi Adında "Kapat", "Açık" ve "Dönem" çevrilmiş değerleri aranıyor. / * + ============================================= ============================ + - | SQL Kodu Telif Hakkı 2011-2020 Douglas Volz Consulting, Inc. | - | Her hakkı saklıdır. | - | Bu kodu kullanma izni, orijinal yazarın | - | kabul edildi. Buna açık veya başka hiçbir garanti dahil edilmemiştir | - | izin. | - + =============================================== ============================ + - | - | Orijinal Yazar: Douglas Volz (doug@volzconsulting.com) - | - | Program Adı: xxx_period_status_rept.sql - | - | Parametreler: - | p_functional_area - rapor etmek istediğiniz fonksiyonel alan, null ile çalışır, - | veya geçerli fonksiyonel alanlar. İsimleri - | fonksiyonel alanlar şunlardır: Defteri Kebir, Envanter, Kiralama - | Yönetim, Borçlar, Projeler, Satın Alma ve Alacaklar. - | p_operating_unit - Bildirmek istediğiniz İşletim Birimi, tümü için boş bırakın - | işletim birimleri (isteğe bağlı) - | p_ledger - rapor etmek istediğiniz genel muhasebe, tümü için boş bırakın - | defterler (isteğe bağlı) - | p_period_name - Raporlamak istediğiniz istenen hesap dönemi - | p_report_period_option - Periyot Açılışı ve Periyot Kapanışını birleştirmek için kullanılan parametre - | raporlar. İngilizce için değer seçeneklerinin listesi şöyledir: - | Kapalı, Açık, Asla Açılmamış veya Tüm Durumlar - | Açıklamaya Göre Değiştirildiğinde Değiştirilen Sürüm - | ======= =========== =============== =================== ======================== - | 1.0 19 Ocak 2015 Douglas Volz xxx_period_open_status_rept.sql'yi birleştirdi - | Apps Associates ve xxx_period_close_status_rept.sql - | bir rapor. İlk olarak 2006 ve 2011'de yazılmıştır. - | 1.7 10 Nis 2020 Douglas Volz Aşağıdaki çoklu dil değişikliklerini yaptı: - | Fnd_application, fnd_application_vl olarak değiştirildi - | Hr_all_organization_units, hr_all_organization_units_vl olarak değiştirildi - | 1.8 7 Mayıs 2020 Douglas Volz Yalnızca rapora fnd_product_installations eklendi - | yüklü uygulamalar. - | 1.9 26 Mayıs 2020 Douglas Volz için arama değerleri ve parametreler eklendi. - | Organization_hierarchy_name alt sorgusu. - | 1.10 28 Mayıs 2020 Douglas Volz Dil çevirisi için özel Rapor değiştirildi - | Bileşik Oracle arama değerlerine sahip seçenekler DL. - + =============================================== ============================ + * / US CAC Accounting Period Status Report to show the accounting period status for General Ledger, Inventory, Lease Management, Payables, Projects, Purchasing and Receivables. You can choose All Statuses (open or closed or never opened), Closed, Open or Never Opened periods. And for process manufacturing (OPM), if your cost calendar has the same period end dates as your inventory accounting periods, this report will also display the OPM cost calendar status. Note: this report automatically looks for hierarchies which might be used with the Open Period Control and the Close Period Control Oracle programs. Parameters ========== Period Name - the desired inventory accounting period you wish to report (mandatory). Report Period Option - the parameter used to combine the Period Open and Period Close reports. The list of value choices are: Closed, Open, Never Opened or All Statuses (mandatory). Functional Area - the Oracle module(s) or functional area you wish to report. To see all functional areas leave this parameter empty (optional). Hierarchy Name - select the organization hierarchy used to open and close your inventory organizations. If you leave this parameter blank the report will try to find any organization hierarchy having "Period", "Open", or "Close" in the hierarchy name (optional) Organization Code: any inventory organization, defaults to your session's inventory organization (optional). Operating Unit: Operating Unit you wish to report, leave blank for all operating units (optional). Ledger: general ledger you wish to report, leave blank for all ledgers (optional). /* +=============================================================================+ -- | SQL Code Copyright 2011-2024 Douglas Volz Consulting, Inc. -- | All rights reserved. -- | Permission to use this code is granted provided the original author is -- | acknowledged. No warranties, express or otherwise is included in this permission. -- | -- | Original Author: Douglas Volz (doug@volzconsulting.com) -- | -- | Version Modified on Modified by Description -- | ======= =========== =============== ========================================= -- | 1.0 19 Jan 2015 Douglas Volz Combined the xxx_period_open_status_rept.sql xxx_period_close_status_rept.sql into one report. Originally written in 2006 and 2011. -- | 1.1 19 Jan 2015 Douglas Volz Added OPM Cost Calendar status and Projects. -- | 1.2 19 Dec 2016 Douglas Volz Fixed list of value choices, was preventing purchasing operating units from being reported. -- | 1.3 18 May 2016 Douglas Volz Minor fix for reporting the Organization Hierarchy -- | 1.4 03 Dec 2018 Douglas Volz Open Periods option now checks for Summarized_Flag. -- | 1.5 27 Oct 2019 Douglas Volz Condense A/R, A/P, Projects, Purchasing SQL logic -- | 1.6 16 Jan 2020 Douglas Volz Add operating unit parameter -- | 1.7 10 Apr 2020 Douglas Volz Made the following multi-language changes: Changed fnd_application to fnd_application_vl and changed hr_all_organization_units to hr_all_organization_units_vl -- | 1.8 7 May 2020 Douglas Volz Added fnd_product_installations to only report installed applications. -- | 1.9 26 May 2020 Douglas Volz Added lookup values and parameters for the organization_hierarchy_name subquery. -- | 1.10 28 May 2020 Douglas Volz For language translation, replaced custom Report Options LOV with compound Oracle lookup values. -- | 1.11 21 Jun 2020 Douglas Volz Added Organization Hierarchy as a separate parameter -- | 1.12 07 Feb 2022 Eric Clegg Added who columns using xxen_util functions. -- | 1.13 13 Mar 2022 Douglas Volz Modified for financial apps, to show blank who column values if status = Never Opened. -- | 1.14 11 Jun 2024 Douglas Volz Replaced tabs with spaces. Reinstalled missing parameters. -- +=============================================================================+*/ ZHS CAC Accounting Period Status 报告显示总账、存货、租赁管理、应付款、项目、采购和应收款的会计期间状态。 您可以选择所有状态（已开或已结或从未开过）、已结、已开或从未开过的期间。 而且此报告还将显示过程制造成本日历状态。 注意：此报表会自动查找可能与 "开盘期控制 "和 "关盘期控制 "Oracle程序一起使用的层次结构。 寻找层次结构名称中 "关闭"、"打开 "和 "期间 "的翻译值。 /* +=============================================================================+ -- SQL代码 Copyright 2011-2020 Douglas Volz Consulting, Inc. | -- 保留所有权利。 | -- 允许使用该代码，但前提是原作者必须是｜。 -- 认可。不包含任何明示或暗示的保证。 -- 允许。 | -- +=============================================================================+ -- | -- 原作者：Douglas Volz ()Douglas Volz (doug@volzconsulting.com) -- | -- 程序名称：xxx_period_status_rept.sql。 -- | |--参数。 -- -- p_functional_area -- 你想报告的功能区，可以用空值。 -- 或有效的功能区。 的名称。 -- 职能领域是： 总账、库存、租赁 -- 管理、应付款、项目、采购和应收款。 -- p_operating_unit -- 你想报告的经营单位，所有单位留空。 -- 操作单元(可选) -- p_ledger -- 你想报告的总账，所有的总账留空。 -- 账目（可选） -- -- p_period_name -- -- 您希望报告的会计期间。 -- p_report_period_option -- 用于合并期初和期末的参数。 -- 报道。 对于英文，可选择的值列表是： -- -- 关闭、打开、从未打开或所有状态。 -- | ======= =========== =============== ========================================= -- | 1.0 2015年1月19日 Douglas Volz 将xxx_period_open_status_rept.sql进行了合并。 -- -- 应用程序联营公司和xxx_period_close_status_rept.sql进入。 -- 一份报告。 最初写于2006年和2011年。 -- 1.7 2020年4月10日 Douglas Volz 做了以下多语言的修改。 -- 将fnd_application改为fnd_application_vl。 -- 将hr_all_organization_units改为hr_all_organization_units_vl。 -- 1.8 2020年5月7日 Douglas Volz 增加了fnd_product_installations的报告。 -- 安装的应用程序。 | 1.9 2020年5月26日 Douglas Volz 为 "安装的应用程序 "添加了查找值和参数。 -- 1.10 2020年5月28日 Douglas Volz 在语言翻译方面，替换了自定义报告。 -- 选项LOV与复合Oracle查询值。 -- +=============================================================================+*/ Enginatics R12 only &p_hierarchy_name &p_name_close &p_name_open &p_name_period 1=1 2=2 3=3 4=4 5=5 1 -30 &p_name_close select fl_close.meaning from fnd_lookups fl_close where fl_close.lookup_type = 'CLN_OPEN_CLOSE' and fl_close.lookup_code = 'N' Char an arbitrary value Y US Lookup Value for Close 2 -20 &p_name_open select fl_open.meaning from fnd_lookups fl_open where fl_open.lookup_type = 'CLN_OPEN_CLOSE' and fl_open.lookup_code = 'Y' Char an arbitrary value Y US Lookup Value for Open 3 -10 &p_name_period select fl_period.meaning from fnd_lookups fl_period where fl_period.lookup_type = 'MTH_ENT_PERIOD_OF_USAGE' and fl_period.lookup_code = 'PERIOD' Char an arbitrary value Y US Lookup Value for Period 4 10 1=1 oap.period_name = :p_period_name LOV INV Period 8E2FF36EDF2279D2E0530100007F1FF2 Y select distinct oap.period_name value, max(oap.period_year||'-'||oap.period_num||', '||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)||' ('||oap.period_start_date||' - '||oap.schedule_close_date||')') over (partition by oap.period_name) description, max(oap.period_start_date) over (partition by oap.period_name) period_start_date, max(oap.effective_period_num) over (partition by oap.period_name) effective_period_num from gl_ledgers gl, org_organization_definitions ood, mtl_parameters mp, (select oap.period_year*10000+oap.period_num effective_period_num, oap.* from org_acct_periods oap) oap where oap.period_start_date<=sysdate and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') and ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and gl.period_set_name=oap.period_set_name and gl.ledger_id=ood.set_of_books_id and ood.organization_id=oap.organization_id order by period_start_date desc, effective_period_num desc, oap.period_name Y US Period Name 5 2=2 gp.period_name = :p_period_name US Period Name 6 3=3 oap.period_name = :p_period_name US Period Name 7 4=4 gps.period_name = :p_period_name US Period Name 8 20 5=5 period_status.meaning = :p_report_period_option LOV CST Report Period Options 8E2FF36EDEC979D2E0530100007F1FF2 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='CLOSING_STATUS' and flvv.lookup_code in ('C','N','O') and flvv.view_application_id=101 union select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='AUTHORIZATION STATUS' and flvv.lookup_code='ALL' and flvv.view_application_id=201 All Statuses Y US Report Option 9 30 1=1 fav.application_name = :p_application_name LOV CST Functional Area A2F65F6FEBACA045E053BB6B6358B0E3 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav where fav.application_short_name in ('SQLAP','SQLGL','AR','INV','OKL','PO','PA') order by fav.application_name US Functional Area 10 2=2 fav.application_name = :p_application_name US Functional Area 11 4=4 fav.application_name = :p_application_name US Functional Area 12 35 :hierarchy_name LOV HR Hierarchy Name A6A156EB170F798DE053BB6B635840AB Y select pos.name value, pbg.name description from per_organization_structures pos, per_business_groups pbg where pos.business_group_id=pbg.business_group_id(+) order by pos.name US Hierarchy Name 13 50 1=1 haou2.name = :p_operating_unit LOV INV Operating Unit 9B9627743E84607DE053BB6B635805FB Y select haouv.name value, 'Operating Unit' description from hr_all_organization_units_vl haouv where haouv.organization_id in ( select to_number(hoi.org_information3) from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where mp.organization_id<>mp.master_organization_id and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.organization_id=haou.organization_id and nvl(haou.date_to,sysdate)>=sysdate ) order by 1 US Operating Unit 14 2=2 haou2.name = :p_operating_unit US Operating Unit 15 4=4 haou.name = :p_operating_unit US Operating Unit 16 60 1=1 gl.name = :p_ledger LOV GL Ledger (inv org related) 8E2FF36EDF3A79D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') 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, gl.name US Ledger 17 2=2 gl.name = :p_ledger US Ledger 18 4=4 gl.name = :p_ledger US Ledger :$flex$.ledger Ledger Period Name