[Home] [Help] [Dependency Information]

TABLE: MRP.MRP_RECOMMENDATIONS

Object Details

Object Name:	MRP_RECOMMENDATIONS
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_RECOMMENDATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
MRP_RECOMMENDATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID COMPILE_DESIGNATOR ORGANIZATION_ID NEW_SCHEDULE_DATE
MRP_RECOMMENDATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPILE_DESIGNATOR ORGANIZATION_ID ORDER_TYPE LINE_ID
MRP_RECOMMENDATIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID COMPILE_DESIGNATOR LOAD_TYPE INVENTORY_ITEM_ID
MRP_RECOMMENDATIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLIED COMPILE_DESIGNATOR ORGANIZATION_ID
MRP_RECOMMENDATIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID COMPILE_DESIGNATOR ORGANIZATION_ID ORDER_TYPE NEW_SCHEDULE_DATE
MRP_RECOMMENDATIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOAD_TYPE ORGANIZATION_ID COMPILE_DESIGNATOR INVENTORY_ITEM_ID

Columns

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:

MRP

MRP_RECOMMENDATIONS#