ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FBD51A9E05362FB09050512Y SELECT DISTINCT mif.item_number, mp.organization_code organization_code, lc.lot_number lot_number, to_char(lcmat.cost_trans_date,'DD-MON-YY') cost_trans_date, lcmat.cost_trans_id , lcmat.cost_trans_qty, decode(lcmat.cost_trans_qty, 0,0, round((lcmat.total_trans_cost/lcmat.cost_trans_qty) * :p_exchange_rate_1,9) ) unit_trans_cost, round(lcmat.new_unit_cost*:p_exchange_rate_1,9) new_unit_cost, lcmat.new_onhand_qty, lcmat.cost_trans_uom, mtt.TRANSACTION_TYPE_NAME doc_type, mmt.TRANSACTION_SOURCE_ID doc_id , mmt.TRX_SOURCE_LINE_ID line_id, GMF_GMFLCHST_XMLP_PKG.CF_SRC_TRANSFORMULA(mmt.TRANSACTION_SOURCE_ID,mmt.TRX_SOURCE_LINE_ID,mtt.TRANSACTION_TYPE_NAME,mp.organization_code) CF_SRC_TRANS, GMF_GMFLCHST_XMLP_PKG.CF_SRC_ONHAND_VALUEFORMULA(round(lcmat.new_unit_cost*:p_exchange_rate_1,9),lcmat.new_onhand_qty) CF_SRC_ONHAND_VALUE FROM gmf_lot_costs lc, MTL_ITEM_FLEXFIELDS MIF, mtl_item_categories mic, mtl_categories_kfv mc, gmf_material_lot_cost_txns lcmat, mtl_parameters mp, hr_organization_information hoi, mtl_material_transactions mmt, mtl_transaction_types mtt, gmd_org_access_vw oa WHERE hoi.org_information2 = :p_legal_entity_id AND hoi.org_information_context = 'Accounting Information' AND lc.cost_type_id = :p_cost_type_id AND hoi.organization_id = lc.organization_id AND lc.inventory_item_id = mif.inventory_item_id AND lc.organization_id = mif.organization_id AND mic.inventory_item_id (+) = MIF.inventory_item_id AND mic.organization_id (+) = MIF.organization_id AND mic.category_id = mc.category_id (+) and mc.structure_id (+) = :p_structure_id AND mp.organization_id = hoi.organization_id AND mp.process_enabled_flag = 'Y' AND LCMAT.TRANSACTION_ID = MMT.TRANSACTION_ID AND LCMAT.COST_HEADER_ID = LC.HEADER_ID AND lcmat.transaction_id <> - lcmat.cost_trans_id AND mmt.transaction_type_id = mtt.transaction_type_id AND mp.organization_id = oa.organization_id AND ( ( mc.concatenated_segments >= :p_from_cost_category AND :p_from_cost_category IS NOT NULL ) OR ( :p_from_cost_category IS NULL ) ) AND ( ( mc.concatenated_segments <= :p_to_cost_category AND :p_to_cost_category IS NOT NULL ) OR ( :p_to_cost_category IS NULL ) ) AND ( mif.item_number >= nvl ( :p_frm_item , mif.item_number ) ) AND ( mif.item_number <= nvl ( :p_to_item , mif.item_number ) ) AND ( lc.lot_number >= nvl ( :p_from_lot , lc.lot_number ) ) AND ( lc.lot_number <= nvl ( :p_to_lot , lc.lot_number ) ) AND ( mp.organization_code >= nvl ( :p_frm_orgn , mp.organization_code ) ) AND ( mp.organization_code <= nvl ( :p_to_orgn , mp.organization_code ) ) AND ( lc.cost_date >= nvl ( :p_l_frm_date , lc.cost_date ) ) AND ( lc.cost_date <= nvl ( :p_l_to_date , lc.cost_date ) ) UNION ALL SELECT DISTINCT mif.item_number, mp.organization_code organization_code, lc.lot_number, to_char(lcmat.cost_trans_date,'DD-MON-YY') cost_trans_date, lcmat.cost_trans_id , lcmat.cost_trans_qty, decode(lcmat.cost_trans_qty, 0, round((lcmat.total_trans_cost/decode(lcmat.new_onhand_qty, 0, 1, lcmat.new_onhand_qty))*1, 9), round((lcmat.total_trans_cost/lcmat.cost_trans_qty)*1, 9)) unit_trans_cost, round(lcmat.new_unit_cost*:p_exchange_rate_1,9) new_unit_cost, lcmat.new_onhand_qty, lcmat.cost_trans_uom, 'LADJ' doc_type, -9 doc_id, trx.adjustment_id line_id, GMF_GMFLCHST_XMLP_PKG.CF_SRC_TRANSFORMULA(-9,trx.adjustment_id,'LADJ',mp.organization_code) CF_SRC_TRANS, GMF_GMFLCHST_XMLP_PKG.CF_SRC_ONHAND_VALUEFORMULA(round(lcmat.new_unit_cost*:p_exchange_rate_1,9),lcmat.new_onhand_qty) CF_SRC_ONHAND_VALUE FROM hr_organization_information hoi, gmf_lot_costs lc, mtl_item_flexfields mif, gmf_material_lot_cost_txns lcmat, gmf_lot_cost_adjustments trx, mtl_item_categories mic, mtl_categories_kfv mc, mtl_parameters mp, gmf_lot_cost_adjustment_dtls trxdet, gmd_org_access_vw oa WHERE hoi.org_information2 = :p_legal_entity_id AND hoi.org_information_context = 'Accounting Information' AND lc.cost_type_id = :p_cost_type_id AND lc.organization_id = hoi.organization_id AND mif.inventory_item_id = lc.inventory_item_id AND mif.organization_id = lc.organization_id AND lcmat.cost_header_id = lc.header_id AND lcmat.transaction_id = - lcmat.cost_trans_id --AND trx.adjustment_id = lc.last_costing_doc_id --rnie bug17945655 AND trx.new_cost_header_id = lc.header_id --rnie bug17945655 AND trx.adjustment_date = lcmat.cost_trans_date --rnie bug17945655 AND trx.adjustment_id = trxdet.adjustment_id AND mic.inventory_item_id (+) = MIF.inventory_item_id AND mic.organization_id (+) = MIF.organization_id AND mic.category_id = mc.category_id (+) and mc.structure_id (+) = :p_structure_id AND mp.organization_id = hoi.organization_id AND mp.process_enabled_flag = 'Y' AND mp.organization_id = oa.organization_id AND ( ( mc.concatenated_segments >= :p_from_cost_category AND :p_from_cost_category IS NOT NULL ) OR ( :p_from_cost_category IS NULL ) ) AND ( ( mc.concatenated_segments <= :p_to_cost_category AND :p_to_cost_category IS NOT NULL ) OR ( :p_to_cost_category IS NULL ) ) AND ( mif.item_number >= nvl ( :p_frm_item , mif.item_number ) ) AND ( mif.item_number <= nvl ( :p_to_item , mif.item_number ) ) AND ( lc.lot_number >= nvl ( :p_from_lot , lc.lot_number ) ) AND ( lc.lot_number <= nvl ( :p_to_lot , lc.lot_number ) ) AND ( mp.organization_code >= nvl ( :p_frm_orgn , mp.organization_code ) ) AND ( mp.organization_code <= nvl ( :p_to_orgn , mp.organization_code ) ) AND ( lc.cost_date >= nvl ( :p_l_frm_date , lc.cost_date ) ) AND ( lc.cost_date <= nvl ( :p_l_to_date , lc.cost_date ) ) GROUP BY mif.item_number , mp.organization_code , lc.lot_number , to_char(lcmat.cost_trans_date,'DD-MON-YY') , lcmat.cost_trans_id ,lcmat.cost_trans_qty , lcmat.total_trans_cost , lcmat.new_unit_cost , lcmat.new_onhand_qty , lcmat.cost_trans_uom , trx.adjustment_id /*USKUMARI Bug 14091093*/ UNION ALL SELECT DISTINCT mif.item_number, mp.organization_code organization_code, lc.lot_number, to_char(lcmat.cost_trans_date,'DD-MON-YY') , lcmat.cost_trans_id , lcmat.cost_trans_qty, decode(lcmat.cost_trans_qty, 0,sum(GLLCA.COSTED_QUANTITY), round((lcmat.total_trans_cost/lcmat.cost_trans_qty) * :p_exchange_rate,9) ) unit_trans_cost, round(lcmat.new_unit_cost*:p_exchange_rate,9) new_unit_cost, lcmat.new_onhand_qty, lcmat.cost_trans_uom, 'LCADJ' doc_type, -9 doc_id, glat.adj_transaction_id line_id, GMF_GMFLCHST_XMLP_PKG.CF_SRC_TRANSFORMULA(-9,glat.adj_transaction_id,'LCADJ',mp.organization_code) CF_SRC_TRANS, /* USKUMARI Bug 14091093 */ GMF_GMFLCHST_XMLP_PKG.CF_SRC_ONHAND_VALUEFORMULA(round(lcmat.new_unit_cost*:p_exchange_rate_1,9),lcmat.new_onhand_qty) CF_SRC_ONHAND_VALUE /* USKUMARI Bug 14091093 */ FROM hr_organization_information hoi, gmf_lot_costs lc, mtl_item_flexfields mif, gmf_material_lot_cost_txns lcmat, gmf_LC_lot_cost_adjs gllca, gmf_lc_adj_transactions glat, mtl_item_categories mic, mtl_categories_kfv mc, mtl_parameters mp, gmd_org_access_vw oa WHERE hoi.org_information2= :p_legal_entity_id AND hoi.org_information_context = 'Accounting Information' AND lc.cost_type_id = :p_cost_type_id AND lc.organization_id = hoi.organization_id AND mif.inventory_item_id = lc.inventory_item_id AND mif.organization_id = lc.organization_id AND lcmat.cost_header_id = lc.header_id AND lcmat.transaction_id = -lcmat.cost_trans_id AND glat.adj_transaction_id = lc.last_costing_doc_id AND glat.adj_transaction_id = gllca.adj_transaction_id AND mic.inventory_item_id(+) = MIF.inventory_item_id AND mic.organization_id(+) = MIF.organization_id AND mic.category_id = mc.category_id(+) and mc.structure_id(+) = :p_structure_id AND mp.organization_id = hoi.organization_id AND mp.process_enabled_flag = 'Y' AND mp.organization_id = oa.organization_id AND ( ( mc.concatenated_segments >= :p_from_cost_category AND :p_from_cost_category IS NOT NULL ) OR (:p_from_cost_category IS NULL )) AND ((mc.concatenated_segments <= :p_to_cost_category AND :p_to_cost_category IS NOT NULL ) OR (:p_to_cost_category IS NULL ) ) AND ( mif.item_number >= nvl(:p_frm_item,mif.item_number) ) AND ( mif.item_number <= nvl(:p_to_item ,mif.item_number) ) AND ( lc.lot_number >= nvl(:p_from_lot,lc.lot_number) ) AND ( lc.lot_number <= nvl( :p_to_lot,lc.lot_number) ) AND ( mp.organization_code >= nvl(:p_frm_orgn ,mp.organization_code) ) AND ( mp.organization_code <= nvl(:p_to_orgn, mp.organization_code)) AND ( lc.cost_date >= nvl(:p_l_frm_date,lc.cost_date) ) AND ( lc.cost_date <= nvl(:p_l_to_date,lc.cost_date) ) GROUP BY mif.item_number, mp.organization_code, lc.lot_number, to_char(lcmat.cost_trans_date,'DD-MON-YY') , lcmat.cost_trans_id , /*USKUMARI Bug 14091093*/ lcmat.cost_trans_qty, lcmat.total_trans_cost, lcmat.new_unit_cost, lcmat.new_onhand_qty, lcmat.cost_trans_uom, glat.adj_transaction_id ORDER BY 1 ASC,2 ASC,3 ASC , 4 ASC, 5 ASC /*USKUMARI Bug 14091093*/ GMF GMFLCHST_XML AR GMF تقرير تاريخ تكلفة اللوط في OPM (تنسيق XML) Imported from BI Publisher Description: تقرير تاريخ تكلفة اللوط في OPM Application: ماليات التصنيع التشغيلي Source: تقرير تاريخ تكلفة اللوط في OPM (تنسيق XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG D GMF Chargenkostenrechnung - Historie Imported from BI Publisher Description: OPM Auswertung "Chargenkostenrechnung - Historie" Application: Process Manufacturing Financials Source: Chargenkostenrechnung - Historie (XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG E GMF Historial de Costes de Lote de OPM Imported from BI Publisher Description: Historial de costes de lote de OPM Application: Process Manufacturing Financials Source: Historial de Costes de Lote de OPM (XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG F GMF OPM - Etat historique de valorisation du lot Imported from BI Publisher Description: OPM - Etat historique de valorisation du lot Application: Process Manufacturing Financials Source: OPM - Etat historique de valorisation du lot (XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG I GMF Rapporto Cronologia costo lotto OPM Imported from BI Publisher Description: Rapporto Cronologia costo lotto OPM Application: Process Manufacturing Financials Source: Rapporto Cronologia costo lotto OPM (XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG JA GMF OPMロット原価履歴レポート Imported from BI Publisher Description: OPMロット原価履歴レポート Application: Process Manufacturing Financials Source: OPMロット原価履歴レポート(XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG KO GMF OPM 로트 원가 내역 보고서 Imported from BI Publisher Description: OPM 로트 원가 내역 보고서 Application: Process Manufacturing Financials Source: OPM 로트 원가 내역 보고서(XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG PTB GMF OPM - Relatório do Histórico de Custo do Lote Imported from BI Publisher Description: OPM - Relatório do Histórico de Custo do Lote Application: Process Manufacturing Financials Source: OPM - Relatório do Histórico de Custo do Lote (XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG RU GMF история затрат партии Imported from BI Publisher Description: УНП: история затрат партии Application: Финансы УНП Source: УНП: история затрат партии (XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG S GMF Kostnadshistorik för parti Imported from BI Publisher Description: OPM: Kostnadshistorik för parti Application: Processtillverkning: Ekonomi Source: OPM: Kostnadshistorik för parti (XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG TR GMF OPM Lot Maliyet Tarihçe Raporu Imported from BI Publisher Description: OPM Lot Maliyet Tarihçe Raporu Application: Üretim Prosesi Finansal Yönetim Source: OPM Lot Maliyet Tarihçe Raporu (XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG US GMF OPM Lot Cost History Imported from BI Publisher Description: OPM Lot Cost History Report Application: Process Manufacturing Financials Source: OPM Lot Cost History Report (XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG ZHS GMF OPM 批次成本历史记录报表 Imported from BI Publisher Description: OPM 批次成本历史记录报表 Application: OPM 财务管理系统 Source: OPM 批次成本历史记录报表 (XML) Short Name: GMFLCHST_XML DB package: GMF_GMFLCHST_XMLP_PKG BI Publisher :cp_bill_only_so_text :cp_cost_adjustment_text :cp_drop_ship_so_text :cp_format_mask :cp_inv_adjustment_text :cp_lc_adjustment_text :cp_prod_text :cp_receipt_text :cp_so_text :cp_xfer_text :p_adjustment_text :p_bill_only_so_text :p_conc_request_id :p_cost_type_id :p_currency_code :p_currency_code_1 :p_drop_ship_so_text :p_exchange_rate :p_exchange_rate_1 :p_format_mask :p_frm_date :p_frm_item :p_frm_orgn :p_from_cost_category :p_from_cost_category_id :p_from_item_id :p_from_lot :p_from_organization_id :p_l_frm_date :p_l_frm_date_v :p_l_to_date :p_l_to_date_v :p_legal_entity_id :p_organization_context :p_prod_text :p_receipt_text :p_so_text :p_structure_id :p_to_cost_category :p_to_cost_category_id :p_to_date :p_to_item :p_to_item_id :p_to_lot :p_to_organization_id :p_to_orgn 1 -50 :p_structure_id LOV Oracle GMF_SRS_CATEGORY_STRUCTURE_ID Y select mcs.structure_id id, mcs.structure_id value, null description from mtl_default_category_sets mdc,mtl_category_sets mcs where mdc.functional_area_id=19 and mcs.category_set_id=mdc.category_set_id order by value,description SELECT mcs.structure_id FROM mtl_default_category_sets mdc, mtl_category_sets mcs WHERE mdc.functional_area_id = 19 and mcs.category_set_id = mdc.category_set_id AR معرف الهيكل الافتراضي معرف الهيكل الافتراضي D Dummy-Strukturkennung Dummy-Strukturkennung E Id Estructura Ficticia Id Estructura Ficticia F ID structure fictif ID structure fictif I Id struttura fittizia Id della struttura fittizia JA ダミー体系ID ダミー体系ID KO Dummy 구조 ID Dummy 구조 ID PTB ID da Estrutura Fictícia ID da Estrutura Fictícia RU Фиктивный идентификатор структуры Фиктивный идентификатор структуры S Id för dummy-struktur Id för dummy-struktur TR Sözde Yapı No Sözde Yapı No US Dummy Structure ID Dummy Structure ID ZHS 虚拟结构标识 虚拟结构标识 2 -40 :p_organization_context Number fnd_profile.value('MFG_ORGANIZATION_ID') AR سياق التنظيم سياق التنظيم D Organisationskontext Organisationskontext E Contexto de Organización Contexto de Organización F Contexte de l'organisation Contexte de l'organisation I Contesto organizzazione Contesto dell'organizzazione JA 組織コンテキスト 組織コンテキスト KO 조직 컨텍스트 조직 컨텍스트 PTB Contexto da Organização Contexto da Organização RU Контекст организации Контекст организации S Organisationssammanhang Organisationssammanhang TR Organizasyon İçeriği Organizasyon İçeriği US Organization Context Organization Context ZHS 组织上下文 组织上下文 3 -30 :sy_all Char fnd_profile.value('SY$ALL') US SY ALL SY ALL 4 -20 :nonblocksql LOV Oracle NONBLOCKSQL Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=108473 order by ffvv.flex_value NO AR Sql غير مدرج بالقطعة Sql غير مدرج بالقطعة E SQL No Bloqueante SQL No Bloqueante F SQL hors bloc SQL hors bloc JA 未ブロックSQL 未ブロックSQL KO 비블록 SQL 비블록 SQL PTB Sql de Não Bloqueio Sql de Não Bloqueio RU SQL без блоков SQL без блоков S Icke-blockerande SQL Icke-blockerande SQL TR Blok Dışı Sql Blok Dışı Sql US Non Block Sql Non Block Sql ZHS 非块结构 SQL 非块结构 SQL 5 10 :p_legal_entity_id LOV Oracle GMF_SRS_LEGAL_ENTITY Y select legal_entity_id id, legal_entity_name value, null description from gmf_legal_entities where legal_entity_id in (select legal_entity_id from gmf_fiscal_policies) order by legal_entity_name SELECT legal_entity_name FROM gmf_legal_entities where legal_entity_id = :PARAMETER.NUMBER1 Y AR الكيان القانوني الكيان القانوني D Mandant Mandant E Entidad Jurídica Entidad Jurídica 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 GMF_SRS_LOT_COST_TYPES Y select mthd.cost_type_id id, mthd.cost_mthd_code value, mthd.cost_mthd_desc description from cm_mthd_mst mthd where mthd.cost_type=6 and delete_mark=0 order by mthd.cost_mthd_code SELECT distinct cost_mthd_code FROM cm_mthd_mst WHERE cost_type = 6 and cost_type_id = :PARAMETER.NUMBER2 Y AR نوع التكلفة نوع التكلفة D Kostenrechnungsart Kostenrechnungsart 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_from_organization_id LOV Oracle GMF_SRS_FROM_ORGANIZATION Y select ood.organization_id id, ood.organization_code value, ood.organization_name description from org_organization_definitions ood,mtl_parameters mp where ood.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and ood.legal_entity=:$flex$.gmf_srs_legal_entity order by value,description SELECT distinct organization_code FROM mtl_parameters WHERE organization_id = :PARAMETER.NUMBER4 AR من التنظيم من التنظيم D Von Organisation Von Organisation E De Organización De Organización F Organisation d'origine Organisation d'origine I Organizzazione - Da Organizzazione - Da JA 組織:自 組織:自 KO 조직: 부터 조직: 부터 PTB Da Organização Da Organização RU Организация с Организация с S Från organisation Från organisation TR İlk Organizasyon İlk Organizasyon US From Organization From Organization ZHS 起始组织 起始组织 8 40 :p_to_organization_id LOV Oracle GMF_SRS_TO_ORGANIZATION Y select ood.organization_id id, ood.organization_code value, ood.organization_name description from org_organization_definitions ood,mtl_parameters mp where ood.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and ood.legal_entity=:$flex$.gmf_srs_legal_entity and ood.organization_code>=:$flex$.gmf_srs_from_organization.value order by value,description SELECT distinct organization_code FROM mtl_parameters WHERE organization_id = :PARAMETER.NUMBER4 AR إلى التنظيم إلى التنظيم D Nach Organisation Nach Organisation E A Organización A Organización F Organisation - A Organisation - A I Organizzazione - A Organizzazione - A JA 組織:至 組織:至 KO 조직: 까지 조직: 까지 PTB Organização - Até Organização - Até RU Организация по Организация по S Till organisation Till organisation TR Son Organizasyon Son Organizasyon US To Organization To Organization ZHS 目标组织 目标组织 9 50 :p_from_item_id Char SELECT distinct item_number FROM mtl_item_flexfields where inventory_item_id = :PARAMETER.NUMBER3 AR P_FROM_ITEM من الصنف D P_FROM_ITEM Von Artikel E P_FROM_ITEM De Artículo F P_FROM_ITEM Article - De I P_FROM_ITEM Articolo - Da JA P_FROM_ITEM 品目:自 KO P_FROM_ITEM 품목: 부터 PTB P_FROM_ITEM Item - De RU P_FROM_ITEM Позиция с S P_FROM_ITEM Från artikel TR P_FROM_ITEM İlk Kalem US P_FROM_ITEM From Item ZHS P_FROM_ITEM 起始物料 10 60 :p_to_item_id Char SELECT distinct item_number FROM mtl_item_flexfields where inventory_item_id = :PARAMETER.NUMBER3 AR P_TO_ITEM إلى الصنف D P_TO_ITEM Bis Artikel E P_TO_ITEM A Artículo F P_TO_ITEM Article - A I P_TO_ITEM Articolo - A JA P_TO_ITEM 品目:至 KO P_TO_ITEM 품목: 까지 PTB P_TO_ITEM Item - Até RU P_TO_ITEM Позиция по S P_TO_ITEM Till artikel TR P_TO_ITEM Son Kalem US P_TO_ITEM To Item ZHS P_TO_ITEM 终止物料 11 70 :p_from_lot LOV Oracle GMF_SRS_FROM_LOT_NUMBERS Y select lot_number id, lot_number value, null description from mtl_lot_numbers where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and inventory_item_id=:$flex$.p_from_item order by lot_number SELECT :PARAMETER.CHAR1 FROM DUAL AR من اللوط من اللوط D Von Charge Von Charge E De Lote De Lote F Lot - Du Lot - Du I Lotto - Da Lotto - Da JA ロット:自 ロット:自 KO 시작 로트 시작 로트 PTB Lote - De Lote - De RU Партия с Партия с S Från parti Från parti TR İlk Lot İlk Lot US From Lot From Lot ZHS 起始批次 起始批次 12 80 :p_to_lot LOV Oracle GMF_SRS_TO_LOT_NUMBERS Y select lot_number id, lot_number value, null description from mtl_lot_numbers where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and inventory_item_id=:$flex$.p_to_item order by lot_number SELECT :PARAMETER.CHAR1 FROM DUAL AR إلى اللوط إلى اللوط D Bis Charge Bis Charge E A Lote A Lote F Lot - A Lot - A I Lotto - A Lotto - A JA ロット:至 ロット:至 KO 종료 로트 종료 로트 PTB Lote - Até Lote - Até RU Партия по Партия по S Till parti Till parti TR Son Lot Son Lot US To Lot To Lot ZHS 终止批次 终止批次 13 90 :p_from_cost_category_id Char AR من فئة تكلفة الصنف من فئة تكلفة الصنف D Von Artikelkostenkategorie Von Artikelkostenkategorie E De Categoría de Coste de Artículo De Categoría de Coste de Artículo F Catégorie de coût article - De Catégorie de coût article - De I Categoria costo articolo - Da Categoria costo articolo - Da JA 品目原価カテゴリ:自 品目原価カテゴリ:自 KO 시작 품목 원가 범주 시작 품목 원가 범주 PTB De - Categoria de Custo do Item De - Categoria de Custo do Item RU Категория стоимости позиций с Категория стоимости позиций с S Från artikelkostnadskategori Från artikelkostnadskategori TR İlk Kalem Maliyet Kategorisi İlk Kalem Maliyet Kategorisi US From Item Cost Category From Item Cost Category ZHS 起始项目成本类别 起始项目成本类别 14 100 :p_to_cost_category_id Char AR إلى فئة تكلفة الصنف إلى فئة تكلفة الصنف D Bis Artikelkostenkategorie Bis Artikelkostenkategorie E A Categoría de Coste de Artículo A Categoría de Coste de Artículo F Catégorie de coût article - A Catégorie de coût article - A I Categoria costo articolo - A Categoria costo articolo - A JA 品目原価カテゴリ:至 品目原価カテゴリ:至 KO 종료 품목 원가 범주 종료 품목 원가 범주 PTB Até - Categoria de Custo do Item Até - Categoria de Custo do Item RU Категория стоимости позиций по Категория стоимости позиций по S Till artikelkostnadskategori Till artikelkostnadskategori TR Son Kalem Maliyet Kategorisi Son Kalem Maliyet Kategorisi US To Item Cost Category To Item Cost Category ZHS 终止项目成本类别 终止项目成本类别 15 110 :p_frm_date DateTime SELECT FND_DATE.DATE_TO_CHARDT(COST_DATE) FROM GMF_LOT_COSTS WHERE HEADER_ID = :PARAMETER.NUMBER5 AR من التاريخ من التاريخ D Von Datum Von Datum E De Fecha De Fecha F Date - Du Date - Du I Data - Da Data - Da JA 日付:自 日付:自 KO 시작 일자 시작 일자 PTB Data - De Data - De RU Дата с Дата с S Från datum Från datum TR Başlangıç Tarihi Başlangıç Tarihi US From Date From Date ZHS 自日期 自日期 16 120 :p_to_date DateTime SELECT FND_DATE.DATE_TO_CHARDT(COST_DATE) FROM GMF_LOT_COSTS WHERE HEADER_ID = :PARAMETER.NUMBER5 AR إلى التاريخ إلى التاريخ D Bis Datum Bis Datum E A Fecha A Fecha F Date - A Date - A I Data - A Data - A JA 日付:至 日付:至 KO 종료 일자 종료 일자 PTB Data - Até Data - Até RU Дата по Дата по S Till datum Till datum TR Bitiş Tarihi Bitiş Tarihi US To Date To Date ZHS 至日期 至日期 17 130 :p_currency_code LOV Oracle GMF_GL_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code SELECT base_currency_code FROM gmf_fiscal_policies where legal_entity_id = :$flex$.legal_entity AR العملة العملة D Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 18 140 :p_exchange_rate Number 1.000000000000000 AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de Cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa de Câmbio RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz Kuru US Exchange Rate Exchange Rate ZHS 汇率 汇率