ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472A451A9E05362FB09050512Y SELECT WL.LINE_CODE Line , WL.DESCRIPTION Line_Desc , DECODE(:P_SORT_BY,6,WE.WIP_ENTITY_NAME,'X') C_ASSY , DECODE(:P_SORT_BY,6,WE.DESCRIPTION,'X') Assembly_Desc , DECODE(WRO.WIP_SUPPLY_TYPE,2,2,3,2,WRO.WIP_SUPPLY_TYPE) Supply_Code , ML.MEANING Wip_Supply_Type --, &P_COMP Component , MSI2.DESCRIPTION Comp_Desc , DECODE(:P_SORT_BY,6,WRO.OPERATION_SEQ_NUM,1) Op_Seq , NVL(BD.DEPARTMENT_CODE,' ') Department , NVL(WRO.SUPPLY_SUBINVENTORY,' ') Supply_Subinv --, null Supply_Locator , NVL(MIL.INVENTORY_LOCATION_ID,-1) Locator_Id , SUM((LEAST(BCD.NEXT_SEQ_NUM + WRS.PROCESSING_WORK_DAYS,:C_END_NUM) - GREATEST(BCD.NEXT_SEQ_NUM,:C_START_NUM)) * WRO.QUANTITY_PER_ASSEMBLY * WRS.DAILY_PRODUCTION_RATE ) Quantity_Required , MSI2.PRIMARY_UOM_CODE UOM , MOQ2.SUBINVENTORY_CODE On_Hand_Subinv , DECODE(MIL2.INVENTORY_LOCATION_ID,NULL,NULL,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_det_loc_disp', 'INV', 'MTLL', 101, MIL2.ORGANIZATION_ID, MIL2.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE')) On_Hand_Locator , DECODE(MOQ2.SUBINVENTORY_CODE,NVL(WRO.SUPPLY_SUBINVENTORY,'-1'), DECODE(NVL(MOQ2.LOCATOR_ID,-1),NVL(WRO.SUPPLY_LOCATOR_ID,-1),1,0),0) Supply_Flag , NVL(MOQ2.QUANTITY,0) Quantity_On_Hand, WIP_WIPREPCK_XMLP_PKG.order_func(DECODE ( :P_SORT_BY , 6 , WRO.OPERATION_SEQ_NUM , 1 ), NVL ( WRO.SUPPLY_SUBINVENTORY , ' ' ), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_component_disp', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), NVL ( BD.DEPARTMENT_CODE , ' ' ), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_disp', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_comp_sort', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_loc_sort', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'PADDED_VALUE')) C_Order, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_component_disp', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_Component_Disp, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_disp', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_Locator_Disp, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_comp_sort', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_Comp_Sort, WIP_WIPREPCK_XMLP_PKG.c_loc_sortformula(NVL ( MIL.INVENTORY_LOCATION_ID , - 1 ), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_loc_sort', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'PADDED_VALUE')) C_Loc_Sort FROM MFG_LOOKUPS ML , MTL_SYSTEM_ITEMS MSI2 , MTL_ITEM_LOCATIONS MIL , MTL_ITEM_LOCATIONS MIL2 , MTL_SECONDARY_INVENTORIES MSINV , BOM_DEPARTMENTS BD , BOM_CALENDAR_DATES BCD , MTL_ITEM_QUANTITIES_VIEW MOQ2 , WIP_REQUIREMENT_OPERATIONS WRO , WIP_REPETITIVE_SCHEDULES WRS , WIP_LINES WL , WIP_ENTITIES WE WHERE WL.ORGANIZATION_ID = :P_ORGANIZATION_ID &C_Limit_Lines AND WRS.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WRS.LINE_ID = WL.LINE_ID AND WRS.STATUS_TYPE IN &C_Limit_Status AND WE.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID AND WE.ORGANIZATION_ID = :P_ORGANIZATION_ID &C_Limit_Assemblies AND WRO.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID AND WRO.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WRO.REPETITIVE_SCHEDULE_ID = WRS.REPETITIVE_SCHEDULE_ID AND WRO.WIP_SUPPLY_TYPE <> 6 AND WRO.REQUIRED_QUANTITY != 0 &C_Limit_Supply_Type &C_Limit_Subinv AND ML.LOOKUP_TYPE = 'WIP_SUPPLY_PICK' AND ML.LOOKUP_CODE = DECODE(WRO.WIP_SUPPLY_TYPE,2,2,3,2,WRO.WIP_SUPPLY_TYPE) AND ML.ENABLED_FLAG = 'Y' AND BCD.CALENDAR_CODE = :C_CALENDAR_CODE AND BCD.EXCEPTION_SET_ID = :C_EXCEPTION_SET AND BCD.CALENDAR_DATE = TRUNC(WRO.DATE_REQUIRED) AND (BCD.NEXT_SEQ_NUM < :C_END_NUM AND (BCD.NEXT_SEQ_NUM + WRS.PROCESSING_WORK_DAYS) > :C_START_NUM) AND BD.DEPARTMENT_ID(+) = WRO.DEPARTMENT_ID AND BD.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MIL.INVENTORY_LOCATION_ID(+) = WRO.SUPPLY_LOCATOR_ID AND MIL.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSI2.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID AND MSI2.ORGANIZATION_ID = WRO.ORGANIZATION_ID AND MOQ2.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MOQ2.INVENTORY_ITEM_ID(+) = WRO.INVENTORY_ITEM_ID AND MSINV.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSINV.SECONDARY_INVENTORY_NAME(+) = MOQ2.SUBINVENTORY_CODE AND (MSINV.DISABLE_DATE IS NULL OR MSINV.DISABLE_DATE > TRUNC(SYSDATE)) AND MIL2.INVENTORY_LOCATION_ID(+) = MOQ2.LOCATOR_ID AND MIL2.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID GROUP BY WL.LINE_CODE , WL.DESCRIPTION , DECODE(:P_SORT_BY,6,WE.WIP_ENTITY_NAME,'X') , DECODE(:P_SORT_BY,6,WE.DESCRIPTION,'X') , DECODE(WRO.WIP_SUPPLY_TYPE,2,2,3,2,WRO.WIP_SUPPLY_TYPE) , ML.MEANING --, &P_COMP , MSI2.DESCRIPTION , DECODE(:P_SORT_BY,6,WRO.OPERATION_SEQ_NUM,1) , NVL(BD.DEPARTMENT_CODE,' ') , NVL(WRO.SUPPLY_SUBINVENTORY,' ') --, &P_SUPPLY_LOC , NVL(MIL.INVENTORY_LOCATION_ID,-1) , MSI2.PRIMARY_UOM_CODE , MOQ2.SUBINVENTORY_CODE , MOQ2.REVISION , DECODE(MIL2.INVENTORY_LOCATION_ID,NULL,NULL,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_det_loc_disp', 'INV', 'MTLL', 101, MIL2.ORGANIZATION_ID, MIL2.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE')) , DECODE(MOQ2.SUBINVENTORY_CODE,NVL(WRO.SUPPLY_SUBINVENTORY,'-1'), DECODE(NVL(MOQ2.LOCATOR_ID,-1),NVL(WRO.SUPPLY_LOCATOR_ID,-1),1,0),0) , NVL(MOQ2.QUANTITY,0), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_component_disp', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_disp', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_comp_sort', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_loc_sort', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'PADDED_VALUE') ORDER BY 1 ASC,2 ASC,3 ASC,5 ASC,19,14 ASC,15 ASC WIP WIPREPCK_XML AR WIP تقرير قائمة الانتقاء التكراري (بتنسيق XML) Imported from BI Publisher Description: تقرير قائمة اللقط التكراري Application: العمل في الإنجاز Source: تقرير قائمة الانتقاء التكراري (بتنسيق XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG D WIP Linienaufträge - Entnahmeschein Imported from BI Publisher Description: Linienaufträge - Entnahmeschein Application: Fertigung Source: Linienaufträge - Entnahmeschein (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG E WIP Lista de Acopio Repetitiva Imported from BI Publisher Description: Informe de lista de acopio repetitiva Application: Work in Process Source: Lista de Acopio Repetitiva (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG F WIP Etat Liste à servir par programme de fabrication Imported from BI Publisher Description: Etat Liste à servir par programme de fabrication Application: Work In Process Source: Etat Liste à servir par programme de fabrication (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG I WIP Rapporto Elenco di selezione ripetitiva Imported from BI Publisher Description: Rapporto Elenco di selezione ripetitiva Application: Work in Process Source: Rapporto Elenco di selezione ripetitiva (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG JA WIP ライン型製造オーダー・ピック・リスト・レポート Imported from BI Publisher Description: ライン型製造オーダー・ピック・リスト・レポート Application: Work in Process Source: ライン型製造オーダー・ピック・リスト・レポート(XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG KO WIP 반복 불출 목록 보고서 Imported from BI Publisher Description: 반복 제조 출하 목록 보고서 Application: Work in Process Source: 반복 불출 목록 보고서(XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG PTB WIP Relatório de Lista de Separação Repetitiva Imported from BI Publisher Description: Rel. Lista Separç. Reptv. Application: Work in Process Source: Relatório de Lista de Separação Repetitiva (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG RU WIP Список выбора для серийного производства Imported from BI Publisher Description: Список выбора для серийного производства Application: Незавершенное производство Source: Список выбора для серийного производства (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG S WIP Repetitiv plocklista - rapport Imported from BI Publisher Description: Repetitiv plocklista - rapport Application: Work in Process Source: Repetitiv plocklista - rapport (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG TR WIP Seri Üretim Toplama Listesi Raporu Imported from BI Publisher Description: Seri Üretim Toplama Listesi Raporu Application: Üretim İzleme Source: Seri Üretim Toplama Listesi Raporu (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG US WIP Repetitive Pick List Imported from BI Publisher Description: Repetitive Pick List Report Application: Work in Process Source: Repetitive Pick List Report (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG ZHS WIP 重复性拣料单报表 Imported from BI Publisher Description: 重复性拣料单报表 Application: 在制品管理系统 Source: 重复性拣料单报表 (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG BI Publisher &c_limit_assemblies &c_limit_lines &c_limit_status &c_limit_subinv &c_limit_supply_type &p_comp &p_supply_loc :c_calendar_code :c_end_num :c_exception_set :c_start_num :p_comp :p_conc_request_id :p_debug :p_detail_loc :p_from_job :p_from_line :p_organization_id :p_qty_precision :p_sort_by :p_start_date :p_start_date1 :p_supply_days :p_supply_loc :p_supply_subinv :p_supply_type :p_to_job :p_to_line :p_txn_only :qty 1 -30 :p_organization_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 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad precisión de cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점이하 자리수 수량 소수점자리 PTB Precisão da Quantidade Precisão da Quantidade RU Точность количества Точность количества S Kvantitetsprecision kvantitetsprecision TR Miktar Duyarlılığı miktar duyarlılığı US Quantity Precision quantity precision ZHS 数量精确度 数量精确度 3 10 :p_sort_by LOV Oracle WIP_SRS_REP_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 (4,6,9) order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'WIP_REP_SRW_SORT' AND LOOKUP_CODE = 6 Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por clasificar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por classificar por RU Сортировка параметр сортировки S Sortera efter sortera efter TR Sıralama Ölçütü sıralama bazı US Sort By sort by ZHS 排序依据 排序依据 4 20 :p_txn_only 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 = 2 Y AR قابل للحركة فقط قابل للحركة فقط D Nur transaktionsfähig Nur transaktionsfähig E Sólo Transacciones Permitidas sólo transacciones permitidas F Mouvement admis seulement Mouvement admis seulement I Solo transazione consentita Solo transazione consentita JA 取引可能のみ 取引可能のみ KO 트랜잭션 가능만 트랜잭션 가능만 PTB Somente Transacionável somente transacionável RU Только допускающие транзакции только допускающие транзакции S Endast överföringsbar endast överföringsbar TR Salt İşlemlenebilir salt işlemlenebilir US Transactable Only transactable only ZHS 仅可进行事务处理 仅可进行事务处理 5 30 :p_start_date Date sysdate Y AR تاريخ البداية تاريخ البداية D Startdatum Startdatum E Fecha de Inicio fecha de inicio F Date de début Date de début I Data avvio Data avvio JA 開始日 開始日 KO 시작 일자 시작 일자 PTB Data Inicial data inicial RU Начальная дата начальная дата S Startdatum startdatum TR Başlangıç Tarihi başlangıç tarihi US Start Date start date ZHS 起始日期 起始日期 6 40 :p_supply_days Number 1 Y AR أيام التوريد أيام التوريد D Reichweite Reichweite E Días de Aprovisionamiento días de aprovisionamiento F Jours de couverture Jours de couverture I Giorni fornitura Giorni di fornitura JA 供給日数 供給日数 KO 공급 일수 공급 일수 PTB Dias de Suprimento Dias de Suprimento RU Срок предложения срок предложения S Täcktid täcktid TR Tedarik Gün Sayısı tedarik gün sayısı US Days of Supply days of supply ZHS 供应天数 供应天数 7 50 :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 línea F Lignes - De Lignes - De I Linee - Da Linee - Da JA ライン:自 ライン:自 KO 라인: 부터 라인: 부터 PTB Linhas - De Linhas - De RU Линии с линии с S Från rader Rader från TR Hatlar, İlk Hat başlangıcı US Lines From lines from ZHS 生产线自 生产线自 8 60 :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 إلى سطور إلى D Bis Bis Linie E A a línea F A Lignes - A I A Linee - A JA 至 ライン:至 KO 까지 라인: 까지 PTB Até Linhas - até RU По линии по S Till rader till TR Son Hat bitişi US To lines to ZHS 至 生产线至 9 70 :p_from_job 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 conjunto F Produits - De Produits - De I Assiemi - Da Assiemi - Da JA 組立:自 組立:自 KO 조립품: 부터 조립품: 부터 PTB Montagens - De Montagens - De RU Сборки с сборки с S Från produkter produkter från TR Ürünler: İlk ürünler: ilk US Assemblies From assemblies from ZHS 装配件自 装配件自 10 80 :p_to_job 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 إلى 2 المنتجات إلى D Bis 2 Bis Baugruppe E A 2 a conjunto F A 2 Produits - A I A 2 Assiemi - A JA 至 2 組立:至 KO 까지 2 조립품: 까지 PTB Até 2 Montagens - De RU По 2 сборки по S Till 2 produkter till TR Son 2 son ürünler US To 2 assemblies to ZHS 至 2 装配件至 11 90 :p_supply_type LOV Oracle WIP_SRS_SUPPLY_TYPES_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_SUPPLY_PICK' and lookup_code not in (6,7) order by lookup_code AR نوع التوريد نوع التوريد D Bedarfsdeckungsart Entnahmeart E Tipo de Aprovisionamiento tipo de aprovisionamiento F Type d'approvisionnement Type approvisionnement I Tipo di fornitura Tipo di fornitura JA 供給タイプ 供給タイプ KO 공급 유형 공급 유형 PTB Tipo de Suprimento Tipo de Suprimento RU Тип предложения Тип предложения S Tillgångstyp tillgångstyp TR Tedarik Tipi tedarik tipi US Supply Type supply type ZHS 供应类型 供应类型 12 100 :p_supply_subinv LOV Oracle WIP_SRS_SUBINVENTORIES_OPT Y select secondary_inventory_name id, secondary_inventory_name value, null description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and (disable_date is null or disable_date>trunc(sysdate)) order by secondary_inventory_name AR مخزن التوريد مخزن التوريد D Entnahmelager Entnahmelager E Subalmacén de Aprovisionamiento Subalmacén de aprovisionamiento F Magasin d'approvisionnement Magasin d'approvisionnement I Sottomagazzino di fornitura Sottomagazzino di fornitura JA 供給保管場所 供給保管場所 KO 공급 창고 공급 창고 PTB Subinventário de Suprimento Subinventário de Suprimento RU Складское подразделение предложения складское подразделение предложения S Lagerställe för uttag lagerställe för uttag TR Tedarik Stok Yeri tedarik stok yeri US Supply Subinventory supply subinventory ZHS 供应子库存 供应子库存