ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDECB79D2E0530100007F1FF2 INV Category Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US 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 8E2FF36EDE8579D2E0530100007F1FF2 INV Item Type Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US 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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 0DECEFFEC76FF389E0630100007F259E INV Physical Inventory Y select mpi.physical_inventory_name value, mpi.description description from mtl_physical_inventories mpi, mtl_parameters mp where mpi.organization_id=mp.organization_id and (mp.organization_code = :$flex$.organization_code or (:$flex$.organization_code is null and mp.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID')) ) order by value US 8E2FF36EDF2A79D2E0530100007F1FF2 INV Subinventory Y select msi.secondary_inventory_name value, msi.description||' ('||mp.organization_code||')' description from mtl_parameters mp, mtl_secondary_inventories msi where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msi.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 msi.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or xxen_util.contains(:$flex$.organization_code,mp.organization_id)='Y' ) and mp.organization_id=msi.organization_id order by mp.organization_code, msi.secondary_inventory_name US 8E2FF36EDF0779D2E0530100007F1FF2 PER Employee Y Y select ppx.full_name value, (select fu.user_name from fnd_user fu where ppx.person_id=fu.employee_id and rownum=1) description from per_people_x ppx, per_assignments_x pax where ppx.employee_number is not null and ppx.current_employee_flag='Y' and ppx.person_id=pax.person_id and pax.primary_flag='Y' and pax.assignment_type='E' order by ppx.full_name US 0328F6AEC7D30675E0636DFB090525F7 with mpit_qry as ( select /*+ INLINE */ -- Physical Inventory mp.organization_code, mpiv.physical_inventory_name, mpiv.description, mpiv.physical_inventory_date, mpiv.snapshot_complete, mpiv.freeze_date snapshot_date, xxen_util.meaning(mpiv.adjustments_posted,'INV_YES_NO',3) adjustments_posted, mpiv.last_adjustment_date, mpiv.total_adjustment_value, xxen_util.meaning(mpiv.approval_required,'INV_CC_APPROVAL',700) approval_required, mpiv.approval_tolerance_pos quantity_tolerance_plus, mpiv.approval_tolerance_neg quantity_tolerance_minus, mpiv.cost_variance_pos value_tolerance_plus, mpiv.cost_variance_neg value_tolerance_minus, xxen_util.meaning(mpiv.all_subinventories_flag,'INV_YES_NO',3) all_subinventories, (select listagg(mps.subinventory,',') within group (order by mps.subinventory) from mtl_physical_subinventories mps where mps.physical_inventory_id = mpiv.physical_inventory_id and mps.organization_Id = mpiv.organization_id ) subinventories, xxen_util.meaning(mpiv.exclude_zero_balance,'INV_YES_NO',3) exclude_zero_balance, xxen_util.meaning(mpiv.exclude_negative_balance,'INV_YES_NO',3) exclude_negative_balance, xxen_util.meaning(mpiv.dynamic_tag_entry_flag,'INV_YES_NO',3) dynamic_tag_entry_flag, mpiv.next_tag_number, mpiv.tag_number_increments, mpiv.number_of_skus, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = mpiv.default_gl_adjust_account ) default_adjustment_account, -- Tags mpit.tag_number, msiv.concatenated_segments item, mpit.revision, msiv.description item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) item_type, msiv.item_type item_type_code, msiv.primary_uom_code item_primary_uom, msiv.secondary_uom_code item_secondary_uom, mck.concatenated_segments item_category, mpit.subinventory, milk.concatenated_segments locator, mpit.lot_number, mpit.lot_expiration_date, mpit.serial_num serial_number, inv_invarptp_xmlp_pkg.cf_parent_lpnformula(mpit.parent_lpn_id) parent_lpn, inv_invarptp_xmlp_pkg.cf_outermost_lpnformula(mpit.outermost_lpn_id,mpit.parent_lpn_id) outermost_lpn, -- mpit.tag_uom uom, mpit.tag_quantity quantity, mpit.tag_secondary_uom secondary_uom, mpit.tag_secondary_quantity secondary_quantity, (select papf.full_name from per_all_people_f papf where papf.person_id = mpit.counted_by_employee_id and sysdate between papf.effective_start_date and papf.effective_end_date ) last_counted_by, xxen_util.meaning(decode(mpit.void_flag,1,mpit.void_flag,null),'INV_YES_NO',3) void, -- mpa.system_quantity, mpa.secondary_system_qty secondary_system_quantity, -- inv_invarptp_xmlp_pkg.cf_cost_groupformula(mpit.cost_group_id)cost_group_name, -- mpit.attribute_category, mpit.attribute1, mpit.attribute2, mpit.attribute3, mpit.attribute4, mpit.attribute5, mpit.attribute6, mpit.attribute7, mpit.attribute8, mpit.attribute9, mpit.attribute10, mpit.attribute11, mpit.attribute12, mpit.attribute13, mpit.attribute14, mpit.attribute15, mpiv.physical_inventory_id, mpit.tag_id, mpit.last_update_date, mpit.last_updated_by from mtl_physical_inventories_v mpiv, mtl_physical_inventory_tags mpit, mtl_physical_adjustments mpa, mtl_parameters mp, mtl_item_locations_kfv milk, mtl_system_items_vl msiv, mtl_item_categories mic, mtl_categories_kfv mck where mpiv.physical_inventory_id = mpit.physical_inventory_id and mpiv.organization_id = mpit.organization_id and mpit.adjustment_id = mpa.adjustment_id (+) and mpiv.organization_id = mp.organization_id and mpit.organization_id = milk.organization_id (+) and mpit.locator_id = milk.inventory_location_id (+) and mpit.organization_id = msiv.organization_id (+) and mpit.inventory_item_id = msiv.inventory_item_id (+) and mpit.organization_id = mic.organization_id (+) and mpit.inventory_item_id = mic.inventory_item_id (+) and :p_category_set_id = mic.category_set_id (+) and mic.category_id = mck.category_id (+) and -- from INVADPPI (Physical Inventory Tag Counts) form 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') = 'Y' and mpiv.adjustments_posted = 2 and -- Exclude Serial Controlled Items in Physical Inventories defined for Multiple Serial Numbers Requests per Tag. -- We are not handling this scenario as yet &lp_multiple_sn_clause -- not exists (select null 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 and nvl(mpa.approval_status,0) = 3 -- processed ) ) -- -- Main Query Starts Here -- select /*+ push_pred(mpit) */ null action_, null status_, null message_, null request_id_, null modified_columns_, to_date(null) timestamp_, null row_id, :p_upload_mode upload_mode, mpit.organization_code, mpit.physical_inventory_name, -- Tags mpit.tag_number, mpit.item, mpit.revision, mpit.item_description, mpit.item_type, mpit.item_category, mpit.item_primary_uom, mpit.item_secondary_uom, mpit.subinventory, mpit.locator, mpit.lot_number, mpit.lot_expiration_date, mpit.serial_number, mpit.parent_lpn, mpit.outermost_lpn, -- nvl(mpit.uom,mpit.item_primary_uom) uom, mpit.quantity, mpit.secondary_uom, mpit.secondary_quantity, mpit.last_counted_by, :p_counter_emp_name counted_by, mpit.void, -- mpit.system_quantity, mpit.secondary_system_quantity, -- mpit.cost_group_name, -- mpit.attribute_category, mpit.attribute1, mpit.attribute2, mpit.attribute3, mpit.attribute4, mpit.attribute5, mpit.attribute6, mpit.attribute7, mpit.attribute8, mpit.attribute9, mpit.attribute10, mpit.attribute11, mpit.attribute12, mpit.attribute13, mpit.attribute14, mpit.attribute15, -- ids mpit.tag_id from mpit_qry mpit where mpit.organization_code = :p_organization_code and mpit.physical_inventory_name = :p_physical_inv_name and 1=1 Y U INV_INVARPTP_XMLP_PKG A xxen_inv_upload.upload_physical_inv_tag_count US INV Physical Inventory Tag Count Upload INV Physical Inventory Tag Count Upload ================================= This upload enables the user to upload counts against the Physical Inventory Tags defined against the specified Physical Inventory. The upload supports - the update of counts against existing Tags - the generation of new tags. For clients on R12.2.14 or creation of manually entered tag numbers is supported For clients on earlier releases, to generate a new tag leave the tag number blank. The tag number will be automatically generated when the tag is created For clients on R12.2.3 or later - the upload also supports the voiding/unvoiding of existing tags as well Note: There is currently a bug in the R12.2.3+ API that will reject the creation/update of tags for items which do not require Locatiors in Subinvnetories wher the Location Control is set to 'Check Item Level'. The API is only checking the Locator control level at the subinventory level, and if is not set to 'Locators not required' will reject any tags for items where no locator is specified. For this reason, if the physical inventory being uploaded includes any subinventories with Locator Control set to 'Check Item Level', the upload will revert to using the older API. Enginatics R12 only Upload &lp_multiple_sn_clause 1=1 :p_category_set_id :p_conc_request_id :p_counter_emp_name :p_item_flexdata :p_item_hi :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_organization_code :p_physical :p_physical_inv_name :p_range :p_range_flex :p_range_sql :p_sort_id :p_struct_num :p_subinventory :p_tag_hi :p_tag_lo :p_upload_mode :p_wms_installed 1 -30 :p_category_set_id Number select mcsv.category_set_id from mtl_category_sets_vl mcsv where mcsv.category_set_name = :$flex$.category_set US Category Set Id 2 -20 &lp_multiple_sn_clause not (nvl(mpiv.serial_count_option,1) = 2 and msiv.serial_number_control_code in (2,5)) and Char select 'Y' from dba_tab_columns where owner = 'INV' and table_name = 'MTL_PHYSICAL_INVENTORIES' and column_name = 'SERIAL_COUNT_OPTION' US Multiple Serial Count Option 3 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV custom Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, 'Create new tags' description from dual union all select xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_update) value, 'Update existing tags' description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, 'Update existing tags and allow Creation of new tags' description from dual U Y US Upload Mode 4 20 :p_organization_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 5 30 :p_physical_inv_name LOV INV Physical Inventory 0DECEFFEC76FF389E0630100007F259E Y select mpi.physical_inventory_name value, mpi.description description from mtl_physical_inventories mpi, mtl_parameters mp where mpi.organization_id=mp.organization_id and (mp.organization_code = :$flex$.organization_code or (:$flex$.organization_code is null and mp.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID')) ) order by value Y US Physical Inventory 6 40 :p_counter_emp_name LOV PER Employee 8E2FF36EDF0779D2E0530100007F1FF2 Y Y select ppx.full_name value, (select fu.user_name from fnd_user fu where ppx.person_id=fu.employee_id and rownum=1) description from per_people_x ppx, per_assignments_x pax where ppx.employee_number is not null and ppx.current_employee_flag='Y' and ppx.person_id=pax.person_id and pax.primary_flag='Y' and pax.assignment_type='E' order by ppx.full_name select ppx.full_name from per_people_x ppx, per_assignments_x pax where ppx.person_id in (select fu.employee_id from fnd_user fu where fu.user_id=fnd_global.user_id) and ppx.employee_number is not null and ppx.current_employee_flag='Y' and ppx.person_id=pax.person_id and pax.primary_flag='Y' and pax.assignment_type='E' and rownum=1 Y US Counted By 7 50 1=1 mpit.subinventory=:p_subinventory LOV INV Subinventory 8E2FF36EDF2A79D2E0530100007F1FF2 Y select msi.secondary_inventory_name value, msi.description||' ('||mp.organization_code||')' description from mtl_parameters mp, mtl_secondary_inventories msi where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msi.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 msi.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or xxen_util.contains(:$flex$.organization_code,mp.organization_id)='Y' ) and mp.organization_id=msi.organization_id order by mp.organization_code, msi.secondary_inventory_name US Subinventory 8 60 1=1 :p_category_set is not null LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name select category_set_name from mtl_default_sets_view where functional_area_id = 1 Y US Category Set 9 70 1=1 mpit.item_category >= :p_category_from LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US Category From 10 80 1=1 mpit.item_category <= :p_category_to LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US Category To 11 90 1=1 mpit.item = :p_item 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 US Item 12 100 1=1 mpit.item >= :p_item_from 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 US Item From 13 110 1=1 mpit.item <= :p_item_to 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 US Item To 14 120 1=1 mpit.item_type_code=xxen_util.lookup_code(:p_item_type,'ITEM_TYPE',3) LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US Item Type 15 130 1=1 mpit.locator = :p_locator 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 US Locator 16 140 1=1 mpit.locator >= :p_locator_from 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 US Locator From 17 150 1=1 mpit.locator <= :p_locator_to 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 US Locator To 18 160 1=1 mpit.tag_number >= :p_tag_num_from 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 mpi.physical_inventory_name = :$flex$.physical_inventory order by value US Tag Number From 19 170 1=1 mpit.tag_number <= :p_tag_num_to 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 mpi.physical_inventory_name = :$flex$.physical_inventory order by value US Tag Number To 20 180 1=1 mpit.void is not null LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y US Void Status 21 1=1 mpit.void is null N US Void Status :$flex$.category_set Category Set Category From :$flex$.category_set Category Set Category Set Id :$flex$.category_set Category Set Category To :$flex$.organization_code Organization Code Category Set :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Item From :$flex$.organization_code Organization Code Item To :$flex$.organization_code Organization Code Locator :$flex$.organization_code Organization Code Locator From :$flex$.organization_code Organization Code Locator To :$flex$.organization_code Organization Code Physical Inventory :$flex$.organization_code Organization Code Subinventory :$flex$.organization_code Organization Code Tag Number From :$flex$.organization_code Organization Code Tag Number To :$flex$.physical_inventory Physical Inventory Tag Number From :$flex$.physical_inventory Physical Inventory Tag Number To D9C9F7841C08ACC2402A9F8DA6ADF647 Default SYSADMIN 25 COUNTED_BY 4 ITEM 8 ITEM_CATEGORY 6 ITEM_DESCRIPTION 19 ITEM_PRIMARY_UOM 21 ITEM_SECONDARY_UOM 7 ITEM_TYPE 18 LAST_COUNTED_BY 10 LOCATOR 23 LOT_EXPIRATION_DATE 11 LOT_NUMBER 1 ORGANIZATION_CODE 2 PHYSICAL_INVENTORY_NAME 14 QUANTITY 5 REVISION 16 SECONDARY_QUANTITY 22 SECONDARY_SYSTEM_QUANTITY 15 SECONDARY_UOM 12 SERIAL_NUMBER 9 SUBINVENTORY 20 SYSTEM_QUANTITY 24 TAG_ID 3 TAG_NUMBER 13 UOM 17 VOID S Site D9C9F7841C08ACC2402A9F8DA6ADF647 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 TIMESTAMP_ Date date Y 7 ROW_ID Char varchar2 Y 8 UPLOAD_MODE Char varchar2 :$flex$.upload_mode Y 9 ORGANIZATION_CODE LOV custom varchar2 Y select mp.organization_code value, null description from mtl_parameters mp where mp.organization_code = nvl(:$flex$.organization_code,mp.organization_code) and exists ( select null from mtl_physical_inventories mpi where mpi.organization_id=mp.organization_id and mpi.physical_inventory_name = nvl(:$flex$.physical_inventory,mpi.physical_inventory_name) ) order by value :$flex$.organization_code Y Y 10 PHYSICAL_INVENTORY_NAME LOV custom varchar2 Y select mpi.physical_inventory_name value, mpi.description description from mtl_physical_inventories mpi, mtl_parameters mp where mpi.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and mpi.physical_inventory_name = nvl(:$flex$.physical_inventory,mpi.physical_inventory_name) order by value :$flex$.physical_inventory Y Y 11 TAG_NUMBER Char varchar2 Leave blank when creating a new Tag. The Tag Number will be automatically generated Y 12 ITEM LOV custom varchar2 Y Y select msiv.concatenated_segments value, msiv.description description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and msiv.stock_enabled_flag = 'Y' and ( nvl(mp.wms_enabled_flag,'N') = 'N' or nvl((select fpi.status from fnd_product_installations fpi where fpi.application_id = 385),'N') != 'I' or msiv.container_item_flag = 'Y' ) order by msiv.concatenated_segments Y 13 REVISION LOV custom varchar2 Y select mirav.revision value, null description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_item_revisions_all_v mirav where mp.organization_id = msiv.organization_id and msiv.organization_id = mirav.organization_id and msiv.inventory_item_id = mirav.inventory_item_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item and msiv.revision_qty_control_code = 2 order by mirav.revision select mirav.revision from mtl_parameters mp, mtl_system_items_vl msiv, mtl_item_revisions_all_v mirav where mp.organization_id = msiv.organization_id and msiv.organization_id = mirav.organization_id and msiv.inventory_item_id = mirav.inventory_item_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item and msiv.revision_qty_control_code = 2 14 ITEM_DESCRIPTION Char varchar2 select msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item 15 ITEM_TYPE Char varchar2 select xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item 16 ITEM_CATEGORY Char varchar2 select mck.concatenated_segments from mtl_parameters mp, mtl_system_items_vl msiv, mtl_item_categories mic, mtl_categories_kfv mck where mp.organization_code = :$column$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item and mic.organization_id = msiv.organization_id and mic.inventory_item_id = msiv.inventory_item_id and mic.category_set_id = :$flex$.category_set_id and mck.category_id = mic.category_id 17 ITEM_PRIMARY_UOM Char varchar2 select msiv.primary_uom_code from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item 18 ITEM_SECONDARY_UOM Char varchar2 select msiv.secondary_uom_code from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item 19 SUBINVENTORY LOV custom varchar2 Y select mpsv.subinventory value, mpsv.description description from mtl_physical_subinventories_v mpsv, mtl_parameters mp, mtl_physical_inventories mpi where mpsv.organization_id = mp.organization_id and mpsv.organization_id = mpi.organization_id and mpsv.physical_inventory_id = mpi.physical_inventory_id and mp.organization_code = :$column$.organization_code and mpi.physical_inventory_name = :$column$.physical_inventory_name and (select inv_material_status_grp.sub_valid_for_item(mpsv.organization_id,msiv.inventory_item_id,mpsv.subinventory) from mtl_system_items_vl msiv where msiv.organization_id = mpsv.organization_id and msiv.concatenated_segments = :$column$.item ) ='Y' and inv_material_status_grp.is_status_applicable(null,null,8,null,null,mpsv.organization_id,null,mpsv.subinventory,null,null,null,'Z') = 'Y' order by mpsv.subinventory Y 20 LOCATOR LOV custom varchar2 Y select milk.concatenated_segments value, milk.description description from mtl_item_locations_kfv milk, mtl_secondary_inventories msi, mtl_parameters mp, mtl_system_items_vl msiv where milk.organization_id=mp.organization_id and milk.organization_id=msi.organization_id and milk.subinventory_code=msi.secondary_inventory_name and milk.organization_id = msiv.organization_id and msiv.concatenated_segments = :$column$.item and mp.organization_code = :$column$.organization_code and milk.subinventory_code = :$column$.subinventory and nvl(milk.disable_date,sysdate) >= trunc(sysdate) and (mp.stock_locator_control_code in (2,3) or (mp.stock_locator_control_code = 4 and (msi.locator_type in (2,3) or (msi.locator_type = 5 and msiv.location_control_code in (2,3)) ) ) ) order by milk.concatenated_segments 21 LOT_NUMBER LOV custom varchar2 Y select mlnav.lot_number value, mlnav.expiration_date description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_lot_numbers_all_v mlnav where mp.organization_id = msiv.organization_id and msiv.organization_id = mlnav.organization_id and msiv.inventory_item_id = mlnav.inventory_item_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item and inv_material_status_grp.is_status_applicable(null,null,8,null,null,mlnav.organization_id,mlnav.inventory_item_id,null,null,mlnav.lot_number,null,'O') = 'Y' order by mlnav.lot_number 22 LOT_EXPIRATION_DATE LOV custom date Y select mlnav.expiration_date value, mlnav.lot_number description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_lot_numbers_all_v mlnav where mp.organization_id = msiv.organization_id and msiv.organization_id = mlnav.organization_id and msiv.inventory_item_id = mlnav.inventory_item_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item and mlnav.lot_number = :$column$.lot_number order by mlnav.expiration_date select mlnav.expiration_date from mtl_parameters mp, mtl_system_items_vl msiv, mtl_lot_numbers_all_v mlnav where mp.organization_id = msiv.organization_id and msiv.organization_id = mlnav.organization_id and msiv.inventory_item_id = mlnav.inventory_item_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item and mlnav.lot_number = :$column$.lot_number 23 SERIAL_NUMBER LOV custom varchar2 Y select distinct msn.serial_number value, null description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_serial_numbers msn where mp.organization_id = msiv.organization_id and msiv.organization_id = msn.current_organization_id and msiv.inventory_item_id = msn.inventory_item_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item and inv_material_status_grp.is_status_applicable(null,null,8,null,null,msn.current_organization_id,msn.inventory_item_id,null,null,null,msn.serial_number,'S') = 'Y' order by msn.serial_number 24 PARENT_LPN LOV custom varchar2 Y select wlpn.license_plate_number value, null description from mtl_parameters mp, wms_license_plate_numbers wlpn where mp.organization_code = :$column$.organization_code and wlpn.organization_id = mp.organization_id and wlpn.subinventory_code = :$column$.subinventory and (:$column$.locator is null or wlpn.locator_id = (select milk.inventory_location_id from mtl_item_locations_kfv milk where milk.organization_id = mp.organization_id and milk.subinventory_code = :$column$.subinventory and milk.concatenated_segments = :$column$.locator and nvl(milk.disable_date,sysdate) >= trunc(sysdate) ) ) and nvl(mp.wms_enabled_flag,'N') = 'Y' and nvl((select fpi.status from fnd_product_installations fpi where fpi.application_id = 385),'N') = 'I' order by wlpn.license_plate_number 25 OUTERMOST_LPN Char varchar2 26 UOM LOV custom varchar2 Y select miuv.uom_code value, miuv.unit_of_measure description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_item_uoms_view miuv where mp.organization_id = msiv.organization_id and msiv.organization_id = miuv.organization_id and msiv.inventory_item_id = miuv.inventory_item_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item order by miuv.uom_code select msiv.primary_uom_code from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_id = msiv.organization_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item Y 27 QUANTITY Number number Y 28 SECONDARY_UOM LOV custom varchar2 Y select miuv.uom_code value, miuv.unit_of_measure description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_item_uoms_view miuv where mp.organization_id = msiv.organization_id and msiv.organization_id = miuv.organization_id and msiv.inventory_item_id = miuv.inventory_item_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item order by miuv.uom_code select msiv.secondary_uom_code from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_id = msiv.organization_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item 29 SECONDARY_QUANTITY Number number 30 LAST_COUNTED_BY Char varchar2 31 COUNTED_BY LOV varchar2 PER Employee 8E2FF36EDF0779D2E0530100007F1FF2 Y Y select ppx.full_name value, (select fu.user_name from fnd_user fu where ppx.person_id=fu.employee_id and rownum=1) description from per_people_x ppx, per_assignments_x pax where ppx.employee_number is not null and ppx.current_employee_flag='Y' and ppx.person_id=pax.person_id and pax.primary_flag='Y' and pax.assignment_type='E' order by ppx.full_name :$flex$.Counted_By Y 32 VOID LOV custom varchar2 Y select ml.meaning value, null description from mfg_lookups ml where ml.lookup_type = 'SYS_YES_NO' and ml.lookup_code = 1 and :$column$.action_ = xxen_upload.action_meaning(xxen_upload.action_update) and exists (select null from dba_objects where object_type = 'PACKAGE' and object_name = 'INV_PHY_INV_PUB') order by ml.meaning select ml.lookup_code id, ml.meaning value from mfg_lookups ml where ml.lookup_type = 'SYS_YES_NO' 33 SYSTEM_QUANTITY Number number 34 SECONDARY_SYSTEM_QUANTITY Number number 35 COST_GROUP_NAME Char varchar2 36 ATTRIBUTE_CATEGORY Char varchar2 37 ATTRIBUTE1 Char varchar2 38 ATTRIBUTE2 Char varchar2 39 ATTRIBUTE3 Char varchar2 40 ATTRIBUTE4 Char varchar2 41 ATTRIBUTE5 Char varchar2 42 ATTRIBUTE6 Char varchar2 43 ATTRIBUTE7 Char varchar2 44 ATTRIBUTE8 Char varchar2 45 ATTRIBUTE9 Char varchar2 46 ATTRIBUTE10 Char varchar2 47 ATTRIBUTE11 Char varchar2 48 ATTRIBUTE12 Char varchar2 49 ATTRIBUTE13 Char varchar2 50 ATTRIBUTE14 Char varchar2 51 ATTRIBUTE15 Char varchar2 52 TAG_ID Number number Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 request_id_ out Number REQUEST_ID_ U 5 upload_mode_ in Char UPLOAD_MODE U 6 timestamp_ in/out Date TIMESTAMP_ U 7 p_row_id in/out Char ROW_ID U 8 p_physical_inventory_name in Char PHYSICAL_INVENTORY_NAME U 9 p_physical_inventory_id in Number U 10 p_organization_code in Char ORGANIZATION_CODE U 11 p_organization_id in Number U 12 p_tag_number in Char TAG_NUMBER U 13 p_tag_id in Number TAG_ID U 14 p_item in Char ITEM U 15 p_inventory_item_id in Number U 16 p_revision in Char REVISION U 17 p_subinventory in Char SUBINVENTORY U 18 p_locator in Char LOCATOR U 19 p_locator_id in Number U 20 p_lot_number in Char LOT_NUMBER U 21 p_serial_num in Char SERIAL_NUMBER U 22 p_parent_lpn in Char PARENT_LPN U 23 p_parent_lpn_id in Number U 24 p_tag_uom in Char UOM U 25 p_count_quantity in Number QUANTITY U 26 p_tag_secondary_uom in Char SECONDARY_UOM U 27 p_tag_secondary_quantity in Number SECONDARY_QUANTITY U 28 p_counted_by_employee in Char COUNTED_BY U 29 p_counted_by_employee_id in Number U 30 p_approval_status in Number U 31 p_approved_by_employee in Char U 32 p_approved_by_employee_id in Number U 33 p_void_flag in Number VOID Order By x.tag_number, x.item, x.revision, x.subinventory, x.locator, x.lot_number, x.serial_number, x.uom, x.quantity Success SQL select /*+ ordered push_pred(mpit) */ case when xu.status_code_ = xxen_upload.status_success and mpit.tag_id is not null then xxen_upload.action_meaning(xxen_upload.action_update) else xu.action_ end action_, case when xu.status_code_ = xxen_upload.status_success and mpit.tag_id is not null then xu.status_ else xxen_upload.status_meaning(xxen_upload.status_error) end status_, case when xu.status_code_ = xxen_upload.status_success and mpit.tag_id is not null then xu.message_ else nvl(xu.message_,'The API failed to ' || xu.action_ || ' the Tag') end message_, xu.request_id_, xu.modified_columns_, xu.timestamp_, xu.row_id, xu.upload_mode, nvl2(mpit.tag_id,mpit.organization_code,xu.organization_code) organization_code, nvl2(mpit.tag_id,mpit.physical_inventory_name,xu.physical_inventory_name) physical_inventory_name, -- Tags nvl2(mpit.tag_id,mpit.tag_number,xu.tag_number) tag_number, nvl2(mpit.tag_id,mpit.item,xu.item) item, nvl2(mpit.tag_id,mpit.revision,xu.revision) revision, nvl2(mpit.tag_id,mpit.item_description,xu.item_description) item_description, nvl2(mpit.tag_id,mpit.item_type,xu.item_type) item_type, nvl2(mpit.tag_id,mpit.item_category,xu.item_category) item_category, nvl2(mpit.tag_id,mpit.item_primary_uom,xu.item_primary_uom) item_primary_uom, nvl2(mpit.tag_id,mpit.item_secondary_uom,xu.item_secondary_uom) item_secondary_uom, nvl2(mpit.tag_id,mpit.subinventory,xu.subinventory) subinventory, nvl2(mpit.tag_id,mpit.locator,xu.locator) locator, nvl2(mpit.tag_id,mpit.lot_number,xu.lot_number) lot_number, nvl2(mpit.tag_id,mpit.lot_expiration_date,xu.lot_expiration_date) lot_expiration_date, nvl2(mpit.tag_id,mpit.serial_number,xu.serial_number) serial_number, nvl2(mpit.tag_id,mpit.parent_lpn,xu.parent_lpn) parent_lpn, nvl2(mpit.tag_id,mpit.outermost_lpn,xu.outermost_lpn) outermost_lpn, -- nvl2(mpit.tag_id,mpit.uom,xu.uom) uom, nvl2(mpit.tag_id,mpit.quantity,xu.quantity) quantity, nvl2(mpit.tag_id,mpit.secondary_uom,xu.secondary_uom) secondary_uom, nvl2(mpit.tag_id,mpit.secondary_quantity,xu.secondary_quantity) secondary_quantity, nvl2(mpit.tag_id,mpit.last_counted_by,xu.last_counted_by) last_counted_by, xu.counted_by counted_by, nvl2(mpit.tag_id,mpit.void,xu.void) void, -- nvl2(mpit.tag_id,mpit.system_quantity,xu.system_quantity) system_quantity, nvl2(mpit.tag_id,mpit.secondary_system_quantity,xu.secondary_system_quantity) secondary_system_quantity, -- nvl2(mpit.tag_id,mpit.cost_group_name,xu.cost_group_name) cost_group_name, -- nvl2(mpit.tag_id,mpit.attribute_category,xu.attribute_category) attribute_category, nvl2(mpit.tag_id,mpit.attribute1,xu.attribute1) attribute1, nvl2(mpit.tag_id,mpit.attribute2,xu.attribute2) attribute2, nvl2(mpit.tag_id,mpit.attribute3,xu.attribute3) attribute3, nvl2(mpit.tag_id,mpit.attribute4,xu.attribute4) attribute4, nvl2(mpit.tag_id,mpit.attribute5,xu.attribute5) attribute5, nvl2(mpit.tag_id,mpit.attribute6,xu.attribute6) attribute6, nvl2(mpit.tag_id,mpit.attribute7,xu.attribute7) attribute7, nvl2(mpit.tag_id,mpit.attribute8,xu.attribute8) attribute8, nvl2(mpit.tag_id,mpit.attribute9,xu.attribute9) attribute9, nvl2(mpit.tag_id,mpit.attribute10,xu.attribute10) attribute10, nvl2(mpit.tag_id,mpit.attribute11,xu.attribute11) attribute11, nvl2(mpit.tag_id,mpit.attribute12,xu.attribute12) attribute12, nvl2(mpit.tag_id,mpit.attribute13,xu.attribute13) attribute13, nvl2(mpit.tag_id,mpit.attribute14,xu.attribute14) attribute14, nvl2(mpit.tag_id,mpit.attribute15,xu.attribute15) attribute15, -- ids nvl2(mpit.tag_id,mpit.tag_id,xu.tag_id) tag_id from xxen_inv_physical_inven_9270_u xu, mpit_qry mpit where decode(xu.status_code_,xxen_upload.status_success,to_number(xu.row_id),to_number(null)) = mpit.tag_id (+) and xu.timestamp_ <= mpit.last_update_date (+) Default value :$flex$.Counted_By Counted By|:p_counter_emp_name| COUNTED_BY LOV query :$column$.organization_code ORGANIZATION_CODE ITEM Default value :$column$.item ITEM ITEM_CATEGORY Default value :$column$.organization_code ORGANIZATION_CODE ITEM_CATEGORY Default value :$flex$.category_set_id Category Set Id|:p_category_set_id| ITEM_CATEGORY Default value :$column$.item ITEM ITEM_DESCRIPTION Default value :$column$.organization_code ORGANIZATION_CODE ITEM_DESCRIPTION Default value :$column$.item ITEM ITEM_PRIMARY_UOM Default value :$column$.organization_code ORGANIZATION_CODE ITEM_PRIMARY_UOM Default value :$column$.item ITEM ITEM_SECONDARY_UOM Default value :$column$.organization_code ORGANIZATION_CODE ITEM_SECONDARY_UOM Default value :$column$.item ITEM ITEM_TYPE Default value :$column$.organization_code ORGANIZATION_CODE ITEM_TYPE LOV query :$column$.item ITEM LOCATOR LOV query :$column$.organization_code ORGANIZATION_CODE LOCATOR LOV query :$column$.subinventory SUBINVENTORY LOCATOR Default value :$column$.item ITEM LOT_EXPIRATION_DATE LOV query :$column$.item ITEM LOT_EXPIRATION_DATE Default value :$column$.lot_number LOT_NUMBER LOT_EXPIRATION_DATE LOV query :$column$.lot_number LOT_NUMBER LOT_EXPIRATION_DATE Default value :$column$.organization_code ORGANIZATION_CODE LOT_EXPIRATION_DATE LOV query :$column$.organization_code ORGANIZATION_CODE LOT_EXPIRATION_DATE LOV query :$column$.item ITEM LOT_NUMBER LOV query :$column$.organization_code ORGANIZATION_CODE LOT_NUMBER LOV query :$flex$.organization_code Organization Code|:p_organization_code| ORGANIZATION_CODE Default value :$flex$.organization_code Organization Code|:p_organization_code| ORGANIZATION_CODE LOV query :$flex$.physical_inventory Physical Inventory|:p_physical_inv_name| ORGANIZATION_CODE LOV query :$column$.locator LOCATOR PARENT_LPN LOV query :$column$.organization_code ORGANIZATION_CODE PARENT_LPN LOV query :$column$.subinventory SUBINVENTORY PARENT_LPN LOV query :$column$.organization_code ORGANIZATION_CODE PHYSICAL_INVENTORY_NAME LOV query :$flex$.physical_inventory Physical Inventory|:p_physical_inv_name| PHYSICAL_INVENTORY_NAME Default value :$flex$.physical_inventory Physical Inventory|:p_physical_inv_name| PHYSICAL_INVENTORY_NAME LOV query :$column$.item ITEM REVISION Default value :$column$.item ITEM REVISION LOV query :$column$.organization_code ORGANIZATION_CODE REVISION Default value :$column$.organization_code ORGANIZATION_CODE REVISION Default value :$column$.item ITEM SECONDARY_UOM LOV query :$column$.item ITEM SECONDARY_UOM Default value :$column$.organization_code ORGANIZATION_CODE SECONDARY_UOM LOV query :$column$.organization_code ORGANIZATION_CODE SECONDARY_UOM LOV query :$column$.item ITEM SERIAL_NUMBER LOV query :$column$.organization_code ORGANIZATION_CODE SERIAL_NUMBER LOV query :$column$.item ITEM SUBINVENTORY LOV query :$column$.organization_code ORGANIZATION_CODE SUBINVENTORY LOV query :$column$.physical_inventory_name PHYSICAL_INVENTORY_NAME SUBINVENTORY LOV query :$column$.item ITEM UOM Default value :$column$.item ITEM UOM Default value :$column$.organization_code ORGANIZATION_CODE UOM LOV query :$column$.organization_code ORGANIZATION_CODE UOM Default value :$flex$.upload_mode Upload Mode|1=1| UPLOAD_MODE LOV query :$column$.action_ ACTION_ VOID