This table contains Inventory Replenishment Request Details - Data will not be available for Replenishment Requests where Processing Status (PROCESSING_STATUS_CODE) in ('ERROR','PENDING')
Module: Inventory Management
REPLENISH_REQUEST_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| REPLENISH_REQUEST_ID | NUMBER | 38 | 0 | True | This column stores the primary key of the Replenish Request. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source Record identifier | ||||
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | #2 This column stores Inventory item identifier | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
| ORGANIZATION_ID | NUMBER | 38 | 0 | #2, #3 This identifies the inventory organization. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| ORGANIZATION_CODE | VARCHAR2 | 32 | Organization code of the replenishment request | ||||
| INVENTORY_ORG_PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 | Business unit that serves as the profit center. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Inventory organization business unit identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Inventory organization legal entity identifier | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| PRIMARY_LEDGER_ID | NUMBER | 38 | 0 | Business unit primary ledger identifier | DW_LEDGER_D | LEDGER_ID | |
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | #1 Name of the accounting calendar. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | #1 Accounting period type. Examples are Weekly, Monthly, Quarterly. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| SUBINVENTORY_CODE | VARCHAR2 | 16 | #3 Subinventory of the replenishment request | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME | ||
| SUBINVENTORY_LOCATION_ID | NUMBER | 38 | 0 | This identifies the item locator | DW_WORKER_LOCATION_D | LOCATION_ID | |
| SUBINVENTORY_GROUP | VARCHAR2 | 128 | Name of the Subinventory Group. | ||||
| LOCATOR_ID | NUMBER | 38 | 0 | Locator identifier of the replenishment request | DW_INV_LOCATOR_D | INVENTORY_LOCATION_ID | |
| PROCESSING_STATUS_CODE | VARCHAR2 | 32 | This column stores the processing status. | DW_ORA_DOS_SUPPLY_REQUEST_STATUS_LKP_TL | ORA_DOS_SUPPLY_REQUEST_STATUS_CODE | ||
| OVERRIDE_REPLENISH_COUNT_TYPE_CODE | VARCHAR2 | 32 | 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. | DW_INV_DEFAULT_REPLEN_COUNT_TYPE_LKP_TL | ORA_REPLENISHMENT_COUNT_METHOD_CODE | ||
| CREATION_DATE | DATE | #1 Indicates the date and time of the creation of the row. | DW_DAY_D | CALENDAR_DATE | |||
| CREATION_TIMESTAMP | TIMESTAMP | indicates the date and time of the creation of the row. | |||||
| LAST_UPDATE_TIMESTAMP | TIMESTAMP | indicates the date and time of the last update of the row. | |||||
| NOT_PLANNED_RECORDS | NUMBER | Number of not planned records in the replenishment request | |||||
| TRANSACTION_UOM_CODE | VARCHAR2 | 16 | Unit of measure code of the replenishment request | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| TRANSACTION_QUANTITY | NUMBER | Requested quantity of the replenishment request | |||||
| PUOM_CODE | VARCHAR2 | 16 | The principal unit of measure in which the quantity of an item is managed | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| PUOM_TRANSACTION_QUANTITY | NUMBER | Requested quantity of the primary replenishment request |
# 1 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on CREATION_DATE column. #2 In these cases in addition to the inventory item id column, ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D. #3 In these cases in addition to SUBINVENTORY_CODE the ORGANIZATION_ID column should be used for join with DW_INV_SUBINVENTORY_D
Copyright © 2019, 2026, Oracle and/or its affiliates.