ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4702B51A9E05362FB09050512Y SELECT secondary_inventory subinventory, description description, --ROUND(SUM(NVL(CPSV.inventory_value,0)),:c_std_prec) SUM_CPSV_INVENTORY_VALUE ROUND(SUM(NVL(CPSV.inventory_value,0)),2) SUM_CPSV_INVENTORY_VALUE FROM cst_period_summary_v CPSV WHERE CPSV.organization_id = :P_ORG_ID AND CPSV.acct_period_id = :C_ACCT_PERIOD_ID GROUP BY secondary_inventory, description UNION ALL SELECT secondary_inventory_name, description, 0 FROM mtl_secondary_inventories MSI WHERE MSI.organization_id = :P_ORG_ID AND NOT EXISTS ( SELECT 'X' FROM cst_period_summary_v CPSV WHERE CPSV.organization_id = MSI.organization_id AND CPSV.secondary_inventory = MSI.secondary_inventory_name AND CPSV.acct_period_id = :C_ACCT_PERIOD_ID ) &C_order_by INV INVTRCLS_XML AR INV إجمالي قيمة إقفال الفترة (بتنسيق XML) Imported from BI Publisher Description: إجمالي قيمة إقفال الفترة Application: المخازن Source: إجمالي قيمة إقفال الفترة (بتنسيق XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG D INV Periodenabschlusswert - Übersicht Imported from BI Publisher Description: Periodenabschlusswert - Übersicht Application: Lager Source: Periodenabschlusswert - Übersicht (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG E INV Resumen de Valores de Cierre de Períodos Imported from BI Publisher Description: Resumen de Valores de Cierre de Períodos Application: Inventory Source: Resumen de Valores de Cierre de Períodos (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG F INV Synthèse des valeurs à la clôture de période Imported from BI Publisher Description: Synthèse des valeurs à la clôture de période Application: Inventory Source: Synthèse des valeurs à la clôture de période (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG I INV Sintetico valori chiusura periodo Imported from BI Publisher Description: Sintetico valori chiusura periodo Application: Inventory Source: Sintetico valori chiusura periodo (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG JA INV 期間クローズ価額要約 Imported from BI Publisher Description: 期間クローズ価額要約 Application: Inventory Source: 期間クローズ価額要約(XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG KO INV 기간 마감 금액 요약 Imported from BI Publisher Description: 기간 마감 금액 요약 Application: Inventory Source: 기간 마감 금액 요약(XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG PTB INV Resumo do valor de fechamento do período Imported from BI Publisher Description: Sumário de valor de fechamento do período Application: Inventário Source: Resumo do valor de fechamento do período (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG RU INV Сводка значений при закрытии периода Imported from BI Publisher Description: Сводка значений при закрытии периода Application: Запасы Source: Сводка значений при закрытии периода (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG S INV Värdesummering vid periodstängning Imported from BI Publisher Description: Periodstängning värde totalt Application: Inventory Source: Värdesummering vid periodstängning (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG TR INV Dönem kapanışı değer özeti Imported from BI Publisher Description: Dönem kapanışı değer özeti Application: Stok Yönetimi Source: Dönem kapanışı değer özeti (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG US INV Period close value summary Imported from BI Publisher Description: Period close value summary Application: Inventory Source: Period close value summary (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG ZHS INV 期间关闭值汇总 Imported from BI Publisher Description: 期间结算值汇总 Application: 库存管理系统 Source: 期间关闭值汇总 (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG BI Publisher &c_order_by :c_acct_period_id :c_std_precision :p_close_date :p_close_date_t :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 INV_SRS_CLS_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_CLS_SORT' and enabled_flag='Y' order by lookup_code select meaning from mfg_lookups where lookup_type = 'INV_SRS_CLS_SORT' and enabled_flag = 'Y' and lookup_code = 1 Y AR فرز بواسطة خيار الفرز D Sortieren nach Sortieroption E Ordenar por Opción de Ordenació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 期间关闭日期 期间关闭日期