ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id 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 与库存组织有关的会计科目表 8E2FF36EDEB879D2E0530100007F1FF2 GL Ledger Y select 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 AR دفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحالية D Ledger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen Anmeldeverantwortung E Libros restringidos por el conjunto de acceso, definido por el valor del perfil "Conjunto de acceso a datos GL" de la responsabilidad de inicio de sesión actual F Grands livres limités par un ensemble d'accès, défini par la valeur du profil "GL Data Access Set" de la responsabilité de connexion actuelle I Libri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login corrente JA 現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳 KO 현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장 PTB Ledgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de login RU Леджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в систему S Ledgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaret TR Mevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterler US Ledgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibility ZHS 由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations A6579155E9B2D355E053BB6B6358ED35 PO Destination Type Code Y select plc.displayed_field value, plc.description from po_lookup_codes plc where plc.lookup_type='DESTINATION TYPE' order by plc.displayed_field US E55C3BEB562414D2E0530100007FD2D3 select nvl(gl.short_name, gl.name) Ledger, haou2.name Operating_Unit, acct_dist.organization_code Org_Code, oap.period_name Period_Name, &segment_columns acct_dist.item_number Item_Number, acct_dist.item_description Item_Description, -- Revision for version 1.13 acct_dist.item_type Item_Type, -- Revision for version 1.17 -- If the item does not exist, get the expense category information &category_columns -- Revision for version 1.19 nvl(flv2.meaning, acct_dist.accounting_line_type) Accounting_Line_Type, flv1.meaning Transaction_Type, -- End revision for version 1.19 -- Revision for version 1.16 acct_dist.vendor_name Supplier_Name, pl.displayed_field Destination_Type, -- Revision for version 1.18 &p_show_purchase_order &p_show_project -- End fix for version 1.18 -- Fix for version 1.9 and 1.17 &p_show_wip_osp -- Revision for version 1.17, preventing Expense Receipts to be reported -- acct_dist.primary_uom_code UOM_Code, (select muomv.uom_code from mtl_units_of_measure_vl muomv where muomv.uom_code = acct_dist.primary_uom_code) UOM_Code, -- End revision for version 1.17 sum(acct_dist.primary_quantity) Quantity, gl.currency_code Currency_Code, sum(acct_dist.amount) Amount from org_acct_periods oap, gl_code_combinations gcc, -- Revision for version 1.19 fnd_lookup_values flv1, fnd_lookup_values flv2, -- End revision for version 1.19 hr_organization_information hoi, hr_all_organization_units_vl haou, -- inv_organization_id hr_all_organization_units_vl haou2, -- operating unit gl_ledgers gl, po_lookup_codes pl, -- Revision for version 1.18 &wip_osp_tables &project_tables -- Revision for version 1.17 &rcv_sla_tables -- ========================================================================== -- Use this inline table to fetch the receiving transactions -- ========================================================================== (select mp.organization_code organization_code, rt.organization_id organization_id, rrsl.period_name period_name, rrsl.code_combination_id code_combination_id, rrsl.rcv_sub_ledger_id rcv_sub_ledger_id, msiv.concatenated_segments item_number, msiv.description item_description, -- Revision for version 1.13 fcl.meaning item_type, -- Revision for version 1.17 rsl.item_id, rsl.to_organization_id, pol.category_id, -- End revision for version 1.17 rrsl.accounting_line_type accounting_line_type, rt.transaction_type transaction_type, -- Revision for version 1.16 pov.vendor_name, pod.destination_type_code destination_type_code, -- Fix for version 1.18 poh.segment1 po_num, pol.line_num po_line, rt.po_release_id, -- End fix for version 1.18 pod.project_id project_id, -- Fix for version 1.18 rt.wip_entity_id, rt.bom_resource_id, -- End fix for version 1.18 -- Revision for version 1.14 and 1.17, preventing Expense Receipts to be reported -- muomv.uom_code primary_uom_code, msiv.primary_uom_code primary_uom_code, -- End revision for version 1.17 decode(sign(nvl(rrsl.accounted_dr,0) - nvl(rrsl.accounted_cr,0)), -- Fix for version 1.8, sign of qty incorrect on CORRECTION transactions -- 1, rt.primary_quantity, -- -1, -1 * rt.primary_quantity, 1, 1 * abs(rt.primary_quantity), -1, -1 * abs(rt.primary_quantity), rt.primary_quantity -- End fix for version 1.8 ) primary_quantity, nvl(rrsl.accounted_dr,0) - nvl(rrsl.accounted_cr,0) amount from rcv_receiving_sub_ledger rrsl, -- Fix for version 1.10 rcv_accounting_events rae, rcv_transactions rt, rcv_shipment_lines rsl, -- Fix for version 1.9 po_headers_all poh, po_lines_all pol, -- Fix for version 1.9 po_distributions_all pod, mtl_system_items_vl msiv, -- Revision for version 1.17, preventing Expense Receipts to be reported -- mtl_units_of_measure_vl muomv, mtl_parameters mp, -- Revision for version 1.13 fnd_common_lookups fcl, -- Revision for version 1.16 po_vendors pov -- ======================================================== -- Material Transaction, org and item joins -- ======================================================== where rrsl.rcv_transaction_id = rt.transaction_id -- Fix for version 1.10 and rae.accounting_event_id = rrsl.accounting_event_id and rae.rcv_transaction_id = rt.transaction_id -- End fix for version 1.10 and rt.shipment_line_id = rsl.shipment_line_id -- Expense destinations may not always have an item_id and rsl.item_id = msiv.inventory_item_id (+) and rsl.to_organization_id = msiv.organization_id (+) -- Revision for version 1.17, preventing Expense Receipts to be reported -- and muomv.uom_code = nvl(msiv.primary_uom_code, rt.uom_code) and pod.po_distribution_id = nvl(rt.po_distribution_id, to_number(rrsl.reference3)) and mp.organization_id = rt.organization_id and rt.po_header_id = poh.po_header_id and rt.po_line_id = pol.po_line_id and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and 4=4 -- p_trx_date_from, p_trx_date_to, p_dest_type_code, p_item_number, p_po_number, p_org_code and fcl.lookup_code (+) = msiv.item_type and fcl.lookup_type (+) = 'ITEM_TYPE' -- Revision for version 1.16 and pov.vendor_id = poh.vendor_id ) acct_dist -- ======================================================== -- Inventory Org accounting period joins -- ======================================================== -- Revision for version 1.13 where oap.period_name = acct_dist.period_name and oap.organization_id = acct_dist.organization_id -- ======================================================== -- Version 1.3, added lookup values to see more detail -- ======================================================== -- Revision for version 1.19 and flv1.lookup_type = 'RCV TRANSACTION TYPE' and flv1.lookup_code = acct_dist.transaction_type and flv1.language = userenv('lang') and flv2.lookup_type (+) = 'XLA_ACCOUNTING_CLASSES' and flv2.lookup_code (+) = acct_dist.accounting_line_type and flv2.language (+) = userenv('lang') -- End revision for version 1.19 and pl.lookup_type = 'DESTINATION TYPE' and pl.lookup_code = acct_dist.destination_type_code -- ======================================================== -- Dynamic SQL joins -- ======================================================== &project_table_joins &osp_wip_table_joins -- ======================================================== -- using the base tables to avoid using -- org_organization_definitions and hr_operating_units -- ======================================================== and hoi.org_information_context = 'Accounting Information' and hoi.organization_id = acct_dist.organization_id and hoi.organization_id = haou.organization_id -- this gets the organization name and haou2.organization_id = to_number(hoi.org_information3) -- this gets the operating unit id and gl.ledger_id = to_number(hoi.org_information1) -- get the ledger_id 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 haou2.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and 1=1 -- p_dest_type_code, p_operating_unit, p_ledger -- ======================================================== -- Revision for version 1.17, SLA and Non-SLA joins. -- ======================================================== &rcv_sla_table_joins &rcv_non_sla_table_joins -- ========================================================== group by nvl(gl.short_name, gl.name), haou2.name, acct_dist.organization_code, oap.period_name, &segment_columns_grp acct_dist.item_number, acct_dist.item_description, -- Revision for version 1.13 acct_dist.item_type, -- Revision for version 1.17, for category subquery acct_dist.item_id, acct_dist.to_organization_id, acct_dist.category_id, -- End revision for version 1.17 -- Revision for version 1.19 nvl(flv2.meaning, acct_dist.accounting_line_type), -- Accounting Line Type flv1.meaning, -- Transaction Type -- End revision for version 1.19 -- Revision for version 1.16 acct_dist.vendor_name, -- Supplier_Name, pl.displayed_field, -- Destination Type -- Revision for version 1.17 &group_by_purchase_order &group_by_project -- Revision for version 1.17 &group_by_wip_osp -- End fix for version 1.9 -- End revision for version 1.17 acct_dist.primary_uom_code, gl.currency_code order by nvl(gl.short_name, gl.name), -- Ledger haou2.name, -- Operating_Unit acct_dist.organization_code, -- Org_Code oap.period_name, -- Period_Name &segment_columns_grp acct_dist.item_number, -- Item_Number -- Revision for version 1.19 nvl(flv2.meaning, acct_dist.accounting_line_type), -- Accounting Line Type flv1.meaning, -- Transaction Type -- End revision for version 1.19 pl.displayed_field -- Destination Type &order_by_purchase_order &order_by_project &order_by_wip_osp Added operating unit security Y D CAC Receiving Account Summary Bericht, um die Verteilungen der empfangenden Buchhaltung in einer Zusammenfassung nach Artikel, Bestellung, Bestellzeile, Freigabe und Projektnummer zu erhalten. Für die externe Verarbeitung, einschließlich des WIP-Auftrags, der OSP-Artikelnummer und des OSP-Ressourcencodes. Und für Ausgabenziele, auch wenn es keine Positionsnummer auf der Bestellzeile gibt, erhält dieser Bericht die Ausgabenkategorie-Informationen, in der ersten Kategorie-Spalte. (Hinweis: Dieser Bericht wurde nicht mit Belastungsbuchungen getestet). /* +=============================================================================+ | Copyright 2009- 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_wip_dist_xla_sum_rept.sql -- | -- | Parameter: -- | p_trx_date_from -- Start-Transaktionsdatum für WIP-Buchhaltungstransaktionen, -- | obligatorisch. -- | p_trx_date_to -- End-Transaktionsdatum für WIP-Buchhaltungstransaktionen, -- | obligatorisch. -- | p_item_number -- Geben Sie die spezifische Positionsnummer ein, die Sie melden möchten (optional) -- | p_org_code -- Spezifische Bestandsorganisation, über die Sie berichten möchten (optional) -- | p_operating_unit -- Betriebseinheit, die Sie melden möchten, leer lassen für alle -- | operating units (optional) -- | p_ledger -- Hauptbuch, über das Sie berichten möchten, für alle leer lassen -- | ledger (optional) -- | p_category_set1 -- Der erste zu berichtende Positionstypen-Satz, typischerweise der -- | Kosten- oder Produktlinien-Kategoriesatz -- | p_category_set2 -- Die zweite zu meldende Artikelkategorie, typischerweise die -- | Bestandskategoriesatz -- | -- | Beschreibung: -- | Bericht, um die WIP-Abrechnungsverteilungen in einer Zusammenfassung nach WIP-Job zu erhalten, -- | Ressource, Gemeinkosten und WIP-Kostenfortschreibung. Und für die externe Verarbeitung, -- | einschließlich der Bestellnummer, Zeile und Freigabenummer. -- | -- | Version Geändert am Geändert von Beschreibung -- | ======= =========== ============== ========================================= -- | 1.0 06 Nov 2009 Douglas Volz Erstcodierung -- | 1.11 05 Jul 2019 Douglas Volz Hinzugefügt: -- | | a) Die Aufschlüsselung der Transaktionsmounts nach Kosten wurde hinzugefügt. -- | Element. -- | b) Die Summe der Ressourcen-/Gemeinkostenstunden oder -- | Beträge zu einer primären Mengenspalte hinzugefügt, plus, -- | das Mengen-UOM-Feld hinzugefügt. -- | 1.12 23 Apr 2020 Douglas Volz Umstellung auf mehrsprachige Ansichten für den Artikel -- | Stamm, Positionstypen und Betriebseinheiten. -- | Projektnummer hinzugefügt. -- +=============================================================================+*/ E CAC Receiving Account Summary Informe para obtener las distribuciones contables de recepción, en resumen, por artículo, orden de compra, línea de orden de compra, liberación y número de proyecto. Para el procesamiento externo, incluyendo el trabajo WIP, el número de artículo OSP y el código de recurso OSP. Y para los destinos de los gastos, incluso cuando no hay un número de artículo en la línea de pedido, este informe obtendrá la información de la categoría de gastos, en la primera columna de la categoría. (Nota: este informe no ha sido probado con entradas de gravamen). /* +=============================================================================+ -- Copyright 2009- 2020 Douglas Volz Consulting, Inc. | -- Todos los derechos reservados. | -- Se autoriza el uso de este código siempre que 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_wip_dist_xla_sum_rept.sql -- | -- -- Parámetros: -- | p_trx_date_from -- fecha de inicio de la transacción para las transacciones contables WIP, -- | obligatorio. -- | p_trx_date_to -- fecha de finalización de la transacción para las transacciones contables WIP, -- | obligatorio. -- | p_item_number -- Introduzca el número de artículo específico que desea informar (opcional). -- | p_org_code -- Organización de inventario específica sobre la que desea informar (opcional) -- | p_operating_unit -- Unidad operativa de la que desea informar, dejar en blanco para todas -- | unidades operativas (opcional) -- | p_ledger -- Libro mayor del que desea informar, dejar en blanco para todos -- | libros mayores (opcional) -- | p_category_set1 -- El primer conjunto de categorías de artículos sobre el que se va a informar, normalmente el -- | Conjunto de categorías de costes o líneas de productos -- | p_category_set2 -- El segundo conjunto de categorías de artículos a reportar, típicamente el -- | Conjunto de categorías de inventario -- | -- | Descripción: -- | Informe para obtener las distribuciones contables del WIP, en resumen, por trabajo WIP, -- | actualización de recursos, gastos generales y costes WIP. Y para el procesamiento externo, -- | incluyendo el número de orden de compra, línea y número de liberación. -- | -- | Versión modificada en Modificado por Descripción -- | ======= =========== ============== ========================================= -- | 1.0 06 Nov 2009 Douglas Volz Codificación inicial -- | 1.11 05 jul 2019 Douglas Volz Añadido: -- | a) Se ha añadido el desglose de los montajes de las transacciones por coste -- | elemento. -- | b) Añadida la suma de horas de recursos / gastos generales o -- | cantidades a una columna de cantidad primaria, además, -- | añadido el campo de cantidad UOM. -- | 1.12 23 Abr 2020 Douglas Volz Cambiado a vistas multi-idioma para el artículo -- | maestro, categorías de artículos y unidades operativas. -- | Añadido el número de proyecto. -- +=============================================================================+*/ F CAC Receiving Account Summary Rapport pour obtenir les distributions comptables de réception, en résumé, par article, commande, ligne de commande, version et numéro de projet. Pour le traitement externe, y compris le travail WIP, le numéro d'article OSP et le code de ressource OSP. Et pour les destinations des dépenses, même s'il n'y a pas de numéro d'article sur la ligne de commande, ce rapport obtiendra les informations sur la catégorie de dépenses, dans la première colonne de la catégorie. (Remarque : ce rapport n'a pas été testé avec des entrées de charges). /* +=============================================================================+ | Copyright 2009- 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_wip_dist_xla_sum_rept.sql -- | -- | Paramètres : -- | p_trx_date_from -- date de début des transactions de la comptabilité des encours, -- | obligatoire. -- | p_trx_date_to -- date de fin de transaction pour les transactions de comptabilité WIP, -- | obligatoire. -- | p_item_number -- Saisissez le numéro d'article spécifique que vous souhaitez signaler (facultatif) | p_org_code -- Organisation spécifique de l'inventaire que vous souhaitez signaler (facultatif) | 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_category_set1 -- La première catégorie d'articles à signaler, généralement le | Ensemble de catégories de coûts ou de lignes de produits | p_category_set2 -- La deuxième catégorie d'articles à signaler, généralement le | Ensemble de catégories d'inventaire -- | -- | Description : | Rapport permettant d'obtenir les répartitions comptables des TEC, en résumé, par poste de TEC, -- | mise à jour des ressources, des frais généraux et des coûts de l'IPF. Et pour le traitement externe, -- | y compris le numéro de commande, la ligne et le numéro de sortie. -- | -- | Version modifiée le Modifié par la description -- | ======= =========== ============== ========================================= -- | 1.0 06 Nov 2009 Codage initial de Douglas Volz -- | 1.11 05 Jul 2019 Douglas Volz Ajouté : -- | a) Ajout de la ventilation des montants des transactions par coût -- | élément. -- | b) Ajout de la somme des heures de ressources / frais généraux ou -- | correspond à une colonne de quantité primaire, plus, -- | a ajouté le champ de la quantité UOM. -- | 1.12 23 avr 2020 Douglas Volz passe en mode multi-langues pour l'article -- | maître, catégories d'articles et unités d'exploitation. -- | Numéro de projet ajouté. -- +=============================================================================+*/ I CAC Receiving Account Summary Rapporto per ottenere le distribuzioni contabili di ricezione, in sintesi, per articolo, ordine di acquisto, linea di ordine di acquisto, numero di rilascio e di progetto. Per l'elaborazione esterna, incluso il lavoro WIP, il numero di articolo OSP e il codice della risorsa OSP. E per le destinazioni di spesa, anche quando non c'è un numero di articolo sulla linea dell'ordine di acquisto, questo rapporto otterrà le informazioni sulla categoria di spesa, nella prima colonna della categoria. (Nota: questo rapporto non è stato testato con le voci di ingombro). /* +=============================================================================+ -- | Copyright 2009- 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_wip_dist_xla_sum_rept.sql -- | -- | Parametri: -- | p_trx_date_from -- data iniziale della transazione per le transazioni contabili WIP, -- | obbligatorio. -- | p_trx_date_to -- data finale della transazione per le transazioni contabili WIP, -- | obbligatorio. -- | p_item_number -- Inserisci il numero di articolo specifico che vuoi segnalare (opzionale) -- | p_org_code -- Organizzazione specifica dell'inventario che vuoi riportare (opzionale) -- | p_operating_unit -- Unità operativa che volete segnalare, lasciate vuoto per tutte -- | unità operative (opzionale) -- p_ledger -- Contabilità generale che vuoi segnalare, lascia in bianco per tutti -- | ledger (opzionale) -- | p_category_set1 -- La prima categoria di voci da riportare, tipicamente la -- | categoria di costo o di linea di prodotto -- | p_category_set2 -- La seconda categoria di articoli da riportare, tipicamente la -- | Set di categorie di inventario -- | -- | Descrizione: -- | Report per ottenere le distribuzioni contabili WIP, in sintesi, per lavoro WIP, -- | risorse, spese generali e aggiornamento dei costi WIP. E per l'elaborazione esterna, -- | incluso il numero dell'ordine di acquisto, la linea e il numero di rilascio. -- | -- | Versione Modificata il Modificato da Descrizione -- | ======= =========== ============== ========================================= -- | 1.0 06 Nov 2009 Douglas Volz Codifica iniziale -- | 1.11 05 Jul 2019 Douglas Volz Aggiunto: -- | a) Aggiunto il breakout dei supporti di transazione per costo -- | elemento. -- | b) Aggiunta la somma delle ore di risorse / spese generali o -- | importi a una colonna di quantità primaria, più, -- | aggiunto il campo quantità UOM. -- | 1.12 23 Apr 2020 Douglas Volz Modificate le viste multilingue per l'elemento -- | master, categorie di articoli e unità operative. -- | Aggiunto il numero di progetto. -- +=============================================================================+*/ JA CAC Receiving Account Summary 受信会計の分配金を、項目別、発注書別、発注ライン別、リリース別、プロジェクト番号別にまとめて取得するレポート。 外部処理の場合は、WIPジョブ、OSP項目番号、OSPリソースコードを取得します。 また、支出先については、注文書ラインに項目番号がない場合でも、このレポートは、最初のカテゴリ列に支出カテゴリ情報を取得します。 (注: このレポートでは、不良債権エントリのテストは行っていません。) /* +=============================================================================+ --｜著作権 2009-2020 Douglas Volz Consulting, Inc. | | --｜このコードの使用を許可するには、原著作者が｜原著作者であることが条件となります。 -- : - - 認められています。 本製品には、明示的であるか否かにかかわらず、いかなる保証も含まれていません。 -- --｜permission. | -- +=============================================================================+ -- | -- --｜原著者。ダグラス・ヴォルツ (doug@volzconsulting.com) -- | --｜プログラム名: xxx_wip_dist_xla_sum_rept.sql -- | -- | パラメータ。 -- | p_trx_date_from -- WIP会計トランザクションのトランザクション開始日。 --｜必須。 -- | p_trx_date_to -- WIP会計トランザクションのトランザクション終了日。 --｜必須。 -- | p_item_number -- 報告したい特定の項目番号を入力してください(オプション) -- | p_org_code -- 報告したい特定のインベントリ組織 (オプション) -- | p_operating_unit -- 報告したい操作ユニット、すべて空白のままにしておく。 -- 操作ユニット(オプション) -- | p_ledger -- 報告したい総勘定元帳、すべて空白のままにしておきます。 --｜元帳（オプション | p_category_set1 -- レポートする最初の項目カテゴリセット、通常は -- コストまたは製品ラインのカテゴリーセット | p_category_set2 -- 報告するために設定された2番目の項目カテゴリ、通常は -- 在庫区分セット -- | --｜説明。 --｜WIPジョブ別にWIP会計分布をまとめて取得するレポートです。 -- リソース、オーバーヘッド、WIPコストの更新。 また、外部処理のため。 --｜注文書番号、ライン番号、リリース番号を含む。 -- | -- 説明文で変更されています。 -- | ======= =========== ============== ========================================= --｜1.0 2009年11月06日 ダグラス・ボルツ初期コーディング --｜1.11 05 Jul 2019 Douglas Volz 追加しました。 -- | a) コスト別のトランザクションマウントのブレイクアウトを追加しました。 --｜要素を追加しました。 -- b) リソース/オーバーヘッド時間の総和を加算したもの、または --｜一次量列の量をプラスしています。 --｜数量UOMフィールドを追加した。 -- | 1.12 23 Apr 2020 Douglas Volz アイテムの多言語表示に変更した。 --｜マスター、アイテムカテゴリ、運営単位を追加しました。 --｜プロジェクト番号を追加しました。 -- +=============================================================================+*/ KO CAC Receiving Account Summary 입고 회계 분배를 품목, 구매 오더, 구매 오더 라인, 릴리스 및 프로젝트 번호별로 요약하여 가져옵니다. WIP 작업, OSP 품목 번호 및 OSP 자원 코드를 포함한 외주 가공용. 비용 대상의 경우 구매 발주 라인에 품목 번호가없는 경우에도이 보고서는 비용 범주 정보를 첫 번째 범주 열로 가져옵니다. (참고 :이 보고서는 예산 가집행 입력으로 테스트되지 않았습니다.) / * + ============================================= ============================= + -| 저작권 2009-2020 Douglas Volz Consulting, Inc. | -| 판권 소유. | -| 이 코드를 사용할 수있는 권한은 원래 작성자가 | -| 인정. 여기에는 명시 적 또는 기타 어떠한 보증도 포함되지 않습니다. -| 허가. | -+ ============================================= ============================= + -| -| 원저자 : Douglas Volz (doug@volzconsulting.com) -| -| 프로그램 이름 : xxx_wip_dist_xla_sum_rept.sql -| -| 매개 변수 : -| p_trx_date_from-WIP 회계 거래의 시작 거래 일자, -| 필수. -| p_trx_date_to-WIP 회계 거래에 대한 거래 종료일, -| 필수. -| p_item_number-보고 할 특정 품목 번호를 입력합니다 (선택 사항). -| p_org_code-보고 할 특정 재고 조직 (선택 사항) -| p_operating_unit-보고 할 운영 단위, 모두 비워 둡니다. -| 운영 단위 (선택 사항) -| p_ledger-보고하려는 총계정 원장, 모두 비워 둡니다. -| 원장 (선택 사항) -| p_category_set1-보고 할 첫 번째 항목 범주 세트, 일반적으로 -| 비용 또는 제품 라인 범주 세트 -| p_category_set2-보고 할 두 번째 항목 범주로, 일반적으로 -| 재고 범주 세트 -| -| 기술: -| 요약하면 WIP 작업별로 WIP 계정 분배를 가져 오는 보고서, -| 자원, 간접비 및 WIP 비용 갱신. 그리고 외주 가공의 경우 -| 구매 오더 번호, 라인 및 릴리스 번호를 포함합니다. -| -| 수정 된 버전 설명에 의해 수정 됨 -| ======= =========== =============================== ======================= -| 1.0 2009 년 11 월 6 일 Douglas Volz 초기 코딩 -| 1.11 2019 년 7 월 5 일 Douglas Volz 추가 : -| a) 비용에 따른 트랜잭션 마운트의 브레이크 아웃 추가 -| 요소. -| b) 자원 / 간접 시간의 합계를 추가하거나 -| 기본 수량 열에 금액을 추가하고 -| 수량 UOM 필드를 추가했습니다. -| 1.12 2020 년 4 월 23 일 Douglas Volz 항목에 대한 다국어보기로 변경됨 -| 마스터, 품목 범주 및 운영 단위. -| 프로젝트 번호가 추가되었습니다. -+ ============================================== ============================= + * / PTB CAC Receiving Account Summary Relatório para obter as distribuições contábeis de recebimento, em resumo, por item, pedido de compra, linha de pedido de compra, liberação e número do projeto. Para processamento externo, incluindo o trabalho WIP, número do item OSP e o código do recurso OSP. E para destinos de despesas, mesmo quando não há número de item na linha do pedido de compra, este relatório obterá as informações de categoria de despesas, na primeira coluna de categoria. (Nota: este relatório não foi testado com entradas de ônus). /* +=============================================================================+ | Copyright 2009- 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_wip_dist_xla_sum_rept.sql | Parâmetros: | p_trx_date_from -- data de início da transação para as transações contábeis WIP, | obrigatório. | p_trx_date_to -- data final de transação para transações contábeis WIP, | obrigatório. | p_item_number -- Insira o número do item específico que você deseja relatar (opcional) | p_org_code -- Organização de inventário específica que você deseja relatar (opcional) | p_operating_unit -- 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_category_set1 -- A primeira categoria de item definida para relatar, tipicamente o | Conjunto de Categorias de Custo ou Linha de Produtos | p_category_set2 -- A segunda categoria de item definida para relatar, tipicamente o | Conjunto de Categorias de Estoque -- | Descrição: | Relatório para obter as distribuições da contabilidade WIP, em resumo, por trabalho WIP, | atualização de recursos, despesas gerais e custos WIP. E para processamento externo, | incluindo o número do pedido de compra, linha e número de liberação. | Versão Modificada em Modificada por Descrição -- | ======= =========== ============== ========================================= | 1.0 06 Nov 2009 Douglas Volz Codificação Inicial | 1.11 05 Jul 2019 Douglas Volz Adicionado: | | a) Adicionada a quebra de montagens de transação por custo | elemento. -- | b) Acrescentou a soma dos recursos / horas gerais ou | corresponde a uma coluna de quantidade primária, mais, | acrescentou o campo UOM de quantidade. | 1.12 23 Abr 2020 Douglas Volz Mudou para visualizações em vários idiomas para o item | categorias principais, itens e unidades operacionais. -- | Adicionado número do projeto. -- +=============================================================================+*/ S CAC Receiving Account Summary Rapportera för att få de mottagande redovisningsfördelningarna, i sammandrag, efter artikel, inköpsorder, inköpsorderrad, release och projektnummer. För extern bearbetning, inklusive WIP-jobb, OSP-artikelnummer och OSP-resurskod. Och för utgiftsdestinationer, även när det inte finns något artikelnummer på inköpsordern, kommer denna rapport att få information om utgiftskategorin i den första kategorikolumnen. (Obs! Den här rapporten har inte testats med inteckningar.) / * + ================================================== ================================ + - | Upphovsrätt 2009-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_wip_dist_xla_sum_rept.sql - | - | Parametrar: - | p_trx_date_from - startdatum för WIP-redovisningstransaktioner, - | obligatorisk. - | p_trx_date_to - avslutande transaktionsdatum för WIP-redovisningstransaktioner, - | obligatorisk. - | p_item_number - Ange det specifika artikelnummer du vill rapportera (valfritt) - | p_org_code - Specifik inventeringsorganisation som du vill rapportera (valfritt) - | 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_category_set1 - Den första artikelkategorin som ska rapporteras, vanligtvis - | Kostnad eller produktlinjekategoriuppsättning - | p_category_set2 - Den andra artikelkategorin som ska rapporteras, vanligtvis - | Inventory Category Set - | - | Beskrivning: - | Rapportera för att få WIP-redovisningen fördelat, i sammandrag, efter WIP-jobb, - | resurs-, overhead- och WIP-kostnadsuppdatering. Och för extern bearbetning, - | inklusive inköpsordernummer, rad och släppnummer. - | - | Version modifierad på modifierad av beskrivning - | ===================================================== ========================= - | 1.0 06 nov 2009 Douglas Volz inledande kodning - | 1.11 05 jul 2019 Douglas Volz Tillagt: - | a) Lade till fördelningen av transaktionsbelopp per kostnad - | element. - | b) Lade till summan av resurs / allmänna timmar eller - | uppgår till en primär kvantitetskolumn, plus - | lagt till antal UOM-antal. - | 1.12 23 apr 2020 Douglas Volz Ändrad till flerspråkiga vyer för artikeln - | master, artikelkategorier och driftenheter. - | Lagt till projektnummer. - + ================================================== ================================ + * / TR CAC Receiving Account Summary Özet olarak, kalem, satınalma siparişi, satınalma siparişi satırı, sürüm ve proje numarasına göre alıcı muhasebe dağıtımlarını almak için rapor. WIP işi, OSP öğe numarası ve OSP kaynak kodu dahil olmak üzere harici işlemler için. Ve harcama hedefleri için, satınalma siparişi satırında kalem numarası olmasa bile, bu rapor ilk kategori sütununa gider kategorisi bilgilerini alacaktır. (Not: bu rapor ipotek girişleriyle test edilmemiştir.) / * + ============================================= ============================ + - | Telif Hakkı 2009-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_wip_dist_xla_sum_rept.sql - | - | Parametreler: - | p_trx_date_from - Devam Eden Çalışma muhasebe işlemleri için işlem başlangıç tarihi, - | zorunlu. - | p_trx_date_to - Yarı mamul muhasebe işlemleri için işlem tarihinin sona erdirilmesi, - | zorunlu. - | p_item_number - Bildirmek istediğiniz belirli öğe numarasını girin (isteğe bağlı) - | p_org_code - Raporlamak istediğiniz belirli envanter organizasyonu (isteğe bağlı) - | 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_category_set1 - Raporlanacak ilk öğe kategorisi, genellikle - | Maliyet veya Ürün Grubu Kategori Kümesi - | p_category_set2 - Raporlanacak ikinci öğe kategorisi, genellikle - | Envanter Kategori Kümesi - | - | Açıklama: - | Devam Eden Çalışma muhasebesi dağıtımlarının özet olarak WIP işi ile alınabilmesi için rapor, - | kaynak, genel gider ve Devam Eden Çalışma maliyet güncellemesi. Ve dış işleme için, - | satın alma siparişi numarası, satırı ve sürüm numarası dahil. - | - | Açıklamaya Göre Değiştirildiğinde Değiştirilen Sürüm - | ======= =========== ============== ================== ======================= - | 1.0 06 Kas 2009 Douglas Volz İlk Kodlama - | 1.11 05 Tem 2019 Douglas Volz Eklendi: - | a) Maliyete göre işlem bağlantılarının kırılması eklendi - | öğesi. - | b) Kaynak / genel gider saatlerinin toplamı eklendi veya - | tutarları birincil miktar sütunu artı, - | miktar UOM alanını ekledi. - | 1.12 23 Nis 2020 Douglas Volz Öğenin çoklu dil görünümlerine değiştirildi - | ana, ürün kategorileri ve işletim birimleri. - | Proje Numarası eklendi. - + =============================================== ============================ + * / US CAC Receiving Account Summary Report to get the receiving accounting distributions, in summary, by item, purchase order, purchase order line, release and project number. With the Show SLA Accounting parameter you can choose to use the Release 12 Subledger Accounting (Create Accounting) account setups by selecting Yes. And if you have not modified your SLA accounting rules, select No to allow this report to run a bit faster. With parameters to limit the report size, to display or not display purchase information (purchase order, line, release) and WIP outside processing information (WIP job and OSP resource code). And if you accrue expense receipts at time of receipt, for expense destinations when there is no item number, this report will get the expense category information and put it into the columns for the first category set. (Note: this report has not been tested with encumbrance entries.) Parameters: =========== Transaction Date From: enter the starting transaction date (mandatory). Transaction Date To: enter the ending transaction date (mandatory). Show SLA Accounting: enter Yes to use the Subledger Accounting rules for your accounting information (mandatory). If you choose No the report uses the pre-Create Accounting entries. Show Purchase Orders: display the purchase order, line and release information. Enter Yes or No, use to limit the report size (mandatory). Show Projects: display the project number and name. Enter Yes or No, use to limit the report size (mandatory). Show WIP Outside Processing: display the WIP job and outside processing resource. Enter Yes or No, use to limit the report size (mandatory). Category Set 1: any item category you wish, typically the Cost or Product Line category set (optional). Category Set 2: any item category you wish, typically the Inventory category set (optional). Supplier Name: enter the specific supplier you wish to report (optional). PO Number: enter the specific purchase order number you wish to report (optional). Destination Code: enter the purchase order destination type you wish to report (optional). You can choose Inventory, Expense or Shop Floor (WIP outside processing). Item Number: enter the specific item number(s) you wish to report (optional). Organization Code: enter the specific inventory organization(s) you wish to report (optional). Operating Unit: enter the specific operating unit(s) you wish to report (optional). Ledger: enter the specific ledger(s) you wish to report (optional). /* +=============================================================================+ -- | Copyright 2009- 2022 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. -- +=============================================================================+ -- | -- | Version Modified on Modified by Description -- | ======= =========== ============== ========================================= -- | 1.0 06 Nov 2009 Douglas Volz Initial Coding -- | 1.15 17 Sep 2021 Douglas Volz Parameter changes, adding item number, PO number. -- | 1.16 08 Jul 2022 Douglas Volz Subledger Accounting performance improvements -- | and parameter to show or not show PO information. -- | 1.17 14 Aug 2022 Douglas Volz Revision for expense/no item receipts. -- | Combine SLA and Non-SLA Receiving Acct Reports. Make -- | Show SLA, Show PO and Show WIP OSP dynamic SQL parameters. -- | 1.18 21 Aug 2022 Douglas Volz Streamline dynamic SQL code. -- | 1.19 03 Sep 2022 Douglas Volz Language translations for Accounting Line Types. -- +=============================================================================+*/ ZHS CAC Receiving Account Summary 报表获取接收会计分配，按项目、采购单、采购单行、放行和项目编号汇总。 对于外部处理，包括WIP作业、OSP项目号和OSP资源代码。 而对于费用去向，即使采购单行上没有项目编号，本报表也会得到费用类别信息，进入第一个类别栏。 (注：本报告尚未对负担条目进行测试。) /* +=============================================================================+ -- | 版权所有 2009-2020 道格拉斯-沃尔兹咨询公司。 | -- 保留所有权利。 | -- 允许使用该代码，但前提是原作者必须是｜。 -- 认可。 不包含任何明示或暗示的保证。 -- 允许。 | -- +=============================================================================+ -- | -- 原作者：Douglas Volz ()Douglas Volz (doug@volzconsulting.com) -- | -- 程序名称：xxx_wip_dist_xla_sum_rept.sql。 -- | -- 参数。 -- p_trx_date_from -- WIP核算交易的起始交易日期。 |--强制性的。 -- p_trx_date_to -- WIP会计交易的结束交易日期。 -- 必须填写。 -- p_item_number -- 输入您想报告的具体项目编号（可选）。 -- -- p_org_code -- -- 您希望报告的具体清单组织（可选）。 -- | p_operating_unit -- 您希望报告的操作单位，所有单位留空。 -- 操作单元(可选) -- p_ledger -- 你想报告的总账，所有的总账留空。 -- 账目（可选） -- p_category_set1 -- 要报告的第一个项目类别，通常是p_category_set1。 -- 成本或产品系列类别集 -- p_category_set2 -- 要报告的第二个项目类别，通常是p_category_set2。 -- 库存类别集 -- | -- 描述。 -- 按WIP作业获取WIP核算分布情况的报告。 -- 资源、间接费用和在制品成本更新。 并用于外部加工。 -- 包括订单号、行号和放行号。 -- | -- | ======= =========== ============== ========================================= | 1.0 2009年11月6日 道格拉斯-沃尔兹初始编码。 -- | 1.11 05 Jul 2019 Douglas Volz 新增。 -- | a) 添加了按成本划分的交易挂载的分类。 -- b) 增加了资源/间接费用小时数的总和，或增加了资源/间接费用小时数的总和。 -- b) 增加了资源/间接费用小时数的总和或 |相当于一个主要数量列，加上。 -- 增加了数量UOM字段。 -- 1.12 2020年4月23日 Douglas Volz 改为多语言浏览项目。 -- 增加了项目编号。 -- -- 增加了项目编号。 -- +=============================================================================+*/ Enginatics R12 only &category_columns &group_by_project &group_by_purchase_order &group_by_wip_osp &order_by_project &order_by_purchase_order &order_by_wip_osp &osp_wip_table_joins &p_show_project &p_show_purchase_order &p_show_wip_osp &project_table_joins &project_tables &rcv_non_sla_table_joins &rcv_sla_table_joins &rcv_sla_tables &segment_columns &segment_columns_grp &wip_osp_tables 1=1 4=4 1 -10 &segment_columns select 'gcc.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=:chart_of_accounts) order by fifsv.segment_num 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=(select ood.chart_of_accounts_id from org_organization_definitions ood where ood.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) Y US Chart of Accounts 2 &segment_columns_grp select 'gcc.'||lower(fifsv.application_column_name)||',' text from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=:chart_of_accounts) order by fifsv.segment_num US Chart of Accounts 3 10 4=4 rae.transaction_date >= :p_trx_date_from and rrsl.transaction_date >= :p_trx_date_from Date select max(oap.period_start_date) from org_acct_periods oap, mtl_parameters mp where mp.organization_id = oap.organization_id and mp.organization_id <> mp.master_organization_id Y US Transaction Date From 4 20 4=4 rae.transaction_date < :p_trx_date_to + 1 and rrsl.transaction_date < :p_trx_date_to + 1 Date select max(oap.schedule_close_date) from org_acct_periods oap, mtl_parameters mp where mp.organization_id = oap.organization_id and mp.organization_id <> mp.master_organization_id Y US Transaction Date To 5 30 &rcv_sla_tables xla_distribution_links xdl, xla_ae_headers ah, xla_ae_lines al, LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y Y US Show SLA Accounting 6 &rcv_non_sla_table_joins and gcc.code_combination_id (+) = acct_dist.code_combination_id N US Show SLA Accounting 7 &rcv_sla_table_joins and ah.ledger_id = gl.ledger_id and ah.application_id = al.application_id and ah.application_id = 707 and ah.ae_header_id = al.ae_header_id and al.ledger_id = ah.ledger_id and al.ae_header_id = xdl.ae_header_id and al.ae_line_num = xdl.ae_line_num and xdl.application_id = 707 and xdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER' and xdl.source_distribution_id_num_1 = acct_dist.rcv_sub_ledger_id and gcc.code_combination_id (+) = al.code_combination_id Y US Show SLA Accounting 8 40 &p_show_purchase_order acct_dist.po_num PO_Number, acct_dist.po_line PO_Line, (select pr.release_num from po_releases_all pr where pr.po_release_id = acct_dist.po_release_id) Release_Number, LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y Y US Show Purchase Orders 9 &group_by_purchase_order acct_dist.po_num, acct_dist.po_line, acct_dist.po_release_id, Y US Show Purchase Orders 10 &order_by_purchase_order ,acct_dist.po_num -- PO_Number ,acct_dist.po_line -- PO_Line ,(select pr.release_num from po_releases_all pr where pr.po_release_id = acct_dist.po_release_id) Y US Show Purchase Orders 11 50 &p_show_project pp.segment1 Project_Number, pp.name Project_Name, LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N Y US Show Projects 12 &group_by_project pp.segment1, pp.name, Y US Show Projects 13 &order_by_project ,pp.segment1 ,pp.name Y US Show Projects 14 &project_table_joins and pp.project_id (+) = acct_dist.project_id Y US Show Projects 15 &project_tables pa_projects_all pp, Y US Show Projects 16 60 &p_show_wip_osp we.wip_entity_name WIP_Job, br.resource_code Resource_Code, LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N Y US Show WIP Outside Processing 17 &group_by_wip_osp we.wip_entity_name, br.resource_code, Y US Show WIP Outside Processing 18 &order_by_wip_osp ,we.wip_entity_name ,br.resource_code Y US Show WIP Outside Processing 19 &osp_wip_table_joins and we.wip_entity_id (+) = acct_dist.wip_entity_id and br.resource_id (+) = acct_dist.bom_resource_id Y US Show WIP Outside Processing 20 &wip_osp_tables wip_entities we, bom_resources br, Y US Show WIP Outside Processing 21 70 &category_columns select x.* from ( select '(select min(mcb.'||lower(fifsv.application_column_name)||') keep (dense_rank first order by mcb.category_id) from mtl_item_categories mic, mtl_categories_b mcb where ((mic.category_set_id='||mcsv.category_set_id||' and acct_dist.to_organization_id=mic.organization_id and acct_dist.item_id=mic.inventory_item_id and mic.category_id=mcb.category_id) or (acct_dist.category_id=mcb.category_id and acct_dist.item_id is null) ) ) "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",' sql_text from mtl_category_sets_vl mcsv, (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where mcsv.category_set_name=:category_set_name1 and mcsv.structure_id=fifsv.id_flex_num and fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and fifsv.enabled_flag='Y' order by fifsv.id_flex_num, fifsv.segment_num ) x union all select '(select min(mct.description) keep (dense_rank first order by mct.category_id) from mtl_item_categories mic, mtl_categories_tl mct where ((mic.category_set_id='||mcsv.category_set_id||' and acct_dist.to_organization_id=mic.organization_id and acct_dist.item_id=mic.inventory_item_id and mic.category_id=mct.category_id and mct.language=userenv(''lang'')) or (acct_dist.category_id=mct.category_id and mct.language=userenv(''lang'')and acct_dist.item_id is null) ) ) "'||substrb(mcsv.category_set_name||' Description',1,xxen_report.max_column_length)||'",' sql_text from mtl_category_sets_vl mcsv where mcsv.category_set_name=:category_set_name1 LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=11)) US Category Set 1 22 80 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'acct_dist', p_item_id_column=>'item_id', p_org_id_column=>'to_organization_id') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=5)) US Category Set 2 23 90 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'acct_dist', p_item_id_column=>'item_id', p_org_id_column=>'to_organization_id') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name xxen_util.previous_parameter_value(:parameter_id) US Category Set 3 24 100 4=4 pov.vendor_name = :p_supplier_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US Supplier Name 25 110 4=4 poh.segment1 = :p_po_number LOV custom Y Y select pha.segment1 value, xxen_util.meaning(pha.type_lookup_code,'PO TYPE',201)||nvl2(aps.vendor_name,': '||aps.vendor_name,null) description from po_headers_all pha, ap_suppliers aps where pha.org_id in (select haouv.organization_id 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 )) and pha.vendor_id=aps.vendor_id(+) order by pha.creation_date desc US PO Number 26 120 1=1 pl.displayed_field = :p_dest_type_code LOV PO Destination Type Code A6579155E9B2D355E053BB6B6358ED35 Y select plc.displayed_field value, plc.description from po_lookup_codes plc where plc.lookup_type='DESTINATION TYPE' order by plc.displayed_field US Destination Code 27 130 4=4 msiv.concatenated_segments = :p_item_number LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Item Number 28 140 4=4 mp.organization_code = :p_org_code LOV custom Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where mp.organization_id=mp.master_organization_id) and ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code 29 150 1=1 haou2.name = :p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name US Operating Unit 30 160 1=1 gl.name = :p_ledger LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select 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 :$flex$.chart_of_accounts Chart of Accounts Ledger :$flex$.ledger Ledger Operating Unit :$flex$.ledger Ledger Organization Code :$flex$.operating_unit Operating Unit Organization Code :$flex$.operating_unit Operating Unit Supplier Name :$flex$.organization_code Organization Code Category Set 1 :$flex$.organization_code Organization Code Category Set 2 :$flex$.organization_code Organization Code Category Set 3 :$flex$.organization_code Organization Code Item Number :$flex$.organization_code Organization Code Supplier Name