ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F8851A9E05362FB09050512Y SELECT CCG.cost_group costgroup, CCG.description description, ROUND(SUM(NVL(CPCSV.inventory_value,0)),:c_std_prec) sum_value FROM cst_cost_groups CCG, cst_cost_group_accounts CCGA, cst_period_cg_summary_v CPCSV WHERE CCGA.organization_id = :P_ORG_ID AND CCG.cost_group_id = CCGA.cost_group_id AND CPCSV.organization_id(+) = CCGA.organization_id AND CPCSV.cost_group_id(+) = CCGA.cost_group_id AND CPCSV.acct_period_id(+) = :c_acct_period_id GROUP BY CCG.cost_group, CCG.description &c_order_by BOM CSTRPCGW_XML AR CST إجمالي قيمة إقفال الفترة - إدارة المستودع (تنسيق XML) Imported from BI Publisher Description: إجمالي قيمة إغلاق الفترة - إدارة المستودع Application: شجرة المنتجات Source: إجمالي قيمة إقفال الفترة - إدارة المستودع (تنسيق XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG D CST Periodenabschlusswert - Übersicht - Lagermanagement Imported from BI Publisher Description: Periodenabschlusswert - Übersicht - Lagermanagement Application: Produktionsdaten Source: Periodenabschlusswert - Übersicht - Lagermanagement (XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG E CST Resumen de Valores de Cierre de Períodos - Gestión de Almacenes Imported from BI Publisher Description: Resumen de Valores de Cierre de Períodos - Gestión de Almacenes Application: Bills of Material Source: Resumen de Valores de Cierre de Períodos - Gestión de Almacenes (XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG F CST Synthèse des valeurs à la clôture de période - Gestion d'entrepôt Imported from BI Publisher Description: Synthèse des valeurs à la clôture de période - Gestion d'entrepôt Application: Bills of Material Source: Synthèse des valeurs à la clôture de période - Gestion d'entrepôt (XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG I CST Sintetico valori chiusura periodo - Warehouse Management Imported from BI Publisher Description: Sintetico valori chiusura periodo - Warehouse Management Application: Bills of Material Source: Sintetico valori chiusura periodo - Warehouse Management (XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG JA CST 期間クローズ値要約 - 倉庫管理 Imported from BI Publisher Description: 期間クローズ値要約 - 倉庫管理 Application: Bills of Material Source: 期間クローズ値要約 - 倉庫管理(XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG KO CST 기간 마감 금액 요약 - 창고 관리 Imported from BI Publisher Description: 기간 폐쇄값 요약 - 창고 관리 Application: Bills of Material Source: 기간 마감 금액 요약 - 창고 관리(XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG PTB CST Resumo do Valor de Fechamento do Período - Gerenciamento do Depósito Imported from BI Publisher Description: Resumo do Valor de Fechamento do Período - Gerenciamento do Depósito Application: Bills of Material Source: Resumo do Valor de Fechamento do Período - Gerenciamento do Depósito (XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG RU CST Сводка значений при закрытии периода - управление складом Imported from BI Publisher Description: Сводка значений при закрытии периода - управление складом Application: Спецификации Source: Сводка значений при закрытии периода - управление складом (XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG S CST Värdesummering vid periodstängning - Lageradministration Imported from BI Publisher Description: Värdesummering vid periodstängning -Lageradministration Application: Bills of Material Source: Värdesummering vid periodstängning - Lageradministration (XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG TR CST Dönem Kapanış Değeri Özeti - Temin Yeri Yönetimi Imported from BI Publisher Description: Dönem Kapanış Değeri Özeti - Temin Yeri Yönetimi Application: Ürün Ağacı Source: Dönem Kapanış Değeri Özeti - Temin Yeri Yönetimi (XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG US CST Period Close Value Summary - Warehouse Management Imported from BI Publisher Description: Period Close Value Summary - Warehouse Management Application: Bills of Material Source: Period Close Value Summary - Warehouse Management (XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG ZHS CST 期间关闭值汇总 - 仓库管理 Imported from BI Publisher Description: 期间关闭值汇总 - 仓库管理 Application: 物料清单管理系统 Source: 期间关闭值汇总 - 仓库管理 (XML) Short Name: CSTRPCGW_XML DB package: BOM_CSTRPCGW_XMLP_PKG BI Publisher &c_order_by :c_acct_period_id :c_order_by :c_std_prec :c_std_precision :lp_close_date :p_close_date :p_conc_request_id :p_condition :p_org_id :p_sort_id :p_struct_num 1 -20 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 2 10 :p_sort_id LOV Oracle CST_SRS_CSTRPCGW_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_SRS_CSTRPCGW_SORT' and enabled_flag='Y' order by lookup_code select meaning from mfg_lookups where lookup_type = 'CST_SRS_CSTRPCGW_SORT' and enabled_flag = 'Y' and lookup_code = 1 Y AR فرز بواسطة خيار الفرز D Sortieren nach Sortieroption E Ordenar por Opción de Clasificación F Tri par Option de tri I Ordina per Opzione di ordinamento JA ソート・キー ソート・オプション KO 정렬 기준 정렬 옵션 PTB Classificar por Opção de Classificação RU Сортировка Параметр сортировки S Sortera efter Sorteringsalternativ TR Sıralama Bazı Sıralama Seçeneği US Sort By Sort Option ZHS 排序依据 排序选项 3 20 :p_close_date LOV Oracle INV_SRS_PERIOD_CLOSE_DATE Y select schedule_close_date id, schedule_close_date value, period_name description from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and open_flag='N' and nvl(summarized_flag,'Y')<>'N' order by acct_period_id desc Y AR تاريخ إقفال الفترة تاريخ إقفال الفترة D Periodenabschlussdatum Periodenabschlussdatum E Fecha de Cierre del Período Fecha de Cierre del Período F Date de clôture de période Date de clôture de période I Data chiusura periodo Data chiusura periodo JA 期間クローズ日 期間クローズ日 KO 기간 마감 일자 기간 마감 일자 PTB Data de Fechamento do Período Data de Fechamento do Período RU Дата закрытия периода Дата закрытия периода S Stängningsdatum för period Stängningsdatum för period TR Dönem Kapanış Tarihi Dönem Kapanış Tarihi US Period Close Date Period Close Date ZHS 期间关闭日期 期间关闭日期