InventoryOrganizationsplantParameters
InventoryOrganizationsplantParameters
Columns
| Name | Type | Description |
| InventoryOrganizationsOrganizationId [KEY] | Long | InventoryOrganizationsOrganizationId of InventoryOrganizationsplantParameters |
| OrganizationId [KEY] | Long | The value that uniquely identifies the item or inventory organization. It is a primary key that the application generates when it creates an item or inventory organization. |
| ManufacturingCalendarId | Long | The value that uniquely identifies the schedule that the organization references as the manufacturing calendar. This attribute is required. |
| DefaultSupplySubinventory | String | The subinventory to use when performing a backflushing operation that pulls and assembles components, and that doesn'thave default values defined. |
| DefaultSupplyLocator | Long | The locator to use when performing a backflushing operation that pulls and assembles components, and that doesn'thave default values defined. The default supply subinventory controls whether or not the locator is required. |
| DefaultCompletionSubinventory | String | The subinventory to use to store the product upon completion if the default isn't defined. |
| DefaultCompletionLocator | Long | The locator to use to store the product upon completion if the default isn't defined. The default completion subinventory controls whether or not the locator is required. |
| StartingOperationSequence | Long | The default sequence number for the first operation in a new work definition. |
| OperationSequenceIncrement | Long | The value that increments the sequence number for each new operation added in the work definition. |
| PhantomOperationInherit | String | Determines whether to charge the components, resources, and overhead from the phantom work definition, or to get them from the operation sequence that's defined for the parent work item. |
| WorkOrderPrefix | String | The alphanumeric text to add as a prefix to the work order name when creating the work order name. |
| WorkOrderStartingNumber | Long | The starting numeric value to use in the document sequence when creating each work order number at the plant. |
| DefaultOvercompletionTolerance | Double | Percent of assemblies that you can overcomplete for each job or schedule. |
| DefaultTransactionMode | String | Specifies whether to allow inventory management to default the transaction quantity to the required quantity during a material transaction or resource transaction in the work order. |
| DefaultTransactionQuantity | String | Enables the default transaction mode. If the user chooses All Mode All Components, then inventory management defaults the resources that it uses for the operation, and the user can create a transaction that uses these resources. |
| QuantityChangeBackflush | String | Determines whether or not Oracle Inventory Management Cloud allows a change to the transaction quantity in the work order. |
| DefaultWorkOrderTravelerTemplate | String | The layout template to use when printing the work order traveler. |
| DefaultLabelTemplate | String | The layout template to use when printing labels. |
| IncludeComponentYieldFlag | Bool | Contains one of the following values: true or false. If true, then do not round each decimal quantity. If false, then round each decimal quantity. The default value is false. |
| AutoAssociateSerialNumberWorkOrderImportFlag | Bool | Contains one of the following values: true or false. If true, then create serial numbers and associate them with a job. If false, then do not create serial numbers. The default value is true. |
| BackflushLotSelection | String | Determines the lots to use when performing a backflush. Valid values include Manual, First In First Out, or First Expiration First Out. |
| StartStopCaptureLevel | String | Determines how to capture time for each serial operation that occurs when performing the work order. Valid values include Operation Serial or Item Serial. |
| PurchaseRequisitionCreationTime | String | The threshold to use when creating purchase requisitions for a work order that involves a supplier operation, and that requires outside processing. |
| MaterialReportingLevel | String | Determines the level when the dispatch list displays material reporting icons. |
| ForecastHorizon | Int | The maximum number of days that the Maintenance Forecast scheduled process calculates. The value for this attribute must be a positive integer. The default value is 30. |
| GenerateWorkOrdersHorizon | Int | The maximum number of days that the Generate Work Order scheduled process calculates. The value for this attribute must be a positive integer. The default value is 7. |
| DefaultPickSlipGroupingRule | Long | Determines the grouping rule to use as the default for the pick slip in each manufacturing work order. The application shares the set of values with the Picking Rule inventory organization parameter in the Item Sourcing Details tab of the Manage Inventory Organization Parameters page. |
| PrintPickSlipsFlag | Bool | Contains one of the following values: true or false. If true, then print the pick slips. If false, then do not print the pick slips. The default value is false. |
| IncludePullComponentsFlag | Bool | Contains one of the following values: true or false. If true, then pick components that use the supply type operation pull or assembly pull in the work order. If false, then do not pick these components. The default value is false. |
| IssuePushComponentsFlag | Bool | Contains one of the following values: true or false. If true, then push components that the application issues directly to the work order. If false, then do not push these components. The default value is false. |
| PrintLabelExternallyFlag | Bool | Contains one of the following values: true or false. If true, then call a business event that uses an application outside of Oracle Fusion applications to print the label. If false, then use an Oracle Fusion Application to print the label. The default value is false. |
| AllowDirectPurchasesForWorkOrdersFlag | Bool | Contains one of the following values: true or false. If true, then allow a work definition to access self-service procurement. If false, then do not allow this access. The default value is false. |
| EnableProcessManufacturingFlag | Bool | Contains one of the following values: true or false. If true, then the plant supports process manufacturing. If false, then the plant only supports discrete manufacturing. The default value is false. |
| DefaultWorkMethod | String | Value that determines which manufacturing method will be the default when defining the work definition. Valid values include Discrete or Process. |
| ManufacturingCalendarName | String | The name of the schedule that the organization references as the manufacturing calendar. |
| EnableIotFlag | Bool | Contains one of the following values: true or false. If true, then the plant is synchronized to Oracle Internet of Things Cloud Service. If false, then the plant isn't synchronized. The default value is false. |
| ManuallyIssueAssemblyToReworkWorkOrderFlag | Bool | Contains one of the following values: true or false. If true, then the assembly must be manually issued for rework. If false, then retain the automatic issuing behavior in the plant. The default value is false. |
| AllowNegativeIssueWithoutSerialNumberEntryFlag | Bool | Contains one of the following values: true or false. If true, then removing a part from a procured finished good will not require the user to specify the serial number of the part. If false, then removing a part from a procured finished good will require the user to specify the serial number of the part. The default value is false. |
| AllowReservationsOnWorkOrdersFlag | Bool | Contains one of the following values: true or false. If true, then the work order allows reservations on specified materials. If false, then reservations are not permitted. The default value is false. |
| MaximumSchedulingDurationInMonths | Int | The maximum allowed duration in months to use when scheduling a work order. The minimum value is 3 months and the maximum value is 48 months. The default value is 12 months. |
| CreatedBy | String | CreatedBy of InventoryOrganizationsplantParameters |
| CreationDate | Datetime | CreationDate of InventoryOrganizationsplantParameters |
| LastUpdateDate | Datetime | LastUpdateDate of InventoryOrganizationsplantParameters |
| LastUpdatedBy | String | LastUpdatedBy of InventoryOrganizationsplantParameters |
| DefaultLotNumberBehavior | String | Value that indicates the defaulting method to use to populate the lot number for the finished product. Valid values include No default and Work order number. The default value is No default. |
| RestrictLotsDuringReturnsFlag | Bool | Contains one of the following values: true or false. If true, then during returns, the choices for the lot are restricted to only those that have been transacted for the manufactured item. If false, then any lot can be selected. The default value is false. |
| DefaultUndercompletionTolerance | Double | Percent of assemblies that you can undercomplete for each job or schedule. |
| InspectionPlanType | String | Value of the default inspection plan for the maintenance facility. |
| DefaultIncludeInPlanningForBulkSupplyTypeFlag | Bool | Contains one of the following values: true or false. If true, then the default behavior is to include an operation item in planning when the operation item supply type is bulk. If false, then it's not. The default value is true. |
| DefaultIncludeInPlanningForSupplierSupplyTypeFlag | Bool | Contains one of the following values: true or false. If true, then the default behavior is to include an operation item in planning when the operation item supply type is supplier. If false, then it's not. The default value is true. |
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 |