ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F07A3869E053B46B63588994Y SELECT MS.STATUS_ID STATUS_ID , MS.STATUS_CODE STATUS_CODE , MS.DESCRIPTION MS_DESCRIPTION , MFG1.MEANING MS_ZONE_CONTROL , MFG2.MEANING MS_LOCATOR_CONTROL , MFG3.MEANING MS_LOT_CONTROL , MFG4.MEANING MS_SERIAL_CONTROL , MFG5.MEANING MS_ENABLED_FLAG FROM MTL_MATERIAL_STATUSES_VL MS , MFG_LOOKUPS MFG1 , MFG_LOOKUPS MFG2 , MFG_LOOKUPS MFG3 , MFG_LOOKUPS MFG4 , MFG_LOOKUPS MFG5 WHERE MS.STATUS_CODE BETWEEN :P_MS_LO AND :P_MS_HI AND ( MFG1.LOOKUP_TYPE = 'SYS_YES_NO' AND MFG1.LOOKUP_CODE = NVL(MS.ZONE_CONTROL,2)) AND ( MFG2.LOOKUP_TYPE = 'SYS_YES_NO' AND MFG2.LOOKUP_CODE = NVL(MS.LOCATOR_CONTROL,2)) AND ( MFG3.LOOKUP_TYPE = 'SYS_YES_NO' AND MFG3.LOOKUP_CODE = NVL(MS.LOT_CONTROL,2)) AND ( MFG4.LOOKUP_TYPE = 'SYS_YES_NO' AND MFG4.LOOKUP_CODE = NVL(MS.SERIAL_CONTROL,2)) AND ( MFG5.LOOKUP_TYPE = 'SYS_YES_NO' AND MFG5.LOOKUP_CODE = NVL(MS.ENABLED_FLAG,2)) ORDER BY MS.STATUS_CODE INV INVMSWHU_XML AR INV تقرير محل استخدام موقف المواد (بتنسيق XML) Application: المخازن Source: تقرير محل استخدام موقف المواد (بتنسيق XML) Short Name: INVMSWHU_XML DB package: INV_INVMSWHU_XMLP_PKG D INV Materialstatus - Verwendungsnachweis Application: Lager Source: Materialstatus - Verwendungsnachweis (XML) Short Name: INVMSWHU_XML DB package: INV_INVMSWHU_XMLP_PKG F INV Etat Cas d'emploi des statuts des matières Application: Inventory Source: Etat Cas d'emploi des statuts des matières (XML) Short Name: INVMSWHU_XML DB package: INV_INVMSWHU_XMLP_PKG US INV Material Status Where-Used Application: Inventory Source: Material Status Where-Used Report (XML) Short Name: INVMSWHU_XML DB package: INV_INVMSWHU_XMLP_PKG ZHS INV 物料状态使用处报表 Application: 库存管理系统 Source: 物料状态使用处报表 (XML) Short Name: INVMSWHU_XML DB package: INV_INVMSWHU_XMLP_PKG BI Publisher :p_conc_request_id :p_dock_door_txt :p_item_flex_all :p_loc_flex_all :p_ms_hi :p_ms_lo :p_org :p_search_loc :p_search_lot :p_search_ser :p_search_sub :p_stg_lane_txt :p_str_loc_txt 1 10 :p_org LOV Oracle INV_SRS_ORG Y select to_char(organization_id) id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,sysdate+1)>sysdate order by value,description Y AR التنظيم D Organisation F Organisation US Organization ZHS 组织 2 20 :p_ms_lo LOV Oracle INV_SRS_MATERIAL_STATUS Y select status_code id, status_code value, null description from mtl_material_statuses_vl order by status_code Y AR موقف المواد من D Von Materialstatus F Statut des matières - De US Material Status From ZHS 物料状态自 3 30 :p_ms_hi LOV Oracle INV_SRS_MATERIAL_STATUS Y select status_code id, status_code value, null description from mtl_material_statuses_vl order by status_code Y AR موقف المواد إلى D Bis Materialstatus F Statut des matières - A US Material Status To ZHS 物料状态至 4 40 :p_search_sub LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code Y AR البحث في المخازن D In Lägern suchen F Recherche dans les magasins US Search in Subinventories ZHS 在子库存中搜索 5 50 :p_search_loc LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code Y AR البحث في محدد المواقع D In Lagerplätzen suchen F Recherche dans les emplacements US Search in Locators ZHS 在货位中搜索 6 60 :p_search_lot LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code Y AR البحث في اللوطات D In Losen suchen F Recherche dans les lots US Search in Lots ZHS 在批次中搜索 7 70 :p_search_ser LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code Y AR البحث في المسلسلات D In Serien suchen F Recherche dans les séries US Search in Serials ZHS 在序列中搜索