1. Tables and Views for SCM
  2. INV_ORG_PARAMETERS

INV_ORG_PARAMETERS

INV_ORG_PARAMETERS maintains a set of default options like locator, lot, and serial controls; item sourcing etc. for each organization defined in Oracle Inventory. Each organization's item master organization (MASTER_ORGANIZATION_ID) is maintained here. You specify which manufacturing calendar the organization will use (CALENDAR_CODE), as well as the set of exceptions to this calendar (CALENDAR_EXCEPTION_SET_ID). .NEGATIVE_INV_RECEIPT_CODE indicates whether this organization will allow negative balances in inventory. It is used in the transaction system to ensure, for example, that you do not over-issue a particular item (if you have indicated that negative balances are not allowed). For lot number and serial number auto-generation, you can specify whether you want the numbers generated from defaults defined at the organization level or the item level (LOT_NUMBER_GENERATION,SERIAL_NUMBER_GENERATION). You can also specify uniqueness constraints for lot numbers (LOT_NUMBER_UNIQUENESS) and serial numbers (SERIAL_NUMBER_TYPE).

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

INV_ORG_PARAMETERS_PK

ORGANIZATION_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
TRACK_COUNTRY_OF_ORIGIN_FLAG VARCHAR2 1 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 is not enabled on the organization. The default value is false.
FILL_KILL_TRANSFER_ORDERS_FLAG VARCHAR2 1 Determines if remaining quantities on transfer order lines will be cancelled during pick release, pick confirm and ship confirm processing. Active
ORGANIZATION_ID NUMBER 18 Yes Organization identifier Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ORGANIZATION_CODE VARCHAR2 18 Organization code Active
MASTER_ORGANIZATION_ID NUMBER 18 Item master organization identifier Active
BUSINESS_UNIT_ID NUMBER 18 Business Unit of the Organization Active
LEGAL_ENTITY_ID NUMBER 18 Legal Entity of the Organization Active
SCHEDULE_ID NUMBER 18 Calendar - Referenced from CRM Scheduler Active
DEFAULT_PICKING_RULE_ID NUMBER 18 Default picking rule code Active
DEFAULT_LOCATOR_ORDER_VALUE NUMBER Default picking order of locators Active
DEFAULT_SUBINV_ORDER_VALUE NUMBER Default picking order for sub-inventories Active
NEGATIVE_INV_RECEIPT_CODE NUMBER Indicates whether negative balances are allowed Active
STOCK_LOCATOR_CONTROL_CODE VARCHAR2 30 Stock locator control code Active
SOURCE_ORGANIZATION_ID NUMBER 18 Organization to source items from Active
SOURCE_SUBINVENTORY VARCHAR2 10 Subinventory to source items from Active
SOURCE_TYPE VARCHAR2 30 Inventory or supplier source type Active
SERIAL_NUMBER_TYPE VARCHAR2 30 Serial number uniqueness control Active
AUTO_SERIAL_ALPHA_PREFIX VARCHAR2 80 Organization-level serial number prefix Active
START_AUTO_SERIAL_NUMBER VARCHAR2 80 Organization-level starting serial number Active
AUTO_LOT_ALPHA_PREFIX VARCHAR2 80 Organization-level prefix for lot numbers Active
LOT_NUMBER_UNIQUENESS VARCHAR2 30 Lot number uniqueness control Active
LOT_NUMBER_GENERATION VARCHAR2 30 Lot number generation control Active
LOT_NUMBER_ZERO_PADDING VARCHAR2 30 Lot number padding control Active
LOT_NUMBER_LENGTH NUMBER Total lot number length Active
STARTING_REVISION VARCHAR2 18 Default starting item revision Active
LPN_PREFIX VARCHAR2 10 LPN_PREFIX Active
LPN_SUFFIX VARCHAR2 10 LPN_SUFFIX Active
LPN_STARTING_NUMBER NUMBER LPN_STARTING_NUMBER Active
TOTAL_LPN_LENGTH NUMBER TOTAL_LPN_LENGTH Active
UCC_128_SUFFIX_FLAG VARCHAR2 1 UCC_128_SUFFIX_FLAG Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Organization parameters (INV_ORG_PARAMETERS) Active
SERIAL_NUMBER_GENERATION VARCHAR2 30 Serial number generation control Active
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
MO_PICK_CONFIRM_REQUIRED NUMBER Flag indicating whether pick confirmation is required Active
OVPK_TRANSFER_ORDERS_ENABLED VARCHAR2 1 OVPK_TRANSFER_ORDERS_ENABLED Active
ALLOCATE_SERIAL_FLAG VARCHAR2 1 Indicates if allocation will happen at serial level for serial controlled items. Active
DISTRIBUTED_ORGANIZATION_FLAG VARCHAR2 1 Distributed Organization Flag Active
ALLOW_DIFFERENT_STATUS NUMBER Indicates whether a transfer / receipt transaction is allowed where the default or lot status differs from the destination lot status. Active
CHILD_LOT_ALPHA_PREFIX VARCHAR2 80 Alphanumeric prefix for child lot number. Used where Generation is Parent + Child Active
CHILD_LOT_NUMBER_LENGTH NUMBER Total length of the child lot number (including the prefix) Active
CHILD_LOT_VALIDATION_FLAG VARCHAR2 1 Indicates whether or not manually entered child lot numbers should be validated against the naming format Active
CHILD_LOT_ZERO_PADDING_FLAG VARCHAR2 1 Indicates whether the child lot name should be padded with zeros (up to the total length) Active
COPY_LOT_ATTRIBUTE_FLAG VARCHAR2 1 Indicates whether lot attributes for the child should be copied from the parent or the item master Active
CREATE_LOT_UOM_CONVERSION NUMBER Indicates whether or not lot specific conversions should be created at receipt Active
PARENT_CHILD_GENERATION_FLAG VARCHAR2 1 Indicates the sequence used for child lot name generation and the format used. Valid values are Parent and Parent + Child. Active
AUTO_DEL_ALLOC_FLAG VARCHAR2 1 Delete Allocations after Source is cancelled Active
ENFORCE_LOCATOR_ALIS_UNQ_FLAG VARCHAR2 1 Indicates whether the Locators alias should be unique or not in an organization. Active
PRE_FILL_PICKED_QTY VARCHAR2 1 Indicates if the picked quantities field will be pre-filled or not Active
CAPTURE_PICKING_EXCEPTION VARCHAR2 1 Capture Picking Exceptions Active
INVENTORY_FLAG VARCHAR2 1 Yes INVENTORY_FLAG Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
QA_SKIPPING_INSP_FLAG VARCHAR2 1 Oracle Quality skipping inspection flag Active
WCS_ENABLED VARCHAR2 1 Warehouse Control System Enabled Active
EAM_ENABLED_FLAG VARCHAR2 1 Organization is EAM enabled Active
WMS_ENABLED_FLAG VARCHAR2 1 WMS (Warehouse Management System) Organization Active
MAINT_ORGANIZATION_ID NUMBER 18 Maintenance Organization Identifier Active
TRADING_PARTNER_ORG_FLAG VARCHAR2 1 Indicates if the organization is a trading partner to any original equipment manufacturer Active
PREGEN_PUTAWAY_TASKS_FLAG NUMBER PREGEN_PUTAWAY_TASKS_FLAG Active
REGENERATION_INTERVAL NUMBER REGENERATION_INTERVAL Active
TIMEZONE_ID NUMBER Identifier for Timezone Active
DEFAULT_WMS_PICKING_RULE_ID NUMBER 18 DEFAULT_WMS_PICKING_RULE_ID Active
DEFAULT_PUT_AWAY_RULE_ID NUMBER 18 Default put away rule - used by WMS only Active
DEFAULT_CARTON_RULE_ID NUMBER 18 Default cartonization rule for this organization - used by WMS only Active
DEFAULT_CYC_COUNT_HEADER_ID NUMBER 18 Default cycle count header for this organization - used by WMS only Active
CROSSDOCK_FLAG NUMBER Flag indicates whether crossdocking occurs by default for this organization - used by WMS only Active
CARTONIZATION_FLAG NUMBER Flag indicates whether cartonization occurs by default in this organization - used for WMS only Active
PROJECT_REFERENCE_ENABLED NUMBER Project Reference enabled flag that indicates whether project references are allowed in the organization or not Active
PROJECT_CONTROL_LEVEL NUMBER Project Control Level that specifies whether project references are being tracked at the project or task level Active
PM_COST_COLLECTION_ENABLED NUMBER Project Manufacturing Cost Collection Enabled flag that indicates whether costs will be collected for project references within the organization or not Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
PICK_QTY_DEFAULT_REASON_ID NUMBER 18 Reason for Capture Picking Exception Active
FIFO_ORIG_RCPT_DATE_FLAG VARCHAR2 1 FIFO_ORIG_RCPT_DATE_FLAG Active
ALLOW_NEG_ONHAND_CC_TXNS VARCHAR2 1 Allow negative onhand quantities due to cycle count transactions Active
PURCHASING_BY_REVISION VARCHAR2 1 Determines if a revision is specified when a purchase order requisition is created for revision controlled items. Active
ROUND_REORDER_QTY_FLAG VARCHAR2 1 Provides the min-max reporting process with rounding options for reorder quantity. Active
REPLNSH_MOVE_ORDER_GROUPING NUMBER 5 Enables you to create only one move order header per request, with each item having its own item. Active
FILL_KILL_MOVE_ORDER_FLAG VARCHAR2 1 Determines if user can close a partially allocated and transacted replenishment move order line. Active
PICK_SLIP_BATCH_SIZE NUMBER 10 Determines the number of move order lines allocated during one commit cycle for replenishment move orders, and move order requisitions. Active
STANDARD_PACK_ENABLED NUMBER 5 Determines if the Organization has Standard Pack Tracking enabled. Active
AUTO_BREAKDOWN_ENABLED VARCHAR2 1 User can check this flag only if the Organization Parameter: FULL SP VISIBILITY is enabled. If the user checks this flag, Auto-breakdown transaction will happen in this organization.The user can change the value of this flag at any point. Example: If the user changes the value from YES to NO, all transactions post this change will NOT lead to auto-breakdown. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER7 NUMBER 1 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
PROFIT_CENTER_BU_ID NUMBER 18 Business unit that serves as the profit center.This may or may not be the same as the Management Business Unit.
PROFIT_CENTER_BUSINESS_UNIT_ID NUMBER 18 Business unit that serves as the profit center.This may or may not be the same as the Management Business Unit. Obsolete
MANUAL_RECEIPT_EXP_AT_DEST VARCHAR2 1 Manual receipt at expense destination flag. Allows an Inventory Organization to indicate how to process internal material transfer orders. Valid values are Y/N.
MFG_PLANT_FLAG VARCHAR2 1 It indicates whether Organization is Manufacturing plant or not.
CONTRACT_MFG_FLAG VARCHAR2 1 It indicates that the Org will be modeling as a contract manufacturer.
SUPPLIER_ID NUMBER 18 The field is mandatory if the parent field for CM indication is selected.It has no default value.
SUPPLIER_SITE_ID NUMBER 18 The field is mandatory if the parent field for CM indication is selected. It has no default value.
TIMEZONE_CODE VARCHAR2 50 Identifier for Timezone Active
INTEGRATED_SYSTEM_CODE VARCHAR2 25 Models the choice when the organization is integrated to another system. Value is optional.
ITEM_GROUPING_CODE VARCHAR2 20 Models the choice of reference organization or definition organization.
ITEM_DEFINITION_ORG_ID NUMBER 18 Indicates which organization serves as the definition for all items in this organization. If self-referential, it is a definition organization. If it points to any other organization, it is a reference organization.
GROUPING_JOB_STATUS VARCHAR2 20 Models the status of the last program job to validate or modify the item grouping behavior of this organization. Permitted values are null, SUBMITTED, FAILURE, SUCCESS.
GROUPING_JOB_ID NUMBER 18 Identifier of the last program job called to validate or modify the item grouping behavior of this organization.
INTERNAL_CUSTOMER_FLAG VARCHAR2 1 Contains True or False. True: The organization represents an internal customer and is associated to an account number and customer name. False: The organization does not represent an internal customer. The default value is false.
CUSTOMER_ACCOUNT_NUMBER VARCHAR2 30 The account number of the customer when the organization represents an internal customer.
PARTY_ID NUMBER 18 Indicates the identifier of the selected customer when the organization represents an internal customer.
USE_CUR_ITEM_COST_FLAG VARCHAR2 1 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.
SPECIAL_HNDLNG_OVRPK_FLAG VARCHAR2 1 Contains one of the following values: Y or N. If Y, then the warehouse supports overpicking and staging to accommodate material movements requiring special handling. If N, the warehouse will not support special handling. The default value is N.
FA_BOOK_TYPE_CODE VARCHAR2 30 The value that uniquely identifies the fixed asset book to be associated with the assets defined in this organization.
ALLOW_ITEM_SUBSTITUTIONS VARCHAR2 1 Contains one of the following values: true or false. If true, then the default setting to allow item substitutions is yes. If false, then the default setting to allow item substitutions is no. The default value is false.
WMS_WITH_MFG_ALM VARCHAR2 1 Contains one of the following values: true or false. If true, then the plant is integrated to WMS for manufacturing or maintenance. If false, then the plant is not integrated. The default value is false.
FILL_KILL_SALES_ORDER_FLAG VARCHAR2 1 Contains one of the following values: true or false. If true, then automatically cancel the remaining quantities on sales order backorder lines during pick release, pick confirm, or ship confirm. If false, then don't cancel. The default value is false.

