Power BI Connector for Oracle Fusion Cloud SCM

Build 26.0.9770

PackingUnitspackingUnitQuantities

Returns on-hand quantities of items contained in the license plate number (LPN), including item, lot, and locator details.

Columns

Name Type SupportedFinders Description
PackingUnitsPackingUnitId [KEY] Long The Id of the packing unit.
LPNId [KEY] Long The Id of the license plate number.
LicensePlateNumber String The license plate number of the packing unit.
OnhandSummaryId Long The Id of the on-hand summary.
InventoryItemId [KEY] Long The Id of the item.
ItemNumber String The number or name that identifies the item.
Quantity Decimal The quantity of the content item.
AvailableToTransact Decimal The quantity available to transact for the item in the LPN.
OrganizationId [KEY] Long The Id of the organization.
OrganizationCode String The abbreviation that identifies the organization.
PrimaryUOMCode String The abbreviation that identifies the primary unit of measure of the item.
SecondaryUOMQuantity Decimal The quantity of the item in the secondary unit of measure.
SecondaryUOMCode String The abbreviation that identifies the secondary unit of measure of the item.
StockingUOMCode String The abbreviation that identifies the unit of measure in which the item is stocked in a subinventory.
StockingUOMQuantity Decimal The quantity of the item in its stocking unit of measure.
LotControlCode Decimal The code that identifies whether the item is lot-controlled. The lookup type EGP_LOT_CONTROL_CODE_TYPE defines the accepted values.
SerialNumberControlCode Decimal The code that identifies whether the item is serial-controlled. The lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE defines the accepted values.
RevisionControlCode Decimal The abbreviation that identifies the revision control of the item.
Revision [KEY] String The revision of the content item.
SubinventoryCode String The abbreviation that identifies the subinventory.
LotNumber [KEY] String The lot or batch number of the item.
LotGrade String The abbreviation that identifies the grade associated with the lot of the item.
LocatorId Long The Id of the item locator for the packing unit.
LocatorName String The name of the locator.
ProjectId [KEY] Long The Id of the project.
ProjectNumber String The number that identifies the project.
TaskId [KEY] Long The Id of the task.
TaskNumber String The number that identifies the task.
OwningType String The abbreviation that identifies the type of owner of the financial liability for consigned inventory.
OwningTypeName String The type of owner of the financial liability for consigned inventory.
OwningEntityId Long The Id of the owning party that is financially responsible for consigned inventory.
OwningEntityName String The owning party that is financially responsible for consigned inventory.
CountryOfOriginCode [KEY] String The abbreviation that identifies the country of origin.
CountryOfOriginName String The name of the country of origin.
BusinessUnitId Long The Id of the business unit.
OnhandSummaryKey String The key that identifies the on-hand summary.
ObjectVersionNumber Int The number that identifies the object version.
BindCOO String FindByCycleCount, findByPhysicalInventory The finder attribute representing the abbreviation that identifies the country of origin.
BindCountedFlag String FindByCycleCount, findByPhysicalInventory Specifies whether the packing units are counted or uncounted.
BindCycleCountHeaderId Long FindByCycleCount The Id of the cycle count.
BindItemId Long FindByCycleCount, findByPhysicalInventory The Id of the item.
BindLocatorId Long FindByCycleCount, findByPhysicalInventory The Id of the inventory locator.
BindLotNumber String FindByCycleCount The number that identifies a lot associated with one or more items.
BindOrganizationId Long FindUnassignedOuterMostLPNs The finder attribute representing the Id of the organization.
BindOrgId Long FindByCycleCount, findByPhysicalInventory The Id of the organization.
BindOwningEntityId Long FindByCycleCount, findByPhysicalInventory The Id of the owning entity.
BindPhysicalInventoryId Long FindByPhysicalInventory The Id of the physical inventory.
BindProjectId Long FindByCycleCount, findByPhysicalInventory The Id of the project.
BindRevision String FindByCycleCount, findByPhysicalInventory The revision of the item.
BindSubinventory String FindByCycleCount, findByPhysicalInventory The name of the subinventory.
BindTaskId Long FindByCycleCount, findByPhysicalInventory The Id of the task.
Finder String The name of the finder method used to search and filter records.
LineStatusCodeValue String FindByShipmentAndLineAttributes The abbreviation that identifies the status code of the shipment line.
PackingUnitId Long PrimaryKey The Id of the packing unit.
PPackingUnit String FindAllLevelsByPackingUnit The finder attribute representing the Id of the packing unit.
ShipmentIdValue Long FindByShipmentAndLineAttributes The Id of the shipment to which the packing unit is assigned.
SourceOrderIdValue Long FindByShipmentAndLineAttributes The Id of the source order header.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770