ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4729851A9E05362FB09050512Y SELECT E.WIP_ENTITY_NAME Job, E.ORGANIZATION_ID C_ORGANIZATION_ID, E.WIP_ENTITY_ID WIP_ENTITY_ID10, D.DESCRIPTION DESCRIPTION, M.PRIMARY_UOM_CODE UOM, D.START_QUANTITY Start_Quantity, D.JOB_TYPE Job_Type, DECODE(M.INVENTORY_ITEM_ID, NULL, NULL,null) FLEXDATA, MSITL.DESCRIPTION Item_Desc, D.COMPLETION_SUBINVENTORY Subinventory, null CLOCFLEX, D.COMPLETION_LOCATOR_ID Compl_Loc_Id, D.BOM_REVISION BOM_Revision, D.BOM_REVISION_DATE BOM_REVISION_DATE, SUBSTR(TO_CHAR(D.BOM_REVISION_DATE,'HH24:MI'),1,5) BOM_TIME, D.SCHEDULED_START_DATE Scheduled_Start, SUBSTR(TO_CHAR(D.SCHEDULED_START_DATE,'HH24:MI'),1,5) START_TIME, LU.MEANING Status, D.ROUTING_REVISION Routing_Revision, D.ROUTING_REVISION_DATE ROUTING_REVISION_DATE, SUBSTR(TO_CHAR(D.ROUTING_REVISION_DATE,'HH24:MI'),1,5) ROUTING_TIME, D.SCHEDULED_COMPLETION_DATE Scheduled_Complete, DECODE(D.BOM_REFERENCE_ID,NULL,NULL, null) C_Bill_Ref_Data, SI2.DESCRIPTION Bill_Ref_Description, DECODE(D.ROUTING_REFERENCE_ID,NULL,NULL, null) C_Routing_Ref_Data, SI3.DESCRIPTION Rout_Ref_Description, SUBSTR(TO_CHAR(D.SCHEDULED_COMPLETION_DATE,'HH24:MI'),1,5) COMPLETION_TIME, SG.SCHEDULE_GROUP_NAME, D.BUILD_SEQUENCE, WL.LINE_CODE, DECODE(M.INVENTORY_ITEM_ID, NULL, NULL,fnd_flex_xml_publisher_apis.process_kff_combination_1('flexfield', 'INV', 'MSTK', 101, M.ORGANIZATION_ID, M.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) FLEXFIELD, DECODE(D.BOM_REFERENCE_ID,NULL,NULL,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_bill_reference', 'INV', 'MSTK', 101, SI2.ORGANIZATION_ID, SI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) C_Bill_Reference, DECODE(D.ROUTING_REFERENCE_ID,NULL,NULL,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_routing_reference', 'INV', 'MSTK', 101, SI3.ORGANIZATION_ID, SI3.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) C_Routing_Reference, DECODE(D.COMPLETION_LOCATOR_ID, NULL, NULL, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_clocator', 'INV', 'MTLL', 101, L.ORGANIZATION_ID, L.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE')) C_CLOCATOR FROM MTL_SYSTEM_ITEMS_B M, MTL_SYSTEM_ITEMS_TL MSITL, MTL_SYSTEM_ITEMS SI2, MTL_SYSTEM_ITEMS SI3, MFG_LOOKUPS LU, MTL_ITEM_LOCATIONS L, WIP_LINES WL, WIP_SCHEDULE_GROUPS SG, WIP_ENTITIES E, WIP_DISCRETE_JOBS D WHERE E.ORGANIZATION_ID = :P_ORGANIZATION_ID &NAME_RANGE &DATE_RANGE &C_SCHEDULE_GROUP AND SG.SCHEDULE_GROUP_ID &P_SG_OUTER = D.SCHEDULE_GROUP_ID AND SG.ORGANIZATION_ID &P_SG_OUTER = D.ORGANIZATION_ID AND WL.LINE_ID (+) = D.LINE_ID AND WL.ORGANIZATION_ID (+) = D.ORGANIZATION_ID AND L.INVENTORY_LOCATION_ID(+) = NVL(D.COMPLETION_LOCATOR_ID,'-1') AND L.ORGANIZATION_ID (+) = D.ORGANIZATION_ID AND D.WIP_ENTITY_ID = E.WIP_ENTITY_ID AND M.INVENTORY_ITEM_ID(+) = E.PRIMARY_ITEM_ID AND MSITL.INVENTORY_ITEM_ID(+) = E.PRIMARY_ITEM_ID AND MSITL.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSITL.LANGUAGE(+) = USERENV('LANG') AND LU.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND LU.LOOKUP_CODE = D.STATUS_TYPE AND D.STATUS_TYPE IN (1,3,4,6) AND E.ENTITY_TYPE in (1,5) AND D.ORGANIZATION_ID = :P_ORGANIZATION_ID AND M.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND SI2.ORGANIZATION_ID (+) = :P_ORGANIZATION_ID AND SI3.ORGANIZATION_ID (+) = :P_ORGANIZATION_ID AND SI2.INVENTORY_ITEM_ID (+) = D.BOM_REFERENCE_ID AND SI3.INVENTORY_ITEM_ID (+) = D.ROUTING_REFERENCE_ID ORDER BY &C_ORDER_BY WIP WIPDJRTG_XML AR WIP صحيفة توجيه أمر الشغل المنفصل (بتنسيق XML) Imported from BI Publisher Description: صحيفة توجيه أمر الشغل المنفصل Application: العمل في الإنجاز Source: صحيفة توجيه أمر الشغل المنفصل (بتنسيق XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG D WIP Diskrete Aufträge - Arbeitspläne Imported from BI Publisher Description: Diskrete Aufträge - Arbeitspläne Application: Fertigung Source: Diskrete Aufträge - Arbeitspläne (XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG E WIP Hoja de Ruta de Órdenes de Fabricación Discretas Imported from BI Publisher Description: Hoja de Ruta de Órdenes de Fabricación Discretas Application: Work in Process Source: Hoja de Ruta de Órdenes de Fabricación Discretas (XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG F WIP Gamme de fabrication des OF Imported from BI Publisher Description: Gamme de fabrication des OF Application: Work In Process Source: Gamme de fabrication des OF (XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG I WIP Prospetto ciclo OdL discreto Imported from BI Publisher Description: Prospetto ciclo OdL discreto Application: Work in Process Source: Prospetto ciclo OdL discreto (XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG JA WIP ショップ型製造オーダー工順シート Imported from BI Publisher Description: ショップ型製造オーダー工順シート Application: Work in Process Source: ショップ型製造オーダー工順シート(XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG KO WIP 단속 작업 공정순서표 Imported from BI Publisher Description: 단속 작업 공정순서표 Application: Work in Process Source: 단속 작업 공정순서표(XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG PTB WIP Relatório de Roteiros da Ordem de Produção Discreta Imported from BI Publisher Description: Folha Rot. Ord.Prod.Disc. Application: Work in Process Source: Relatório de Roteiros da Ordem de Produção Discreta (XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG RU WIP Техкарта для отдельных заданий Imported from BI Publisher Description: Техкарта для отдельных заданий Application: Незавершенное производство Source: Техкарта для отдельных заданий (XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG S WIP Operationslista för TO Imported from BI Publisher Description: Operationslista för TO Application: Work in Process Source: Operationslista för TO (XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG TR WIP Kesikli İş Emri Rota Sayfası Imported from BI Publisher Description: Kesikli İş Emri Rota Sayfası Application: Üretim İzleme Source: Kesikli İş Emri Rota Sayfası (XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG US WIP Discrete Job Routing Sheet Imported from BI Publisher Description: Discrete Job Routing Sheet Application: Work in Process Source: Discrete Job Routing Sheet (XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG ZHS WIP 离散任务工艺路线单 Imported from BI Publisher Description: 离散任务工艺路线单 Application: 在制品管理系统 Source: 离散任务工艺路线单 (XML) Short Name: WIPDJRTG_XML DB package: WIP_WIPDJRTG_XMLP_PKG BI Publisher &c_order_by &c_schedule_group &date_range &name_range &p_sg_outer :p_bill_ref :p_clocflex :p_compflex :p_conc_request_id :p_debug :p_flexdata :p_locflex :p_organization_id :p_qty_precision :p_routing_ref :p_schedule_group_from :p_schedule_group_to :p_scheduled_start_date1 :p_scheduled_start_date2 :p_sg_outer :p_sort_by :p_wip_entity_name1 :p_wip_entity_name2 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_wip_entity_name1 LOV Oracle WIP_SRS_DISCRETE_JOBS_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 not in (2,9,10) order by wip_entity_name AR أوامر الشغل من D Von Fertigungsauftrag E De Orden de Fabricación F Ordres de fabrication - De I OdL - Da JA 製造オーダー:自 KO 작업: 부터 PTB Ordens de Produção - De RU Задания с S Från TO TR İş Emirleri, İlk US Jobs From ZHS 任务自 4 20 :p_wip_entity_name2 LOV Oracle WIP_SRS_DISCRETE_JOBS_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 not in (2,9,10) 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 至 5 30 :p_scheduled_start_date1 Date AR تواريخ البداية المجدولة من D Geplanter Start von E De Fecha Inicio Programada F Dates début prévues - De I Date inizio programmate - Da JA 計画開始日:自 KO 스케줄 시작일자: 부터 PTB Datas Iniciais Programadas - De RU Плановые даты начала с S Från schemalagda startdatum TR Çizelgelenmiş Başlangıç Tarihleri: İlk US Scheduled Start Dates From ZHS 预定起始日期自 6 40 :p_scheduled_start_date2 Date 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 7 50 :p_schedule_group_from LOV Oracle WIP_SRS_SCHEDULE_GROUPS Y select wsg.schedule_group_name id, wsg.schedule_group_name value, null description from wip_schedule_groups wsg where wsg.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by schedule_group_name AR مجموعة الجدول من مدى مجموعة الجدول من D Von Planungsgruppe Von Planungsgruppe E De Grupo de Programas De Rango de Grupo de Programas F Groupe de planification - De Fourchette de groupes de planification - De I Gruppo di programmi da Intervallo del gruppo di programmi - Da JA 計画グループ 自 計画グループ範囲:自 KO 스케줄 그룹: 부터 스케줄 그룹 범위: 부터 PTB Grupo de Programações - De Faixa do Grupo de Programações - De RU Группа планирования с Нижняя граница диапазона групп планирования S Från schemagrupp Från schemagruppsintervall TR İlk Çizelge Grubu Çizelge Grup Aralığı Başlangıcı US Schedule Group From Schedule Group Range From ZHS 计划组自 计划组范围自 8 60 :p_schedule_group_to LOV Oracle WIP_SRS_SCHEDULE_GROUPS Y select wsg.schedule_group_name id, wsg.schedule_group_name value, null description from wip_schedule_groups wsg where wsg.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by schedule_group_name AR مجموعة الجداول إلى مدى مجموعة الجدول إلى D Bis Planungsgruppe Bis Planungsgruppe E A Grupo de Programas A Rango de Grupo de Programas F Groupe de planification - A Fourchette de groupes de planification - A I Gruppo di programmi a Intervallo gruppi di programmi - A JA 計画グループ 至 計画グループ範囲:至 KO 스케줄 그룹: 까지 스케줄 그룹 범위: 까지 PTB Grupo de Programações - Até Faixa do Grupo de Programações - Até RU Группа планирования по Верхняя граница диапазона групп планирования S Till schemagrupp Till schemagruppsintervall TR Son Çizelge Grubu Çizelge Grup Aralığı Bitişi US Schedule Group To Schedule Group Range To ZHS 计划组至 计划组范围至 9 70 :p_sort_by LOV Oracle WIP_SRS_DISC_DATA_SORT_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_REP_SRW_SORT' and lookup_code in (11,14) order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'WIP_REP_SRW_SORT' AND LOOKUP_CODE = 11 Y AR فرز بواسطة ترتيب الفرز D Sortieren nach Reihenfolge E Ordenar por Orden de Clasificación F Tri par Ordre de tri I Ordina per Criterio di ordinamento JA ソート・キー ソート・オーダー KO 정렬 기준 정렬 순서 PTB Classificar por Ordem de Classificação RU Сортировка Порядок сортировки S Sortera efter Sorteringsordning TR Sıralama Ölçütü Sıralama Düzeni US Sort By Sort Order ZHS 排序依据 排序顺序