ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F8E51A9E05362FB09050512Y SELECT -- Account Sort_option , sum(c_debits) sum_debits , sum(c_credits) sum_credits , sum(c_debits)-sum(c_credits) Net_activity, C_acct_pad, C_acct_field, -- BOM_CSTRPDSS_XMLP_PKG.cf_dr_acct_tot_rformula(:C_dr_acct_tot) CF_dr_acct_tot_r, -- BOM_CSTRPDSS_XMLP_PKG.cf_cr_acct_tot_rformula(:C_cr_acct_tot) CF_cr_acct_tot_r, -- BOM_CSTRPDSS_XMLP_PKG.cf_acct_tot_rformula(:C_acct_tot) CF_acct_tot_r, Sort_option C_item_field_1, BOM_CSTRPDSS_XMLP_PKG.cf_sum_debits_rformula(sum ( c_debits )) CF_sum_debits_r, BOM_CSTRPDSS_XMLP_PKG.cf_sum_credits_rformula(sum ( c_credits )) CF_sum_credits_r, BOM_CSTRPDSS_XMLP_PKG.cf_net_activity_rformula(sum ( c_debits ) - sum ( c_credits )) CF_net_activity_r FROM ( SELECT fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_pad', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_acct_pad, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_field', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_acct_field , decode(:p_sort_id, 1, &C_item_field1, &p_sort_option) Sort_option , nvl(cal.accounted_dr,0) c_debits , nvl(cal.accounted_cr,0) c_credits , cal.ae_line_id FROM cst_ae_lines cal , cst_ae_headers cah , gl_code_combinations gcc , mtl_material_transactions mmt &p_mat_table_from WHERE :p_wip = 2 AND cal.ae_header_id = cah.ae_header_id AND cal.code_combination_id = gcc.code_combination_id AND cah.cost_group_id = :p_cost_group_id AND cah.cost_type_id = :p_cost_type_id AND cah.period_id = :p_period_id AND cah.accounting_event_id = mmt.transaction_id AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id) AND nvl(mmt.owning_tp_type,2) = 2 AND cah.acct_event_source_table = 'MMT' AND &plex_account_where &p_mat_where UNION SELECT fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_pad', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_acct_pad, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_field', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_acct_field , decode(:p_sort_id, 1, &C_item_field1, 2, rt.transaction_type, 3, rt.source_document_code) Sort_option , nvl(cal.accounted_dr,0) c_debits , nvl(cal.accounted_cr,0) c_credits , cal.ae_line_id FROM cst_ae_lines cal , cst_ae_headers cah , gl_code_combinations gcc , rcv_transactions rt &p_rcv_table_from WHERE :p_wip = 2 AND cal.ae_header_id = cah.ae_header_id AND cal.code_combination_id = gcc.code_combination_id AND cah.cost_group_id = :p_cost_group_id AND cah.cost_type_id = :p_cost_type_id AND cah.period_id = :p_period_id AND cah.accounting_event_id = rt.transaction_id AND NVL(rt.consigned_flag, 'N') = 'N' AND cah.acct_event_source_table = 'RT' AND &plex_account_where &p_rcv_where UNION SELECT fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_pad', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_acct_pad, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_field', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_acct_field , decode(:p_sort_id, 1, &C_item_field1, 2, rt.transaction_type, 3, rt.source_document_code) Sort_option , nvl(cal.accounted_dr,0) c_debits , nvl(cal.accounted_cr,0) c_credits , cal.ae_line_id FROM cst_ae_lines cal , cst_ae_headers cah , gl_code_combinations gcc , rcv_transactions rt , rcv_accounting_events rae &p_rcv_table_from WHERE :p_wip = 2 AND cal.ae_header_id = cah.ae_header_id AND cal.code_combination_id = gcc.code_combination_id AND cah.cost_group_id = :p_cost_group_id AND cah.cost_type_id = :p_cost_type_id AND cah.period_id = :p_period_id AND cah.accounting_event_id = rae.accounting_event_id AND rae.rcv_transaction_id = rt.transaction_id AND NVL(rt.consigned_flag, 'N') = 'N' AND cah.acct_event_source_table = 'RAE' AND &plex_account_where &p_rcv_where UNION SELECT fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_pad', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_acct_pad, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_field', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_acct_field , ml.meaning Sort_option , nvl(cal.accounted_dr,0) c_debits , nvl(cal.accounted_cr,0) c_credits , cal.ae_line_id FROM cst_ae_lines cal , cst_ae_headers cah , gl_code_combinations gcc , wip_transactions wt , mfg_lookups ml WHERE :p_wip = 1 AND cal.ae_header_id = cah.ae_header_id AND cal.code_combination_id = gcc.code_combination_id AND cah.cost_group_id = :p_cost_group_id AND cah.cost_type_id = :p_cost_type_id AND cah.period_id = :p_period_id AND cah.accounting_event_id = wt.transaction_id AND cah.acct_event_source_table = 'WT' AND ml.lookup_code = wt.transaction_type AND ml.lookup_type = 'WIP_TRANSACTION_TYPE_SHORT' AND &plex_account_where ) GROUP BY -- Account -- , C_acct_pad, C_acct_field, Sort_option /* Order By 1 ,2*/ order by 5,6,10,4 BOM CSTRPWDS_XML AR CST تقرير إجمالي توزيع ما تحت التنفيذ الدوري (تنسيق XML) Imported from BI Publisher Description: تقرير إجمالي توزيع ما تحت التنفيذ الدوري Application: شجرة المنتجات Source: تقرير إجمالي توزيع ما تحت التنفيذ الدوري (تنسيق XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG D CST Periodische Fertigungsaufteilung - Übersicht Imported from BI Publisher Description: Periodische Kontenaufteilungen/Fertigung - Übersicht Application: Produktionsdaten Source: Periodische Fertigungsaufteilung - Übersicht (XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG E CST Resumen Periódico de Distribución de Obra en Curso Imported from BI Publisher Description: Informe Resumen de Distribución Periódica de Cuenta de Obra en Curso Application: Bills of Material Source: Resumen Periódico de Distribución de Obra en Curso (XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG F CST Etat Synthèse des imputations périodiques de la production Imported from BI Publisher Description: Etat de synthèse des répartitions comptables atelier périodiques Application: Bills of Material Source: Etat Synthèse des imputations périodiques de la production (XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG I CST Rapporto Sintetico distribuzione WIP periodica Imported from BI Publisher Description: Rapporto periodico Sintetico distribuzioni conti WIP Application: Bills of Material Source: Rapporto Sintetico distribuzione WIP periodica (XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG JA CST 期間WIP配分要約レポート Imported from BI Publisher Description: 期間WIP勘定科目配分要約レポート Application: Bills of Material Source: 期間WIP配分要約レポート(XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG KO CST 기간별 WIP 분배 요약 보고서 Imported from BI Publisher Description: 기간별 WIP 계정 분배 요약 보고서 Application: Bills of Material Source: 기간별 WIP 분배 요약 보고서(XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG PTB CST Relatório Sumariado de Distribuição WIP (Periódico) Imported from BI Publisher Description: Relatório periódico sumário de distribuições do WIP Application: Bills of Material Source: Relatório Sumariado de Distribuição WIP (Periódico) (XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG RU CST Сводный отчет о периодических распределениях НзП Imported from BI Publisher Description: Сводный отчет о периодических распределениях счетов НзП Application: Спецификации Source: Сводный отчет о периодических распределениях НзП (XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG S CST Periodisk kontering av PIA - översiktsrapport Imported from BI Publisher Description: Periodiska konteringar av PIA - översiktsrapport Application: Bills of Material Source: Periodisk kontering av PIA - översiktsrapport (XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG TR CST Dönemsel WIP Dağıtım Özet Raporu Imported from BI Publisher Description: Dönemsel WIP hesap dağıtımları özet raporu Application: Ürün Ağacı Source: Dönemsel WIP Dağıtım Özet Raporu (XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG US CST Periodic WIP Distribution Summary Imported from BI Publisher Description: Periodic WIP account distributions summary report Application: Bills of Material Source: Periodic WIP Distribution Summary Report (XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG ZHS CST 定期 WIP 分配汇总报表 Imported from BI Publisher Description: 定期 WIP 帐户分配汇总报表 Application: 物料清单管理系统 Source: 定期 WIP 分配汇总报表 (XML) Short Name: CSTRPWDS_XML DB package: BOM_CSTRPDSS_XMLP_PKG BI Publisher &c_item_field1 &p_mat_table_from &p_mat_where &p_rcv_table_from &p_rcv_where &p_sort_option &plex_account_where :cp_acct_id :cp_application :cp_cost_group :cp_cost_type :cp_legal_entity :cp_period_name :cp_precision :cp_request_time :cp_requested_by :cp_responsibility :p_acct_from :p_acct_to :p_conc_request_id :p_cost_group_id :p_cost_type_id :p_gl_struct_num :p_item_struct_num :p_mat_table_from :p_mat_where :p_period_id :p_quantity_precision :p_rcv_table_from :p_rcv_where :p_sort_id :p_sort_option :p_wip :plex_account_flex :plex_account_where :plex_item_flex :qty_precision :r_currency_code 1 -50 :p_wip Number 1 Y AR p_wip طور ما تحت التنفيذ = نعم (القيمة الافتراضية 1) D p_wip Fertigungsmodus = Ja (Standardwert 1) E p_wip Modo WIP = Sí (valor por defecto 1) F p_wip Mode WIP = Oui (valeur par défaut 1) I p_wip Modalità WIP = Sì (valore predefinito 1) JA p_wip WIPモード = Yes (デフォルト値は1) KO p_wip WIP 모드 = Yes (기본값 1) PTB p_wip Modo do WIP = Sim (valor padrão 1) RU p_wip Режим НзП = Да (стандартное значение 1) S p_wip PIA-läge = Ja (standardvärde 1) TR p_wip WIP modu = Evet (öndeğer 1) US p_wip WIP mode = Yes (default value 1) ZHS p_wip WIP 模式 = 是（默认值 1） 2 -40 :p_sort_id Number 2 Y AR فرز بواسطة معرف خيار الفرز D Sortieren nach Kennung Sortieroption E Ordenar por Identificador de Opción de Clasificación F Tri par ID option de tri I Ordina per ID opzione di ordinamento JA ソート・キー ソート・オプションID KO 정렬 기준 정렬 옵션 ID PTB Classificar por ID da opção de classificação RU Сортировка Идентификатор параметра сортировки S Sortera efter Id för sorteringsalternativ TR Sıralama bazı Sıralama senek no US Sort by Sort option ID ZHS 排序依据 排序选项标识 3 -30 :p_gl_struct_num LOV Oracle CST_SRS_PAC_AP_COAID_BY_LECT Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_sets_of_books where set_of_books_id in (select set_of_books_id from cst_le_cost_types where cost_type_id=:$flex$.cst_srs_pac_ct_proc and legal_entity=:$flex$.cst_srs_pac_ap_le ) order by value,description SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id IN (SELECT set_of_books_id FROM cst_le_cost_types WHERE legal_entity = :$flex$.legal_entity and cost_type_id = :$flex$.cost_type) Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات - معامل مخفي D Kontenplankennung Kontenplan - verborgenes Feld E Id Plan de Cuentas Identificador de Plan de Cuentas: Parámetro oculto F ID plan de comptes ID plan de comptes - paramètre caché I ID piano dei conti ID piano dei conti - parametro nascosto JA 勘定体系ID 勘定体系ID - 隠しパラメータ KO 계정 코드집 ID 계정 코드집 ID - 숨은 매개변수 PTB ID do Plano de Contas ID do plano de contas - parâmetro oculto RU Идентификатор плана счетов Идентификатор плана счетов - скрытый параметр S Kontoplans-id Kontoplans-id - dold parameter TR Hesap Planı No Hesap planı no - gizli parametre US Chart of Accounts ID Chart of account ID - hidden parameter ZHS 科目表标识 科目表标识 - 隐藏参数 4 -20 :p_quantity_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') Y AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión de Cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점 이하 자리수 수량 소수점이하 자리수 PTB Precisão da Quantidade Precisão da quantidade RU Точность количества Точность количества S Kvantitetsprecision Kvantitetsprecision TR Miktar Duyarlılığı Miktar duyarlılığı US Quantity Precision Quantity precision ZHS 数量精确度 数量精确度 5 10 :p_legal_entity_id LOV Oracle CST_SRS_PAC_AP_LE Y select legal_entity_id id, name value, null description from xle_firstparty_information_v where legal_entity_id in (select distinct legal_entity from cst_le_cost_types where create_acct_entries='Y') order by value,description Y AR الكيان القانوني كيان قانوني D Mandant Mandant E Entidad Legal Entidad Legal F Entité juridique Entité juridique I Persona giuridica Persona giuridica JA 法的エンティティ 法的エンティティ KO 법인 법인 PTB Pessoa Jurídica Pessoa jurídica RU Юридическое лицо Юридическое лицо S Juridisk enhet Juridisk enhet TR Tüzel Kişilik Tüzel kişilik US Legal Entity Legal entity ZHS 法人主体 法人主体 6 20 :p_cost_type_id LOV Oracle CST_SRS_PAC_CT_PROC Y select ct.cost_type_id id, ct.cost_type value, null description from cst_cost_types ct where ct.cost_type_id in (select distinct cost_type_id from cst_le_cost_types where legal_entity=:$flex$.cst_srs_pac_ap_le and create_acct_entries='Y') and exists (select 1 from cst_pac_periods where pac_period_id in (select pac_period_id from cst_pac_process_phases where process_phase=6 and process_status=4) and cost_type_id=ct.cost_type_id) and nvl(disable_date,sysdate+1)>sysdate order by value,description Y AR نوع التكلفة نوع التكلفة D Kostentyp Kostentyp E Tipo de Coste Tipo de Coste F Type de coût Type de coût I Tipo di costo Tipo di costo JA 原価タイプ 原価タイプ KO 원가 유형 원가 유형 PTB Tipo de Custo Tipo de custo RU Тип затрат Тип затрат S Kostnadstyp Kostnadstyp TR Maliyet Tipi Maliyet tipi US Cost Type Cost type ZHS 成本类型 成本类型 7 30 :p_cost_group_id LOV Oracle CST_SRS_PAC_CG_PROC Y select ccg.cost_group_id id, ccg.cost_group value, null description from cst_cost_groups ccg where ccg.legal_entity=:$flex$.cst_srs_pac_ap_le and exists (select 1 from cst_pac_periods cpp where legal_entity=:$flex$.cst_srs_pac_ap_le and cost_type_id=:$flex$.cst_srs_pac_ct_proc and cpp.pac_period_id in (select cppp.pac_period_id from cst_pac_process_phases cppp where cppp.cost_group_id=ccg.cost_group_id and process_phase=6 and process_status=4 ) ) order by value,description Y AR مجموعة تكاليف التنظيم مجموعة التكاليف D Organisations-Kostengruppe Kostengruppe E Grupo de Costes de Organización Grupo de Costes F Groupe de coûts organisation Groupe de coûts I Gruppo di costi organizzazione Gruppo di costi JA 組織原価グループ 原価グループ KO 조직 원가 그룹 원가 그룹 PTB Grupo de Custos da Organização Grupo de Custos RU Группа затрат для организации Группа затрат S Kostnadsgrupp för organisation Kostnadsgrupp TR Organizasyon Maliyet Grubu Maliyet grubu US Organization Cost Group Cost group ZHS 组织成本组 成本组 8 40 :p_period_id LOV Oracle CST_SRS_PAC_PRD_PROC Y select cpp.pac_period_id id, cpp.period_name value, null description from cst_pac_periods cpp where cpp.legal_entity=:$flex$.cst_srs_pac_ap_le and cpp.cost_type_id=:$flex$.cst_srs_pac_ct_proc and pac_period_id in (select distinct pac_period_id from cst_pac_process_phases where cost_group_id=:$flex$.cst_srs_pac_cg_proc and process_phase=6 and process_status=4) order by value,description Y AR الفترة فترة دورية D Periode Periodische Periode E Período Período Periódico F Période Période I Periodo Periodo per periodo JA 期間 期間別期間 KO 기간 기간별 기간 PTB Período Período (periódico) RU Период Периодический период S Period Periodiseringsperiod TR Dönem Dönemsel dönem US Period Periodic period ZHS 期间 定期期间 9 50 :p_acct_from Char AR حساب من الحساب من D Von Konto Von Konto E De Cuenta De Cuenta F Compte - De Compte - De I Conto - Da Conto - Da JA 勘定科目:自 勘定科目:自 KO 계정: 부터 계정: 부터 PTB Conta - De Conta - de RU Счет с Счет с S Från konto Från konto TR Hesap, İlk İlk Hesap US Account From Account from ZHS 帐户自 帐户自 10 60 :p_acct_to Char AR إلى حساب إلى حساب D Bis Konto Bis Konto E A Cuenta A Cuenta F Compte - A Compte - A I Conto - A Conto - A JA 勘定科目:至 勘定科目:至 KO 계정: 까지 계정: 까지 PTB Conta - até Conta - até RU Счет по Счет по S Till konto Till konto TR Son Hesap Son Hesap US Account to Account to ZHS 帐户至 帐户至