SSIS Components for Oracle Fusion Cloud SCM

Build 26.0.9770

PackingUnitsitemContentCounts

Returns items stored within the license plate number (LPN) in a warehouse, including content count and organization details.

Columns

Name Type SupportedFinders Description
PackingUnitsPackingUnitId [KEY] Long The value that uniquely identifies the packing unit.
ParentLPNId [KEY] Long The value that uniquely identifies the parent license plate number.
ContentCount Int The number of unique items packed in the LPN.
TotalCount Int The total number of items in the LPN.
OrganizationId [KEY] Long The value that uniquely identifies the organization.
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 value that uniquely identifies the cycle count.
BindItemId Long FindByCycleCount, findByPhysicalInventory The value that uniquely identifies the item.
BindLocatorId Long FindByCycleCount, findByPhysicalInventory The value that uniquely identifies 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 value that uniquely identifies the organization.
BindOrgId Long FindByCycleCount, findByPhysicalInventory The value that uniquely identifies the organization.
BindOwningEntityId Long FindByCycleCount, findByPhysicalInventory The value that uniquely identifies the owning entity.
BindPhysicalInventoryId Long FindByPhysicalInventory The value that uniquely identifies the physical inventory.
BindProjectId Long FindByCycleCount, findByPhysicalInventory The value that uniquely identifies the project.
BindRevision String FindByCycleCount, findByPhysicalInventory The revision of the item.
BindSubinventory String FindByCycleCount, findByPhysicalInventory The value that uniquely identifies the subinventory.
BindTaskId Long FindByCycleCount, findByPhysicalInventory The value that uniquely identifies 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 value that uniquely identifies the packing unit.
PPackingUnit String FindAllLevelsByPackingUnit The finder attribute representing the value that uniquely identifies the packing unit.
ShipmentIdValue Long FindByShipmentAndLineAttributes The value that uniquely identifies the shipment to which the packing unit is assigned.
SourceOrderIdValue Long FindByShipmentAndLineAttributes The value that uniquely identifies the source order header.

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