ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 951C664B2D8C472A97C7C64BE03AB439Y select mp.organization_code, milk.subinventory_code subinventory, milk.concatenated_segments locator, milk.description locator_description, mmsv.status_code locator_status, pjm_project.all_proj_idtonum(mil.project_id) project, pjm_project.all_task_idtonum(mil.task_id) task, msiv.concatenated_segments item, msiv.description item_description, moqd.revision, moqd.lot_number, mln.expiration_date lot_expiration_date, wlpn.license_plate_number lpn, xxen_util.yes(case when msiv.serial_number_control_code in (2,5) then 'Y' end) serial_controlled, msiv.primary_uom_code uom, &system_quantity to_number(null) count_quantity, null counted_by, null count_comments from mtl_parameters mp, mtl_secondary_inventories msi, mtl_item_locations_kfv milk, mtl_material_statuses_vl mmsv, mtl_item_locations mil, mtl_onhand_quantities_detail moqd, mtl_system_items_vl msiv, mtl_lot_numbers mln, wms_license_plate_numbers wlpn where 1=1 and mp.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 mp.organization_id=msi.organization_id and msi.quantity_tracked=1 and nvl(msi.disable_date,sysdate)>=sysdate and msi.organization_id=milk.organization_id and msi.secondary_inventory_name=milk.subinventory_code and nvl(milk.physical_location_id,milk.inventory_location_id)=milk.inventory_location_id and nvl(milk.disable_date,sysdate)>=sysdate and milk.status_id=mmsv.status_id(+) and milk.organization_id=mil.organization_id(+) and milk.inventory_location_id=nvl(mil.physical_location_id(+),mil.inventory_location_id(+)) and mil.organization_id=moqd.organization_id(+) and mil.inventory_location_id=moqd.locator_id(+) and moqd.organization_id=msiv.organization_id(+) and moqd.inventory_item_id=msiv.inventory_item_id(+) and moqd.organization_id=mln.organization_id(+) and moqd.inventory_item_id=mln.inventory_item_id(+) and moqd.lot_number=mln.lot_number(+) and moqd.lpn_id=wlpn.lpn_id(+) group by mp.organization_code, milk.subinventory_code, milk.concatenated_segments, milk.description, mmsv.status_code, mil.project_id, mil.task_id, msiv.concatenated_segments, msiv.description, moqd.revision, moqd.lot_number, mln.expiration_date, wlpn.license_plate_number, msiv.serial_number_control_code, msiv.primary_uom_code order by mp.organization_code, milk.subinventory_code, milk.concatenated_segments, msiv.concatenated_segments, moqd.revision, moqd.lot_number, wlpn.license_plate_number New count sheet by active stock locator #,##0.00 US INV Physical Inventory Locator Count Sheet Count sheet listing every active stock locator of the quantity tracked subinventories, as an alternative to printed physical inventory tags. One row per item, revision, lot and LPN on hand in the locator. A locator without on hand stock is listed once with a blank item, so counters can record stock found in locations the system considers empty. On hand held in project and task logical locators is shown against its physical locator, with the project and task. System Quantity is the live on hand at run time, not the physical inventory snapshot. Leave Show System Quantity empty for a blind count. Count Quantity, Counted By and Count Comments are blank for entry. Counts can be loaded with INV Physical Inventory Tag Count Upload with a blank tag number, which requires a physical inventory allowing dynamic tags. Enginatics &system_quantity 1=1 1 10 1=1 mp.organization_code=: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 2 20 1=1 msi.organization_id in (select mpi.organization_id from mtl_physical_inventories mpi where mpi.physical_inventory_name=:physical_inventory and (mpi.all_subinventories_flag=1 or msi.secondary_inventory_name in (select mps.subinventory from mtl_physical_subinventories mps where mpi.physical_inventory_id=mps.physical_inventory_id))) 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 US Physical Inventory 3 30 1=1 msi.secondary_inventory_name=: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 4 40 1=1 milk.concatenated_segments=: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 5 50 &system_quantity sum(moqd.primary_transaction_quantity) system_quantity, 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 Show System Quantity