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


TABLE: MRP.MRP_RECOMMENDATIONS

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


MRP_RECOMMENDATIONS stores Oracle Master Scheduling/MRP's suggestions
for a given plan. Each purchase order, purchase requisition, purchase
order in receiving, discrete job, nonstandard job, intransit shipment,
intransit receipt, planned order and suggested repetitive schedule
will have a corresponding row in MRP_RECOMMENDATIONS. The
NEW_ORDER_QUANTITY and NEW_SCHEDULE_DATE store Oracle Master
Scheduling/MRP's recommended quantities and dates for an order.
OLD_ORDER_QUANTITY and OLD_SCHEDULE_DATE store the current quantity
and date for discrete jobs, purchase orders, purchase requisitions,
nonstandard jobs, intransit shipments and intransit receipts. These
columns will store null values for planned orders and recommended
repetitive schedules. The difference between OLD_SCHEDULE_DATE and
NEW_SCHEDULE_DATE represents the planning process's reschedule
recommendation. In the current version, the planning process does not
recommend quantity changes. Thus OLD_ORDER_QUANTITY and
NEW_ORDER_QUANTITY will be equal.
.
For suggested repetitive schedules, NEW_SCHEDULE_DATE will store the
first unit completion date. The last unit completion date will be
stored in LAST_UNIT_COMPLETION_DATE. FIRST_UNIT_START_DATE and
LAST_UNIT_START_DATE will hold the first unit start date and last unit
start date, respectively. NEW_PROCESSING_DAYS will be equal to the
number of workdays between LAST_UNIT_COMPLETION_DATE and
NEW_SCHEDULE_DATE plus one (for example, if LAST_UNIT_COMPLETION_DATE
equals August 14 and NEW_SCHEDULE_DATE equals August 12, and there are
no holidays between those dates, NEW_PROCESSING_DAYS will equal 3).
NEW_ORDER_QUANTITY will store the daily rate for the suggested
repetitive schedule. OLD_SCHEDULE_DATE and OLD_ORDER_QUANTITY will be
null.
.
FIRM_DATE and FIRM_QUANTITY will store the firm dates and quantities
of planned orders. Both of these columns will be populated only for
planned orders with a FIRM_PLANNED_TYPE of Yes. When the planner
first creates a planned order, it is set to non-firm, and will have
null values in FIRM_DATE and FIRM_QUANTITY. FIRM_DATE and
FIRM_QUANTITY can be updated using the Planner Workbench form.
.
QUANTITY_IN_PROCESS will store that portion of a planned order or
recommended repetitive schedule that was loaded into WIP or PO via the
Planner's Workbench for creation of a Discrete Job, a Purchase
Requisition or a WIP repetitive schedule. QUANTITY_IN_PROCESS will be
populated by the implementation process of the Planner Workbench.
IMPLEMENTED_QUANTITY will store the quantity of the portion of the
planned order that was implemented into a Discrete Job or a Purchase
Requisition. It will be updated by the feedback process of the
Planning Manager. The feedback process will increment the
IMPLEMENTED_QUANTITY and decrement the QUANTITY_IN_PROCESS based on
the quantity of the Discrete Job or Purchase Requisition.
.
DISPOSITION_ID is a foreign key to MRP_ITEM_WIP_ENTITIES for discrete
jobs. For nonstandard jobs, it references MRP_WIP_COMPONENTS. For
purchase orders, purchase requisitions, purchase orders in receiving,
intransit shipments, and intransit receipts, DISPOSITION_ID will be a
foreign key to MRP_ITEM_PURCHASE_ORDERS. DISPOSITION_ID will be equal
to MRP_RECOMMENDATIONS.TRANSACTION_ID for planned orders and suggested
repetitive schedules.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_RECOMMENDATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
MRP_RECOMMENDATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnCOMPILE_DESIGNATOR
ColumnORGANIZATION_ID
ColumnNEW_SCHEDULE_DATE
MRP_RECOMMENDATIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPILE_DESIGNATOR
ColumnORGANIZATION_ID
ColumnORDER_TYPE
ColumnLINE_ID
MRP_RECOMMENDATIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCOMPILE_DESIGNATOR
ColumnLOAD_TYPE
ColumnINVENTORY_ITEM_ID
MRP_RECOMMENDATIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLIED
ColumnCOMPILE_DESIGNATOR
ColumnORGANIZATION_ID
MRP_RECOMMENDATIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnCOMPILE_DESIGNATOR
ColumnORGANIZATION_ID
ColumnORDER_TYPE
ColumnNEW_SCHEDULE_DATE
MRP_RECOMMENDATIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOAD_TYPE
ColumnORGANIZATION_ID
ColumnCOMPILE_DESIGNATOR
ColumnINVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Transaction identifier
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
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
NEW_SCHEDULE_DATE DATE
Yes New schedule completion date
OLD_SCHEDULE_DATE DATE

