ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF1E3869E053B46B63588994 SELECT item_id , item_desc , period_id , period_name , wac , lifo_cost , market_value , justification , layer_quantity , total_layer_quantity , item_code , uom_code , inventory_value , total_inventory_value FROM cstgilev_temp Y BOM CSTGILEV_XML AR CST تقرير تقييم الوارد أخيرًا يصرف أولاً التزايدي الدوري (تنسيق XML) Application: شجرة المنتجات Source: تقرير تقييم الوارد أخيرًا يصرف أولاً التزايدي الدوري (تنسيق XML) Short Name: CSTGILEV_XML DB package: BOM_CSTGILEV_XMLP_PKG D CST LIFO für Bestandsveränderung - Bewertung Application: Produktionsdaten Source: LIFO für Bestandsveränderung - Bewertung (XML) Short Name: CSTGILEV_XML DB package: BOM_CSTGILEV_XMLP_PKG F CST Etat Valorisation LIFO incrémentale périodique Application: Bills of Material Source: Etat Valorisation LIFO incrémentale périodique (XML) Short Name: CSTGILEV_XML DB package: BOM_CSTGILEV_XMLP_PKG US CST Periodic Incremental LIFO Valuation Application: Bills of Material Source: Periodic Incremental LIFO Valuation Report (XML) Short Name: CSTGILEV_XML DB package: BOM_CSTGILEV_XMLP_PKG ZHS CST 期间增量 LIFO 估价报表 Application: 物料清单管理系统 Source: 期间增量 LIFO 估价报表 (XML) Short Name: CSTGILEV_XML DB package: BOM_CSTGILEV_XMLP_PKG BI Publisher :h_cost_group :h_cost_group_desc :h_cost_type :h_cost_type_desc :h_currency :h_fiscal_year :h_legal_entity :h_period :h_report_subtitle :h_upto_date :p_conc_request_id :p_cost_group_id :p_cost_precision :p_cost_precision_1 :p_cost_type_id :p_detailed_report :p_detailed_report_subtitle :p_item_code_from :p_item_code_to :p_legal_entity_id :p_pac_period_id :p_quantity_precision :p_quantity_precision_1 :p_summarized_report_subtitle :p_value_precision :p_value_precision_1 :qty_precision1 :qty_precision2 :qty_precision3 1 10 :p_detailed_report 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 SELECT meaning FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'Y' Y AR تقرير تفصيلي D Detail-Auswertung F Etat détaillé US Detailed Report ZHS 明细报表 2 20 :p_legal_entity_id LOV Oracle CST_SRS_PAC_ILIFO_LE Y select legal_entity_id id, name value, null description from xle_firstparty_information_v where legal_entity_id in (select distinct clct.legal_entity from cst_le_cost_types clct where clct.primary_cost_method=4) order by value,description Y AR الكيان القانوني D Mandant F Entité juridique US Legal Entity ZHS 法人主体 3 30 :p_cost_type_id LOV Oracle CST_SRS_PAC_ILIFO_CT Y select cct.cost_type_id id, cct.cost_type value, cct.description description from cst_cost_types cct,cst_le_cost_types clct where cct.cost_type_id=clct.cost_type_id and clct.legal_entity=:$flex$.cst_srs_pac_ilifo_le and clct.primary_cost_method=4 order by value,description Y AR نوع التكلفة D Kostentyp F Type de coût US Cost Type ZHS 成本类型 4 40 :p_pac_period_id LOV Oracle CST_SRS_PAC_ILIFO_PERIOD Y select pac_period_id id, pac_period_id value, period_name description from cst_pac_periods where legal_entity=:$flex$.cst_srs_pac_ilifo_le and cost_type_id=:$flex$.cst_srs_pac_ilifo_ct order by value,description Y AR الفترة D Periode F Période US Period ZHS 期间 5 50 :p_cost_group_id LOV Oracle CST_SRS_PAC_ILIFO_CG Y select ccg.cost_group_id id, ccg.cost_group value, ccg.description description from cst_cost_groups ccg where ccg.legal_entity=:$flex$.cst_srs_pac_ilifo_le and nvl(ccg.cost_group_type,1)=2 and exists (select 'X' from cst_pac_process_phases cppp where cppp.pac_period_id= :$flex$.cst_srs_pac_ilifo_period and cppp.cost_group_id=ccg.cost_group_id) order by value,description Y AR مجموعة التكاليف D Kostengruppe F Groupe de coûts US Cost Group ZHS 成本组 6 60 :p_item_code_from Char AR الصنف من D Von Artikel F Article - De US Item From ZHS 物料自 7 70 :p_item_code_to Char AR الصنف إلى D Bis Artikel F Article - A US Item To ZHS 物料至 8 80 :p_quantity_precision Number select fnd_profile.value('REPORT_QUANTITY_PRECISION') from dual AR دقة الكمية D Nachkommastellen F Précision des quantités US Quantity Precision ZHS 数量精确度 9 90 :p_cost_precision Number select fnd_profile.value('REPORT_COST_PRECISION') from dual AR دقة التكلفة D Kosten - Präzision F Précision de coût US Cost Precision ZHS 成本精确度 10 100 :p_value_precision Number select fnd_profile.value('REPORT_VALUE_PRECISION') from dual AR دقة القيمة D Wertpräzision F Précision de valeur US Value Precision ZHS 值精确度 :$flex$.cst_srs_pac_ilifo_ct Cost Type Period :$flex$.cst_srs_pac_ilifo_le Legal Entity Cost Group :$flex$.cst_srs_pac_ilifo_le Legal Entity Cost Type :$flex$.cst_srs_pac_ilifo_le Legal Entity Period :$flex$.cst_srs_pac_ilifo_period Period Cost Group