Foreign Keys

Table Foreign Table Foreign Key Column
INV_ORG_PARAMETERS inv_secondary_inventories SOURCE_SUBINVENTORY, SOURCE_ORGANIZATION_ID
inv_abc_classes inv_org_parameters ORGANIZATION_ID
inv_cc_entries_interface inv_org_parameters ORGANIZATION_ID
inv_cycle_count_entries inv_org_parameters ORGANIZATION_ID
inv_strategies_b inv_org_parameters ORGANIZATION_ID
okc_k_lines_b_h inv_org_parameters SHIP_INV_ORG_ID
okc_k_lines_b_h inv_org_parameters RECV_INV_ORG_ID
inv_cycle_count_classes inv_org_parameters ORGANIZATION_ID
inv_lpn_interface inv_org_parameters ORGANIZATION_ID
inv_onhand_quantities_detail inv_org_parameters ORGANIZATION_ID
inv_supply_demand_temp inv_org_parameters ORGANIZATION_ID
inv_selection_criteria_txn inv_org_parameters FROM_ORGANIZATION_ID
inv_selection_criteria_txn inv_org_parameters TO_ORGANIZATION_ID
inv_reservations_interface inv_org_parameters ORGANIZATION_ID
inv_reservations_interface inv_org_parameters TO_ORGANIZATION_ID
inv_serial_numbers inv_org_parameters CURRENT_ORGANIZATION_ID
inv_license_plate_numbers inv_org_parameters ORGANIZATION_ID
inv_interorg_parameters inv_org_parameters FROM_ORGANIZATION_ID
inv_interorg_parameters inv_org_parameters TO_ORGANIZATION_ID
okc_k_lines_b inv_org_parameters SHIP_INV_ORG_ID
okc_k_lines_b inv_org_parameters RECV_INV_ORG_ID
inv_item_locations inv_org_parameters ORGANIZATION_ID
wsh_org_carrier_services inv_org_parameters ORGANIZATION_ID
inv_supply inv_org_parameters TO_ORGANIZATION_ID
inv_supply inv_org_parameters INTRANSIT_OWNING_ORG_ID
inv_supply inv_org_parameters MRP_TO_ORGANIZATION_ID
inv_reservations inv_org_parameters ORGANIZATION_ID
inv_generic_dispositions inv_org_parameters ORGANIZATION_ID
inv_intersub_parameters inv_org_parameters ORGANIZATION_ID
wsh_shipping_parameters inv_org_parameters ORGANIZATION_ID
inv_abc_assignment_groups inv_org_parameters ORGANIZATION_ID
inv_physical_subinventories inv_org_parameters ORGANIZATION_ID
inv_consumption_rules inv_org_parameters FROM_ORGANIZATION_ID
inv_consumption_rules inv_org_parameters TO_ORGANIZATION_ID
inv_secondary_inventories inv_org_parameters SOURCE_ORGANIZATION_ID
inv_secondary_inventories inv_org_parameters ORGANIZATION_ID
inv_lot_numbers inv_org_parameters ORGANIZATION_ID
inv_abc_compile_headers inv_org_parameters ORGANIZATION_ID
inv_transaction_flow_lines inv_org_parameters FROM_ORGANIZATION_ID
inv_onhand_quantities_cons_bkp inv_org_parameters ORGANIZATION_ID
inv_txn_request_lines inv_org_parameters TO_ORGANIZATION_ID
inv_txn_request_lines inv_org_parameters ORGANIZATION_ID
inv_item_sub_inventories inv_org_parameters SOURCE_ORGANIZATION_ID
okc_k_headers_all_b_h inv_org_parameters SHIP_INV_ORG_ID
okc_k_headers_all_b_h inv_org_parameters RECV_INV_ORG_ID
okc_k_headers_all_b_h inv_org_parameters INV_ORGANIZATION_ID
inv_physical_inventories inv_org_parameters ORGANIZATION_ID
inv_cycle_count_headers inv_org_parameters ORGANIZATION_ID
okc_k_headers_all_b inv_org_parameters SHIP_INV_ORG_ID
okc_k_headers_all_b inv_org_parameters RECV_INV_ORG_ID
okc_k_headers_all_b inv_org_parameters INV_ORGANIZATION_ID
inv_transaction_flow_headers inv_org_parameters ORGANIZATION_ID
inv_txn_request_headers inv_org_parameters ORGANIZATION_ID

Indexes

Index Uniqueness Tablespace Columns Status
INV_ORG_PARAMETERS_N1 Non Unique FUSION_TS_TX_DATA MASTER_ORGANIZATION_ID Active
INV_ORG_PARAMETERS_N2 Non Unique FUSION_TS_TX_DATA ITEM_DEFINITION_ORG_ID Active
INV_ORG_PARAMETERS_U1 Unique FUSION_TS_TX_DATA ORGANIZATION_ID Active
INV_ORG_PARAMETERS_U2 Unique FUSION_TS_TX_IDX UPPER("ORGANIZATION_CODE")