ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF383869E053B46B63588994Y SELECT cracd.header_id c_rcv_acv_cost_header_id , 1 c_sort , cracd.parent_distribution_id c_parent_distribution_num , cracd.distribution_num c_distribution_num , aia.invoice_num c_invoice_po_number , :ptxt_source_invoice c_source_type , aida.distribution_line_number c_distribution_line_number , LPAD(cracd.level_num, cracd.level_num) c_level , alc.displayed_field c_line_type , cracd.quantity c_quantity , round(cracd.price,:P_EXT_PRECISION) c_price , round(cracd.amount/:P_PRECISION)*:P_PRECISION c_amount FROM ap_invoices_all aia , ap_invoice_distributions_all aida , ap_lookup_codes alc , cst_rcv_acq_cost_details cracd WHERE alc.lookup_type = 'INVOICE DISTRIBUTION TYPE' AND alc.lookup_code = cracd.line_type AND aida.invoice_distribution_id = cracd.invoice_distribution_id AND aia.invoice_id = aida.invoice_id AND cracd.header_id=:c_rcv_acq_cost_id /* UNION SELECT cracd.header_id c_rcv_acv_cost_header_id , 1 c_sort , cracd.parent_distribution_id c_parent_distribution_num , cracd.distribution_num c_distribution_num , aia.invoice_num c_invoice_po_number , :ptxt_source_invoice c_source_type , aida.distribution_line_number c_distribution_line_number , LPAD(cracd.level_num, cracd.level_num) c_level , alc.displayed_field c_line_type , cracd.quantity c_quantity , round(cracd.price,:P_EXT_PRECISION) c_price , round(cracd.amount/:P_PRECISION)*:P_PRECISION c_amount FROM ap_invoices_all aia , ap_invoice_distributions_all aida , ap_lookup_codes alc , cst_rcv_acq_cost_details cracd WHERE alc.lookup_type = 'INVOICE DISTRIBUTION TYPE' AND alc.lookup_code = cracd.line_type AND aida.invoice_distribution_id = cracd.invoice_distribution_id AND aia.invoice_id = aida.invoice_id */ UNION ALL SELECT cracd.header_id c_rcv_acv_cost_header_id , 2 c_sort , cracd.parent_distribution_id c_parent_distribution_num , cracd.distribution_num c_distribution_num , pha.segment1 c_invoice_po_num , decode(cracd.source_type,'LCM',:ptxt_source_lcm,:ptxt_source_po ) c_source_type , TO_NUMBER(NULL) c_distribution_line_number , TO_CHAR(NULL) c_level , decode(cracd.source_type,'LCM',:ptxt_line_type_lcm,:ptxt_line_type_po) c_line_type , cracd.quantity c_quantity , round(cracd.price,:P_EXT_PRECISION) c_price , round(cracd.amount/:P_PRECISION)*:P_PRECISION c_amount FROM po_headers_all pha , po_line_locations_all plla , cst_rcv_acq_cost_details cracd WHERE cracd.po_line_location_id = plla.line_location_id AND pha.po_header_id = plla.po_header_id and cracd.header_id=:c_rcv_acq_cost_id ORDER BY c_sort , c_parent_distribution_num , c_distribution_num BOM CSTRPACQ_XML AR CST تقرير تكلفة الاكتساب الدوري (تنسيق XML) Application: شجرة المنتجات Source: تقرير تكلفة الاكتساب الدوري (تنسيق XML) Short Name: CSTRPACQ_XML DB package: BOM_CSTRPACQ_XMLP_PKG D CST Periodische Beschaffungskosten Application: Produktionsdaten Source: Periodische Beschaffungskosten (XML) Short Name: CSTRPACQ_XML DB package: BOM_CSTRPACQ_XMLP_PKG F CST Coûts d'acquisition périodiques Application: Bills of Material Source: Coûts d'acquisition périodiques (XML) Short Name: CSTRPACQ_XML DB package: BOM_CSTRPACQ_XMLP_PKG US CST Periodic Acquisition Cost Application: Bills of Material Source: Periodic Acquisition Cost Report (XML) Short Name: CSTRPACQ_XML DB package: BOM_CSTRPACQ_XMLP_PKG ZHS CST 定期请购成本报表 Application: 物料清单管理系统 Source: 定期请购成本报表 (XML) Short Name: CSTRPACQ_XML DB package: BOM_CSTRPACQ_XMLP_PKG BI Publisher :c_rcv_acq_cost_id :h_cost_group :h_cost_type :h_currency :h_legal_entity :h_option_field :h_period :h_report_subtitle :p_all_receipts :p_conc_request_id :p_cost_group_id :p_cost_type_id :p_ext_precision :p_item_code_from :p_item_code_to :p_item_flex_num :p_legal_entity_id :p_period_id :p_precision :p_quantity_precision :plex_item_code_select :plex_item_code_where :plex_option_where :ptxt_item_prompt :ptxt_line_type_lcm :ptxt_line_type_po :ptxt_option_all_receipts :ptxt_option_po_receipts :ptxt_source_invoice :ptxt_source_lcm :ptxt_source_po :qty_precision 1 10 :p_legal_entity_id LOV Oracle CST_SRS_PAC_LEGAL_ENTITY Y select legal_entity_id id, name value, null description from xle_firstparty_information_v order by value,description Y AR الكيان القانوني D Mandant F Entité juridique US Legal Entity ZHS 法人主体 2 20 :p_cost_type_id LOV Oracle CST_SRS_PAC_COST_TYPE 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_legal_entity order by value,description Y AR نوع التكلفة D Kostentyp F Type de coût US Cost Type ZHS 成本类型 3 30 :p_period_id LOV Oracle CST_SRS_PAC_PERIOD Y select cpp.pac_period_id id, cpp.pac_period_id value, cpp.period_name description from cst_pac_periods cpp where cpp.legal_entity=:$flex$.cst_srs_pac_legal_entity and cpp.cost_type_id=:$flex$.cst_srs_pac_cost_type order by value,description Y AR الفترة D Periode F Période US Period ZHS 期间 4 40 :p_cost_group_id LOV Oracle CST_SRS_PAC_COST_GROUP 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_legal_entity 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_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 成本组 5 50 :p_item_code_from Char AR الصنف من D Von Artikel F Article - De US Item From ZHS 物料自 6 60 :p_item_code_to Char AR الصنف إلى D Bis Artikel F Article - A US Item To ZHS 物料至 7 70 :p_all_receipts LOV Oracle CST_SRS_PAC_ACQ_OPTION Y select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='CST_ACQ_REPORT_OPTION' order by value,description AR خيار التشغيل D Startoption F Option d'exécution US Run Option ZHS 运行选项