InventoryOrganizationsinvOrgParameters
InventoryOrganizationsinvOrgParameters
Columns
| Name | Type | Description |
| InventoryOrganizationsOrganizationId [KEY] | Long | InventoryOrganizationsOrganizationId of InventoryOrganizationsinvOrgParameters |
| OrganizationId [KEY] | Long | The value that uniquely identifies the organization. It is a primary key that the application generates when it creates an organization. This attribute is required. |
| Timezone | String | The time zone that the organization uses. |
| MasterOrganizationId | Long | The value that identifies the parent organization or the master organization. This attribute is required. |
| ScheduleId | Long | The value that uniquely identifies the work day calendar for the organization. This attribute is required. |
| DefaultPickingRuleId | Long | The value that identifies the default picking rule to use when selecting material. |
| DefaultLocatorOrderValue | Double | The default picking order assigned to each locator when creating the work order. |
| DefaultSubinventoryOrderValue | Double | The default picking order assigned to each subinventory when creating the work order. |
| NegativeInvReceiptFlag | Bool | Contains one of the following values: true or false. If true, then the organization allows negative balances in inventory. If false, then the organization doesn'tallow negative balances in inventory. The default value is true. |
| StockLocatorControl | String | The default locator control for subinventories, such as predefined, dynamic, or none. |
| SourceType | String | The source type to use when replenishing an item. |
| SourceOrganizationId | Long | The value that uniquely identifies the replenishment organization if the source type is Organization. |
| SourceOrganizationCode | String | The short code of the replenishment organization if the source type is Organization. |
| SourceOrganizationName | String | The name of the replenishment organization if the source type is Organization. |
| SourceSubinventory | String | The value of the replenishment sub inventory if the source type is Organization. |
| SerialNumberType | String | The control level to use that makes sure each serial number is unique when creating the serial number. |
| AutoSerialAlphaPrefix | String | The alphanumeric text to add as a prefix to the serial number when creating the serial number. |
| StartAutoSerialNumber | String | The smallest number to use as the serial number when creating the serial number. |
| AutoLotAlphaPrefix | String | The alphanumeric text to add as a prefix to the lot number when creating the lot number. |
| LotNumberUniqueness | String | The control level to use that makes sure each lot number is unique when creating the lot number. |
| LotNumberGeneration | String | The control level to use when creating each lot number for the organization. |
| LotNumberZeroPaddingFlag | Bool | Contains one of the following values: true or false. If true, then pad the lot number with zeros. If false, then do not pad the lot number with zeros. The default value is false. |
| LotNumberLength | Int | The value of the total length of the lot number. |
| StartingRevision | String | The starting revision to use for the new item, by default. |
| PackingUnitPrefix | String | The prefix to add to the string when creating the packing unit string. |
| PackingUnitSuffix | String | The suffix to add to the string when creating the packing unit string. |
| PackingUnitStartingNumber | Double | The smallest number to use as the packing unit number when creating the packing unit. |
| PackingUnitTotalLength | Double | The value of the total length of the packing unit string. |
| GS1128Flag | Bool | Contains one of the following values: true or false. If true, then enable GS1-128. If false, then do not enable GS1-128. The default value is false. If you enable GS1-128, then the work order uses the international barcode standard. This standard uses the Code 128 barcode specification to identify data and data formats. |
| SerialNumberGeneration | String | The control level to use when creating each serial number for the organization. |
| PickConfirmationRequiredFlag | Bool | Contains one of the following values: true or false. If true, then inventory management requires that you manually confirm each pick. If false, then inventory management doesn'trequire you to manually confirm each pick. The default value is false. |
| OverpickTransferOrdersFlag | Bool | Contains one of the following values: true or false. If true, then inventory management allows you to overpick the movement request. If false, then inventory management doesn'tallow you to overpick the movement request. The default value is false. |
| DistributedOrganizationFlag | Bool | Contains one of the following values: true or false. If true, then use the organization to provide logistics services, such as warehousing or shipping. If false, then do not use the organization to provide logistics services. The default value is false. |
| AllowDifferentLotStatus | Double | Determines whether or not the lot status can change when transferring material that the lot controls. |
| ChildLotControlPrefix | String | The prefix to add to the child lot number when creating the child lot number. |
| ChildLotControlTotalLength | Double | The value of the total length of the child lot number. |
| ChildLotControlFormatValidationFlag | Bool | Contains one of the following values: true or false. If true, then validate the format of the lot number. If false, then do not validate this format. The default value is false. |
| ChildLotControlZeroPaddingFlag | Bool | Contains one of the following values: true or false. If true, then pad the child lot number with zeros. If false, then do not pad the child lot number with zeros. The default value is false. |
| CopyLotAttributeFlag | Bool | Contains one of the following values: true or false. If true, then the child lot inherits attributes from the parent. If false, then the child lot doesn'tinherit attributes from the parent. The default value is false. |
| AutomaticallyCreateLotUOMConversion | Double | Determines whether or not to convert the unit of measure that the lot references. |
| ParentChildGeneration | String | The control level to use when creating each child lot number for the organization. |
| AutomaticallyDeleteAllocationsFlag | Bool | Contains one of the following values: true or false. If true, then if the movement request cancels, then cancel the pick. If false, then if the movement request cancels, then do not cancel the pick. The default value is false. |
| EnforceLocatorAliasUniquenessFlag | Bool | This attribute isn't currently used. |
| PreFillPickedQuantityFlag | Bool | Contains one of the following values: true or false. If true, then populate each picked quantity when confirming the pick slip. If false, then do not populate each picked quantity when confirming the pick slip. The default value is false. |
| CapturePickingExceptionsFlag | Bool | Contains one of the following values: true or false. If true, then capture the exception for each deviation when picking. If false, then do not capture the exception for each deviation when picking. The default value is true. |
| PickQuantityDefaultReasonId | Long | The reason applied for picking quantity exceptions, by default. This attribute is optional. |
| AllowNegativeOnhandTransactionsFlag | Bool | Contains one of the following values: true or false. If true, then allow each transaction that occurs during the cycle count to result in a negative quantity in inventory. If false, then do not allow each transaction that occurs during the cycle count to result in a negative quantity in inventory. The default value is false. |
| UseOriginalReceiptDateFlag | Bool | Contains one of the following values: true or false. If true, then use the original receipt date for on-hand quantity during the transaction. If false, then do not use the original receipt date for on-hand quantity during the transaction. The default value is false. |
| RoundReorderQuantityFlag | Bool | Contains one of the following values: true or false. If true, then round up the reorder quantity to minimize or maximize planning. If false, then do not round up the reorder quantity to minimize or maximize planning. The default value is false. |
| PickSlipBatchSize | Int | The number of movement request lines that inventory management processes together when it allocates material. |
| ReplenishmentMovementRequestGrouping | Int | The threshold to use when grouping movement request lines so that inventory management can replenish inventory. |
| FillKillMoveOrderFlag | Bool | Contains one of the following values: true or false. If true, then allow the request line of a replenishment movement request that's only partially picked to be canceled. If false, then do not allow canceling. The default value is false. |
| ManufacturingPlantFlag | Bool | Contains one of the following values: true or false. If true, then the organization is a manufacturing plant, and it also supports warehouse operations. If false, then the organization isn't a manufacturing plant but it does support warehouse operations. The default value is false. |
| ContractManufacturingFlag | Bool | Contains one of the following values: true or false. If true, then the organization is a contract manufacturing plant, and it also supports warehouse operations. If false, then the organization isn't a contract manufacturing plant, but it does support warehouse operations. The default value is false. |
| SupplierId | Long | The value that uniquely identifies the supplier that the contract manufacturing organization references. If ContractManufacturingFlag is true, then SupplierId is required. |
| SupplierSiteId | Long | The value that uniquely identifies the supplier site that the contract manufacturing organization references. If ContractManufacturingFlag is true, then SupplierId is required. |
| MaintenanceEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the organization performs maintenance, and it also supports warehouse operations. If false, then the organization doesn'tperform maintenance, but it does support warehouse operations. The default value is false. |
| SystemSelectsSerialNumberFlag | Bool | Contains one of the following values: true or false. If true, then the application selects each serial number. If false, then the user selects each serial number. The default value is false. |
| PurchasingByRevisionFlag | Bool | Contains one of the following values: true or false. If true, then the purchase order or the requisition must include the revision when restocking. If false, then the purchase order or the requisition can include the revision as an option when restocking. The default value is false. |
| FillKillTransferOrdersFlag | Bool | Contains one of the following values: true or false. If true, then cancel the remaining quantities on transfer order lines during pick release, pick confirm, or ship confirm. If false, then do not allow this cancelation. The default value is false. |
| ItemGroupingCode | String | Specifies how the application assigns items to the organization. Definition organizations specify their attributes for every item assigned to the organization. Reference organizations specify another definition organization, which provides the definition of all attribute values for the items assigned to this reference organization. |
| ItemDefinitionOrganizationId | Long | The value that uniquely identifies the definition organization. The application uses this attribute only when the item grouping code indicates that the organization is a reference organization, which requires that the definition get all item attribute values from another organization. |
| TrackByProjectFlag | Bool | Contains one of the following values: true or false. If true, then Oracle Project Portfolio Management Cloud integration is enabled on this inventory organization and materials management transactions and manufacturing transactions can gather project details. If false, then project tracking isn't enabled on the organization. The default value is false. |
| TrackByCountryOfOriginFlag | Bool | Contains one of the following values: true or false. If true, then tracking by country of origin is enabled on this inventory organization and materials management transactions can gather these details. If false, then tracking by country of origin isn't enabled on the organization. The default value is false. |
| InternalCustomerFlag | Bool | Contains one of the following values: true or false. If true, then the organization is a destination inventory organization, and it has an associated customer and account number. If false, then the organization isn't a destination organization. The default value is false. |
| InternalCustomerName | String | InternalCustomerName of InventoryOrganizationsinvOrgParameters |
| InternalCustomerId | Long | The value that identifies the customer when the warehouse is the destination inventory organization. |
| InternalCustomerAccountNumber | String | The account number associated with the customer when the warehouse is the destination inventory organization. |
| ScheduleName | String | The name of the work day calendar for the organization. |
| UseCurrentItemCostFlag | Bool | Contains one of the following values: true or false. If true, then the warehouse will default to use the current item cost in the Create Miscellaneous Transaction task. If false, the warehouse will default to not use the current item cost. The default value is false. |
| OverpickForSpecialHandlingFlag | Bool | Contains one of the following values: true or false. If true, then the warehouse supports overpicking and staging to accommodate material movements requiring special handling. If false, the warehouse won't support special handling. The default value is false. |
| CreatedBy | String | CreatedBy of InventoryOrganizationsinvOrgParameters |
| CreationDate | Datetime | CreationDate of InventoryOrganizationsinvOrgParameters |
| LastUpdatedBy | String | LastUpdatedBy of InventoryOrganizationsinvOrgParameters |
| LastUpdateDate | Datetime | LastUpdateDate of InventoryOrganizationsinvOrgParameters |
| AcceptSubstituteItemsFlag | Bool | Contains one of the following values: true or false. If true, then the warehouse accepts substitute items in place of ordered items. If false, then the warehouse doesn't accept substitute items. The default value is false. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Status | String | Status |
| Finder | String | finder |