Old schedule date
NEW_WIP_START_DATE DATE

New WIP schedule start date
OLD_WIP_START_DATE DATE

Old WIP schedule start date
DISPOSITION_ID NUMBER

Order number
DISPOSITION_STATUS_TYPE NUMBER
Yes Disposition type code
ORDER_TYPE NUMBER
Yes Order type code
VENDOR_ID NUMBER

Supplier identifier
VENDOR_SITE_ID NUMBER

Supplier Site Identifier
NEW_ORDER_QUANTITY NUMBER
Yes New order quantity
OLD_ORDER_QUANTITY NUMBER

Old order quantity
NEW_ORDER_PLACEMENT_DATE DATE

New order placement date
OLD_ORDER_PLACEMENT_DATE DATE

Old order placement date
FIRM_PLANNED_TYPE NUMBER
Yes Firm flag
RESCHEDULED_FLAG NUMBER

Flag indicating if this row been rescheduled using the Planner Workbench form
SCHEDULE_COMPRESSION_DAYS NUMBER

Order schedule compression days
NEW_PROCESSING_DAYS NUMBER

Repetitive schedule processing days
IMPLEMENTED_QUANTITY NUMBER

Planned order implemented quantity
PURCH_LINE_NUM NUMBER

Purchase order line number
REVISION VARCHAR2 (3)
Inventory item revision code
LAST_UNIT_COMPLETION_DATE DATE

Last unit completion date for recommended repetitive schedules
FIRST_UNIT_START_DATE DATE

First unit start date for repetitive schedules
LAST_UNIT_START_DATE DATE

Last unit start date for repetitive schedules
DAILY_RATE NUMBER

Daily rate for recommended repetitive schedules
OLD_DOCK_DATE DATE

Current dock date
NEW_DOCK_DATE DATE

Suggested dock date
SUPPLY_AVAIL_DATE DATE

Supply available date.
RESCHEDULE_DAYS NUMBER

Difference between old and new schedule dates
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
QUANTITY_IN_PROCESS NUMBER

Quantity being processed by the WIP/PO interface processes
FIRM_QUANTITY NUMBER

Firm planned quantity
FIRM_DATE DATE

Firm planned order date
NETTING_DATE DATE

Not currently used
PLANNING_MAKE_BUY_CODE NUMBER

Not currently used
UPDATED NUMBER

Flag to determine whether add workday modification was applied
STATUS NUMBER

Attribute used for online replanning
APPLIED NUMBER

Attribute used for online replanning
IMPLEMENT_DEMAND_CLASS VARCHAR2 (30)
Implement Demand Class
IMPLEMENT_DATE DATE

Implement due date
IMPLEMENT_QUANTITY NUMBER

Implement quantity
IMPLEMENT_FIRM NUMBER

Implement firm type
IMPLEMENT_WIP_CLASS_CODE VARCHAR2 (10)
Implement WIP job class code
IMPLEMENT_JOB_NAME VARCHAR2 (240)
Implement job name
IMPLEMENT_DOCK_DATE DATE

Implement dock date
IMPLEMENT_STATUS_CODE NUMBER

Implement job status code
IMPLEMENT_EMPLOYEE_ID NUMBER

Implement employee identifier
IMPLEMENT_UOM_CODE VARCHAR2 (3)
Implement UOM code
IMPLEMENT_LOCATION_ID NUMBER

Implement location identifier
IMPLEMENT_SOURCE_ORG_ID NUMBER

Implement source organization identifier
IMPLEMENT_VENDOR_ID NUMBER

Implement supplier identifier
IMPLEMENT_VENDOR_SITE_ID NUMBER

Implement supplier site identifier
RELEASE_STATUS NUMBER

Release status
LOAD_TYPE NUMBER

Load program to execute
IMPLEMENT_AS NUMBER (22)
Implement order type
DEMAND_CLASS VARCHAR2 (30)
Not currently used
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Not currently used
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Not currently used
LINE_ID NUMBER

Line identifier
SOURCE NUMBER

Not currently used
BY_PRODUCT_USING_ASSY_ID NUMBER

Not currently used
SOURCE_ORGANIZATION_ID NUMBER

Not currently used
SOURCE_VENDOR_SITE_ID NUMBER

Not currently used
SOURCE_VENDOR_ID NUMBER

Not currently used
SOURCE_SUPPLY_SCHEDULE_NAME VARCHAR2 (10)
Not currently used
NEW_SHIP_DATE DATE

