ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations C08F390F417C9DC4E0530100007FC523 INV Locator Y select milk.concatenated_segments value, ood.organization_code||': '||ood.organization_name description from mtl_item_locations_kfv milk, org_organization_definitions ood where milk.organization_id=ood.organization_id and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') order by milk.concatenated_segments US 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 C6E085D4700551A9E05362FB09050512 select x.organization_code, x.organization_name, x.physical_inventory, x.tag, x.item, x.description, x.primary_uom, x.revision, x.subinventory, x.locator, x.lot_number, x.serial_number, x.parent_lpn, x.outermost_lpn, x.cost_group, x.phys_inv_adjust_applicable, x.adjustments_posted, x.last_adjustment_date, x.adjustment_approval_status, x.adjustment_id from ( select mpi.physical_inventory_name physical_inventory, mp.organization_code organization_code, hou.name organization_name, mpit.tag_number tag, mpit.inventory_item_id item_id, null description, mpit.revision revision, null primary_uom, mpit.subinventory subinventory, mpit.locator_id locator_id, mpit.lot_number lot_number, mpit.serial_num serial_number, mpit.parent_lpn_id, mpit.outermost_lpn_id, mpit.cost_group_id, null item, null locator, decode(:p_wms_installed,'TRUE',inv_invarptp_xmlp_pkg.cf_parent_lpnformula(mpit.parent_lpn_id),null) parent_lpn, decode(:p_wms_installed,'TRUE',inv_invarptp_xmlp_pkg.cf_outermost_lpnformula(mpit.outermost_lpn_id,mpit.parent_lpn_id),null) outermost_lpn, decode(:p_wms_installed,'TRUE',inv_invarptp_xmlp_pkg.cf_cost_groupformula(mpit.cost_group_id),null) cost_group, -- inv_material_status_grp.is_status_applicable( null, null,8,null,null,mpit.organization_id,mpit.inventory_item_id,mpit.subinventory,mpit.locator_id,mpit.lot_number,mpit.serial_num,'A') phys_inv_adjust_applicable, xxen_util.meaning(decode(mpi.last_adjustment_date ,null,2,1),'SYS_YES_NO',700) adjustments_posted, mpi.last_adjustment_date, nvl( (select decode(nvl(mpa.approval_status,0),0,'None',1,'Approved',2,'Rejected',3,'Processed',mpa.approval_status) from mtl_physical_adjustments mpa where mpit.organization_id = mpa.organization_id and mpit.physical_inventory_id= mpa.physical_inventory_id and mpit.adjustment_id = mpa.adjustment_id and mpit.inventory_item_id = mpa.inventory_item_id ), 'No Adjustment Exists' ) adjustment_approval_status, mpit.adjustment_id from mtl_parameters mp, mtl_physical_inventories mpi, hr_organization_units hou, mtl_physical_inventory_tags mpit where 1=1 and mp.organization_id = mpit.organization_id and hou.organization_id = mp.organization_id and mpit.physical_inventory_id = mpi.physical_inventory_id and mpit.inventory_item_id is null and :p_item_lo || :p_item_high is null and :p_loc_lo || :p_loc_hi is null union select mpi.physical_inventory_name physical_inventory, mp.organization_code organization_code, hou.name organization_name, mpit.tag_number tag, mpit.inventory_item_id item_id, msi.description description, mpit.revision revision, msi.primary_uom_code primary_uom, mpit.subinventory subinventory, mpit.locator_id locator_id, mpit.lot_number lot_number, mpit.serial_num serial_number, mpit.parent_lpn_id, mpit.outermost_lpn_id, mpit.cost_group_id, msi.concatenated_segments item, mil.concatenated_segments locator, decode(:p_wms_installed,'TRUE',inv_invarptp_xmlp_pkg.cf_parent_lpnformula(mpit.parent_lpn_id),null) parent_lpn, decode(:p_wms_installed,'TRUE',inv_invarptp_xmlp_pkg.cf_outermost_lpnformula(mpit.outermost_lpn_id,mpit.parent_lpn_id),null) outermost_lpn, decode(:p_wms_installed,'TRUE',inv_invarptp_xmlp_pkg.cf_cost_groupformula(mpit.cost_group_id),null) cost_group, -- inv_material_status_grp.is_status_applicable( null, null,8,null,null,mpit.organization_id,mpit.inventory_item_id,mpit.subinventory,mpit.locator_id,mpit.lot_number,mpit.serial_num,'A') phys_inv_adjust_applicable, xxen_util.meaning(decode(mpi.last_adjustment_date ,null,2,1),'SYS_YES_NO',700) adjustments_posted, mpi.last_adjustment_date, nvl( (select decode(nvl(mpa.approval_status,0),0,'None',1,'Approved',2,'Rejected',3,'Processed',mpa.approval_status) from mtl_physical_adjustments mpa where mpit.organization_id = mpa.organization_id and mpit.physical_inventory_id= mpa.physical_inventory_id and mpit.adjustment_id = mpa.adjustment_id and mpit.inventory_item_id = mpa.inventory_item_id ), 'No Adjustment Exists' ) adjustment_approval_status, mpit.adjustment_id from mtl_system_items_vl msi, mtl_item_locations_kfv mil, mtl_parameters mp, mtl_physical_inventories mpi, hr_organization_units hou, mtl_physical_inventory_tags mpit where 1=1 and 2=2 and msi.inventory_item_id = mpit.inventory_item_id and msi.organization_id = mpit.organization_id and mp.organization_id = msi.organization_id and hou.organization_id = mp.organization_id and mil.inventory_location_id (+)= mpit.locator_id and mil.organization_id (+)= mpit.organization_id and mpit.physical_inventory_id = mpi.physical_inventory_id ) x order by &lp_order_by Y INV INVARPTP_XML AR INV بطاقات المخزون الفعلي (بتنسيق XML) Imported from BI Publisher Description: بطاقات المخزون الفعلي Application: المخازن Source: بطاقات المخزون الفعلي (بتنسيق XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG D INV Belege für Stichtagsinventur Imported from BI Publisher Description: Auswertung "Belege für Stichtagsinventur" Application: Lager Source: Belege für Stichtagsinventur (XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG E INV Etiquetas de Inventario Físico Imported from BI Publisher Description: Etiquetas del Inventario Físico Application: Inventory Source: Etiquetas de Inventario Físico (XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG F INV Fiches d'inventaire physique Imported from BI Publisher Description: Fiches d'inventaire Application: Inventory Source: Fiches d'inventaire physique (XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG I INV Cartellini inventario fisico Imported from BI Publisher Description: Cartellini inventario fisico Application: Inventory Source: Cartellini inventario fisico (XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG JA INV 実地棚卸現品票 Imported from BI Publisher Description: 実地棚卸現品票 Application: Inventory Source: 実地棚卸現品票(XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG KO INV 총실사 태그 Imported from BI Publisher Description: 총실사 태그 Application: Inventory Source: 총실사 태그(XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG PTB INV Etiquetas de Inventário Físico Imported from BI Publisher Description: Etiquetas de Inventário Físico Application: Inventário Source: Etiquetas de Inventário Físico (XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG RU INV Инвентарные ярлыки Imported from BI Publisher Description: Инвентарные ярлыки Application: Запасы Source: Инвентарные ярлыки (XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG S INV Inventeringskort Imported from BI Publisher Description: Inventeringskort Application: Inventory Source: Inventeringskort (XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG TR INV Fiziksel Sayım Etiketleri Imported from BI Publisher Description: Fiziksel Sayım Etiketleri Application: Stok Yönetimi Source: Fiziksel Sayım Etiketleri (XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG US INV Physical Inventory Tags Imported from BI Publisher Description: Physical Inventory Tags Application: Inventory Source: Physical Inventory Tags (XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG ZHS INV 实地盘点货签 Imported from BI Publisher Description: 实地盘点货签 Application: 库存管理系统 Source: 实地盘点货签 (XML) Short Name: INVARPTP_XML DB package: INV_INVARPTP_XMLP_PKG Enginatics &lp_order_by 1=1 2=2 :p_conc_request_id :p_item_flexdata :p_item_hi :p_item_high :p_item_lo :p_item_orderby :p_item_struct :p_item_where :p_loc_flexdata :p_loc_hi :p_loc_lo :p_loc_orderby :p_loc_struct :p_order_by :p_org_id :p_physical :p_range :p_range_flex :p_range_sql :p_sort_id :p_struct_num :p_subinventory :p_tag_hi :p_tag_lo :p_wms_installed 1 -10 1=1 mpit.organization_id = :p_org_id LOV custom Y select ood.organization_id id, ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code select mp.organization_id from mtl_parameters mp where mp.organization_code = :$flex$.organization_code Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ID ZHS 组织 组织 2 10 :p_org_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') Y US Organization Code Organization 3 20 1=1 mpi.physical_inventory_id = :p_physical LOV custom Y select physical_inventory_id id, physical_inventory_name value, description description from mtl_physical_inventories where organization_id=:$flex$.Organization order by value, description Y AR المخزون الفعلي اسم المخزون الفعلي D Stichtagsinventur Bezeichnung Stichtagsinventur E Inventario Físico Nombre de Inventario Físico F Inventaire physique Nom de l'inventaire physique I Inventario fisico Nome inventario fisico JA 実地棚卸 実地棚卸名 KO 총실사 총실사명 PTB Inventário Físico Nome do Inventário Físico RU Общая инвентаризация Имя общей инвентаризации S Lagerinventering Inventering: Namn TR Fiziksel Sayım Fiziksel Sayım Adı US Physical Inventory Physical Inventory Name ZHS 实地盘点 实地盘点名称 4 30 1=1 nvl(mpit.subinventory,'#null#') = nvl(:p_subinventory,nvl(mpit.subinventory,'#null#')) LOV custom Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=:$flex$.organization order by secondary_inventory_name AR المخزن المخزن D Lager Lager E Subalmacén Subalmacén F Magasin Magasin I Sottomagazzino Sottomagazzino JA 保管場所 保管場所 KO 창고 창고 PTB Subinventário Subinventário RU Складское подразделение Складское подразделение S Lagerställe Lagerställe TR Stok Yeri Stok Yeri US Subinventory Subinventory ZHS 子库存 子库存 5 40 2=2 msi.concatenated_segments>=:p_item_lo LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments AR من الصنف من الصنف D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR İlk Kalem İlk Kalem US Item From From Item ZHS 起始物料 起始物料 6 50 2=2 msi.concatenated_segments<=:p_item_hi LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments :$flex$.item_from AR إلى 3 إلى الصنف D Bis 3 Bis Artikel E A 3 A Artículo F A 3 Article - A I A 3 Articolo - A JA 至 3 品目:至 KO 까지 3 품목: 까지 PTB Até 3 Item - Até RU По 3 Позиция по S Till 3 Till artikel TR Son 3 Son Kalem US Item To To Item ZHS 至 3 终止物料 7 60 2=2 mil.concatenated_segments>=:p_loc_lo LOV INV Locator C08F390F417C9DC4E0530100007FC523 Y select milk.concatenated_segments value, ood.organization_code||': '||ood.organization_name description from mtl_item_locations_kfv milk, org_organization_definitions ood where milk.organization_id=ood.organization_id and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') order by milk.concatenated_segments AR من محدد المواقع من محدد المواقع D Von Lagerplatz Von Lagerplatz E De Ubicación De Ubicación F Depuis l'emplacement Depuis l'emplacement I Collocazione d'origine Collocazione d'origine JA 保管棚:自 保管棚:自 KO From 보관처 From 보관처 PTB De Endereço De Endereço RU Складское место с Складское место с S Från lagerplats Från lagerplats TR İlk Stok Adresi İlk Stok Adresi US Locator From From Locator ZHS 起始货位 起始货位 8 70 2=2 mil.concatenated_segments<=:p_loc_hi LOV INV Locator C08F390F417C9DC4E0530100007FC523 Y select milk.concatenated_segments value, ood.organization_code||': '||ood.organization_name description from mtl_item_locations_kfv milk, org_organization_definitions ood where milk.organization_id=ood.organization_id and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') order by milk.concatenated_segments :$flex$.locator_from AR إلى 2 إلى محدد المواقع D Bis 2 Bis Lagerplatz E A 2 A Ubicación F A 2 Vers l'emplacement I A 2 Collocazione - A JA 至 2 保管棚:至 KO 까지 2 To 보관처 PTB Até 2 Para Endereço RU По 2 Складское место-получатель S Till 2 Till lagerplats TR Son 2 Son Stok Adresi US Locator To To Locator ZHS 至 2 目标货位 9 80 1=1 mpit.tag_number >= :p_tag_lo LOV custom Y select mpit.tag_number value, null description from mtl_physical_inventories mpi, mtl_physical_inventory_tags mpit, mtl_parameters mp where mpi.physical_inventory_id = mpit.physical_inventory_id and mpi.organization_id = mpit.organization_id and mpi.organization_id = mp.organization_id and mp.organization_code = :$flex$.organization_code and xxen_util.contains(:$flex$.Physical_Inventory,mpi.physical_inventory_id) = 'Y' order by value AR من العلامة من العلامة D Von Beleg Von Beleg E De Etiqueta De Etiqueta F Fiche - De Fiche - De I Cartellino - Da Cartellino - Da JA 現品表:自 現品表:自 KO 태그: 부터 태그: 부터 PTB Etiqueta - De Etiqueta - De RU Ярлык с Ярлык с S Från etikett Från etikett TR İlk Etiket İlk Etiket US Tag From From Tag ZHS 起始货签 起始货签 10 90 1=1 mpit.tag_number <= :p_tag_hi LOV custom Y select mpit.tag_number value, null description from mtl_physical_inventories mpi, mtl_physical_inventory_tags mpit, mtl_parameters mp where mpi.physical_inventory_id = mpit.physical_inventory_id and mpi.organization_id = mpit.organization_id and mpi.organization_id = mp.organization_id and mp.organization_code = :$flex$.organization_code and xxen_util.contains(:$flex$.Physical_Inventory,mpi.physical_inventory_id) = 'Y' order by value :$flex$.tag_from AR إلى إلى العلامة D Bis Bis Beleg E A A Etiqueta F A Fiche - A I A Cartellino - A JA 至 現品表:至 KO 까지 태그: 까지 PTB Até Etiqueta - Até RU По Ярлык по S Till Till etikett TR Son Son Etiket US Tag To To Tag ZHS 至 目标货签 11 100 :p_sort_id LOV Oracle INV_SRS_PHYS_TAG_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_PHYS_TAG_SORT' order by lookup_code 1 Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar 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 Bazı Sıralama Bazı US Sort By Sort By ZHS 排序依据 排序依据 12 &lp_order_by x.tag 1 US Sort By 13 &lp_order_by x.subinventory, x.locator, x.item, x.revision, x.lot_number, x.serial_number, x.tag 2 US Sort By 14 &lp_order_by x.subinventory, x.item, x.revision, x.lot_number, x.serial_number, x.locator, x.tag 3 US Sort By 15 &lp_order_by x. item, x.subinventory, x.locator, x.tag 4 US Sort By :$flex$.Organization Organization Physical Inventory :$flex$.Physical_Inventory Physical Inventory Tag From :$flex$.Physical_Inventory Physical Inventory Tag To :$flex$.item_from Item From Item To :$flex$.locator_from Locator From Locator To :$flex$.organization Organization Subinventory :$flex$.organization_code Organization Code Item From :$flex$.organization_code Organization Code Item To :$flex$.organization_code Organization Code Locator From :$flex$.organization_code Organization Code Locator To :$flex$.organization_code Organization Code Organization :$flex$.organization_code Organization Code Tag From :$flex$.organization_code Organization Code Tag To :$flex$.tag_from Tag From Tag To