DBA Data[Home] [Help] [Dependency Information]

TABLE: MRP.MRP_AGGREGATE_RATES

Object Details
Object Name: MRP_AGGREGATE_RATES
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_AGGREGATE_RATES
Subobject Name:
Status: VALID


MRP_AGGREGATE_RATES stores the aggregation of the repetitive schedules
defined in WIP. Each row contains one aggregate rate, which may
combine one or more repetitive schedules into a single rate. For
example, if there are two rates defined in WIP, one for 10 per day
from 1-MAY to 10-MAY and another for 5 per day from 5-MAY to 15-MAY,
MRP_AGGREGATE_RATES will contain 3 rates: 10 per day from 1-MAY to 4-
MAY, 15 per day from 5-MAY to 10-MAY, and 5 per day from 11-MAY to 15-
MAY.
.
The rates are defined by FIRST_UNIT_COMPLETION_DATE and
LAST_UNIT_COMPLETION_DATE and by DAILY_RATE. PROCESSING_DAYS will be
the number of work days that the rate runs. FIRM_PLAN_STATUS_TYPE
will be set to yes (1) if all repetitive schedules that make up the
aggregate rate are firmed. Otherwise, it will be set to no (2). If
the aggregate rate is made up of several repetitive schedules, some
that are firmed and some that are not, then FIRM_PLAN_STATUS_TYPE will
be set to no (2) and the sum of the firmed repetitive schedules will
be stored in MINIMUM_FIRM_RATE.
.
The table is populated by the Snapshot and used by the Planner. The
data in MRP_AGGREGATE_RATES is derived from MRP_REPETITIVE_SCHEDULES,
which in turn is derived from WIP_REPETITIVE_SCHEDULES.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_AGGREGATE_RATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCOMPILE_DESIGNATOR
ColumnINVENTORY_ITEM_ID
ColumnFIRST_UNIT_COMPLETION_DATE
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
FIRST_UNIT_COMPLETION_DATE DATE
Yes First unit completion date
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UNIT_COMPLETION_DATE DATE
Yes Last unit completion date
FIRST_UNIT_START_DATE DATE
Yes First unit start date
LAST_UNIT_START_DATE DATE
Yes Last unit start date
PROCESSING_DAYS NUMBER
Yes Processing days
DAILY_RATE NUMBER
Yes Daily rate of production
REVISION VARCHAR2 (3)
Inventory item revision code
MINIMUM_FIRM_RATE NUMBER

Minimum firmed rate
FIRM_PLAN_STATUS_TYPE NUMBER
Yes Flag to indicate if the entire aggregate rate is firm planned
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
PROJECT_ID NUMBER (15)
Project identifier
TASK_ID NUMBER (15)
Task identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UNIT_COMPLETION_DATE
,      FIRST_UNIT_START_DATE
,      LAST_UNIT_START_DATE
,      PROCESSING_DAYS
,      DAILY_RATE
,      REVISION
,      MINIMUM_FIRM_RATE
,      FIRM_PLAN_STATUS_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      TASK_ID
FROM MRP.MRP_AGGREGATE_RATES;

Dependencies

[top of page]

MRP.MRP_AGGREGATE_RATES does not reference any database object

MRP.MRP_AGGREGATE_RATES is referenced by following:

SchemaAPPS
SynonymMRP_AGGREGATE_RATES