# DW_INV_REPLENISHMENT_REQUESTS_CF

This table contains Inventory Replenishment Request Details - Data will not be available for Replenishment Requests where Processing Status (PROCESSING_STATUS_CODE) in ('ERROR','PENDING')

## Details

Module: Inventory Management

## Key Columns

REPLENISH_REQUEST_ID

## Columns

Columns
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 |  |

## Notes

# 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.