SSIS Components for Oracle Fusion Cloud SCM

Build 26.0.9770

PackingUnitspackingUnitItems

Returns items packed within the license plate number (LPN), including item quantity, unit of measure, and locator details.

Columns

Name Type SupportedFinders Description
PackingUnitsPackingUnitId [KEY] Long Value that uniquely identifies the packing unit.
InventoryItemId [KEY] Long Value that uniquely identifies the item.
ItemNumber String Number that identifies the content item.
ItemDescription String Description of the container item.
ItemImage String Value that provides a reference to the item's image.
TotalQuantity Decimal Total quantity of the item.
LPNId [KEY] Long Value that uniquely identifies the license plate number.
OrganizationId [KEY] Long Value that uniquely identifies the organization.
TotalSecondaryQuantity Decimal Total quantity of the item in the secondary unit of measure.
PrimaryUOMCode String Abbreviation that identifies the primary unit of measure of the item.
PrimaryUOMName String Name of the primary unit of measure of the item.
SecondaryUOMCode String Abbreviation that identifies the secondary unit of measure of the item.
SecondaryUOMName String Name of the secondary unit of measure of the item.
LotControlCode Decimal Value that identifies whether the item is lot-controlled. The lookup type EGP_LOT_CONTROL_CODE_TYPE defines the accepted values.
SerialNumberControlCode Decimal Value that identifies whether the item is serial-controlled. The lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE defines the accepted values.
RevisionControlCode Decimal Abbreviation that identifies the revision control of the item.
SubinventoryCode String Code that identifies the packing unit subinventory.
LocatorId Long Value that uniquely identifies the item locator for the LPN.
LocatorName String Concatenated name of the inventory locator for the LPN.
AvailableToTransact Decimal Quantity available to transact for the item in the LPN.
OwningTypeName String Type of owner of the financial liability for consigned inventory.
ProjectCount Long Number of distinct projects associated with items in the LPN.
CountryOfOriginCount Long Number of distinct countries of origin associated with items in the LPN.
TrackingUnitOfMeasure String Unit of measure of the item.
SecondaryDefaultIndicator String Value that indicates how the conversion between primary and secondary units of measure is handled. Valid values are Default, Fixed, and No Default. The lookup type EGP_DEFAULTING defines the accepted values.
BindCOO String FindByCycleCount, findByPhysicalInventory The finder attribute which represents the abbreviation that identifies the country of origin.
BindCountedFlag String FindByCycleCount, findByPhysicalInventory Value that indicates whether the packing units are counted or uncounted.
BindCycleCountHeaderId Long FindByCycleCount Value that uniquely identifies the cycle count.
BindItemId Long FindByCycleCount, findByPhysicalInventory Value that uniquely identifies the item.
BindLocatorId Long FindByCycleCount, findByPhysicalInventory Value that uniquely identifies the inventory locator.
BindLotNumber String FindByCycleCount Number that identifies a lot associated with one or more items.
BindOrganizationId Long FindUnassignedOuterMostLPNs The finder attribute which represents the value that uniquely identifies the organization.
BindOrgId Long FindByCycleCount, findByPhysicalInventory Value that uniquely identifies the organization.
BindOwningEntityId Long FindByCycleCount, findByPhysicalInventory Value that uniquely identifies the owning entity.
BindPhysicalInventoryId Long FindByPhysicalInventory Value that uniquely identifies the physical inventory.
BindProjectId Long FindByCycleCount, findByPhysicalInventory Value that uniquely identifies the project.
BindRevision String FindByCycleCount, findByPhysicalInventory Revision of the item.
BindSubinventory String FindByCycleCount, findByPhysicalInventory Value that uniquely identifies the subinventory.
BindTaskId Long FindByCycleCount, findByPhysicalInventory Value that uniquely identifies the task.
Finder String The name of the finder method used to search and filter records.
LineStatusCodeValue String FindByShipmentAndLineAttributes Abbreviation that identifies the status code of the shipment line.
PackingUnitId Long PrimaryKey Value that uniquely identifies the packing unit.
PPackingUnit String FindAllLevelsByPackingUnit The finder attribute which represents the value that uniquely identifies the packing unit.
ShipmentIdValue Long FindByShipmentAndLineAttributes Value that uniquely identifies the shipment to which the packing unit is assigned.
SourceOrderIdValue Long FindByShipmentAndLineAttributes Value that uniquely identifies the source order header.

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