ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472A551A9E05362FB09050512Y SELECT E.ORGANIZATION_ID ORGANIZATION_ID10, E.WIP_ENTITY_ID WIP_ENTITY_ID10, RS.REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID10, E.WIP_ENTITY_NAME Assembly, E.DESCRIPTION, M.PRIMARY_UOM_CODE UOM, RS.FIRST_UNIT_START_DATE First_Unit_Start, TO_CHAR(RS.FIRST_UNIT_START_DATE,'HH24:MI') FUS_TIME, L.LINE_CODE Line, L.DESCRIPTION LINE_DESC, RS.DAILY_PRODUCTION_RATE Daily_Rate, RS.FIRST_UNIT_COMPLETION_DATE First_Unit_Comp, TO_CHAR(RS.FIRST_UNIT_COMPLETION_DATE,'HH24:MI') FUC_TIME, LU.MEANING Status, RS.PROCESSING_WORK_DAYS Process_Days, RS.LAST_UNIT_START_DATE Last_Unit_Start, TO_CHAR(RS.LAST_UNIT_START_DATE,'HH24:MI') LUS_TIME, RS.BOM_REVISION BOM_Revision, RS.BOM_REVISION_DATE, RI.COMPLETION_SUBINVENTORY Completion_Sub, null CLOCFLEX, RI.COMPLETION_LOCATOR_ID Compl_Loc_Id, TO_CHAR(RS.BOM_REVISION_DATE,'HH24:MI') BOM_TIME, (RS.PROCESSING_WORK_DAYS * RS.DAILY_PRODUCTION_RATE) Total_Units, RS.LAST_UNIT_COMPLETION_DATE Last_Unit_Comp, TO_CHAR(RS.LAST_UNIT_COMPLETION_DATE,'HH24:MI') LUC_TIME, RS.ROUTING_REVISION Rtg_Revision, RS.ROUTING_REVISION_DATE, TO_CHAR(RS.ROUTING_REVISION_DATE,'HH24:MI') RTG_TIME, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_clocator', 'INV', 'MTLL', 101, X.ORGANIZATION_ID, X.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_CLOCATOR FROM WIP_ENTITIES E, WIP_REPETITIVE_SCHEDULES RS, WIP_REPETITIVE_ITEMS RI, WIP_LINES L, MTL_SYSTEM_ITEMS M, MTL_ITEM_LOCATIONS X, MFG_LOOKUPS LU WHERE E.ORGANIZATION_ID = :P_ORGANIZATION_ID AND RS.ORGANIZATION_ID = :P_ORGANIZATION_ID AND RI.ORGANIZATION_ID = :P_ORGANIZATION_ID AND M.ORGANIZATION_ID = E.ORGANIZATION_ID AND L.ORGANIZATION_ID = :P_ORGANIZATION_ID &ASSEMBLY_SPEC &LINE_SPEC AND X.ORGANIZATION_ID (+) = RI.ORGANIZATION_ID AND X.INVENTORY_LOCATION_ID (+) = RI.COMPLETION_LOCATOR_ID AND M.INVENTORY_ITEM_ID = E.PRIMARY_ITEM_ID AND RS.WIP_ENTITY_ID = E.WIP_ENTITY_ID AND RI.WIP_ENTITY_ID = E.WIP_ENTITY_ID AND L.LINE_ID = RI.LINE_ID AND RS.LINE_ID = RI.LINE_ID AND LU.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND LU.LOOKUP_CODE = RS.STATUS_TYPE &DATE_RANGE AND E.ENTITY_TYPE = 2 AND RS.STATUS_TYPE IN (1,3,4,6) ORDER BY E.WIP_ENTITY_NAME, RS.FIRST_UNIT_START_DATE WIP WIPRERTG_XML AR WIP صحيفة التوجيه التكرارية (بتنسيق XML) Imported from BI Publisher Description: صحيفة التوجية التكرارية Application: العمل في الإنجاز Source: صحيفة التوجيه التكرارية (بتنسيق XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG D WIP Linienaufträge - Arbeitspläne Imported from BI Publisher Description: Linienaufträge - Arbeitspläne Application: Fertigung Source: Linienaufträge - Arbeitspläne (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG E WIP Hoja de Ruta Repetitiva Imported from BI Publisher Description: Hoja de Ruta Repetitiva Application: Work in Process Source: Hoja de Ruta Repetitiva (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG F WIP Gamme de fabrication répétitive Imported from BI Publisher Description: Gamme de fabrication répétitive Application: Work In Process Source: Gamme de fabrication répétitive (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG I WIP Prospetto Ciclo ripetitivo Imported from BI Publisher Description: Prospetto ciclo ripetitivo Application: Work in Process Source: Prospetto Ciclo ripetitivo (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG JA WIP ライン型工順シート Imported from BI Publisher Description: ライン型工順シート Application: Work in Process Source: ライン型工順シート(XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG KO WIP 반복 공정순서표 Imported from BI Publisher Description: 반복 공정순서표 Application: Work in Process Source: 반복 공정순서표(XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG PTB WIP Relatório de Roteiros Repetitivos Imported from BI Publisher Description: Relatório Roteiros Repetitivos Application: Work in Process Source: Relatório de Roteiros Repetitivos (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG RU WIP Техкарта для графиков серийного производства Imported from BI Publisher Description: Техкарта для графиков серийного производства Application: Незавершенное производство Source: Техкарта для графиков серийного производства (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG S WIP Repetitiv operationslista Imported from BI Publisher Description: Repetitiv operationslista Application: Work in Process Source: Repetitiv operationslista (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG TR WIP Seri Üretim Rota Sayfası Imported from BI Publisher Description: Seri Üretim Rota Sayfası Application: Üretim İzleme Source: Seri Üretim Rota Sayfası (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG US WIP Repetitive Routing Sheet Imported from BI Publisher Description: Repetitive Routing Sheet Application: Work in Process Source: Repetitive Routing Sheet (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG ZHS WIP 重复性工艺路线单 Imported from BI Publisher Description: 重复性工艺路线单 Application: 在制品管理系统 Source: 重复性工艺路线单 (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG BI Publisher &assembly_spec &date_range &line_spec :p_assembly :p_clocflex :p_compflex :p_conc_request_id :p_debug :p_first_unit_start_date1 :p_first_unit_start_date2 :p_line_code :p_locflex :p_organization_id :p_qty_precision 1 -30 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y US Org_id 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 :p_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 Y AR المنتج D Baugruppe E Conjunto F Produit I Assieme JA 組立品 KO 조립품 PTB Montagem RU Сборка S Montering TR Ürün US Assembly ZHS 装配件 4 20 :p_line_code 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 Y AR سطر D Linie E Línea F Ligne I Linea JA ライン KO 라인 PTB Linha RU Линия S Rad TR Hat US Line ZHS 生产线 5 30 :p_first_unit_start_date1 Date AR تواريخ بداية الوحدة الأولى من D Startdatum erste Einheit von E De Fecha Inicio Primera Unidad F Dates de début de la première unité - Du I Date inizio prima unità da JA 第1単位開始日:自 KO 최초 조립품 시작 일자: 부터 PTB Datas Iniciais da Primeira Unidade - De RU Даты начала первой единицы с S Startdatum för första enhet från TR İlk Birim Başlangıç Tarihleri: İlk US First Unit Start Dates From ZHS 第一单位起始起始日期 6 40 :p_first_unit_start_date2 Date AR إلى D Bis E A F A I A JA 至 KO 까지 PTB Até RU По S Till TR Son US To ZHS 至