1. Tables and Views for SCM
  2. INV_REPLENISH_REQUEST

INV_REPLENISH_REQUEST

This table stores the Replenishment Request details for PAR replenishment management

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

INV_REPLENISH_REQUEST_PK

REPLENISH_REQUEST_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REPLENISH_REQUEST_ID NUMBER 18 Yes This column stores the primary key of the Replenish Request. Active
DI_REQUEST_ID NUMBER 18 This column stores the unique identifier for upload from the Desktop integration.
GROUP_ID NUMBER 18 Yes Group id of the replenish request Active
ORGANIZATION_ID NUMBER 18 This identifies the inventory organization. Active
ORGANIZATION_CODE VARCHAR2 18 Organization code of the replenishment request Active
ORGANIZATION_NAME VARCHAR2 240 Organization name of the replenishment request
INVENTORY_ITEM_ID NUMBER 18 This column stores Inventory item identifier Active
ITEM_NUMBER VARCHAR2 300 Item number of the replenishment request Active
SUBINVENTORY VARCHAR2 10 Subinventory of the replenishment request Active
SUBINVENTORY_GROUP VARCHAR2 100 Name of the Subinventory Group.
LOCATOR_ID NUMBER 18 Locator identifier of the replenishment request Active
LOCATOR_NAME VARCHAR2 255 Locator name of the replenishment request Active
OVERRIDE_REPLENISH_COUNT_TYPE VARCHAR2 30 Indicates the override replenishment count type. Values include Order PAR, On-Hand Quantity, and Order Quantity. If this field is not specified, the Replenishment Count Type specified for the item or the subinventory will be used.
QUANTITY NUMBER Requested quantity of the replenishment request Active
UOM_CODE VARCHAR2 3 Unit of measure code of the replenishment request Active
UNIT_OF_MEASURE VARCHAR2 25 Unit of measure of the replenishment request Active
NOT_PLANNED_RECORDS NUMBER Number of not planned records in the replenishment request
PROCESSING_STATUS VARCHAR2 18 This column stores the processing status. Active
ERROR_MESSAGE_CODE VARCHAR2 50 Error message code of the replenishment request Active
ERROR_MESSAGE_TEXT VARCHAR2 240 Error message text of the replenishment request Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 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_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 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_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
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. 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
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
LOAD_REQUEST_ID NUMBER 18 Load request identifier. Used for SAAS Processing Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. 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

Foreign Keys

Table Foreign Table Foreign Key Column
INV_REPLENISH_REQUEST inv_replenish_request_group GROUP_ID
inv_replenishments inv_replenish_request REPLENISH_REQUEST_ID

Indexes

Index Uniqueness Tablespace Columns Status
INV_REPLENISH_REQUEST_N1 Non Unique Default GROUP_ID
INV_REPLENISH_REQUEST_N2 Non Unique Default ORGANIZATION_ID, SUBINVENTORY, PROCESSING_STATUS
INV_REPLENISH_REQUEST_N3 Non Unique Default ORGANIZATION_NAME, SUBINVENTORY, PROCESSING_STATUS
INV_REPLENISH_REQUEST_N4 Non Unique Default DI_REQUEST_ID
INV_REPLENISH_REQUEST_PK Unique FUSION_TS_TX_IDX REPLENISH_REQUEST_ID Active