ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472C151A9E05362FB09050512Y select :WIP_ENTITY_ID_1,'Pending Move Transactions' PTXN_TABLE from dual WHERE exists ( SELECT 1 FROM WIP_MOVE_TXN_INTERFACE WHERE ORGANIZATION_ID = :P_ORGANIZATION_ID AND WIP_ENTITY_ID = :WIP_ENTITY_ID_1 UNION ALL SELECT 1 FROM WSM_LOT_MOVE_TXN_INTERFACE WHERE ORGANIZATION_ID = :P_ORGANIZATION_ID AND WIP_ENTITY_ID = :WIP_ENTITY_ID_1 AND STATUS <> 4 ) UNION ALL SELECT :WIP_ENTITY_ID_1 WIP_ENTITY_ID2 ,'Pending Resource Transactions' PTXN_TABLE FROM DUAL WHERE exists ( SELECT 1 FROM WIP_COST_TXN_INTERFACE WHERE ORGANIZATION_ID = :P_ORGANIZATION_ID AND WIP_ENTITY_ID = :WIP_ENTITY_ID_1 ) UNION ALL SELECT :WIP_ENTITY_ID_1 WIP_ENTITY_ID2 ,'Pending Material Transactions' PTXN_TABLE FROM DUAL WHERE exists ( SELECT 1 FROM MTL_MATERIAL_TRANSACTIONS_TEMP WHERE ORGANIZATION_ID = :P_ORGANIZATION_ID AND TRANSACTION_SOURCE_ID = :WIP_ENTITY_ID_1 AND TRANSACTION_SOURCE_TYPE_ID = 5 ) UNION ALL SELECT :WIP_ENTITY_ID_1 WIP_ENTITY_ID2 ,'Uncosted Material Transactions' PTXN_TABLE FROM DUAL WHERE exists ( SELECT 1 FROM MTL_MATERIAL_TRANSACTIONS WHERE ORGANIZATION_ID = :P_ORGANIZATION_ID AND TRANSACTION_SOURCE_ID = :WIP_ENTITY_ID_1 AND COSTED_FLAG IN ( 'N' , 'E' ) AND TRANSACTION_SOURCE_TYPE_ID = 5 ) UNION ALL SELECT :WIP_ENTITY_ID_1 WIP_ENTITY_ID2 ,'Pending Operation Yield' PTXN_TABLE FROM DUAL WHERE exists ( SELECT 1 FROM WIP_OPERATION_YIELDS WHERE ORGANIZATION_ID = :P_ORGANIZATION_ID AND WIP_ENTITY_ID = :WIP_ENTITY_ID_1 AND STATUS in ( 1 , 3 ) ) UNION ALL SELECT :WIP_ENTITY_ID_1 WIP_ENTITY_ID2 ,'Pending WIP Lot Transactions' PTXN_TABLE FROM DUAL WHERE exists ( SELECT 1 FROM WSM_SM_STARTING_JOBS SJ, WSM_SPLIT_MERGE_TRANSACTIONS WMT WHERE SJ.WIP_ENTITY_ID = :WIP_ENTITY_ID_1 AND SJ.TRANSACTION_ID = WMT.TRANSACTION_ID AND WMT.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WMT.STATUS <> 4 UNION SELECT 1 FROM WSM_SM_RESULTING_JOBS RJ, WSM_SPLIT_MERGE_TRANSACTIONS WMT WHERE RJ.WIP_ENTITY_ID = :WIP_ENTITY_ID_1 AND RJ.TRANSACTION_ID = WMT.TRANSACTION_ID AND WMT.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WMT.STATUS <> 4 ) UNION ALL SELECT :WIP_ENTITY_ID_1 WIP_ENTITY_ID2 ,'Uncosted WIP Lot Transactions ' PTXN_TABLE FROM DUAL WHERE exists ( SELECT 1 FROM WSM_SM_STARTING_JOBS SJ, WSM_SPLIT_MERGE_TRANSACTIONS WMT WHERE SJ.WIP_ENTITY_ID = :WIP_ENTITY_ID_1 AND SJ.TRANSACTION_ID = WMT.TRANSACTION_ID AND WMT.ORGANIZATION_ID = :P_ORGANIZATION_ID AND NVL(WMT.COSTED ,1) <> 4 UNION SELECT 1 FROM WSM_SM_RESULTING_JOBS RJ, WSM_SPLIT_MERGE_TRANSACTIONS WMT WHERE RJ.WIP_ENTITY_ID = :WIP_ENTITY_ID_1 AND RJ.TRANSACTION_ID = WMT.TRANSACTION_ID AND WMT.ORGANIZATION_ID = :P_ORGANIZATION_ID AND NVL(WMT.COSTED ,1) <> 4 ) UNION ALL SELECT :WIP_ENTITY_ID_1 WIP_ENTITY_ID2 ,'Pending PO Requisitions' PTXN_TABLE FROM DUAL WHERE exists ( SELECT 1 FROM PO_RELEASES_ALL PR, PO_HEADERS_ALL PH, PO_DISTRIBUTIONS_ALL PD, PO_LINE_LOCATIONS_ALL PL WHERE PD.DESTINATION_ORGANIZATION_ID = :P_ORGANIZATION_ID AND PD.WIP_ENTITY_ID = :WIP_ENTITY_ID_1 AND PD.PO_LINE_ID is not null AND PD.LINE_LOCATION_ID is not null AND PL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID AND PH.PO_HEADER_ID = PD.PO_HEADER_ID AND PL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID AND pr.po_release_id (+) = PD.PO_RELEASE_ID AND NVL(PR.CANCEL_FLAG ,'N') = 'N' AND ( PL.QUANTITY_RECEIVED < ( PL.QUANTITY - PL.QUANTITY_CANCELLED ) ) ) OR exists ( SELECT 1 FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.DESTINATION_ORGANIZATION_ID = :P_ORGANIZATION_ID AND PRL.WIP_ENTITY_ID = :WIP_ENTITY_ID_1 AND NVL(PRL.CANCEL_FLAG ,'N') = 'N' AND PRL.LINE_LOCATION_ID is null ) OR exists ( SELECT 1 FROM PO_REQUISITIONS_INTERFACE_ALL PRI WHERE PRI.DESTINATION_ORGANIZATION_ID = :P_ORGANIZATION_ID AND PRI.WIP_ENTITY_ID = :WIP_ENTITY_ID_1 ) WSM WSMPNTXN_XML AR WSM تقرير الحركات المعلقة (بتنسيق XML) Imported from BI Publisher Description: تقرير الحركات المعلقة Application: إدارة صالة الإنتاج Source: تقرير الحركات المعلقة (بتنسيق XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG D WSM Anstehende Transaktionen Imported from BI Publisher Description: Auswertung "Anstehende Transaktionen" Application: Shop Floor Management Source: Anstehende Transaktionen (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG E WSM Transacciones Pendientes Imported from BI Publisher Description: Informe de transacciones pendientes Application: Shop Floor Management Source: Transacciones Pendientes (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG F WSM Etat Mouvements en attente Imported from BI Publisher Description: Etat Mouvements en attente Application: Shop Floor Management Source: Etat Mouvements en attente (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG I WSM Rapporto Transazioni in sospeso Imported from BI Publisher Description: Rapporto Transazioni in sospeso Application: Shop Floor Management Source: Rapporto Transazioni in sospeso (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG JA WSM 保留取引レポート Imported from BI Publisher Description: 保留取引レポート Application: Shop Floor Management Source: 保留取引レポート(XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG KO WSM 대기중 트랜잭션 보고서 Imported from BI Publisher Description: 보류중 트랜잭션 보고서 Application: Shop Floor Management Source: 대기중 트랜잭션 보고서(XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG PTB WSM Relatório de Transações Pendentes Imported from BI Publisher Description: Relatório de Transações Pendentes Application: Gerenciamento do Chão-de-Fábrica Source: Relatório de Transações Pendentes (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG RU WSM Отчет об отложенных транзакциях Imported from BI Publisher Description: Отчет об отложенных транзакциях Application: Руководство цехом Source: Отчет об отложенных транзакциях (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG S WSM Avvaktande transaktioner - rapport Imported from BI Publisher Description: Avvaktande transaktioner - rapport Application: Shop Floor Management Source: Avvaktande transaktioner - rapport (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG TR WSM Beklemedeki İşlemler Raporu Imported from BI Publisher Description: Beklemedeki İşlemler Raporu Application: Atölye Yönetimi Source: Beklemedeki İşlemler Raporu (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG US WSM Pending Transactions Imported from BI Publisher Description: Pending Transactions Report Application: Shop Floor Management Source: Pending Transactions Report (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG ZHS WSM 待定事务处理报表 Imported from BI Publisher Description: 待定事务处理报表 Application: 车间管理系统 Source: 待定事务处理报表 (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG BI Publisher :p_acct_class_type :p_class_range :p_class_type :p_conc_request_id :p_date_complete :p_entity_type :p_exclude_reserved_jobs :p_exclude_uncomplete_jobs :p_from_class :p_from_complete_date :p_from_job :p_from_release_date :p_from_start_date :p_job_name :p_organization_id :p_release_date :p_start_date :p_status :p_to_class :p_to_complete_date :p_to_job :p_to_release_date :p_to_start_date :wip_entity_id_1 1 -20 :p_organization_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 10 :p_acct_class_type LOV Oracle WSM_SRS_CLASS_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_CLASS_TYPE' and lookup_code in (5,7) order by lookup_code AR نوع الطبقة D Klassenart E Tipo de Clase F Type de classe I Tipo classe JA 区分タイプ KO 분류 유형 PTB Tipo de Classe RU Тип класса S Klasstyp TR Sınıf Tipi US Class Type ZHS 分类类型 3 20 :p_from_class LOV Oracle WSM_SRS_LBJ_CLASSES 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 in (5,7) order by class_code AR من الطبقة D Von Klasse E De Clase F Classe - De I Classe - Da JA 区分:自 KO From 분류 PTB Classe - De RU Класс с S Från klass TR İlk Sınıf US From Class ZHS 自分类 4 30 :p_to_class LOV Oracle WSM_SRS_LBJ_CLASSES 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 in (5,7) order by class_code AR إلى الطبقة D Bis Klasse E A Clase F Classe - A I Classe - A JA 区分:至 KO To 분류 PTB Classe - Até RU Класс по S Till klass TR Son Sınıf US To Class ZHS 终止分类 5 40 :p_from_job LOV Oracle WSM_SRS_LBJ Y select we.wip_entity_name id, we.wip_entity_name value, null description from wip_entities we,wip_discrete_jobs dj where we.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and we.organization_id=dj.organization_id and we.wip_entity_id=dj.wip_entity_id and dj.status_type in (1,3,4,5,6,7,9,11,15) and we.entity_type=5 order by value,description AR من أمر الشغل D Von Auftrag E De Orden de Fabricación F OF - De I OdL - Da JA 製造オーダー:自 KO From 작업 PTB Ordem de Produção - De RU Задания с S Från TO TR İlk İş Emri US From Job ZHS 自任务 6 50 :p_to_job LOV Oracle WSM_SRS_LBJ Y select we.wip_entity_name id, we.wip_entity_name value, null description from wip_entities we,wip_discrete_jobs dj where we.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and we.organization_id=dj.organization_id and we.wip_entity_id=dj.wip_entity_id and dj.status_type in (1,3,4,5,6,7,9,11,15) and we.entity_type=5 order by value,description select :$flex$.from_job from dual AR إلى أمر الشغل D Bis Auftrag E A Orden de Fabricación F OF - A I OdL - A JA 製造オーダー:至 KO To 작업 PTB Ordem de Produção - Até RU Задания по S Till TO TR Son İş Emri US To Job ZHS 终止任务 7 60 :p_from_release_date Date AR من تاريخ إصدار أمر الشغل D Von Auftragsabrufdatum E De Fecha de Liberación de Orden de Fabricación F Date de lancement OF - Du I Data rilascio OdL - Da JA 製造オーダー・リリース日:自 KO From 작업 릴리즈 일자 PTB Data da Liberação da Ordem de Produção - De RU Дата выпуска задания с S Från frisläppningsdatum för TO TR İlk İş Serbest Bırakma Tarihi US From Job Release Date ZHS 起始任务发放日期 8 70 :p_to_release_date Date select to_date(:$flex$.from_job_release_date,'yyyy/mm/dd hh24:mi:ss') from dual AR إلى تاريخ إصدار أمر الشغل D Bis Auftragsabrufdatum E A Fecha de Liberación de Orden de Fabricación F Date de lancement OF - Au I Data rilascio OdL - A JA 製造オーダー・リリース日:至 KO To 작업 릴리즈 일자 PTB Data da Liberação da Ordem de Produção - Até RU Дата выпуска задания по S Till frisläppningsdatum för TO TR Son İş Serbest Bırakma Tarihi US To Job Release Date ZHS 终止任务发放日期 9 80 :p_from_start_date Date AR من تاريخ بداية أمر الشغل D Von Auftragsstartdatum E De Fecha de Inicio de Orden de Fabricación F Date de début OF - Du I Data inizio OdL - Da JA 製造オーダー開始日:自 KO From 작업 시작 일자 PTB Data Inicial da Ordem de Produção - De RU Дата начала задания с S Från startdatum för TO TR İlk İş Başlangıç Tarihi US From Job Start Date ZHS 起始任务起始日期 10 90 :p_to_start_date Date select to_date(:$flex$.from_job_start_date,'yyyy/mm/dd hh24:mi:ss') from dual AR إلى تاريخ بداية أمر الشغل D Bis Auftragsstartdatum E A Fecha de Inicio de Orden de Fabricación F Date de début OF - Au I Data inizio OdL - A JA 製造オーダー開始日:至 KO To 작업 시작 일자 PTB Data Inicial da Ordem de Produção - Até RU Дата начала задания по S Till startdatum för TO TR Son İş Başlangıç Tarihi US To Job Start Date ZHS 终止任务起始日期 11 100 :p_from_complete_date Date AR من تاريخ إتمام أمر الشغل D Von Auftragsfertigstellungsdatum E De Fecha de Finalización de Orden de Fabricación F Date de fin OF - Du I Data completamento OdL - Da JA 製造オーダー完了日:自 KO From 작업 완료 일자 PTB Data de Término da Ordem de Produção - De RU Дата завершения задания с S Från slutförandedatum för TO TR İlk İş Tamamlama Tarihi US From Job Completion Date ZHS 起始任务完成日期 12 110 :p_to_complete_date Date select to_date(:$flex$.from_job_completion_date,'yyyy/mm/dd hh24:mi:ss') from dual AR إلى تاريخ إتمام أمر الشغل D Bis Auftragsfertigstellungsdatum E A Fecha de Finalización de Orden de Fabricación F Date de fin OF - Au I Data completamento OdL - A JA 製造オーダー完了日:至 KO To 작업 완료 일자 PTB Data de Término da Ordem de Produção - Até RU Дата завершения задания по S Till slutförandedatum för TO TR Son İş Emri Tamamlama Tarihi US To Job Completion Date ZHS 终止任务完成日期 13 120 :p_status LOV Oracle WSM_SRS_JOB_PENDING_TXN_STATUS_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_JOB_STATUS' and lookup_code in (3,4,5,6,7,15) order by value,description select meaning from mfg_lookups where lookup_type='WIP_JOB_STATUS' AND lookup_code=5 AR الموقف E Estado F Statut I Stato JA ステータス KO 상태 RU Статус TR Statü US Status ZHS 状态 14 130 :p_exclude_reserved_jobs 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 Ohne reservierte Aufträge E Excluir Órdenes de Fabricación Reservadas F Exclure les ordres de fabrication réservés I Escludi OdL impegnati JA 予約済製造オーダーの除外 KO 예약된 작업 제외 PTB Excluir Ordens de Produção Reservadas RU Исключить зарезервированные задания S Exkludera reserverade TO TR Ayrılan İş Emirlerini Hariç Tut US Exclude Reserved Jobs ZHS 排除保留的任务 15 140 :p_exclude_uncomplete_jobs 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 Ohne nicht fertig gestellte Aufträge E Excluir Órdenes de Fabricación No Finalizadas F Exclure les ordres de fabrication non terminés I Escludi OdL non completati JA 未完了製造オーダーの除外 KO 완료되지 않은 작업 제외 PTB Excluir Ordens de Produção Não-concluídas RU Исключить незавершенные задания S Exkludera ej slutförda TO TR Tamamlanmamış İş Emirlerini Hariç Tut US Exclude Un-Completed Jobs ZHS 排除未完成的任务