ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F6151A9E05362FB09050512 SELECT BEV.ORGANIZATION_ID COMPO_ORG_ID, BEV.SORT_ORDER SORT_ORDER, LPAD(TO_CHAR(BEV.PLAN_LEVEL), LEAST(9,BEV.PLAN_LEVEL),'.') PLAN_LEVEL, BEV.TOP_BILL_SEQUENCE_ID TOP_BILL_SEQUENCE_ID, BEV.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID10, BEV.ITEM_NUM ITEM_SEQ_NUM, BEV.OPERATION_SEQ_NUM OPERATION_SEQ_NUM, BEV.COMPONENT_ITEM_ID COMPONENT_ITEM_ID, BEV.ITEM_NUMBER COMPONENT_NUMBER, BEV.UNIT_OF_MEASURE ITEM_UOM, BEV.EFFECTIVITY_DATE EFFECTIVITY_DATE, TO_CHAR(BEV.EFFECTIVITY_DATE, 'HH24:MI') EFFECTIVITY_TIME, BEV.DISABLE_DATE DISABLE_DATE, TO_CHAR(BEV.DISABLE_DATE, 'HH24:MI') DISABLE_TIME, ROUND(BEV.COMPONENT_QUANTITY,:P_qty_precision) COMPONENT_QUANTITY, ROUND(BEV.EXTENDED_QUANTITY,:P_qty_precision) EXTENDED_QUANTITY, BEV.CHANGE_NOTICE CHANGE_NOTICE, SUBSTR(FL.MEANING,1,4) ENG_ITEM_FLAG, BEV.PARENT_ALTERNATE COMPONENT_ALTERNATE, BEV.ENG_BILL ENG_BILL, BEV.PLANNING_FACTOR PLANNING_FACTOR, ROUND(BEV.COMPONENT_YIELD_FACTOR,:P_qty_precision) COMPONENT_YIELD_FACTOR, DECODE(BOM.COMMON_BILL_SEQUENCE_ID, BOM.BILL_SEQUENCE_ID, BEV.WIP_SUPPLY_TYPE, PARENT.WIP_SUPPLY_TYPE) WIP_SUPPLY_TYPE, PARENT.ORGANIZATION_ID PARENT_ORG_ID, DECODE(BOM.COMMON_BILL_SEQUENCE_ID, BOM.BILL_SEQUENCE_ID, BEV.SUPPLY_SUBINVENTORY, PARENT.WIP_SUPPLY_SUBINVENTORY) SUPPLY_SUBINVENTORY, null C_LOCATOR_FLEXDATA, ROUND(BEV.MANUFACTURING_LEAD_TIME,:P_qty_precision) MANUFACTORYING_LEAD_TIME, BEV.PARENT_ITEM_ID PARENT_ITEM_ID, BEV.OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT, ROUND((1-(BEV.OPERATION_LEAD_TIME_PERCENT/100))*PARENT.FULL_LEAD_TIME,:P_qty_precision) OPERATION_OFFSET, ROUND(BEV.CUM_MANUFACTURING_LEAD_TIME,:P_qty_precision) CUM_MANUFACTURING_LEAN_TIME, ROUND(BEV.CUMULATIVE_TOTAL_LEAD_TIME,:P_qty_precision) CUMULATIVE_TOTAL_LEAD_TIME, SUBSTR(LU1.MEANING, 1, 20) BOM_ITEM_TYPE, BEV.OPTIONAL OPTIONAL, BEV.MUTUALLY_EXCLUSIVE_OPTIONS MUTUALLY_EXCLUSIVE_OPTIONS, BEV.CHECK_ATP CHECK_ATP, BEV.SO_BASIS SO_BASIS, BEV.REQUIRED_TO_SHIP REQUIRED_TO_SHIP, BEV.REQUIRED_FOR_REVENUE REQUIRED_FOR_REVENUE, BEV.INCLUDE_ON_SHIP_DOCS INCLUDE_ON_SHIP_DOCS, ROUND(BEV.MINIMUM_QUANTITY,:P_qty_precision) MINIMUM_QUANTITY, ROUND(BEV.MAXIMUM_QUANTITY,:P_qty_precision) MAXIMUM_QUANTITY, DECODE(BOM.COMMON_BILL_SEQUENCE_ID, BOM.BILL_SEQUENCE_ID, BEV.SUPPLY_LOCATOR_ID, PARENT.WIP_SUPPLY_LOCATOR_ID) SUPPLY_LOCATOR_ID, MCK.CONCATENATED_SEGMENTS CATEGORY, MSI.INVENTORY_ITEM_STATUS_CODE ITEM_STATUS, BOM_BOMRBOMS_XMLP_PKG.cf_comp_descformula(BEV.COMPONENT_ITEM_ID, BEV.ORGANIZATION_ID) CF_COMP_DESC, BOM_BOMRBOMS_XMLP_PKG.get_rev(BEV.ORGANIZATION_ID, BEV.COMPONENT_ITEM_ID) C_D3_REVISION, BOM_BOMRBOMS_XMLP_PKG.cf_revision_descformula(BEV.COMPONENT_ITEM_ID, :C_D3_REVISION) CF_REVISION_DESC, BOM_BOMRBOMS_XMLP_PKG.supply_type_dispformula(DECODE ( BOM.COMMON_BILL_SEQUENCE_ID , BOM.BILL_SEQUENCE_ID , BEV.WIP_SUPPLY_TYPE , PARENT.WIP_SUPPLY_TYPE )) supply_type_disp, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_flexfield', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_LOCATOR_FLEXFIELD, BOM_BOMRBOMS_XMLP_PKG.eng_bill_dispformula(BEV.ENG_BILL) ENG_BILL_DISP, BOM_BOMRBOMS_XMLP_PKG.optional_dispformula(BEV.OPTIONAL) OPTIONAL_DISP, BOM_BOMRBOMS_XMLP_PKG.mutually_dispformula(BEV.MUTUALLY_EXCLUSIVE_OPTIONS) MUTUALLY_DISP, BOM_BOMRBOMS_XMLP_PKG.check_atp_dispformula(BEV.CHECK_ATP) CHECK_ATP_DISP, BOM_BOMRBOMS_XMLP_PKG.required_to_ship_dispformula(BEV.REQUIRED_TO_SHIP) REQUIRED_TO_SHIP_DISP, BOM_BOMRBOMS_XMLP_PKG.required_for_revenue_dispformu(BEV.REQUIRED_FOR_REVENUE) REQUIRED_FOR_REVENUE_DISP, BOM_BOMRBOMS_XMLP_PKG.include_on_ship_docs_dispformu(BEV.INCLUDE_ON_SHIP_DOCS) INCLUDE_ON_SHIP_DOCS_DISP FROM BOM_EXPLOSION_VIEW BEV, MTL_ITEM_LOCATIONS MIL, FND_COMMON_LOOKUPS LU1, FND_LOOKUPS FL, BOM_BILL_OF_MATERIALS BOM, MTL_SYSTEM_ITEMS PARENT, MTL_SYSTEM_ITEMS MSI, MTL_ITEM_CATEGORIES MIC, MTL_DEFAULT_CATEGORY_SETS MDCS, MTL_CATEGORIES_KFV MCK, MFG_LOOKUPS ML WHERE BEV.GROUP_ID = :P_GROUP_ID AND BEV.PLAN_LEVEL > 0 AND BEV.SUPPLY_LOCATOR_ID = MIL.INVENTORY_LOCATION_ID(+) AND MIL.ORGANIZATION_ID(+) = BEV.ORGANIZATION_ID AND LU1.APPLICATION_ID(+) = 401 AND BEV.ITEM_TYPE = LU1.LOOKUP_CODE(+) AND LU1.LOOKUP_TYPE(+) = 'ITEM_TYPE' AND FL.LOOKUP_TYPE = 'YES_NO' AND FL.LOOKUP_CODE = BEV.ENG_ITEM_FLAG AND BEV.PARENT_ITEM_ID = PARENT.INVENTORY_ITEM_ID AND BEV.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = BEV.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIC.CATEGORY_SET_ID = MDCS.CATEGORY_SET_ID AND MDCS.FUNCTIONAL_AREA_ID = ML.LOOKUP_CODE AND ML.LOOKUP_TYPE = 'MTL_FUNCTIONAL_AREAS' AND ML.LOOKUP_CODE = 1 AND MIC.CATEGORY_ID = MCK.CATEGORY_ID AND BOM.BILL_SEQUENCE_ID = BEV.BILL_SEQUENCE_ID AND ( ( (:P_VERIFY_FLAG IS NULL) OR (:P_VERIFY_FLAG <> 1) ) OR ( (:P_VERIFY_FLAG = 1) AND (BEV.LOOP_FLAG = 1) ) ) and BEV.TOP_BILL_SEQUENCE_ID=:M_TOP_BILL_SEQUENCE_ID and PARENT.ORGANIZATION_ID=:M_ORG_ID ORDER BY BEV.SORT_ORDER Y BOM BOMRBOMV_XML AR BOM تقرير حلقة شجرة المنتجات (تنسيق XML) Imported from BI Publisher Description: تقرير حلقة شجرة المنتج Application: شجرة المنتجات Source: تقرير حلقة شجرة المنتجات (تنسيق XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG D BOM Stücklisten - Kontinuitätsprüfung Imported from BI Publisher Description: Stücklisten - Kontinuitätsprüfung Application: Produktionsdaten Source: Stücklisten - Kontinuitätsprüfung (XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG E BOM Bucles en Listas de Materiales Imported from BI Publisher Description: Informe de bucles en listas de materiales Application: Bills of Material Source: Bucles en Listas de Materiales (XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG F BOM Etat Bouclages de nomenclature Imported from BI Publisher Description: Etat Bouclages de nomenclature Application: Bills of Material Source: Etat Bouclages de nomenclature (XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG I BOM Rapporto Loop distinte base Imported from BI Publisher Description: Rapporto Loop distinte base Application: Bills of Material Source: Rapporto Loop distinte base (XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG JA BOM 部品構成表ループ・レポート Imported from BI Publisher Description: 部品構成表ループ・レポート Application: Bills of Material Source: 部品構成表ループ・レポート(XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG KO BOM 루프 보고서 Imported from BI Publisher Description: BOM 루프 보고서 Application: Bills of Material Source: BOM 루프 보고서(XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG PTB BOM Relatório de Loop da Lista de Materiais Imported from BI Publisher Description: Relatório de Loop da Lista de Materiais Application: Bills of Material Source: Relatório de Loop da Lista de Materiais (XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG RU BOM Отчет о цикле спецификаций Imported from BI Publisher Description: Отчет о цикле спецификаций Application: Спецификации Source: Отчет о цикле спецификаций (XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG S BOM Produktstrukturslinga Imported from BI Publisher Description: Produktstrukturslinga Application: Bills of Material Source: Produktstrukturslinga (XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG TR BOM Ürün Ağacı Döngü Raporu Imported from BI Publisher Description: Ürün Ağacı Döngü Raporu Application: Ürün Ağacı Source: Ürün Ağacı Döngü Raporu (XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG US BOM Bill of Material Loop Imported from BI Publisher Description: Bill of Material Loop Report Application: Bills of Material Source: Bill of Material Loop Report (XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG ZHS BOM 物料清单循环报表 Imported from BI Publisher Description: 物料清单循环报表 Application: 物料清单管理系统 Source: 物料清单循环报表 (XML) Short Name: BOMRBOMV_XML DB package: BOM_BOMRBOMS_XMLP_PKG BI Publisher :c_d3_revision :dummy :lp_all_orgs :lp_organization_id :lp_revision_date :m_org_id :m_top_bill_sequence_id :p_all_orgs :p_alt_option :p_alt_option_type :p_alternate_desg :p_bom_or_eng :p_cat_between :p_category_from :p_category_set :p_category_set_id :p_category_structure_id :p_category_to :p_compo_flexdata :p_conc_request_id :p_debug :p_err_msg :p_explode_option :p_explode_option_type :p_explosion_level :p_explosion_quantity :p_full_desc_choice :p_full_description :p_group_id :p_impl :p_impl_flag :p_item_from :p_item_id :p_item_structure_id :p_item_to :p_locator_flexdata :p_locator_structure_id :p_msg_buf :p_no :p_order_by :p_order_by_type :p_org_hierarchy :p_organization_id :p_organization_name :p_plan_factor :p_plan_factor_flag :p_print_option1 :p_print_option1_flag :p_print_option2 :p_print_option2_flag :p_print_option3 :p_print_option3_flag :p_print_option4 :p_print_option4_flag :p_print_option5 :p_print_option5_flag :p_print_option6 :p_print_option6_flag :p_prvd31_cnt :p_prvd32_cnt :p_qty_precision :p_range_option :p_range_option_type :p_revision :p_revision_date :p_sequence_id :p_sequence_id1 :p_specific_item :p_verify_flag :p_yes 1 -180 :p_bom_or_eng Char fnd_profile.value('BOM_OR_ENG') Y AR BOM_SRS_NONE_CHAR علامة فاتورة هندسية D BOM_SRS_NONE_CHAR Konstruktionsstückliste E BOM_SRS_NONE_CHAR Lista de Diseño F BOM_SRS_NONE_CHAR Indicateur Nomenclature étude I BOM_SRS_NONE_CHAR Flag Distinta tecnica JA BOM_SRS_NONE_CHAR 設計構成表フラグ KO BOM_SRS_NONE_CHAR 설계 BOM 플래그 PTB BOM_SRS_NONE_CHAR Indicador de Lista de Engenharia RU BOM_SRS_NONE_CHAR Флаг технологической спецификации S BOM_SRS_NONE_CHAR Konstruktionsstruktur-flagga TR BOM_SRS_NONE_CHAR Mühendislik faturası işareti US BOM_SRS_NONE_CHAR Engineering bill flag ZHS BOM_SRS_NONE_CHAR 工程清单标志 2 -170 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR BOM_SRS_ORG_ID معرف التنظيم D BOM_SRS_ORG_ID Organisation E BOM_SRS_ORG_ID Id Organización F BOM_SRS_ORG_ID ID organisation I BOM_SRS_ORG_ID ID org. JA BOM_SRS_ORG_ID 組織ID KO BOM_SRS_ORG_ID 조직 ID PTB BOM_SRS_ORG_ID id da org. RU BOM_SRS_ORG_ID идентификатор организации S BOM_SRS_ORG_ID org.-id TR BOM_SRS_ORG_ID org no US BOM_SRS_ORG_ID org id ZHS BOM_SRS_ORG_ID 组织标识 3 -160 :p_category_structure_id Number select structure_id from mtl_category_sets where category_set_id = :$flex$.category_set 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 类别结构 类别结构 4 -150 :p_explosion_level Number select nvl(MAXIMUM_BOM_LEVEL, 60) from bom_parameters bp, org_organization_definitions ood where bp.organization_id (+) = ood.organization_id and ood.organization_id = :$FLEX$.BOM_SRS_ORG_ID Y AR BOM_SRS_LEVELS مستويات الانفجار D BOM_SRS_LEVELS Aufzulösende Ebenen E BOM_SRS_LEVELS Niveles a Explosionar F BOM_SRS_LEVELS Niveaux à exploser I BOM_SRS_LEVELS Livelli da esplodere JA BOM_SRS_LEVELS 展開レベル KO BOM_SRS_LEVELS 전개할 레벨 PTB BOM_SRS_LEVELS Níveis para Explosão RU BOM_SRS_LEVELS Уровни разузлования S BOM_SRS_LEVELS Nivåer att bryta ned TR BOM_SRS_LEVELS Açılım Düzeyleri US BOM_SRS_LEVELS Levels to Explode ZHS BOM_SRS_LEVELS 展开层 5 -140 :p_impl_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code=1 Y AR المنفذ فقط المنفذ فقط D Nur implementiert Nur implementiert E Sólo Implantados Sólo Implantados F Appliqué seulement Appliqué seulement I Solo implementati Solo implementati JA 実施済のみ 実施済のみ KO 이행 완료만 이행 완료만 PTB Somente Implementados Somente Implementados RU Только внедренные Только внедренные S Endast införda Endast införda TR Sadece Uygulanan Sadece Uygulanan US Implemented Only Implemented Only ZHS 仅限于已实施的 仅限于已实施的 6 -130 :p_explode_option_type LOV Oracle BOM_SRS_INQUIRY_DISPLAY_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='BOM_INQUIRY_DISPLAY_TYPE' and ((:$flex$.bom_srs_levels=1) or (:$flex$.bom_srs_levels!=1 and (lookup_code=2 or lookup_code=3)) ) order by value,description select meaning from mfg_lookups where lookup_type='BOM_INQUIRY_DISPLAY_TYPE' and lookup_code=3 Y AR خيارات العرض خيارات العرض D Anzeigeoption Anzeigeoption E Opción de Visualización Opción de Visualización F Option d'affichage Option d'affichage I Opzione di visualizzazione Opzione di visualizzazione JA 表示オプション 表示オプション KO 표시 옵션 표시 옵션 PTB Opção de Exibição Opção de Exibição RU Режим просмотра Режим просмотра S Visningsalternativ Visningsalternativ TR Görüntüleme Seçeneği Görüntüleme Seçeneği US Display Option Display Option ZHS 显示选项 显示选项 7 -120 :p_explosion_quantity Number 1 Y AR كمية الانفجار كمية الانفجار D Menge auflösen Menge auflösen E Cantidad de Explosión Cantidad de Explosión F Quantité explosion Quantité explosion I Quantità di esplosione Quantità di esplosione JA 展開数量 展開数量 KO 전개 수량 전개 수량 PTB Quantidade da Explosão Quantidade da Explosão RU Количество разузлования Количество разузлования S Nedbrytningskvantitet Nedbrytningskvantitet TR Açılım Miktarı Açılım Miktarı US Explosion Quantity Explosion Quantity ZHS 展开数量 展开数量 8 -110 :p_group_id Number select BOM_EXPLOSION_TEMP_S.NEXTVAL from dual Y AR معرف المجموعة معرف المجموعة D Gruppenkennung Gruppenkennung E Id Grupo Id Grupo F ID groupe ID groupe I Id gruppo Id gruppo JA グループID グループID KO 그룹 ID 그룹 ID PTB Id do Grupo Id do Grupo RU Идентификатор группы Идентификатор группы S Grupp-id Grupp-id TR Grup no Grup no US Group id Group id ZHS 组标识 组标识 9 -100 :p_print_option1_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR تفاصيل المنتج تفاصيل المنتج D Detail Baugruppe Detail Baugruppe E Detalles de Conjunto Detalles de Conjunto F Détail produit Détail produit I Dettagli assieme Dettagli assieme JA 組立詳細 組立詳細 KO 조립품 상세내역 조립품 상세내역 PTB Detalhe da Montagem Detalhe da Montagem RU Сведения о сборке Сведения о сборке S Produktdetalj Produktdetalj TR Ürün Detayı Ürün Detayı US Assembly Detail Assembly Detail ZHS 装配件详细资料 装配件详细信息 10 -90 :p_print_option2_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR تفاصيل أوامر العملاء تفاصيل أوامر العملاء D Detail Auftrag Detail Auftrag E Detalles de Registro de Pedidos Detalles de Registro de Pedidos F Détail saisie cde Détail saisie cde I Dettagli inserimento ordine Dettagli inserimento ordine JA 受注入力詳細 受注入力詳細 KO 수주관리 상세내역 수주관리 상세내역 PTB Detalhes de Entrada da Ordem Detalhes de Entrada da Ordem RU Сведения о вводе заказов Сведения о вводе заказов S Orderdetalj Orderdetalj TR Sipariş Girişi Detayı Sipariş Girişi Detayı US Order Entry Detail Order Entry Detail ZHS 订单分录详细信息 订单分录详细信息 11 -80 :p_print_option3_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR تفاصيل فترة التسليم تفاصيل فترة التسليم D Durchlaufzeit Detail Durchlaufzeit E Detalles del Plazo Detalles del Plazo F Détail délai Détail délai I Dettagli lead time Dettagli sul lead time JA リードタイム詳細 リードタイム詳細 KO 리드타임 상세내역 리드타임 상세내역 PTB Detalhes de Leadtime Detalhes de Leadtime RU Сведения о времени обработки заказа Сведения о сроке опережения S Ledtidsdetalj Ledtidsdetalj TR Bekleme Süresi Detayı Bekleme Süresi Detayı US Leadtime Detail Leadtime Detail ZHS 提前期详细资料 提前期详细信息 12 -70 :p_print_option4_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR مؤشرات مرجعية مؤشرات مرجعية D Referenzdesignatoren Referenzdesignatoren E Identificadores de Referencia Identificadores de Referencia F Repères Repères I Indicatori di riferimento Indicatori di riferimento JA 参照指標 参照指標 KO 참조 지정자 참조 지정자 PTB Designadores de Referência Designadores de Referência RU Справочные указатели Справочные указатели S Referensbeteckningar Referensbeteckningar TR Referans Koordinatları Referans Koordinatları US Reference Designators Reference Designators ZHS 参考指示符 参考指示符 13 -60 :p_print_option5_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR إبدال مكونات إبدال مكونات D Substitutkomponenten Substitutkomponenten E Componentes Sustitutos Componentes Sustitutos F Composants de substitution Composants de substitution I Componenti sostitutivi Componenti sostitutivi JA 代替構成部品 代替構成部品 KO 대체 구성품 대체 구성품 PTB Componentes Substitutos Componentes Substit. RU Компоненты замены Компоненты замены S Utbyteskomponenter Utbyteskomponenter TR Eşdeğer Bileşenler Eşdeğer Bileşenler US Substitute Components Substitute Components ZHS 替代组件 替代组件 14 -50 :p_order_by_type LOV Oracle BOM_SRS_BILL_SORT_ORDER Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='BOM_BILL_SORT_ORDER_TYPE' order by meaning select meaning from mfg_lookups where lookup_type = 'BOM_BILL_SORT_ORDER_TYPE' and lookup_code = 1 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 Ord. Por Ord. Por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Bazı Sıralama Bazı US Order By Order By ZHS 排序依据 排序依据 15 -40 :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') Y AR خيار الدقة الديناميكية خيار الدقة الديناميكية D Option Nachkommastellen Option Nachkommastellen E Opción Precisión Dinámica Opción Precisión Dinámica F Option précision dynamique Option précision dynamique I Opzione precisione dinamica Opzione precisione dinamica JA 動的演算精度オプション 動的演算精度オプション KO 동적 소수점자리 옵션 동적 소수점자리 옵션 PTB Opção de Precisão Dinâmica Opção de Precisão Dinâmica RU Динамическая точность Динамическая точность S Alternativ för dynamisk precision Alternativ för dynamisk precision TR Dinamik Duyarlılık Seçeneği Dinamik Duyarlılık Seçeneği US Dynamic Precision Option Dynamic Precision Option ZHS 动态精确度选项 动态精确度选项 16 -30 :p_verify_flag LOV Oracle BOM_SRS_YES_NO2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 1 Y AR علامة التحقيق علامة التحقيق D Prüfen Prüfen E Verificación Verificación F Indicateur Vérifier Indicateur Vérifier I Flag Verifica Flag Verifica JA 確認フラグ 確認フラグ KO 플래그 검증 플래그 검증 PTB Verificar indicador Verificar indicador RU Флаг проверки Флаг проверки S Verifieringsflagga Verifieringsflagga TR Onayla işareti Onayla işareti US Verify flag Verify flag ZHS 核实标志 核实标志 17 -10 :p_dummy Number SELECT 1 FROM DUAL WHERE (:$flex$.item_selection <> '1' OR :$FLEX$.BOM_SRS_SPECIFIC_BILL:NULL IS NOT NULL) Y AR الصنف 2 الحقل الافتراضي لفرض القيمة الشرطية مطلوب D Artikel 2 Dummy-Feld für die Vorgabe von "Bedingt erforderlich" E Artículo 2 Campo ficticio para aplicar valores necesarios de forma condicional F Article 2 Champ fictif pour l'application de Obligatoire selon contexte I Articolo 2 Campo fittizio per applicazione condizionale obbligatorio JA 品目 2 条件必須を使用するためのダミー・フィールド KO 품목 2 조건부 집행을 위한 Dummy 필드 필수 PTB Item 2 Campo Fictício para Impor Condicional Obrigatório RU Позиция 2 Фиктивное поле для использования обязательных при определенных условиях S Artikel 2 Dummy-fält för att genomföra villkorsberoende TR Kalem 2 Gerekli Koşulu Uygulamak için Sözde Alan US Item 2 Dummy Field for Enforcing Conditional Required ZHS 物料 2 用来实施“有条件”/“必备”条件的虚拟字段 18 10 :p_range_option_type LOV Oracle BOM_SRS_ITEM_RANGE_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='BOM_SELECTION_TYPE' order by meaning select meaning from mfg_lookups where lookup_type = 'BOM_SELECTION_TYPE' and lookup_code = 1 Y AR اختيار الصنف اختيار الصنف D Artikelauswahl Artikelauswahl E Selección de Artículos Selección de Artículos F Sélection d'articles Sélection d'articles I Selezione articolo Selezione articolo JA 品目選択 品目選択 KO 품목 선택 품목 선택 PTB Seleção de Item Seleção de Item RU Отбор позиций Отбор позиций S Artikelurval Artikelurval TR Kalem Seçimi Kalem Seçimi US Item Selection Item Selection ZHS 物料选择 物料选择 19 20 :p_item_id Char AR BOM_SRS_SPECIFIC_BILL الصنف D BOM_SRS_SPECIFIC_BILL Artikel E BOM_SRS_SPECIFIC_BILL Artículo F BOM_SRS_SPECIFIC_BILL Article I BOM_SRS_SPECIFIC_BILL Articolo JA BOM_SRS_SPECIFIC_BILL 品目 KO BOM_SRS_SPECIFIC_BILL 품목 RU BOM_SRS_SPECIFIC_BILL Позиция S BOM_SRS_SPECIFIC_BILL Artikel TR BOM_SRS_SPECIFIC_BILL Kalem US BOM_SRS_SPECIFIC_BILL Item ZHS BOM_SRS_SPECIFIC_BILL 物料 20 30 :p_alt_option_type LOV Oracle BOM_SRS_ALT_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MCG_AUTOLOAD_OPTION' order by meaning select MEANING from MFG_LOOKUPS where LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION' and LOOKUP_CODE = 1 Y AR اختيار بديل اختيار بديل D Alternative Auswahl Alternative Auswahl E Selección Alternativa Selección Alternativa F Sélection des produits de remplacement Sélection des produits de remplacement I Selezione alternativa Selezione alternativa JA 代替選択 代替選択 KO 대체 선택 대체선택 PTB Seleção Alternativa Seleção Alternativa RU Выбор варианта Выбор варианта S Alternativ Alternativ TR Alternatif Seçim Alternatif Seçim US Alternate Selection Alternate Selection ZHS 替代选择 替代选择 21 40 :p_alternate_desg LOV Oracle BOM_SRS_BILL_ALTERNATE Y select alternate_designator_code id, alternate_designator_code value, description description from bom_alternate_designators where organization_id=:$flex$.bom_srs_org_id and :$flex$.bom_srs_alt_option=3 and alternate_designator_code in (select alternate_bom_designator from bom_bill_of_materials where ((:$flex$.bom_srs_none_char='BOM' and assembly_type=1) or (:$flex$.bom_srs_none_char='ENG') ) and organization_id=:$flex$.bom_srs_org_id and ((:$flex$.bom_srs_specific_bill:null is null) or (assembly_item_id= :$flex$.bom_srs_specific_bill:null) ) ) order by alternate_designator_code AR البديل مؤشر بديل D Alternative Alternativer Designator E Alternativa Identificador Alternativo F Produit de remplacement Repère de remplacement I Alternativa Indicatore alternativa JA 代替 代替指標 KO 대체 대체 지정자 PTB Alternativa Designador alternativo RU Вариант Указатель варианта S Alternativ 2 Alternativ beteckning TR Alternatif Alternatif koordinat US Alternate Alternate designator ZHS 替代项 替代指示符 22 50 :p_revision LOV Oracle BOM_SRS_BILL_REVISION Y select revision id, revision value, null description from bom_item_revisions_view where organization_id=:$flex$.bom_srs_org_id and inventory_item_id=:$flex$.bom_srs_specific_bill and :$flex$.bom_srs_item_range_option=1 order by fnd_date.canonical_to_date(effectivity_date),revision AR المراجعة مراجعة الصنف D Version Artikelversion E Revisión Revisión de Artículo F Version Version d'article I Revisione Revisione articolo JA 改訂 品目改訂 KO 개정 품목 개정 PTB Revisão Revisão do item RU Версия Версия позиции S Revision Artikelrevision TR Revizyon Kalem revizyonu US Revision Item revision ZHS 版本 物料版本 23 60 :p_revision_date DateTime select nvl(high_date,fnd_date.date_to_chardt(sysdate)) from bom_item_revisions_view where organization_id=:$FLEX$.BOM_SRS_ORG_ID AND INVENTORY_ITEM_ID(+)=:$FLEX$.BOM_SRS_SPECIFIC_BILL AND REVISION(+) = :$flex$.revision Y AR التاريخ وقت وتاريخ سريان المفعول D Datum Gültigkeitsdatum und -zeit E Fecha Fecha y Hora en Vigor F Date Date et heure de validité I Data Data e ora validità JA 日付 有効日時 KO 일자 적용 일자 및 시간 PTB Data Data e Hora da Efetivação RU Дата Дата и время действия S Datum Giltighetsdatum och giltighetstid TR Tarih Geçerlilik Tarihi ve saati US Date Effective Date and time ZHS 日期 有效日期和时间 24 70 :p_item_from Char AR الأصناف من الأصناف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Articles - De I Articoli - Da Articoli - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Itens - De Itens - De RU Позиции с Позиции с S Från artiklar Från artiklar TR Kalemler, İlk Kalemler, İlk US Items From Items From ZHS 物料自 物料自 25 80 :p_item_to Char AR إلى أصناف إلى D Bis Bis Artikel E A A Artículo F A Articles - A I A Articoli - A JA 至 品目:至 KO 까지 품목: 까지 PTB Até Itens - Até RU По Позиции по S Till Till artiklar TR Son Kalemler: Son US To Items to ZHS 至 物料至 26 90 :p_category_set_id LOV Oracle BOM_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, null 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 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 类别集 类别集 27 100 :p_category_from Char AR الفئات من الفئات من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégories - De I Categorie - Da Categorie - Da JA カテゴリ:自 カテゴリ:自 KO 범주: 부터 범주: 부터 PTB Categorias - De Categorias - De RU Категории с Категории с S Från kategorier Från kategorier TR Kategoriler, İlk Kategoriler, İlk US Categories From Categories From ZHS 类别自 类别自 28 110 :p_category_to Char AR إلى 2 الفئات إلى D Bis 2 Bis Kategorie E A 2 A categoría F A 2 Catégories - A I A 2 Categorie - A JA 至 2 カテゴリ:至 KO 까지 2 범주: 까지 PTB Até 2 categorias - até RU По 2 Категория по S Till 2 kategorier till TR Son 2 kategoriler: son US To 2 categories to ZHS 至 2 分类至 :$FLEX$.BOM_SRS_ORG_ID BOM_SRS_ORG_ID BOM_SRS_LEVELS :$FLEX$.BOM_SRS_ORG_ID BOM_SRS_ORG_ID Date :$FLEX$.BOM_SRS_SPECIFIC_BILL BOM_SRS_SPECIFIC_BILL Date :$flex$.bom_srs_alt_option Alternate Selection Alternate :$flex$.bom_srs_item_range_option Item Selection Revision :$flex$.bom_srs_levels BOM_SRS_LEVELS Display Option :$flex$.bom_srs_none_char BOM_SRS_NONE_CHAR Alternate :$flex$.bom_srs_org_id BOM_SRS_ORG_ID Alternate :$flex$.bom_srs_org_id BOM_SRS_ORG_ID Revision :$flex$.bom_srs_specific_bill BOM_SRS_SPECIFIC_BILL Revision :$flex$.category_set Category Set Category Structure :$flex$.item_selection Item Selection Item 2 :$flex$.revision Revision Date