ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4703051A9E05362FB09050512 SELECT decode(:P_BREAK_ID, 1, nvl(null, 'None'), 2,mut.transaction_date, nvl(mut.serial_number,'None')) break_column, decode(:P_BREAK_ID, 1,msi.inventory_item_id , '1') break_item_id, decode(:P_BREAK_ID, 1,msi.description, '2') break_item_desc, decode(:P_BREAK_ID, 1, NULL, &P_ITEM_FLEXDATA) item_flexdata, decode(:P_BREAK_ID,1,'4', msi.inventory_item_id) item_id, decode(:P_BREAK_ID,1,'5', msi.description ) item_desc, decode(:P_BREAK_ID, 2,'6', mut.transaction_date) txn_date, decode(:P_BREAK_ID,3,'7',nvl(mut.serial_number,'None')) serial_number, mmt.revision rev, mtxt.transaction_type_name txn_type_name, mut.transaction_source_id txn_source_id, DECODE (mut.transaction_source_type_id, 1,poh.segment1, 2,null, 3,null, 5,wip1.wip_entity_name, 6,null, 7,porh.segment1, 8,&P_MKTS_FLEXDATA, 9,cch.cycle_count_header_name, 10,mpi.physical_inventory_name, 11,cupd.description, 12,&P_MKTS_FLEXDATA, mut.transaction_source_name) txn_source_data, mut.subinventory_code subinv, DECODE (:P_rpt_uom, 1, ROUND(NVL(abs(mmt.transaction_quantity),0)/ NVL(mmt.primary_quantity,0),:P_QTY_PRECISION), 2, 1*sign(mmt.transaction_quantity), ROUND(NVL(abs(mmt.transaction_quantity),0)/ NVL(mmt.primary_quantity,0),:P_QTY_PRECISION)) rpt_qty, DECODE (:P_rpt_uom, 1,ROUND(NVL(mmt.transaction_quantity,0),:P_QTY_PRECISION), 2,ROUND(NVL(mmt.primary_quantity,0),:P_QTY_PRECISION), ROUND(NVL(mmt.transaction_quantity,0),:P_QTY_PRECISION)) tot_qty, DECODE (:P_rpt_uom, 1,mmt.transaction_uom, 2,msi.primary_uom_code, mmt.transaction_uom) uom, ROUND(( round(NVL(mmt.actual_cost,0),:C_ext_precision) * sign(mmt.transaction_quantity)) ,:C_std_precision) extd_cost, mcat.category_id catg_id, null catg_flexdata, mut.transaction_id txn_id, mmt.transaction_set_id txn_set_id, mmt.created_by txn_create_by1, fndu.user_name txn_user_name, mut.creation_date txn_create_dt, mmt.transaction_reference txn_ref, mtr.reason_name reason_name, mut.locator_id locator_id, null loc_flexdata, mut.transaction_source_type_id txn_src_type_id, ' ' lot_number, MP.ORGANIZATION_CODE organization, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_break_item_value', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_break_item_value, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_value, --&C_txn_src_value C_txn_src_value, decode(mut.transaction_source_type_id,2,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_src_value1', 'INV', 'MKTS', 101, NULL, mkts.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE'),3,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_src_value2', 'SQLGL', 'GL#', GLCC.CHART_OF_ACCOUNTS_ID, NULL, GLCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'),6,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_src_value3', 'INV', 'MDSP', 101, MDSP.ORGANIZATION_ID, MDSP.DISPOSITION_ID, 'ALL', 'Y', 'VALUE'),8,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_src_value1', 'INV', 'MKTS', 101, NULL, mkts.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE'),12,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_src_value1', 'INV', 'MKTS', 101, NULL, mkts.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE'),DECODE (mut.transaction_source_type_id, 1,poh.segment1, 2,null, 3,null, 5,wip1.wip_entity_name, 6,null, 7,porh.segment1, 8,&P_MKTS_FLEXDATA, 9,cch.cycle_count_header_name, 10,mpi.physical_inventory_name, 11,cupd.description, 12,&P_MKTS_FLEXDATA, mut.transaction_source_name)) C_txn_src_value, INV_INVTRSNT_XMLP_PKG.calc_unit_cost(DECODE ( :P_rpt_uom , 1 , ROUND ( NVL ( mmt.transaction_quantity , 0 ) , :P_QTY_PRECISION ) , 2 , ROUND ( NVL ( mmt.primary_quantity , 0 ) , :P_QTY_PRECISION ) , ROUND ( NVL ( mmt.transaction_quantity , 0 ) , :P_QTY_PRECISION ) ), ROUND ( ( round ( NVL ( mmt.actual_cost , 0 ) , :C_ext_precision ) * sign ( mmt.transaction_quantity ) ) , :C_std_precision ), :C_ext_precision) C_unit_cost, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_value', 'INV', 'MTLL', 101, mil.ORGANIZATION_ID, mil.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_locator_value, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_catg_value', 'INV', 'MCAT', mcat.STRUCTURE_ID, NULL, mcat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_catg_value FROM &C_type_break_from MTL_ITEM_LOCATIONS mil , PO_HEADERS_ALL poh , MTL_SALES_ORDERS mkts , GL_CODE_COMBINATIONS glcc , WIP_ENTITIES wip1 , CST_COST_UPDATES cupd , MTL_CYCLE_COUNT_HEADERS cch , PO_REQUISITION_HEADERS_ALL porh , MTL_GENERIC_DISPOSITIONS mdsp , MTL_PHYSICAL_INVENTORIES mpi , MTL_UNIT_TRANSACTIONS mut, MTL_CATEGORIES mcat , MTL_ITEM_CATEGORIES micat , MTL_SYSTEM_ITEMS msi, FND_USER fndu , MTL_TRANSACTION_TYPES mtxt, MTL_TRANSACTION_REASONS mtr, MTL_MATERIAL_TRANSACTIONS mmt, MTL_PARAMETERS MP WHERE &P_CATG_WHERE and &P_ITEM_WHERE and mmt.reason_id = mtr.reason_id (+) and mmt.created_by = fndu.user_id (+) and mmt.transaction_type_id = mtxt.transaction_type_id (+) and mut.locator_id = mil.inventory_location_id (+) and mut.organization_id = mil.organization_id (+) and mut.transaction_source_type_id != 11 &C_serial_where &C_reason_where &C_txn_type_where &C_subinv_where &C_source_type_where &C_source_where and mp.organization_id = mmt.organization_id and mut.transaction_source_id = poh.po_header_id (+) and mut.transaction_source_id = mkts.sales_order_id (+) and mut.transaction_source_id = glcc.code_combination_id (+) and mut.transaction_source_id = wip1.wip_entity_id (+) and mut.organization_id = wip1.organization_id (+) and mut.transaction_source_id = mdsp.disposition_id (+) and mut.transaction_source_id = porh.requisition_header_id (+) and mut.transaction_source_id = cch.cycle_count_header_id (+) and mut.organization_id = cch.organization_id (+) and mut.transaction_source_id = mpi.physical_inventory_id (+) and mut.organization_id = mpi.organization_id (+) and mut.transaction_source_id = cupd.cost_update_id (+) and mut.organization_id = cupd.organization_id (+) and mmt.inventory_item_id = msi.inventory_item_id and mmt.organization_id = msi.organization_id and micat.category_id = mcat.category_id and mmt.inventory_item_id = micat.inventory_item_id and micat.category_set_id = :P_CATG_SET_ID and mmt.organization_id = micat.organization_id and mmt.transaction_id = mut.transaction_id and mmt.transaction_date >= :P_TXN_DATE_LO and mmt.transaction_date <= :P_TXN_DATE_HI + 1 - (1/(24*3600)) and mmt.organization_id = NVL(:P_ORG_ID ,MMT.ORGANIZATION_ID) UNION SELECT decode(:P_BREAK_ID, 1, nvl(null, 'None'), 2,mut.transaction_date, nvl(mut.serial_number,'None')) break_column, decode(:P_BREAK_ID, 1,msi.inventory_item_id , '1') break_item_id, decode(:P_BREAK_ID, 1,msi.description, '2') break_item_desc, decode(:P_BREAK_ID, 1, NULL, &P_ITEM_FLEXDATA) item_flexdata, decode(:P_BREAK_ID,1,'4', msi.inventory_item_id) item_id, decode(:P_BREAK_ID,1,'5', msi.description ) item_desc, decode(:P_BREAK_ID, 2,'6', mut.transaction_date) txn_date, decode(:P_BREAK_ID,3,'7',nvl(mut.serial_number,'None')) serial_number, mmt.revision rev, mtxt.transaction_type_name txn_type_name, mut.transaction_source_id txn_source_id, DECODE (mut.transaction_source_type_id, 1,poh.segment1, 2,null, 3,null, 5,wip1.wip_entity_name, 6,null, 7,porh.segment1, 8,&P_MKTS_FLEXDATA, 9,cch.cycle_count_header_name, 10,mpi.physical_inventory_name, 11,cupd.description, 12,&P_MKTS_FLEXDATA, mut.transaction_source_name) txn_source_data, mut.subinventory_code subinv, DECODE (:P_rpt_uom, 1, ROUND(NVL(abs(mmt.transaction_quantity),0)/ NVL(mmt.primary_quantity,0),:P_QTY_PRECISION), 2, 1*sign(mmt.transaction_quantity), ROUND(NVL(abs(mmt.transaction_quantity),0)/ NVL(mmt.primary_quantity,0),:P_QTY_PRECISION)) rpt_qty, DECODE (:P_rpt_uom, 1,ROUND(NVL(mmt.transaction_quantity,0),:P_QTY_PRECISION), 2,ROUND(NVL(mmt.primary_quantity,0),:P_QTY_PRECISION), ROUND(NVL(mmt.transaction_quantity,0),:P_QTY_PRECISION)) tot_qty, DECODE (:P_rpt_uom, 1,mmt.transaction_uom, 2,msi.primary_uom_code, mmt.transaction_uom) uom, ROUND(( round(NVL(mmt.actual_cost,0),:C_ext_precision) * sign(mmt.transaction_quantity)) ,:C_std_precision) extd_cost, mcat.category_id catg_id, null catg_flexdata, mut.transaction_id txn_id, mmt.transaction_set_id txn_set_id, mmt.created_by txn_create_by1, fndu.user_name txn_user_name, mut.creation_date txn_create_dt, mmt.transaction_reference txn_ref, mtr.reason_name reason_name, mut.locator_id locator_id, null loc_flexdata, mut.transaction_source_type_id txn_src_type_id, mtln.lot_number lot_number, MP.ORGANIZATION_CODE organization, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_break_item_value', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_break_item_value, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_value, --&C_txn_src_value C_txn_src_value, decode(mut.transaction_source_type_id,2,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_src_value1', 'INV', 'MKTS', 101, NULL, mkts.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE'),3,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_src_value2', 'SQLGL', 'GL#', GLCC.CHART_OF_ACCOUNTS_ID, NULL, GLCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'),6,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_src_value3', 'INV', 'MDSP', 101, MDSP.ORGANIZATION_ID, MDSP.DISPOSITION_ID, 'ALL', 'Y', 'VALUE'),8,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_src_value1', 'INV', 'MKTS', 101, NULL, mkts.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE'),12,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_src_value1', 'INV', 'MKTS', 101, NULL, mkts.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE'),DECODE (mut.transaction_source_type_id, 1,poh.segment1, 2,null, 3,null, 5,wip1.wip_entity_name, 6,null, 7,porh.segment1, 8,&P_MKTS_FLEXDATA, 9,cch.cycle_count_header_name, 10,mpi.physical_inventory_name, 11,cupd.description, 12,&P_MKTS_FLEXDATA, mut.transaction_source_name)) C_txn_src_value, INV_INVTRSNT_XMLP_PKG.calc_unit_cost(DECODE ( :P_rpt_uom , 1 , ROUND ( NVL ( mmt.transaction_quantity , 0 ) , :P_QTY_PRECISION ) , 2 , ROUND ( NVL ( mmt.primary_quantity , 0 ) , :P_QTY_PRECISION ) , ROUND ( NVL ( mmt.transaction_quantity , 0 ) , :P_QTY_PRECISION ) ), ROUND ( ( round ( NVL ( mmt.actual_cost , 0 ) , :C_ext_precision ) * sign ( mmt.transaction_quantity ) ) , :C_std_precision ), :C_ext_precision) C_unit_cost, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_value', 'INV', 'MTLL', 101, mil.ORGANIZATION_ID, mil.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_locator_value, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_catg_value', 'INV', 'MCAT', mcat.STRUCTURE_ID, NULL, mcat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_catg_value FROM &C_type_break_from MTL_TRANSACTION_LOT_NUMBERS mtln, MTL_ITEM_LOCATIONS mil , PO_HEADERS_ALL poh , MTL_SALES_ORDERS mkts , GL_CODE_COMBINATIONS glcc , WIP_ENTITIES wip1 , CST_COST_UPDATES cupd , MTL_CYCLE_COUNT_HEADERS cch , PO_REQUISITION_HEADERS_ALL porh , MTL_GENERIC_DISPOSITIONS mdsp , MTL_PHYSICAL_INVENTORIES mpi , MTL_UNIT_TRANSACTIONS mut , MTL_CATEGORIES mcat , MTL_ITEM_CATEGORIES micat , MTL_SYSTEM_ITEMS msi , FND_USER fndu , MTL_TRANSACTION_TYPES mtxt , MTL_TRANSACTION_REASONS mtr , MTL_MATERIAL_TRANSACTIONS mmt , MTL_PARAMETERS MP WHERE &P_CATG_WHERE and &P_ITEM_WHERE and mmt.reason_id = mtr.reason_id (+) and mmt.created_by = fndu.user_id (+) and mmt.transaction_type_id = mtxt.transaction_type_id (+) and mut.locator_id = mil.inventory_location_id (+) and mut.organization_id = mil.organization_id (+) and mut.transaction_source_type_id != 11 &C_serial_where &C_reason_where &C_txn_type_where &C_subinv_where &C_source_type_where &C_source_where and mp.organization_id = mmt.organization_id and mut.transaction_source_id = poh.po_header_id (+) and mut.transaction_source_id = mkts.sales_order_id (+) and mut.transaction_source_id = glcc.code_combination_id (+) and mut.transaction_source_id = wip1.wip_entity_id (+) and mut.organization_id = wip1.organization_id (+) and mut.transaction_source_id = mdsp.disposition_id (+) and mut.transaction_source_id = porh.requisition_header_id (+) and mut.transaction_source_id = cch.cycle_count_header_id (+) and mut.organization_id = cch.organization_id (+) and mut.transaction_source_id = mpi.physical_inventory_id (+) and mut.organization_id = mpi.organization_id (+) and mut.transaction_source_id = cupd.cost_update_id (+) and mut.organization_id = cupd.organization_id (+) and mmt.inventory_item_id = msi.inventory_item_id and mmt.organization_id = msi.organization_id and micat.category_id = mcat.category_id and mmt.inventory_item_id = micat.inventory_item_id and micat.category_set_id = :P_CATG_SET_ID and mmt.organization_id = micat.organization_id and mtln.serial_transaction_id = mut.transaction_id and mmt.transaction_id = mtln.transaction_id and mmt.transaction_date >= :P_TXN_DATE_LO and mmt.transaction_date <= :P_TXN_DATE_HI + 1 - (1/(24*3600)) and mmt.organization_id = NVL(:P_ORG_ID, MMT.ORGANIZATION_ID) order by 33,1,2,8,20 desc Y INV INVTRSNT_XML AR INV مسجل حركة الرقم المسلسل (بتنسيق XML) Imported from BI Publisher Description: مسجل حركة الرقم المسلسل Application: المخازن Source: مسجل حركة الرقم المسلسل (بتنسيق XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG D INV Transaktionsprotokoll - Seriennummern Imported from BI Publisher Description: Transaktionsprotokoll - Seriennummern Application: Lager Source: Transaktionsprotokoll - Seriennummern (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG E INV Registro de Transacciones por Número de Serie Imported from BI Publisher Description: Registro de Transacciones por Número de Serie Application: Inventory Source: Registro de Transacciones por Número de Serie (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG F INV Registre mouvements par numéro de série Imported from BI Publisher Description: Registre mouvements par numéro de série Application: Inventory Source: Registre mouvements par numéro de série (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG I INV Registro transazioni numeri di serie Imported from BI Publisher Description: Registro transazioni numeri di serie Application: Inventory Source: Registro transazioni numeri di serie (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG JA INV シリアル番号取引台帳 Imported from BI Publisher Description: シリアル番号取引台帳 Application: Inventory Source: シリアル番号取引台帳(XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG KO INV 일련번호 트랜잭션 등록 Imported from BI Publisher Description: 일련번호 트랜잭션 등록 Application: Inventory Source: 일련번호 트랜잭션 등록(XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG PTB INV Registro de transação do número de série Imported from BI Publisher Description: Registro de transação do número de série Application: Inventário Source: Registro de transação do número de série (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG RU INV Реестр транзакций с серийными номерами Imported from BI Publisher Description: Реестр транзакций с серийными номерами Application: Запасы Source: Реестр транзакций с серийными номерами (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG S INV Serienummer - transaktionsregister Imported from BI Publisher Description: Serienummer - transaktionsregister Application: Inventory Source: Serienummer - transaktionsregister (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG TR INV Seri numarası işlem kaydı Imported from BI Publisher Description: Seri numarası işlem kaydı Application: Stok Yönetimi Source: Seri numarası işlem kaydı (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG US INV Serial number transaction register Imported from BI Publisher Description: Serial number transaction register Application: Inventory Source: Serial number transaction register (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG ZHS INV 序列号事务处理登记表 Imported from BI Publisher Description: 序列号事务处理登记 Application: 库存管理系统 Source: 序列号事务处理登记表 (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG BI Publisher &c_reason_where &c_serial_where &c_source_type_where &c_source_where &c_subinv_where &c_txn_src_value &c_txn_type_where &c_type_break_from &p_catg_where &p_item_flexdata &p_item_where &p_mkts_flexdata :c_ext_precision :c_std_precision :p_audit_detail :p_break_id :p_category_detail :p_catg_flexdata :p_catg_hi :p_catg_lo :p_catg_order_by :p_catg_set_id :p_catg_struct_num :p_catg_where :p_conc_request_id :p_dummy :p_dummy_validate :p_g_org :p_glcc_flexdata :p_glcc_order_by :p_glcc_struct_num :p_item_flexdata :p_item_hi :p_item_lo :p_item_order_by :p_item_where :p_loc_detail :p_loc_flexdata :p_lot_detail :p_mdsp_flexdata :p_mdsp_order_by :p_mkts_flexdata :p_mkts_order_by :p_optimizer_code :p_order_source :p_org_id :p_qty_precision :p_reason_detail :p_reason_hi :p_reason_lo :p_rpt_qty_type :p_rpt_uom :p_rpt_uom_type :p_serial_hi :p_serial_lo :p_source_where :p_struct_num :p_subinv_hi :p_subinv_lo :p_trace_flag :p_txn_date_hi :p_txn_date_lo :p_txn_source_hi :p_txn_source_lo :p_txn_source_type_id :p_txn_type_hi :p_txn_type_lo 1 -80 :p_break_id Number 3 Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Bazı Sıralama Bazı US Sort By Sort By ZHS 排序依据 排序依据 2 -70 :p_g_org Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR P_G_ORG التنظيم العام D P_G_ORG Globale Organisation E P_G_ORG Organización Global F P_G_ORG Organisation globale I P_G_ORG Organizzazione globale JA P_G_ORG グローバル組織 KO P_G_ORG 글로벌 조직 PTB P_G_ORG Organização Global RU P_G_ORG Глобальная организация S P_G_ORG Global organisation TR P_G_ORG Global Organizasyon US P_G_ORG Global Organization ZHS P_G_ORG 全局组织 3 -60 :p_dummy Number SELECT 1 FROM DUAL WHERE :$flex$.organization is not null US P_DUMMY DUMMY 4 -50 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية الدقة D Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión F Précision des quantités Précision I Precisione quantità Precisione JA 数量精度 精度 KO 수량 소수점이하 자리수 소수점 이하 자리수 PTB Precisão da Quantidade Precisão RU Точность количества Точность S Kvantitetsprecision Precision TR Miktar Duyarlılığı Duyarlılık US Quantity Precision Precision ZHS 数量精确度 精确度 5 -40 :p_glcc_struct_num Number select chart_of_accounts_id from org_organization_definitions where organization_id = fnd_profile.value('mfg_organization_id') Y AR هيكل الأستاذ العام هيكل الأستاذ العام D Rechnungswesenstruktur Rechnungswesenstruktur E Estructura Contable Estructura Contable F Structure GL Structure GL I Struttura GL Struttura GL JA GL体系 GL体系 KO GL 구조 GL 구조 PTB Estrutura GL Estrutura GL RU Структура ГК Структура ГК S RED-struktur RED-struktur TR GL Yapısı GL Yapısı US GL Structure GL Structure ZHS GL 结构 GL 结构 6 -30 :p_dummy_validate Number SELECT 1 FROM DUAL WHERE (:$flex$.organization:NULL IS NOT NULL OR :$flex$.to:NULL IS NOT NULL) Y AR التنظيم أو الصنف p_dummy_validate D Organisation oder Artikel p_dummy_validate E Organización o Artículo p_dummy_validate F Organisation ou article p_dummy_validate I Organizzazione o articolo p_dummy_validate JA 組織または品目 p_dummy_validate KO 조직 또는 품목 p_dummy_validate PTB Organização ou Item p_dummy_validate RU Организация или позиция p_dummy_validate S Organisation eller artikel p_dummy_validate TR Organizasyon veya Kalem p_dummy_validate US Organization or Item p_dummy_validate ZHS 组织或物料 p_dummy_validate 7 -20 :p_catg_struct_num Number select structure_id from mtl_category_sets where category_set_id = nvl(:$flex$.category_set,NULL) Y AR هيكل الفئة هيكل الفئة D Kategoriestruktur Kategoriestruktur E Estructura de Categoría Estructura de Categoría F Structure de catégorie Structure de catégorie I Struttura categoria Struttura categoria JA カテゴリ体系 カテゴリ体系 KO 범주 구조 범주 구조 PTB Estrutura da Categoria Estrutura da Categoria RU Структура категорий Структура категорий S Kategoristruktur Kategoristruktur TR Kategori Yapısı Kategori Yapısı US Category Structure Category Structure ZHS 类别结构 类别结构 8 10 :p_rpt_uom LOV Oracle INV_SRS_REG_UOM Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_REG_UOM' and enabled_flag='Y' order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'INV_SRS_REG_UOM' AND LOOKUP_CODE = 2 Y AR وحدة القياس وحدة القياس D Maßeinheit Maßeinheit E Unidad de Medida Unidad de Medida F Unité de mesure Unité de mesure I Unità di misura Unità di misura JA 単位 単位 KO UOM UOM PTB Unidade de Medida Unidade de Medida RU ЕИ ЕИ S Måttenhet Måttenhet TR Ölçü Birimi Ölçü Birimi US Unit of Measure Unit of Measure ZHS 单位 单位 9 20 :p_org_id LOV Oracle INV_SRS_ORG_ACCESS Y select organization_id id, organization_code value, organization_name description from org_access_view where responsibility_id=to_number(fnd_profile.value('RESP_ID')) and resp_application_id=to_number(fnd_profile.value('RESP_APPL_ID')) order by organization_code SELECT ORGANIZATION_CODE FROM MTL_PARAMETERS WHERE ORGANIZATION_ID= :$flex$.p_g_org 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 组织 组织 10 30 :p_txn_date_lo Date sysdate Y AR تواريخ الحركات من من تاريخ D Von Transaktionsdatum Von Datum E De Fecha de Transacción De Fecha F Dates de mouvement - Du Date - Du I Date transazione - Da Data - Da JA 取引日:自 日付:自 KO 트랜잭션 일자: 부터 일자: 부터 PTB Datas Transação - De Data De RU Даты транзакций с Дата с S Från transaktionsdatum Från datum TR İşlem Tarihleri: İlk Başlangıç Tarihi US Transaction Dates From Date From ZHS 事务处理起始日期 日期自 11 40 :p_txn_date_hi Date sysdate Y AR إلى إلى تاريخ D Bis Bis Datum E A A Fecha F Au Date - Au I A Data - A JA 至 日付:至 KO 까지 일자: 까지 PTB Até Data Até RU По Дата по S Till Till datum TR Son Bitiş Tarihi US To Date To ZHS 至 日期至 12 50 :p_audit_detail LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code select meaning from mfg_lookups where lookup_code = 2 and lookup_type = 'SYS_YES_NO' Y AR تفاصيل التدقيق تفاصيل التدقيق D Protokolldetails Protokolldetails E Detalle de Auditoría Detalle de Auditoría F Détails audit Détails audit I Dettagli audit Dettagli audit JA 監査詳細 監査詳細 KO 감사 상세내역 감사 상세내역 PTB Detalhe da Auditoria Detalhe da Auditoria RU Сведения об аудите Сведения об аудите S Kontrolldetalj Kontrolldetalj TR Denetleme Detayı Denetleme Detayı US Audit Detail Audit Detail ZHS 跟踪明细 跟踪明细 13 60 :p_reason_detail LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code select meaning from mfg_lookups where lookup_code = 2 and lookup_type = 'SYS_YES_NO' Y AR تفاصيل السبب تفاصيل السبب D Grund-Detail Grund-Detail E Detalle de Motivo Detalle de Motivo F Détails motif Détails motif I Dettaglio motivo Dettaglio motivo JA 事由詳細 事由詳細 KO 사유 상세내역 사유 상세내역 PTB Detalhe do Motivo Detalhe do Motivo RU Сведения об основании Сведения об основании S Orsaksdetalj Orsaksdetalj TR Neden Detayı Neden Detayı US Reason Detail Reason Detail ZHS 原因明细 原因明细 14 70 :p_loc_detail LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code select meaning from mfg_lookups where lookup_code = 2 and lookup_type = 'SYS_YES_NO' Y AR تفاصيل الموقع تفاصيل الموقع D Lagerplatzdetails Lagerplatzdetails E Detalle de Ubicación Detalle de Ubicación F Détails lieu Détails lieu I Dettaglio ubicazione Dettaglio ubicazione JA 事業所詳細 事業所詳細 KO 위치 상세내역 위치 상세내역 PTB Detalhe do Local Detalhe do Local RU Сведения о расположении Сведения о расположении S Platsdetalj Platsdetalj TR Yerleşim Detayı Yerleşim Detayı US Location Detail Location Detail ZHS 地点明细 地点明细 15 80 :p_category_detail LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code select meaning from mfg_lookups where lookup_code = 2 and lookup_type = 'SYS_YES_NO' Y AR تفاصيل الفئة تفاصيل الفئة D Kategoriedetails Kategoriedetails E Detalle de Categoría Detalle de Categoría F Détails catégorie Détails catégorie I Dettagli categoria Dettagli categoria JA カテゴリ詳細 カテゴリ詳細 KO 범주 상세내역 범주 상세내역 PTB Detalhe da Categoria Detalhe da Categoria RU Сведения о категории Сведения о категории S Kategoridetalj Kategoridetalj TR Kategori Detayı Kategori Detayı US Category Detail Category Detail ZHS 类别明细 类别明细 16 90 :p_lot_detail LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code select meaning from mfg_lookups where lookup_code = 2 and lookup_type = 'SYS_YES_NO' Y AR تفاصيل رقم اللوط تفاصيل رقم اللوط D Losnummerndetails Losnummerndetails E Detalle de Número de Lote Detalle de Número de Lote F Détails numéro lot Détails numéro lot I Dettagli numero lotto Dettagli numero lotto JA ロット番号詳細 ロット番号詳細 KO 로트번호 상세내역 로트번호 상세내역 PTB Detalhe do Número de Lote Detalhe do Número de Lote RU Сведения о номере партии Сведения о номере партии S Partinummerdetalj Partinummerdetalj TR Lot Numarası Detayı Lot Numarası Detayı US Lot Number Detail Lot Number Detail ZHS 批号明细 批号明细 17 100 :p_serial_lo LOV Oracle INV_SRS_SERIAL_ITEM_DESC Y select serial_number id, serial_number value, item description from mtl_serial_number_gen_v where current_organization_id= nvl(:$flex$.inv_srs_org_access:null,current_organization_id) order by value,description AR أرقام مسلسة من رقم مسلسل من D Von Seriennummer Von Seriennummer E De Número de Serie De Número de Serie F Numéro série - De Numéro de série - De I Numeri di serie - Da Numero di serie - Da JA シリアル番号:自 シリアル番号:下位 KO 일련번호: 부터 일련번호 하한 PTB Números de Série - De Número de Série - Inferior RU Серийные номера с Серийный номер с S Från serienummer Serienummer från TR Seri Numarası, İlk Seri Numarası İlk: US Serial Numbers From Serial Number Low ZHS 序列号自 序列号下限 18 110 :p_serial_hi LOV Oracle INV_SRS_SERIAL_ITEM_DESC Y select serial_number id, serial_number value, item description from mtl_serial_number_gen_v where current_organization_id= nvl(:$flex$.inv_srs_org_access:null,current_organization_id) order by value,description AR إلى 2 رقم مسلسل إلى D Bis 2 Bis Seriennummer E A 2 A Número de Serie F A Numéro de série - A I A 2 Numero di serie massimo JA 至 2 シリアル番号:上位 KO 까지 2 일련번호 상한 PTB Até 2 Número de Série - Superior RU По 2 Серийный номер по S Till 2 Till serienummer TR Son 2 Seri Numarası Son: US To 2 Serial Number High ZHS 至 2 序列号上限 19 120 :p_item_lo Char AR الأصناف من صنف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Article - De I Articoli - Da Articolo - Minimo JA 品目:自 品目:下位 KO 품목: 부터 품목 하한 PTB Itens - De Item Inferior RU Позиции с Позиция с S Från artiklar Från artikel TR Kalemler - İlk Kalem Alt Değeri US Items From Item Low ZHS 物料自 物料下限 20 130 :p_item_hi Char AR إلى 3 صنف إلى D Bis 3 Bis Artikel E A 3 A Artículo F A 2 Article - A I A 3 Articolo - Massimo JA 至 3 品目:上位 KO 까지 3 품목 상한 PTB Até 3 Item Superior RU По 3 Позиция по S Till 3 Till artikel TR Son 3 Kalem Üst Değeri US To 3 Item High ZHS 至 3 物料上限 21 140 :p_txn_type_lo LOV Oracle INV_SRS_TXN_TYPE_NV Y select transaction_type_name id, transaction_type_name value, description description from mtl_transaction_types order by value,description AR أنواع الحركة من نوع الحركة من D Von Transaktionsart Von Transaktionsart E De Tipo de Transacción De Tipo de Transacción F Type mouvement - De Type de mouvement - De I Tipi di transazione - Da Tipo transazione - Minimo JA 取引タイプ:自 取引タイプ:自 KO 트랜잭션 유형: 부터 트랜잭션 유형 하한 PTB Tipos de Transação - De Tipo de Transação - Inferior RU Типы транзакций с Тип транзакции с S Transaktionstyper från Från transaktionstyp TR İşlem Tipleri: İlk İşlem Tipi Alt Değeri US Transaction Types From Transaction Type Low ZHS 事务处理类型自 事务处理类型下限 22 150 :p_txn_type_hi LOV Oracle INV_SRS_TXN_TYPE_NV Y select transaction_type_name id, transaction_type_name value, description description from mtl_transaction_types order by value,description AR إلى 4 نوع الحركة إلى D Bis 4 Bis Transaktionsart E A 4 A Tipo de Transacción F A 3 Type de mouvement - A I A 4 Tipo transazione - Massimo JA 至 4 取引タイプ:至 KO 까지 4 트랜잭션 유형 상한 PTB Até 4 Tipo de Transação - Superior RU По 4 Тип транзакции по S Till 4 Till transaktionstyp TR Son 4 İşlem Tipi Üst Değeri US To 4 Transaction Type High ZHS 至 4 事务处理类型上限 23 160 :p_reason_lo LOV Oracle INV_SRS_TXN_REASON Y select reason_name id, reason_name value, description description from mtl_transaction_reasons order by value,description AR أسباب الحركة من سبب حركة من D Von Transaktionsgrund Von Transaktionsgrund E De Motivo de Transacción De Motivo de Transacción F Motif mouvement - De Motif mouvement - De I Motivi transazione da Motivo transazione - Da JA 取引事由:自 取引事由:下位 KO 트랜잭션 사유: 부터 트랜잭션 사유 하한 PTB Motivos da Transação - De Motivo da Transação - Inferior RU Основания транзакций с Основание транзакции с S Transaktionsorsaker från Transaktionsorsak från TR İşlem Nedenleri: İlk İşlem Nedeni İlk: US Transaction Reasons From Transaction Reason Low ZHS 事务处理原因自 事务处理原因下限 24 170 :p_reason_hi LOV Oracle INV_SRS_TXN_REASON Y select reason_name id, reason_name value, description description from mtl_transaction_reasons order by value,description AR إلى 5 سبب حركة إلى D Bis 5 Bis Transaktionsgrund E A 5 A Motivo de Transacción F A 4 Motif mouvement - A I A 5 Motivo transazione - A JA 至 5 取引事由:上位 KO 까지 5 트랜잭션 사유 상한 PTB Até 5 Motivo da Transação - Superior RU По 5 Основание транзакции по S Till 5 Transaktionsorsak till TR Son 5 İşlem Nedeni Son: US To 5 Transaction Reason High ZHS 至 5 事务处理原因上限 25 180 :p_subinv_lo LOV Oracle INV_SRS_SUBINV_GEN Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=:$flex$.inv_srs_org_access and :$flex$.p_dummy=1 and :$flex$.inv_srs_org_access is not null order by secondary_inventory_name AR المخازن من مخزن من D Von Lager Von Lager E De Subalmacén De Subalmacén F Magasins - De Magasin - De I Sottomagazzini - Da Sottomagazzino - Da JA 保管場所:自 保管場所:下位 KO 창고: 부터 창고 하한 PTB Subinventários - De Subinventário - Inferior RU Складские подразделения с Складское подразделение с S Från lagerställen Från lagerställe TR Stok Yerleri, İlk Stok Yeri İlk: US Subinventories From Subinventory Low ZHS 子库存自 子库存下限 26 190 :p_subinv_hi LOV Oracle INV_SRS_SUBINV_GEN Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=:$flex$.inv_srs_org_access and :$flex$.p_dummy=1 and :$flex$.inv_srs_org_access is not null order by secondary_inventory_name AR إلى 6 مخزن إلى D Bis 6 Bis Lager E A 6 A Subalmacén F A 5 Magasin - A I A 6 Sottomagazzino - A JA 至 6 保管場所:上位 KO 까지 6 창고 상한 PTB Até 6 Subinventário - Superior RU По 6 Складское подразделение по S Till 6 Till lagerställe TR Son 6 Stok Yeri Son: US To 6 Subinventory High ZHS 至 6 子库存上限 27 200 :p_catg_set_id LOV Oracle INV_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by value,description select category_set_name from mtl_default_sets_view where functional_area_id = 1 Y AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet E Juego de Categorías Juego de Categorías F Jeu de catégories Jeu de catégories I Serie di categorie Serie di categorie JA カテゴリ・セット カテゴリ・セット KO 범주 세트 범주 세트 PTB Conj. Categorias Conj. Categorias RU Набор катег. Набор катег. S Kategoriuppsättning Kategoriuppsättning TR Kategori Kümesi Kategori Kümesi US Category Set Category Set ZHS 类别集 类别集 28 210 :p_catg_lo Char AR الفئات من الفئة من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégorie - De I Categorie - Da Categoria (min) JA カテゴリ:自 カテゴリ:下位 KO 범주: 부터 범주 하한 PTB Categorias - De Categoria - Inferior RU Категории с Категория с S Från kategorier Från kategori TR Kategoriler - İlk Kategori Alt Değeri US Categories From Category Low ZHS 类别自 类别下限 29 220 :p_catg_hi Char AR إلى 7 الفئة إلى D Bis 7 Bis Kategorie E A 7 Categoría Superior F A 6 Catégorie - A I A 7 Categoria (max) JA 至 7 カテゴリ:上位 KO 까지 7 범주 상한 PTB Até 7 Categoria - Superior RU По 7 Категория по S Till 7 Till kategori TR Son 7 Kategori Üst Değeri US To 7 Category High ZHS 至 7 类别上限 30 230 :p_txn_source_type_id LOV Oracle INV_SRS_SOURCE_TYPE_NC Y select transaction_source_type_id id, transaction_source_type_name value, description description from mtl_txn_source_types where transaction_source_type_id!=11 order by transaction_source_type_name AR نوع المصدر نوع المصدر D Bezugsart Bezugsart E Tipo de Origen Tipo de Origen F Type d'origine Type d'origine I Tipo di origine Tipo di origine JA ソース・タイプ ソース・タイプ KO 출처 유형 출처 유형 PTB Tipo de Origem Tipo de Origem RU Тип источника Тип источника S Källtyp Källtyp TR Kaynak Tipi Kaynak Tipi US Source Type Source Type ZHS 来源类型 来源类型 31 240 :p_txn_source_lo Char AR مصادر الحركة من مصدر من D Von Transaktionsherkunft Von Herkunft E De Origen de Transacción De Origen F Origine mouvement - De Origine - De I Origini transazione da Origine - Da JA 取引ソース:自 ソース:下位 KO 트랜잭션 출처: 부터 출처 하한 PTB Origens da Transação - De Origem - Inferior RU Источники транзакций с Источник с S Transaktionskällor från Källor från TR İşlem Kaynakları: İlk İlk Kaynak US Transaction Sources From Source Low ZHS 事务处理来源自 来源下限 32 250 :p_txn_source_hi Char AR إلى 8 مصدر إلى D Bis 8 Bis Herkunft E A 8 A Origen F A 7 Origine - A I A 8 Origine - A JA 至 8 ソース:上位 KO 까지 8 출처 상한 PTB Até 8 Origem - Superior RU По 8 Источник по S Till 8 Källor till TR Son 8 Son Kaynak US To 8 Source High ZHS 至 8 来源上限 :$flex$.category_set Category Set Category Structure :$flex$.inv_srs_org_access Organization Subinventories From :$flex$.inv_srs_org_access Organization To 6 :$flex$.organization Organization P_DUMMY :$flex$.p_dummy P_DUMMY Subinventories From :$flex$.p_dummy P_DUMMY To 6 :$flex$.p_g_org P_G_ORG Organization