ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472A051A9E05362FB09050512 SELECT WRS.WIP_ENTITY_ID WIP_Entity_ID_CLASS, WRS.REPETITIVE_SCHEDULE_ID Repetitive_Schedule_Id, WRI.CLASS_CODE Class_Code, WAC.DISABLE_DATE Disable_Date, WAC.DESCRIPTION Description, DECODE(WRS.MATERIAL_ACCOUNT,NULL,NULL, null) C_Mtl_Val_Data, DECODE(WRS.MATERIAL_OVERHEAD_ACCOUNT,NULL,NULL, null) C_Mtl_OH_Val_Data, DECODE(WRS.RESOURCE_ACCOUNT,NULL,NULL, null) C_Res_Val_Data, DECODE(WRS.OUTSIDE_PROCESSING_ACCOUNT,NULL,NULL, null) C_Out_Proc_Val_Data, DECODE(WRS.OVERHEAD_ACCOUNT,NULL,NULL, null) C_OH_Val_Data, DECODE(WRS.MATERIAL_VARIANCE_ACCOUNT,NULL,NULL, null) C_Mtl_Variance_Data, DECODE(WRS.RESOURCE_VARIANCE_ACCOUNT,NULL,NULL, null) C_Res_Variance_Data, DECODE(WRS.OUTSIDE_PROC_VARIANCE_ACCOUNT,NULL,NULL, null) C_Out_Proc_Variance_Data, DECODE(WRS.OVERHEAD_VARIANCE_ACCOUNT,NULL,NULL, null) C_OH_Variance_Data, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_material_valuation', 'SQLGL', 'GL#', GL1.CHART_OF_ACCOUNTS_ID, NULL, GL1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Material_Valuation, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_mat_ovhead_valuat', 'SQLGL', 'GL#', GL2.CHART_OF_ACCOUNTS_ID, NULL, GL2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Mat_Ovhead_Valuat, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_resource_valuation', 'SQLGL', 'GL#', GL3.CHART_OF_ACCOUNTS_ID, NULL, GL3.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Resource_Valuation, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_outside_proc_valuation', 'SQLGL', 'GL#', GL4.CHART_OF_ACCOUNTS_ID, NULL, GL4.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Outside_Proc_Valuation, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_overhead_valuation', 'SQLGL', 'GL#', GL5.CHART_OF_ACCOUNTS_ID, NULL, GL5.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Overhead_Valuation, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_material_variance', 'SQLGL', 'GL#', GL6.CHART_OF_ACCOUNTS_ID, NULL, GL6.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Material_Variance, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_resource_variance', 'SQLGL', 'GL#', GL8.CHART_OF_ACCOUNTS_ID, NULL, GL8.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Resource_Variance, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_outside_proc_variance', 'SQLGL', 'GL#', GL9.CHART_OF_ACCOUNTS_ID, NULL, GL9.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Outside_Proc_Variance, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_overhead_variance', 'SQLGL', 'GL#', GL10.CHART_OF_ACCOUNTS_ID, NULL, GL10.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Overhead_Variance FROM GL_CODE_COMBINATIONS GL1, GL_CODE_COMBINATIONS GL2, GL_CODE_COMBINATIONS GL3, GL_CODE_COMBINATIONS GL4, GL_CODE_COMBINATIONS GL5, GL_CODE_COMBINATIONS GL6, GL_CODE_COMBINATIONS GL8, GL_CODE_COMBINATIONS GL9, GL_CODE_COMBINATIONS GL10, WIP_ACCOUNTING_CLASSES WAC, WIP_REPETITIVE_ITEMS WRI, WIP_REPETITIVE_SCHEDULES WRS WHERE WRS.ORGANIZATION_ID = :P_ORG_ID AND WRI.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID AND WRI.ORGANIZATION_ID = :P_ORG_ID AND WRI.LINE_ID = WRS.LINE_ID AND WAC.ORGANIZATION_ID = :P_ORG_ID AND WRI.CLASS_CODE = WAC.CLASS_CODE AND WRS.MATERIAL_ACCOUNT = GL1.CODE_COMBINATION_ID (+) AND WRS.MATERIAL_OVERHEAD_ACCOUNT = GL2.CODE_COMBINATION_ID (+) AND WRS.RESOURCE_ACCOUNT = GL3.CODE_COMBINATION_ID (+) AND WRS.OUTSIDE_PROCESSING_ACCOUNT = GL4.CODE_COMBINATION_ID (+) AND WRS.OVERHEAD_ACCOUNT = GL5.CODE_COMBINATION_ID (+) AND WRS.MATERIAL_VARIANCE_ACCOUNT = GL6.CODE_COMBINATION_ID (+) AND WRS.RESOURCE_VARIANCE_ACCOUNT = GL8.CODE_COMBINATION_ID (+) AND WRS.OUTSIDE_PROC_VARIANCE_ACCOUNT = GL9.CODE_COMBINATION_ID (+) AND WRS.OVERHEAD_VARIANCE_ACCOUNT = GL10.CODE_COMBINATION_ID (+) AND GL1.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF AND GL2.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF AND GL3.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF AND GL4.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF AND GL5.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF AND GL6.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF AND GL8.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF AND GL9.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF AND GL10.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF and WRS.WIP_ENTITY_ID=:WIP_entity_id_SCHED and WRS.REPETITIVE_SCHEDULE_ID=:Rep_sched_id_SCHED Y WIP WIPREDAT_XML AR WIP تقرير بيانات الجدول التكراري (بتنسيق XML) Imported from BI Publisher Description: تقرير بيانات الجدول التكراري Application: العمل في الإنجاز Source: تقرير بيانات الجدول التكراري (بتنسيق XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG D WIP Linienaufträge Imported from BI Publisher Description: Linienaufträge Application: Fertigung Source: Linienaufträge (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG E WIP Datos de Programas Repetitivos Imported from BI Publisher Description: Informe de datos de programas repetitivos Application: Work in Process Source: Datos de Programas Repetitivos (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG F WIP Etat Informations sur les programmes répétitifs Imported from BI Publisher Description: Etat Informations sur les programmes répétitifs Application: Work In Process Source: Etat Informations sur les programmes répétitifs (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG I WIP Rapporto Dati programma ripetitivo Imported from BI Publisher Description: Rapporto Dati programma ripetitivo Application: Work in Process Source: Rapporto Dati programma ripetitivo (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG JA WIP ライン型製造オーダー・データ・レポート Imported from BI Publisher Description: ライン型製造オーダー・データ・レポート Application: Work in Process Source: ライン型製造オーダー・データ・レポート(XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG KO WIP 반복 스케줄 데이터 보고서 Imported from BI Publisher Description: 반복 스케줄 데이터 보고서 Application: Work in Process Source: 반복 스케줄 데이터 보고서(XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG PTB WIP Relatório de Dados de Programação Repetitiva Imported from BI Publisher Description: Rel. Dados Programação Repetit. Application: Work in Process Source: Relatório de Dados de Programação Repetitiva (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG RU WIP Отчет по данным графиков серийного производства Imported from BI Publisher Description: Отчет по данным графиков серийного производства Application: Незавершенное производство Source: Отчет по данным графиков серийного производства (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG S WIP Repetitiva plandata - rapport Imported from BI Publisher Description: Repetitiva plandata - rapport Application: Work in Process Source: Repetitiva plandata - rapport (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG TR WIP Seri Üretim Çizelgesi Veri Raporu Imported from BI Publisher Description: Seri Üretim Çizelgesi Veri Raporu Application: Üretim İzleme Source: Seri Üretim Çizelgesi Veri Raporu (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG US WIP Repetitive Schedule Data Imported from BI Publisher Description: Repetitive Schedule Data Report Application: Work in Process Source: Repetitive Schedule Data Report (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG ZHS WIP 重复性计划数据报表 Imported from BI Publisher Description: 重复性计划数据报表 Application: 在制品管理系统 Source: 重复性计划数据报表 (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG BI Publisher :chart_of_accounts_id_def :p_cmpl_locator :p_component_item :p_conc_request_id :p_debug :p_from_assembly :p_from_line :p_from_start_date :p_item_grp_by :p_mtl_oh_val_acct :p_mtl_val_acct :p_mtl_variance :p_oh_val_acct :p_oh_variance :p_org_id :p_out_proc_val_acct :p_out_proc_variance :p_qty_precision :p_res_val_acct :p_res_variance :p_status_limiter :p_std_cost_variance :p_supply_locator :p_to_assembly :p_to_line :p_to_start_date :rep_sched_id_sched :wip_entity_id_sched 1 -40 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR Org_Id معرف التنظيم D Org_Id Organisationskennung E Org_Id Id Organización F Org_Id ID organisation I Org_Id Id dell'organizzazione JA Org_Id 組織ID KO Org_Id 조직 ID PTB Org_Id Id da Organização RU Org_Id Идент. организ. S Org_Id Organisations-id TR Org_Id Organizasyon No US Org_Id Organization Id ZHS Org_Id 组织标识 2 -30 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة حقل الكمية دقة حقل الكمية D Nachkommastellen Nachkommastellen E Precisión del Campo Cantidad Precisión del Campo Cantidad F Précision du champ quantité Précision du champ quantité I Precisione campo quantità Precisione campo quantità JA 数量フィールド精度 数量フィールド精度 KO 수량 필드 소수점자리 수량 필드 소수점자리 PTB Precisão do Campo Quantidade Precisão do Campo Quantidade RU Точность поля количества Точность поля количества S Kvantitetsfältsprecision Kvantitetsfältsprecision TR Miktar Alanı Duyarlılığı Miktar Alanı Duyarlılığı US Quanity Field Precision Quanity Field Precision ZHS 数量字段精确度 数量字段精确度 3 -20 :chart_of_accounts_id_def Number SELECT CHART_OF_ACCOUNTS_ID FROM ORG_ORGANIZATION_DEFINITIONS WHERE ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung E Identificador del Plan de Cuentas Identificador del Plan de Cuentas F ID plan de comptes ID plan de comptes I ID piano dei conti ID del piano dei conti JA 勘定体系ID 勘定体系ID KO 계정코드집 ID 계정코드집 ID PTB Id do Plano de Contas Id do Plano de Contas RU Идент. плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart Of Accounts Id Chart Of Accounts Id ZHS 科目表标识 科目表标识 4 10 :p_status_limiter LOV Oracle WIP_SRS_YES_NO_MAND 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 gültig Nur gültig E Sólo en Vigor Sólo en Vigor F Valide seulement Valide seulement I Solo effettivi Solo effettivi JA 有効のみ 有効のみ KO 유효만 유효만 PTB Somente Efetivos Somente Efetivos RU Только действующие Только действующие S Giltig endast Giltig endast TR Salt Geçerli Salt Geçerli US Effective Only Effective Only ZHS 仅有效 仅有效 5 20 :p_from_assembly LOV Oracle WIP_SRS_REP_SCHEDULES_OPT Y select wip_entity_name id, wip_entity_name value, null description from wip_entities where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and entity_type=2 order by wip_entity_name AR المنتجات من مدى المنتجات من D Von Baugruppe Von Baugruppe E De Conjunto De Rango de Conjuntos F Produits - De Fourchette de produits - De I Assiemi - Da Intervallo assiemi - Da JA 組立:自 組立範囲:自 KO 조립품: 부터 조립품 범위: 부터 PTB Montagens - De Faixa de Montagens - De RU Сборки с Нижняя граница диапазона сборок S Från produkter Produktintervall från TR Ürünler: İlk Ürün Aralığı Başlangıcı US Assemblies From Assemblies Range From ZHS 装配件自 装配件范围自 6 30 :p_to_assembly LOV Oracle WIP_SRS_REP_SCHEDULES_OPT Y select wip_entity_name id, wip_entity_name value, null description from wip_entities where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and entity_type=2 order by wip_entity_name AR إلى مدى المنتجات إلى D Bis Bis Baugruppe E A A Rango de Conjuntos F A Fourchette de produits - A I A Intervallo assiemi - A JA 至 組立範囲:至 KO 까지 조립품 범위: 까지 PTB Até Faixa de Montagens - até RU По Верхняя граница диапазона сборок S Till Produktintervall till TR Son Ürün Aralığı Bitişi US To Assemblies Range To ZHS 至 装配件范围至 7 40 :p_from_line LOV Oracle WIP_SRS_LINES_OPT Y select wl.line_code id, wl.line_code value, null description from wip_lines wl where wl.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by line_code AR السطور من مدى السطور من D Von Linie Von Linie E De Línea De Rango de Líneas F Lignes - De Fourchette de lignes - De I Linee - Da Intervallo linee - Da JA ライン:自 ライン範囲:自 KO 라인: 부터 라인 범위: 부터 PTB Linhas - De Faixa de Linhas - De RU Линии с Нижняя граница диапазона линий S Från rader Radintervall från TR Hatlar, İlk Hat Aralığı Başlangıcı US Lines From Lines Range From ZHS 生产线自 生产线范围自 8 50 :p_to_line LOV Oracle WIP_SRS_LINES_OPT Y select wl.line_code id, wl.line_code value, null description from wip_lines wl where wl.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by line_code AR إلى 2 مدى السطور إلى D Bis 2 Bis Linie E A 2 A Rango de Líneas F A 2 Fourchette de lignes - A I A 2 Intervallo linee - A JA 至 2 ライン範囲:至 KO 까지 2 라인 범위: 까지 PTB Até 2 Faixa de Linhas - até RU По 2 Верхняя граница диапазона линий S Till 2 Radintervall till TR Son 2 Hat Aralığı Bitişi US To 2 Lines Range To ZHS 至 2 生产线范围至 9 60 :p_from_start_date Date AR تواريخ البداية من مدى تواريخ البداية من D Von Von E De Fecha de Inicio De Rango de Fechas de Inicio F Dates début - Du Fourchette de dates de début - Du I Date inizio - Da Intervallo date di inizio - Da JA 開始日:自 開始日範囲:自 KO 시작 일자: 부터 시작일자 범위: 부터 PTB Datas Iniciais - De Faixa de Datas Iniciais - De RU Начальные даты с Нижняя граница диапазона начальных дат S Från startdatum Startdatumintervall från TR Başlangıç Tarihleri, İlk Başlangıç Tarihleri Aralığı: İlk US Start Dates From Start Dates Range From ZHS 起始日期自 起始日期范围自 10 70 :p_to_start_date Date AR إلى 3 مدى تواريخ البداية إلى D Bis 3 Bis E A 3 A Rango de Fechas de Inicio F A 3 Fourchette de dates de début - Au I A 3 Intervallo date di inizio - A JA 至 3 開始日範囲:至 KO 까지 3 시작일자 범위: 까지 PTB Até 3 Faixa de Datas Iniciais - até RU По 3 Верхняя граница диапазона начальных дат S Till 3 Startdatumintervall till TR Son 3 Başlangıç Tarihleri Aralığı: Son US To 3 Start Dates Range To ZHS 至 3 起始日期范围至