ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F7451A9E05362FB09050512Y SELECT CMIAKD.transaction_id TRANSACTION_ID ,CMIAKD.currency_code CURRENCY_CODE ,ROUND(CMIAKD.txn_unit_cost, 2) TXN_UNIT_COST ,CMIAKD.txn_date TXN_DATE ,CMIAKD.txn_type TXN_TYPE ,CMIAKD.txn_source TXN_SOURCE ,CMIAKD.txn_ini_qty TXN_INI_QTY ,CST_MGD_MSTR_BOOK_RPT.get_shipment_num (CMIAKD.transaction_id) SHIPMENT_NUMBER ,CST_MGD_MSTR_BOOK_RPT.get_waybill (CMIAKD.transaction_id) WAYBILL_NUMBER ,CST_MGD_MSTR_BOOK_RPT.get_po_number (CMIAKD.transaction_id, 'PO') PO_NUMBER ,CST_MGD_MSTR_BOOK_RPT.get_po_number (CMIAKD.transaction_id, 'SO') SALESORDER ,CST_MGD_MSTR_BOOK_RPT.get_trx_action (CMIAKD.transaction_id) TRX_ACTION ,ROUND(CMIAKD.txn_ini_unit_cost, 2) TXN_INI_UNIT_COST ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_qty TXN_INI_VALUE ,CMIAKD.txn_fnl_qty TXN_FNL_QTY ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) TXN_FNL_UNIT_COST ,CMIAKD.txn_qty TXN_QTY ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE ,NVL(ROUND(CMIAKD.txn_h_total_cost, 2),0) TXN_VALUE ,CST_MGD_MSTR_BOOK_RPT.get_break_by BREAK_BY ,CST_MGD_MSTR_BOOK_RPT.get_detail_param DETAIL_PARAM ,CST_MGD_MSTR_BOOK_RPT.get_include_item_cost INCL_COST FROM cst_mgd_mstr_book_temp CMIAKD WHERE CMIAKD.inventory_item_id = :inventory_item_id AND :p_break_by = 1 AND :p_detail <> 'S' UNION ALL SELECT CMIAKD.transaction_id TRANSACTION_ID ,CMIAKD.currency_code CURRENCY_CODE ,ROUND(CMIAKD.txn_unit_cost, 2) TXN_UNIT_COST ,CMIAKD.txn_date TXN_DATE ,CMIAKD.txn_type TXN_TYPE ,CMIAKD.txn_source TXN_SOURCE ,CMIAKD.txn_ini_qty TXN_INI_QTY ,CST_MGD_MSTR_BOOK_RPT.get_shipment_num (CMIAKD.transaction_id) SHIPMENT_NUMBER ,CST_MGD_MSTR_BOOK_RPT.get_waybill (CMIAKD.transaction_id) WAYBILL_NUMBER ,CST_MGD_MSTR_BOOK_RPT.get_po_number (CMIAKD.transaction_id, 'PO') PO_NUMBER ,CST_MGD_MSTR_BOOK_RPT.get_po_number (CMIAKD.transaction_id, 'SO') SALESORDER ,CST_MGD_MSTR_BOOK_RPT.get_trx_action (CMIAKD.transaction_id) TRX_ACTION ,ROUND(CMIAKD.txn_ini_unit_cost, 2) TXN_INI_UNIT_COST ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_qty TXN_INI_VALUE ,CMIAKD.txn_fnl_qty TXN_FNL_QTY ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) TXN_FNL_UNIT_COST ,CMIAKD.txn_qty TXN_QTY ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE ,NVL(ROUND(CMIAKD.txn_h_total_cost, 2),0) TXN_VALUE ,CST_MGD_MSTR_BOOK_RPT.get_break_by BREAK_BY ,CST_MGD_MSTR_BOOK_RPT.get_detail_param DETAIL_PARAM ,CST_MGD_MSTR_BOOK_RPT.get_include_item_cost INCL_COST FROM cst_mgd_mstr_book_temp CMIAKD WHERE CMIAKD.inventory_item_id = :inventory_item_id AND CMIAKD.organization_id = :organization_id AND :p_break_by IN (2, 4) AND :p_detail <> 'S' UNION ALL SELECT CMIAKD.transaction_id TRANSACTION_ID ,CMIAKD.currency_code CURRENCY_CODE ,ROUND(CMIAKD.txn_unit_cost, 2) TXN_UNIT_COST ,CMIAKD.txn_date TXN_DATE ,CMIAKD.txn_type TXN_TYPE ,CMIAKD.txn_source TXN_SOURCE ,CMIAKD.txn_ini_qty TXN_INI_QTY ,CST_MGD_MSTR_BOOK_RPT.get_shipment_num (CMIAKD.transaction_id) SHIPMENT_NUMBER ,CST_MGD_MSTR_BOOK_RPT.get_waybill (CMIAKD.transaction_id) WAYBILL_NUMBER ,CST_MGD_MSTR_BOOK_RPT.get_po_number (CMIAKD.transaction_id, 'PO') PO_NUMBER ,CST_MGD_MSTR_BOOK_RPT.get_po_number (CMIAKD.transaction_id, 'SO') SALESORDER ,CST_MGD_MSTR_BOOK_RPT.get_trx_action (CMIAKD.transaction_id) TRX_ACTION ,ROUND(CMIAKD.txn_ini_unit_cost, 2) TXN_INI_UNIT_COST ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_qty TXN_INI_VALUE ,CMIAKD.txn_fnl_qty TXN_FNL_QTY ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) TXN_FNL_UNIT_COST ,CMIAKD.txn_qty TXN_QTY ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE ,NVL(ROUND(CMIAKD.txn_h_total_cost, 2),0) TXN_VALUE ,CST_MGD_MSTR_BOOK_RPT.get_break_by BREAK_BY ,CST_MGD_MSTR_BOOK_RPT.get_detail_param DETAIL_PARAM ,CST_MGD_MSTR_BOOK_RPT.get_include_item_cost INCL_COST FROM cst_mgd_mstr_book_temp CMIAKD WHERE CMIAKD.inventory_item_id = :inventory_item_id AND CMIAKD.organization_id = :organization_id AND CMIAKD.subinventory_code = :sub_inv_org_name AND CMIAKD.sub_inv_organization_id = :sub_inv_org_id AND :p_break_by IN (3, 5) AND :p_detail <> 'S' UNION ALL SELECT 0 TRANSACTION_ID ,NULL CURRENCY_CODE ,0 TXN_UNIT_COST ,NULL TXN_DATE ,txn_type2 TXN_TYPE ,NULL TXN_SOURCE ,0 TXN_INI_QTY ,NULL SHIPMENT_NUMBER ,NULL WAYBILL_NUMBER ,NULL PO_NUMBER ,NULL SALESORDER ,NULL TRX_ACTION ,0 TXN_INI_UNIT_COST ,0 TXN_INI_VALUE ,0 TXN_FNL_QTY ,0 TXN_FNL_UNIT_COST ,SUM(txn_qty2) TXN_QTY ,0 TXN_FNL_VALUE ,NVL(SUM(txn_value2),0) TXN_VALUE ,MAX(break_by2) BREAK_BY ,MAX(detail_param2) DETAIL_PARAM ,MAX(incl_cost2) INCL_COST FROM ( SELECT CMIAKD.txn_type TXN_TYPE2 ,CMIAKD.txn_qty TXN_QTY2 ,NVL(ROUND(CMIAKD.txn_h_total_cost, 2),0) TXN_VALUE2 ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_qty TXN_FNL_VALUE2 ,CST_MGD_MSTR_BOOK_RPT.get_break_by BREAK_BY2 ,CST_MGD_MSTR_BOOK_RPT.get_detail_param DETAIL_PARAM2 ,CST_MGD_MSTR_BOOK_RPT.get_include_item_cost INCL_COST2 FROM cst_mgd_mstr_book_temp CMIAKD WHERE CMIAKD.inventory_item_id = :inventory_item_id AND :p_break_by = 1 AND :p_detail = 'S' UNION ALL SELECT CMIAKD.txn_type TXN_TYPE2 ,CMIAKD.txn_qty TXN_QTY2 ,NVL(ROUND(CMIAKD.txn_h_total_cost, 2),0) TXN_VALUE2 ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE2 ,CST_MGD_MSTR_BOOK_RPT.get_break_by BREAK_BY2 ,CST_MGD_MSTR_BOOK_RPT.get_detail_param DETAIL_PARAM2 ,CST_MGD_MSTR_BOOK_RPT.get_include_item_cost INCL_COST2 FROM cst_mgd_mstr_book_temp CMIAKD WHERE CMIAKD.inventory_item_id = :inventory_item_id AND CMIAKD.organization_id = :organization_id AND :p_break_by IN (2, 4) AND :p_detail = 'S' UNION ALL SELECT CMIAKD.txn_type TXN_TYPE2 ,CMIAKD.txn_qty TXN_QTY2 ,NVL(ROUND(CMIAKD.txn_h_total_cost, 2),0) TXN_VALUE2 ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE2 ,CST_MGD_MSTR_BOOK_RPT.get_break_by BREAK_BY2 ,CST_MGD_MSTR_BOOK_RPT.get_detail_param DETAIL_PARAM2 ,CST_MGD_MSTR_BOOK_RPT.get_include_item_cost INCL_COST2 FROM cst_mgd_mstr_book_temp CMIAKD WHERE CMIAKD.inventory_item_id = :inventory_item_id AND CMIAKD.organization_id = :organization_id AND CMIAKD.subinventory_code = :sub_inv_org_name AND CMIAKD.sub_inv_organization_id = :sub_inv_org_id AND :p_break_by IN (3, 5) AND :p_detail = 'S' ) GROUP BY TXN_TYPE2 ORDER BY 4, 1 ASC BOM CSTGMSBK_XML AR CST تقرير دفتر الحسابات الرئيسي للمخازن (تنسيق XML) Imported from BI Publisher Description: تقرير دفتر الحسابات الرئيسي للمخازن Application: شجرة المنتجات Source: تقرير دفتر الحسابات الرئيسي للمخازن (تنسيق XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT D CST Bestandsbewegungen Imported from BI Publisher Description: Bestandsbewegungen Application: Produktionsdaten Source: Bestandsbewegungen (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT E CST Libro Maestro de Inventario Imported from BI Publisher Description: Informe Libro Maestro de Inventario Application: Bills of Material Source: Libro Maestro de Inventario (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT F CST Déclaration des mouvements de stock Imported from BI Publisher Description: Déclaration des mouvements de stock Application: Bills of Material Source: Déclaration des mouvements de stock (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT I CST Rapporto Registro principale magazzino Imported from BI Publisher Description: Rapporto registro principale magazzino Application: Bills of Material Source: Rapporto Registro principale magazzino (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT JA CST 在庫マスター・ブック・レポート Imported from BI Publisher Description: 在庫マスター・ブック・レポート Application: Bills of Material Source: 在庫マスター・ブック・レポート(XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT KO CST 재고 마스터 장부 보고서 Imported from BI Publisher Description: 재고 마스터 장부 보고서 Application: Bills of Material Source: 재고 마스터 장부 보고서(XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT PTB CST Relatório do Livre-Mestre do Inventário Imported from BI Publisher Description: Relatório do Livro mestre de Inventário Application: Bills of Material Source: Relatório do Livre-Mestre do Inventário (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT RU CST Отчет по главной книге запасов Imported from BI Publisher Description: Отчет по главной книге запасов Application: Спецификации Source: Отчет по главной книге запасов (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT S CST Lagerregisterrapport Imported from BI Publisher Description: Lagerregisterrapport Application: Bills of Material Source: Lagerregisterrapport (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT TR CST Envanter Ana Defter Raporu Imported from BI Publisher Description: Envanter ana Defter Raporu Application: Ürün Ağacı Source: Envanter Ana Defter Raporu (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT US CST Inventory Master Book Imported from BI Publisher Description: Inventory master Book Report Application: Bills of Material Source: Inventory Master Book Report (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT ZHS CST 库存主帐套报表 Imported from BI Publisher Description: 库存主帐套报表 Application: 物料清单管理系统 Source: 库存主帐套报表 (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT BI Publisher :gc_abc_class_name :gc_abc_group_name :gc_application :gc_break :gc_category_set_name_1 :gc_category_set_name_2 :gc_currency_code :gc_detail :gc_include_cost :gc_request_time :gc_requested_by :gc_responsibility :gd_rpt_date_from :gd_rpt_date_to :gn_precision_val :gn_row_count :inventory_item_id :organization_id :p_abc_class_id :p_abc_group_id :p_break_by :p_category_from :p_category_set_id_from :p_category_set_id_to :p_category_structure :p_category_to :p_date_from :p_date_from_formatting :p_date_to :p_date_to_formatting :p_detail :p_fiscal_year :p_include_item_cost :p_inventory_org :p_item_code_from :p_item_code_to :p_ledger_id :p_legal_entity :p_org_id :p_page_number :p_subinv_from :p_subinv_to :sub_inv_org_id :sub_inv_org_name 1 -20 :p_dummy 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' AND :$flex$.all_or_single_inventory_organization = (SELECT lookup_code FROM mfg_lookups WHERE lookup_type = 'CST_ALL_OR_ONE_INV' AND lookup_code = '2' AND enabled_flag ='Y') AR Dummy افتراضي E Dummy Ficticio F Dummy Fictif I Dummy Fittizio JA Dummy ダミー PTB Dummy Fictício RU Dummy Фиктивный TR Dummy Sözde US Dummy Dummy ZHS Dummy 虚拟 2 -10 :p_category_structure Number SELECT MIN(structure_id) FROM mtl_category_sets WHERE category_set_id = :$flex$.category_set_from AND :$flex$.category_set_from = :$flex$.category_set_to 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 类别结构 类别结构 3 10 :p_legal_entity LOV Oracle CST_LEGAL_ENTITY Y select legal_entity_id id, name value, null description from xle_firstparty_information_v where le_effective_to is null order by value,description Y AR الكيان القانوني الكيان القانوني D Mandant Mandant E Entidad Legal Entidad Legal 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 法人主体 法人主体 4 20 :p_ledger_id LOV Oracle CST_LEDGER_NAME Y select glcd2.object_id id, glcd2.object_name value, glcd2.object_type_code description from gl_ledger_configurations glc,gl_ledger_config_details glcd,gl_ledger_config_details glcd2,xle_firstparty_information_v hou,gl_lookups gll where glcd.object_id=hou.legal_entity_id and glcd.object_type_code='LEGAL_ENTITY' and glc.configuration_id=glcd.configuration_id and glc.configuration_id<>-1 and glc.configuration_id<>-2 and glcd2.configuration_id=glc.configuration_id and glcd2.object_type_code in ('PRIMARY','SECONDARY') and hou.legal_entity_id=:$flex$.cst_legal_entity and glcd2.setup_step_code='NONE' and gll.lookup_type='GL_ASF_CFG_STATUS_CODES' and gll.lookup_code=glc.completion_status_code order by value,description Y AR دفتر الأستاذ اسم دفتر الأستاذ D Buch Buchbezeichnung E Libro Mayor Nombre del libro mayor F Livre Nom de livre I Libro contabile Nome libro contabile JA 元帳 元帳名 KO 원장 원장명 PTB Razão Nome do Razão RU Книга Имя книги S Huvudbok Huvudbok TR Defter Defter Adı US Ledger Ledger Name ZHS 分类帐 分类帐名称 5 30 :p_all_or_single LOV Oracle CST_ALL_OR_SINGLE_INV Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='CST_ALL_OR_ONE_INV' and lookup_code in ('1','2') and enabled_flag='Y' order by value,description SELECT meaning FROM mfg_lookups WHERE lookup_type = 'CST_ALL_OR_ONE_INV' AND lookup_code = '2' AND enabled_flag ='Y' Y AR كل تنظيمات المخازن أو تنظيم مخازن مفرد كل تنظيمات المخازن أو تنظيم مخازن مفرد D Alle oder einzelne Lagerorganisation(en) Alle oder einzelne Lagerorganisation(en) E Todas o Una Organización de Inventario Todas o Una Organización de Inventario F Toutes les organisations logistiques ou une seule Toutes les organisations logistiques ou une seule I Tutte o singola organizzazione magazzino Tutte o singola organizzazione magazzino JA すべてまたは単一の在庫組織 すべてまたは単一の在庫組織 KO 모든 또는 단일 재고 조직 모든 또는 단일 재고 조직 PTB Organização Total ou Única do Inventário Organização Total ou Única do Inventário RU Все или одна складская организация Все или одна складская организация S Alla eller enstaka lagerorganisation Alla eller enstaka lagerorganisation TR Envanter Organizasyonlarının Tümü veya Biri Envanter Organizasyonlarının Tümü veya Biri US All or Single Inventory Organization All or Single Inventory Organization ZHS 所有或单个库存组织 所有或单个库存组织 6 40 :p_inventory_org LOV Oracle CST_INVENTORY_ORGANIZATION Y select hou.organization_id id, hou.name value, null description from hr_all_organization_units_tl hou,hr_organization_information hoi1,hr_organization_information hoi2,mtl_parameters mp,gl_ledgers lgr where hou.organization_id=hoi1.organization_id and hou.organization_id=hoi2.organization_id and hou.organization_id=mp.organization_id and hoi1.org_information1='INV' and hoi1.org_information2='Y' and (hoi1.org_information_context || '')='CLASS' and (hoi2.org_information_context || '')='Accounting Information' and hou.language=userenv('LANG') and to_number ( decode ( rtrim (translate (hoi2.org_information1,'0123456789',' ')) ,null ,hoi2.org_information1 ,-99999 ) )=lgr.ledger_id and hoi2.org_information2=:$flex$.cst_legal_entity and :$flex$.dummy=(select max(lookup_code) from fnd_lookups where lookup_type='YES_NO') and ( exists ( select 1 from org_access acc where acc.organization_id=mp.organization_id and acc.responsibility_id=fnd_global.resp_id ) ) and lgr.object_type_code='L' and nvl (lgr.complete_flag,'Y')='Y' order by value,description Y AR تنظيم المخازن تنظيم المخازن D Lagerorganisation Lagerorganisation E Organización de Inventario Organización de Inventario F Organisation logistique Organisation logistique I Organizzazione magazzino Organizzazione magazzino JA 在庫組織 在庫組織 KO 재고 조직 재고 조직 PTB Organização do Inventário Organização do Inventário RU Складская организация Складская организация S Lagerorganisation Lagerorganisation TR Envanter Organizasyonu Envanter Organizasyonu US Inventory Organization Inventory Organization ZHS 库存组织 库存组织 7 50 :p_subinv_from LOV Oracle CST_SUBINVENTORY Y select secondary_inventory_name id, secondary_inventory_name value, null description from mtl_secondary_inventories where organization_id=:$flex$.cst_inventory_organization order by value,description AR مخزن من مخزن من D Von Lager Von Lager E De Subalmacén De Subalmacén F Magasin - De Magasin - De I Sottomagazzino - Da Sottomagazzino - Da JA 保管場所:自 保管場所:自 KO 창고: 부터 창고: 부터 PTB Subinventário - De Subinventário - De RU Складское подразделение с Складское подразделение с S Från lagerställe Från lagerställe TR Stok Yeri: İlk Stok Yeri: İlk US Subinventory From Subinventory From ZHS 子库存自 子库存自 8 60 :p_subinv_to LOV Oracle CST_SUBINVENTORY_HIGH Y select secondary_inventory_name id, secondary_inventory_name value, null description from mtl_secondary_inventories where organization_id=:$flex$.cst_inventory_organization and secondary_inventory_name>=:$flex$.cst_subinventory order by value,description AR مخزن إلى مخزن إلى D Bis Lager Bis Lager E A Subalmacén A Subalmacén F Magasin - A Magasin - A I Sottomagazzino - A Sottomagazzino - A JA 保管場所:至 保管場所:至 KO 창고: 까지 창고: 까지 PTB Subinventário - Até Subinventário - Até RU Складское подразделение по Складское подразделение по S Till lagerställe Till lagerställe TR Stok Yeri: Son Stok Yeri: Son US Subinventory To Subinventory To ZHS 子库存至 子库存至 9 70 :p_date_from Date sysdate Y AR من تاريخ مدى التاريخ - من تاريخ D Datum von Datumsbereich - ab E De Fecha Rango de Fechas: De Fecha F Date - Du Fourchette de dates - Du I Data - Da Intervallo di date - Da JA 日付:自 日付範囲 - 日付:自 KO 일자 시작 일자 범위 - 시작 일자 PTB Data - De Faixa de datas - de RU Дата с Диапазон дат - начальная дата S Från datum Datumintervall - från den TR Başlangıç Tarihi Tarih aralığı - ilk tarih US Date From Date range - from date ZHS 起始日期 日期范围 - 起始日期 10 80 :p_date_to Date sysdate Y AR إلى تاريخ مدى التاريخ - إلى تاريخ D Bis Datum Datumsbereich - bis E A Fecha Rango de Fechas: A Fecha F Date - Au Fourchette de dates - Au I Data - A Intervallo di date - A JA 日付:至 日付範囲 - 日付:至 KO 일자: 까지 일자 범위 - 종료 일자 PTB Data - Até Faixa de datas - até RU Дата по Диапазон дат - конечная дата S Till datum Datumintervall - till den TR Bitiş Tarihi Tarih aralığı - son tarih US Date To Date range - to date ZHS 终止日期 日期范围 - 终止日期 11 90 :p_category_set_id_from LOV Oracle CST_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets where mult_item_cat_assign_flag='N' order by value,description SELECT A.category_set_name FROM mtl_category_sets A, mtl_default_category_sets B WHERE B.functional_area_id = 5 AND A.category_set_id = B.category_set_id AR مجموعة الفئات من مجموعة الفئات من D Von KategorieSet Von KategorieSet E De juego de categorías De juego de categorías F Jeu de catégories - De Jeu de catégories - De I Serie di categorie - Da Serie di categorie - Da JA カテゴリ・セット:自 カテゴリ・セット:自 KO 범주 세트 시작 범주 세트 시작 PTB Conjunto de Categorias - De Conjunto de Categorias - De RU Набор категорий с Набор категорий с S Från kategoriserie Från kategoriserie TR Kategori Kümesi, İlk Kategori Kümesi, İlk US Category Set From Category Set From ZHS 类别集自 类别集自 12 100 :p_category_set_id_to LOV Oracle CST_SRS_CATEGORY_SET_HIGH Y select category_set_id id, category_set_name value, description description from mtl_category_sets where mult_item_cat_assign_flag='N' and category_set_name>=( select category_set_name from mtl_category_sets where category_set_id=:$flex$.cst_srs_category_set) order by value,description SELECT A.category_set_name FROM mtl_category_sets A, mtl_default_category_sets B WHERE B.functional_area_id = 5 AND A.category_set_id = B.category_set_id AR مجموعة الفئات إلى مجموعة الفئات إلى D Bis KategorieSet Bis KategorieSet E A juego de categorías A juego de categorías F Jeu de catégories - A Jeu de catégories - A I Serie di categorie - A Serie di categorie - A JA カテゴリ・セット:至 カテゴリ・セット:至 KO 범주 세트 종료 범주 세트 종료 PTB Conjunto de Categorias - Até Conjunto de Categorias - Até RU Набор категорий по Набор категорий по S Till kategoriserie Till kategoriserie TR Kategori Kümesi, Son Kategori Kümesi, Son US Category Set To Category Set To ZHS 类别集至 类别集至 13 110 :p_category_from Char AR الفئات من فئة الصنف من D Von Kategorie Von Artikelkategorie E De Categoría De Categoría de Artículo F Catégories - De Catégories d'articles - De I Categorie - Da Categoria articolo - Da JA カテゴリ:自 品目カテゴリ:自 KO 범주: 부터 품목 범주: 부터 PTB Categorias - De Categoria do Item - De RU Категории с Категория позиции с S Från kategorier Från artikelkategori TR Kategoriler, İlk Kalem Kategorisi: İlk US Categories From Item Category From ZHS 类别自 物料类别自 14 120 :p_category_to Char AR إلى فئة الصنف إلى D Bis Bis Artikelkategorie E A A Categoría de Artículo F A Catégories d'articles - A I A Categoria articolo - A JA 至 品目カテゴリ:至 KO 까지 품목 범주: 까지 PTB Até Categoria do Item - Até RU По Категория позиции по S Till Till artikelkategori TR Son Kalem Kategorisi: Son US To Item Category To ZHS 至 物料类别至 15 130 :p_item_code_from Char AR الأصناف من مدى رمز الصنف D Von Artikel Artikelschlüsselbereich E De Artículo Rango de Códigos de Artículos F Articles - De Fourchette de codes article I Articoli - Da Intervallo dei codici articolo JA 品目:自 品目コード範囲 KO 품목: 부터 품목 코드 범위 PTB Itens - De Faixas de Códigos do Item RU Позиции с Диапазон кодов позиций S Från artiklar Artikelkodsintervall TR Kalemler, İlk Kalem Kodu Aralığı US Items From Item Code Range ZHS 物料自 物料代码范围 16 140 :p_item_code_to Char AR إلى 2 مدى رمز الصنف D Bis 2 Artikelschlüsselbereich E A 2 Rango de Códigos de Artículos F A 2 Fourchette de codes article I A 2 Intervallo dei codici articolo JA 至 2 品目コード範囲 KO 까지 2 품목 코드 범위 PTB Até 2 Faixas de Códigos do Item RU По 2 Диапазон кодов позиций S Till 2 Artikelkodsintervall TR Son 2 Kalem Kodu Aralığı US To 2 Item Code Range ZHS 至 2 物料代码范围 17 150 :p_abc_group_id LOV Oracle CST_ABC_ASSIGNMENT_GROUP Y select assignment_group_id id, assignment_group_name value, null description from mtl_abc_assignment_groups where organization_id=:$flex$.cst_inventory_organization order by value,description AR مجموعة تخصيص ABC مجموعة تخصيص ABC D ABC-Zuordnungsgruppe ABC-Zuordnungsgruppe E Grupo de Asignaciones ABC Grupo de Asignaciones ABC F Groupe d'affectations ABC Groupe d'affectations ABC I Gruppo Classificazione ABC Gruppo Classificazione ABC JA ABC割当グループ ABC割当グループ KO ABC 지정 그룹 ABC 지정 그룹 PTB Grupo de Atribuições ABC Grupo de Atribuições ABC RU Группа назначения ABC Группа назначения ABC S ABC-tilldelningsgrupp ABC-tilldelningsgrupp TR ABC Atama Grubu ABC Atama Grubu US ABC Assignment Group ABC Assignment Group ZHS ABC 分配组 ABC 分配组 18 160 :p_abc_class_id LOV Oracle CST_ABC_CLASSES Y select class.abc_class_id id, abc_class_name value, description description from mtl_abc_assgn_group_classes assgn,mtl_abc_classes class where assgn.abc_class_id=class.abc_class_id and assgn.assignment_group_id=:$flex$.cst_abc_assignment_group order by value,description AR طبقة ABC طبقة ABC D ABC-Klasse ABC-Klasse E Clase ABC Clase ABC F Classe ABC Classe ABC I Classe ABC Classe ABC JA ABC区分 ABC区分 KO ABC 분류 ABC 분류 PTB Classe ABC Classe ABC RU Класс ABC Класс ABC S ABC-klass ABC-klass TR ABC Sınıfı ABC Sınıfı US ABC Class ABC Class ZHS ABC 分类 ABC 分类 19 170 :p_detail LOV Oracle CST_DETAIL_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookup_values_vl where lookup_type='INV_BOOK_DETAIL' order by meaning select meaning from fnd_lookup_values_vl where lookup_type='INV_BOOK_DETAIL' and lookup_code='S' Y AR مستوى التفاصيل مستوى التفاصيل D Detailebene Detailebene E Nivel de Detalle Nivel de Detalle F Niveau de détail Niveau de détail I Livello di dettaglio Livello di dettaglio JA 詳細のレベル 詳細のレベル KO 상세내역 레벨 상세내역 레벨 PTB Nível de Detalhe Nível de Detalhes RU Уровень детализации Уровень детализации S Detaljnivå Detaljnivå TR Detay Düzeyi Detay Düzeyi US Level of Detail Level Of Detail ZHS 明细层 明细层 20 180 :p_include_item_cost 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 = 'N' Y AR عرض التكلفة تضمين تكلفة الصنف D Kosten anzeigen Artikelkosten berücksichtigen E Mostrar Coste Incluir Coste de Artículo F Afficher le coût Inclure le coût article I Visualizza costo Includi costo articolo JA 原価の表示 品目原価を含む KO 원가 표시 품목 원가 포함 PTB Exibir Custo Incluir Custo do Item RU Вывод затрат Включение стоимости позиций S Visa kostnad Inkludera artikelkostnad TR Maliyeti Görüntüle Kalem Maliyetini Dahil Eder. US Display Cost Include Item Cost ZHS 显示成本 包括物料成本 21 190 :p_break_by LOV Oracle CST_SRS_BREAK_BY_INV Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='CST_BREAK_BY_INV' order by lookup_code SELECT meaning FROM mfg_lookups WHERE lookup_type = 'CST_BREAK_BY_INV' AND lookup_code = '1' Y AR تقسيم حسب تقسيم حسب D Gliedern nach Gliedern nach E Desglosar por Desglosar por F Répartir par Répartir par I Suddividi per Suddividi per JA 区切り単位 区切り単位 KO 분석 기준 분석 기준 PTB Interromper Interromper RU Разбивка Разбивка S Bryt efter Bryt efter TR Kırılım Esası Kırılım Esası US Break By Break By ZHS 分段依据 分段依据 22 200 :p_page_number Char Y AR ترقيم الصفحات رقم الصفحة D Seitennummerierung Seitennummer E Numeración de Páginas Número de página F Numérotation des pages Numéro de page I Numerazione pagine Numero pagina JA ページ採番 ページ番号 KO 페이지 번호 지정 페이지 번호 PTB Numeração de Página Número da Página RU Нумерация страниц Номер страницы S Sidnumrering Sidnummer TR Sayfa Numaralama Sayfa Numarası US Page Numbering Page Number ZHS 页面编号 页码 23 210 :p_fiscal_year Char AR السنة المالية السنة المالية D Geschäftsjahr Geschäftsjahr E Año Fiscal Año Fiscal F Exercice Exercice I Anno fiscale Anno fiscale JA 会計年度 会計年度 KO 회계년도 회계년도 PTB Ano Fiscal Ano Fiscal RU Финансовый год Финансовый год S Räkenskapsår Räkenskapsår TR Mali Yıl Mali Yıl US Fiscal Year Fiscal Year ZHS 会计年度 会计年度