ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472A651A9E05362FB09050512 select wor.wip_entity_id res_entity_id, wor.organization_id res_org_id, wor.operation_seq_num oper_seq_num, bd.department_code department, br.resource_code res_code, br.unit_of_measure res_uom, ml_basis.meaning basis, ml_autocharge.meaning autocharge, ml_std_rate.meaning std_rate, round(decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, (wor.USAGE_RATE_OR_AMOUNT * wtr.key6), 3, (wor.USAGE_RATE_OR_AMOUNT * wtr.key4), 0), decode(:REPORT_RUN_OPT, 2, (wor.usage_rate_or_amount * (decode(wtr.key6,0,0,1))), 3, (wor.usage_rate_or_amount * (decode(wtr.key4,0,0,1))), 0)), :P_qty_precision) std_res_units, round(sum(NVL(wta.PRIMARY_QUANTITY,0)), :P_qty_precision) app_res_units, round(decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, (wor.USAGE_RATE_OR_AMOUNT * wtr.key6), 3, (wor.USAGE_RATE_OR_AMOUNT * wtr.key4), 0), decode(:REPORT_RUN_OPT, 2, (wor.usage_rate_or_amount * (decode(wtr.key6,0,0,1))), 3, (wor.usage_rate_or_amount * (decode(wtr.key4,0,0,1))), 0)) * decode(br.functional_currency_flag, 1, 1, NVL(crc.resource_rate,0)), :precision) res_std_cost, round(sum(NVL(wta.PRIMARY_QUANTITY,0) * decode(wor.STANDARD_RATE_FLAG,1,NVL(wt.standard_resource_rate, 0), NVL(wt.ACTUAL_RESOURCE_RATE,0))), :precision) res_app_cost, round(sum(NVL(wta.PRIMARY_QUANTITY,0) * decode(wor.STANDARD_RATE_FLAG,1,NVL(wt.standard_resource_rate, 0), NVL(wt.ACTUAL_RESOURCE_RATE,0))) - (decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, (wor.USAGE_RATE_OR_AMOUNT * wtr.key6), 3, (wor.USAGE_RATE_OR_AMOUNT * wtr.key4), 0), decode(:REPORT_RUN_OPT, 2, (wor.usage_rate_or_amount * (decode(wtr.key6,0,0,1))), 3, (wor.usage_rate_or_amount * (decode(wtr.key4,0,0,1))), 0)) * decode(br.functional_currency_flag, 1, 1, NVL(crc.resource_rate,0))), :precision) eff_var, wtr.key1 res_line_id, wor.repetitive_schedule_id, wor.resource_seq_num from mfg_lookups ml_basis, mfg_lookups ml_autocharge, mfg_lookups ml_std_rate, wip_operations wo, wip_operation_resources wor, wip_transactions wt, wip_txn_allocations wta, wip_temp_reports wtr, cst_resource_costs crc, bom_resources br, bom_departments bd where wtr.wip_entity_id = :wip_entity_id and wtr.organization_id = :org_id and wtr.program_source = 'WIPREVAL' and wor.repetitive_schedule_id = wtr.key2 and wt.wip_entity_id = :wip_entity_id and wt.organization_id = :org_id and wt.TRANSACTION_TYPE in (1, 3) and wt.operation_seq_num = wor.operation_seq_num and wt.resource_seq_num = wor.resource_seq_num and wt.resource_id = wor.resource_id and wt.line_id = :line_id and wt.transaction_date >=:FROM_PERIOD_START_DATE and wt.transaction_date < :TO_PERIOD_END_DATE + 1 and wta.transaction_id = wt.transaction_id and wta.repetitive_schedule_id = wor.repetitive_schedule_id and wta.organization_id = :org_id and wo.operation_seq_num = wor.operation_seq_num and wo.wip_entity_id = :wip_entity_id and wo.organization_id = :org_id and wo.repetitive_schedule_id = wor.repetitive_schedule_id and bd.department_id = nvl(wor.department_id, wo.department_id) and br.resource_id = wor.resource_id and crc.resource_id (+) = wor.resource_id and crc.cost_type_id (+) = 1 and ml_basis.lookup_code = wor.basis_type and ml_basis.lookup_type = 'CST_BASIS' and ml_autocharge.lookup_code = wor.autocharge_type and ml_autocharge.lookup_type = 'BOM_AUTOCHARGE_TYPE' and ml_std_rate.lookup_code = wor.STANDARD_RATE_FLAG and ml_std_rate.lookup_type = 'SYS_YES_NO' and wor.organization_id = :org_id group by wor.OPERATION_SEQ_NUM, wor.resource_seq_num, wor.repetitive_schedule_id, wor.wip_entity_id, wtr.key1, wor.STANDARD_RATE_FLAG, wor.organization_id, bd.department_code, br.resource_code, br.unit_of_measure, ml_basis.meaning, ml_autocharge.meaning, ml_std_rate.meaning, wor.USAGE_RATE_OR_AMOUNT, wor.BASIS_TYPE, crc.resource_rate, wtr.key6, wtr.key4, br.functional_currency_flag UNION select wor.wip_entity_id res_entity_id, wor.organization_id res_org_id, wor.operation_seq_num oper_seq_num, bd.department_code department, br.resource_code res_code, br.unit_of_measure res_uom, ml_basis.meaning basis, ml_autocharge.meaning autocharge, ml_std_rate.meaning std_rate, round(decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, (wor.USAGE_RATE_OR_AMOUNT * wtr.key6), 3, (wor.USAGE_RATE_OR_AMOUNT * wtr.key4), 0), decode(:REPORT_RUN_OPT, 2, (wor.usage_rate_or_amount * (decode(wtr.key6,0,0,1))), 3, (wor.usage_rate_or_amount * (decode(wtr.key4,0,0,1))), 0)), :P_qty_precision) std_res_units, 0 app_res_units, round(decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, (wor.USAGE_RATE_OR_AMOUNT * wtr.key6), 3, (wor.USAGE_RATE_OR_AMOUNT * wtr.key4), 0), decode(:REPORT_RUN_OPT, 2, (wor.usage_rate_or_amount * (decode(wtr.key6,0,0,1))), 3, (wor.usage_rate_or_amount * (decode(wtr.key4,0,0,1))), 0)) * decode(br.functional_currency_flag, 1, 1, NVL(crc.resource_rate,0)), :precision) res_std_cost, 0 res_app_cost, 0 - round(decode(wor.BASIS_TYPE, 1, decode(:REPORT_RUN_OPT, 2, (wor.USAGE_RATE_OR_AMOUNT * wtr.key6), 3, (wor.USAGE_RATE_OR_AMOUNT * wtr.key4), 0), decode(:REPORT_RUN_OPT, 2, (wor.usage_rate_or_amount * (decode(wtr.key6,0,0,1))), 3, (wor.usage_rate_or_amount * (decode(wtr.key4,0,0,1))), 0)) * decode(br.functional_currency_flag, 1, 1, NVL(crc.resource_rate,0)), :precision) eff_var, wtr.key1 res_line_id, wor.repetitive_schedule_id, wor.resource_seq_num from mfg_lookups ml_basis, mfg_lookups ml_autocharge, mfg_lookups ml_std_rate, wip_operations wo, wip_operation_resources wor, wip_temp_reports wtr, cst_resource_costs crc, bom_resources br, bom_departments bd where wtr.wip_entity_id = :wip_entity_id and wtr.organization_id = :org_id and wtr.program_source = 'WIPREVAL' and wor.repetitive_schedule_id = wtr.key2 and not exists (select 'x' from wip_transactions wt, wip_txn_allocations wta where wt.wip_entity_id = :wip_entity_id and wt.organization_id = :org_id and wt.TRANSACTION_TYPE in (1,3) and wt.operation_seq_num = wor.operation_seq_num and wt.resource_seq_num = wor.resource_seq_num and wt.resource_id = wor.resource_id and wt.line_id = :line_id and wt.transaction_date >= :FROM_PERIOD_START_DATE and wt.transaction_date < :TO_PERIOD_END_DATE + 1 and wta.transaction_id = wt.transaction_id and wta.repetitive_schedule_id = wor.repetitive_schedule_id and wta.organization_id = :org_id) and wo.operation_seq_num = wor.operation_seq_num and wo.wip_entity_id = :wip_entity_id and wo.organization_id = :org_id and wo.repetitive_schedule_id = wor.repetitive_schedule_id and bd.department_id = nvl(wor.department_id, wo.department_id) and br.resource_id = wor.resource_id and crc.resource_id (+) = wor.resource_id and crc.cost_type_id (+) = 1 and ml_basis.lookup_code = wor.basis_type and ml_basis.lookup_type = 'CST_BASIS' and ml_autocharge.lookup_code = wor.autocharge_type and ml_autocharge.lookup_type = 'BOM_AUTOCHARGE_TYPE' and ml_std_rate.lookup_code = wor.STANDARD_RATE_FLAG and ml_std_rate.lookup_type = 'SYS_YES_NO' and wor.organization_id = :org_id and wor.wip_entity_id=:wip_entity_id and wtr.key1=:line_id group by wor.OPERATION_SEQ_NUM, wor.resource_seq_num, wor.repetitive_schedule_id, wor.wip_entity_id, wtr.key1, wor.STANDARD_RATE_FLAG, wor.organization_id, bd.department_code, br.resource_code, br.unit_of_measure, ml_basis.meaning, ml_autocharge.meaning, ml_std_rate.meaning, wor.USAGE_RATE_OR_AMOUNT, wor.BASIS_TYPE, crc.resource_rate, wtr.key6, wtr.key4, br.functional_currency_flag order by 3,4,5 Y WIP WIPREVAL_XML AR WIP تقرير القيمة التكرارية (بتنسيق XML) Imported from BI Publisher Description: تقرير القيمة التكرارية Application: العمل في الإنجاز Source: تقرير القيمة التكرارية (بتنسيق XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG D WIP Linienaufträge - Auftragswerte Imported from BI Publisher Description: Linienaufträge - Auftragswerte Application: Fertigung Source: Linienaufträge - Auftragswerte (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG E WIP Valor de Programa Repetitivo Imported from BI Publisher Description: Informe de valor de programa repetitivo Application: Work in Process Source: Valor de Programa Repetitivo (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG F WIP Etat Valeurs des programmes répétitifs Imported from BI Publisher Description: Etat Valeurs des programmes répétitifs Application: Work In Process Source: Etat Valeurs des programmes répétitifs (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG I WIP Rapporto Valori ripetitivi Imported from BI Publisher Description: Rapporto Valori ripetitivi Application: Work in Process Source: Rapporto Valori ripetitivi (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG JA WIP ライン型製造オーダー価額レポート Imported from BI Publisher Description: ライン型製造オーダー価額レポート Application: Work in Process Source: ライン型製造オーダー価額レポート(XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG KO WIP 반복 값 보고서 Imported from BI Publisher Description: 반복 제조 원가 보고서 Application: Work in Process Source: 반복 값 보고서(XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG PTB WIP Relatório de Valor Repetitivo Imported from BI Publisher Description: Rel. Valor Repetitivo Application: Work in Process Source: Relatório de Valor Repetitivo (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG RU WIP Отчет о стоимости серийного производства Imported from BI Publisher Description: Отчет о стоимости серийного производства Application: Незавершенное производство Source: Отчет о стоимости серийного производства (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG S WIP Repetitivt värde - rapport Imported from BI Publisher Description: Repetitivt värde - rapport Application: Work in Process Source: Repetitivt värde - rapport (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG TR WIP Seri Üretim Değer Raporu Imported from BI Publisher Description: Seri Üretim Değer Raporu. Application: Üretim İzleme Source: Seri Üretim Değer Raporu (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG US WIP Repetitive Value Imported from BI Publisher Description: Repetitive Value Report Application: Work in Process Source: Repetitive Value Report (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG ZHS WIP 重复性价值报表 Imported from BI Publisher Description: 重复性价值报表 Application: 在制品管理系统 Source: 重复性价值报表 (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG BI Publisher :c_counter :c_from_period_start_date :c_include_bulk :c_include_vendor :c_to_period_end_date :calendar_code :chart_of_accts_id :currency_code :exception_set_id :ext_precision :from_assembly :from_assy_disp :from_class :from_class_disp :from_line :from_line_disp :from_period_start_date :from_period_start_date_char :line_id :org_id :org_name :p_conc_request_id :p_debug :p_flexdata_acct :p_flexdata_item :p_include_bulk :p_include_vendor :p_qty_precision :precision :report_option :report_run_opt :report_sort :report_sort_by_aft :to_assembly :to_assy_disp :to_class :to_class_disp :to_line :to_line_disp :to_period_end_date :to_period_end_date_char :where_assembly :where_class :where_line :where_period :wip_entity_id 1 -30 :org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف التنظيم D Organisationskennung E Id Organización F ID organisation I ID organizzazione JA 組織ID KO 조직 ID PTB Id da Organização RU Идент. организ. S Organisations-id TR Organizasyon No US Organization Id ZHS 组织标识 2 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية D Nachkommastellen E Precisión de Cantidad F Précision des quantités I Precisione quantità JA 数量精度 KO 수량 소수점이하 자리수 PTB Precisão da Quantidade RU Точность количества S Kvantitetsprecision TR Miktar Duyarlılığı US Quantity Precision ZHS 数量精确度 3 10 :report_run_opt LOV Oracle WIP_SRS_DISC_VALUE_TYPE_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_WIP_VALUE_REPORT_TYPE' and lookup_code in (1,2,3) order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_WIP_VALUE_REPORT_TYPE' AND LOOKUP_CODE = 1 Y AR نوع التقرير D Auswertungsart E Tipo de Informe F Type d'état I Tipo di rapporto JA レポート・タイプ KO 보고서 유형 PTB Tipo de relatório RU Тип отчета S Rapporttyp TR Rapor Tipi US Report Type ZHS 报表类型 4 20 :p_include_bulk 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 Mit Massengut Mit Massengut E Incluir a Granel Incluir Necesidades a Granel F Inclure dotation Inclure besoins de dotation atelier I Includi fabbisogni di consumo Includi fabbisogni di consumo JA バルクを含む バルク所要量を含む KO Bulk 포함 Bulk 소요량 포함 PTB Incluir Granel Incluir Necessidades a Granel RU Включение масс-потребностей Включение масс-потребностей S Inkludera bulk Inkludera bulkbehov TR Yığını Dahil Et Toplu Gereksinimleri Dahil Eder US Include Bulk Include Bulk Requirements ZHS 包括批量 包括批量需求 5 30 :p_include_vendor 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 Mit Lieferantenbedarf Mit Lieferantenbedarf E Incluir Proveedor Incluir Requisitos de Proveedor F Inclure fournisseur Inclure besoins fournisseur I Includi fornitore Includi fabbisogni fornitore JA 仕入先を含む 仕入先所要量を含む KO 공급자 포함 공급자 소요량 포함 PTB Incluir Fornecedor Incluir Necessidades do Fornecedor RU Включение поставщика Включение потребностей поставщика S Inkludera leverantör Inkludera leverantörsbehov TR Tedarikçiyi Dahil Et Tedarikçi Gereksinimlerini Dahil Et US Include Supplier Include Vendor Requirements ZHS 包括供应商 包括供应商需求 6 40 :from_period_start_date LOV Oracle WIP_SRS_PERIODS_START_DATE_OPT_STANDARD Y select period_start_date id, period_start_date value, null description from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by period_start_date Y AR تاريخ بداية الفترة D Datum von E Fecha Inicio Período F Date de début de période I Data inizio periodo JA 期間開始日 KO 기간 시작 일자 PTB Data Inicial do Período RU Начало периода S Startdatum för period TR Dönem Başlangıç Tarihi US Period Start Date ZHS 期间起始日期 7 50 :to_period_end_date LOV Oracle WIP_SRS_SCHD_CLOSE_DATE_OPT_STANDARD Y select schedule_close_date id, schedule_close_date value, null description from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by schedule_close_date Y AR تاريخ إقفال الفترة D Periodenabschlussdatum E Fecha de Cierre del Período F Date de clôture de période I Data chiusura periodo JA 期間クローズ日 KO 기간 마감 일자 PTB Data de Fechamento do Período RU Дата закрытия периода S Stängningsdatum för period TR Dönem Kapanış Tarihi US Period Close Date ZHS 期间关闭日期 8 60 :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 E De Conjunto F Produits - De I Assiemi - Da JA 組立:自 KO 조립품: 부터 PTB Montagens - De RU Сборки с S Från produkter TR Ürünler: İlk US Assemblies From ZHS 装配件自 9 70 :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 E A F A I A JA 至 KO 까지 PTB Até RU По S Till TR Son US To ZHS 至 10 80 :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 E De Línea F Lignes - De I Linee - Da JA ライン:自 KO 라인: 부터 PTB Linhas - De RU Линии с S Från rader TR Hatlar, İlk US Lines From ZHS 生产线自 11 90 :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 E A 2 F A 2 I A 2 JA 至 2 KO 까지 2 PTB Até 2 RU По 2 S Till 2 TR Son 2 US To 2 ZHS 至 2 12 100 :from_class LOV Oracle WIP_SRS_REP_CLASSES_OPT Y select class_code id, class_code value, null description from wip_accounting_classes where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and class_type=2 order by class_code AR الطبقات من D Von Klasse E De Clase F Classes - De I Classi - Da JA 区分:自 KO 분류: 부터 PTB Classes De RU Классы с S Från klasser TR Sınıflar, İlk US Classes From ZHS 分类自 13 110 :to_class LOV Oracle WIP_SRS_REP_CLASSES_OPT Y select class_code id, class_code value, null description from wip_accounting_classes where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and class_type=2 order by class_code AR إلى 3 D Bis 3 E A 3 F A 3 I A 3 JA 至 3 KO 까지 3 PTB Até 3 RU По 3 S Till 3 TR Son 3 US To 3 ZHS 至 3