New ship date
PROJECT_ID NUMBER (15)
Project identifier
TASK_ID NUMBER (15)
Task identifier
PLANNING_GROUP VARCHAR2 (30)
Planning group
IMPLEMENT_PROJECT_ID NUMBER

Implement project identifier
IMPLEMENT_TASK_ID NUMBER

Implement task identifier
IMPLEMENT_SCHEDULE_GROUP_ID NUMBER

Schedule group identifier for the planned order to be implemented as a discrete job.
IMPLEMENT_BUILD_SEQUENCE NUMBER

Implement build sequence for the planned order to be implemented as a discrete job.
IMPLEMENT_ALTERNATE_BOM VARCHAR2 (10)
Bill of material designator in the planned order being implemented
IMPLEMENT_ALTERNATE_ROUTING VARCHAR2 (10)
Routing designator in the planned order being implemented
IMPLEMENT_LINE_ID NUMBER

Implement line identifier
SOURCE_ITEM_ID NUMBER

Source item identifier
RELEASE_ERRORS VARCHAR2 (2000)
Errors encountered during enhanced select all for release process
NUMBER1 NUMBER

Column to store old implement quantity during select all for release process
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Unit number
IMPLEMENT_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Implement unit number
Query Text

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


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      NEW_SCHEDULE_DATE
,      OLD_SCHEDULE_DATE
,      NEW_WIP_START_DATE
,      OLD_WIP_START_DATE
,      DISPOSITION_ID
,      DISPOSITION_STATUS_TYPE
,      ORDER_TYPE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      NEW_ORDER_QUANTITY
,      OLD_ORDER_QUANTITY
,      NEW_ORDER_PLACEMENT_DATE
,      OLD_ORDER_PLACEMENT_DATE
,      FIRM_PLANNED_TYPE
,      RESCHEDULED_FLAG
,      SCHEDULE_COMPRESSION_DAYS
,      NEW_PROCESSING_DAYS
,      IMPLEMENTED_QUANTITY
,      PURCH_LINE_NUM
,      REVISION
,      LAST_UNIT_COMPLETION_DATE
,      FIRST_UNIT_START_DATE
,      LAST_UNIT_START_DATE
,      DAILY_RATE
,      OLD_DOCK_DATE
,      NEW_DOCK_DATE
,      SUPPLY_AVAIL_DATE
,      RESCHEDULE_DAYS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      QUANTITY_IN_PROCESS
,      FIRM_QUANTITY
,      FIRM_DATE
,      NETTING_DATE
,      PLANNING_MAKE_BUY_CODE
,      UPDATED
,      STATUS
,      APPLIED
,      IMPLEMENT_DEMAND_CLASS
,      IMPLEMENT_DATE
,      IMPLEMENT_QUANTITY
,      IMPLEMENT_FIRM
,      IMPLEMENT_WIP_CLASS_CODE
,      IMPLEMENT_JOB_NAME
,      IMPLEMENT_DOCK_DATE
,      IMPLEMENT_STATUS_CODE
,      IMPLEMENT_EMPLOYEE_ID
,      IMPLEMENT_UOM_CODE
,      IMPLEMENT_LOCATION_ID
,      IMPLEMENT_SOURCE_ORG_ID
,      IMPLEMENT_VENDOR_ID
,      IMPLEMENT_VENDOR_SITE_ID
,      RELEASE_STATUS
,      LOAD_TYPE
,      IMPLEMENT_AS
,      DEMAND_CLASS
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      LINE_ID
,      SOURCE
,      BY_PRODUCT_USING_ASSY_ID
,      SOURCE_ORGANIZATION_ID
,      SOURCE_VENDOR_SITE_ID
,      SOURCE_VENDOR_ID
,      SOURCE_SUPPLY_SCHEDULE_NAME
,      NEW_SHIP_DATE
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
,      IMPLEMENT_PROJECT_ID
,      IMPLEMENT_TASK_ID
,      IMPLEMENT_SCHEDULE_GROUP_ID
,      IMPLEMENT_BUILD_SEQUENCE
,      IMPLEMENT_ALTERNATE_BOM
,      IMPLEMENT_ALTERNATE_ROUTING
,      IMPLEMENT_LINE_ID
,      SOURCE_ITEM_ID
,      RELEASE_ERRORS
,      NUMBER1
,      END_ITEM_UNIT_NUMBER
,      IMPLEMENT_END_ITEM_UNIT_NUMBER
FROM MRP.MRP_RECOMMENDATIONS;

Dependencies

[top of page]

MRP.MRP_RECOMMENDATIONS does not reference any database object

MRP.MRP_RECOMMENDATIONS is referenced by following:

SchemaMRP
ViewMRP_RECOMMENDATIONS#