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

VIEW: APPS.MRP_PLAN_PARAMETERS_V

Object Details
Object Name: MRP_PLAN_PARAMETERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_PLAN_PARAMETERS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
ORGANIZATION_ID NUMBER

Organization identifier
PLANNED_ORGANIZATION NUMBER

Planned Organization Code
COMPILE_DESIGNATOR VARCHAR2 (10)
MPS, MRP or DRP plan identifier
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CURR_SCHEDULE_DESIGNATOR VARCHAR2 (10)
Current Schedule Designator Code
CURR_SCHEDULE_DESC VARCHAR2 (50)
Current Schedule Designator Description
CURR_OPERATION_SCHEDULE_TYPE NUMBER

Current lead time offfset type
CURR_PLAN_TYPE NUMBER

Current Plan Type Code
CURR_PLAN_TYPE_TEXT VARCHAR2 (4000)
Current Plan Type Meaning
CURR_OVERWRITE_OPTION NUMBER

Current value of whether to overwrite the existing plan
CURR_APPEND_PLANNED_ORDERS NUMBER

Current value of whether or not to append the planned orders at the end of the plan
CURR_SCHEDULE_TYPE NUMBER

Current Schedule Type
CURR_SCHEDULE_TYPE_DESC VARCHAR2 (4000)
Current Schedule Type Meaning
ANCHOR_DATE DATE
Yes Repetitive Anchor Date
CURR_CUTOFF_DATE DATE

Current Cutoff Date
CURR_PART_INCLUDE_TYPE NUMBER

Current Include all parts or only schedule items
CURR_PLANNING_TIME_FENCE_FLAG NUMBER

Current consider planning time fences
CURR_DEMAND_TIME_FENCE_FLAG NUMBER

Current consider demand time fences
CURR_CONSIDER_RESERVATIONS NUMBER

Current plan material reservations
CURR_PLAN_SAFETY_STOCK NUMBER

Current plan safety stock
CURR_CONSIDER_WIP NUMBER

Current consider work in process
CURR_CONSIDER_PO NUMBER

Current consider purchase orders
CURR_SNAPSHOT_LOCK NUMBER

Current value of the flag that determines whether the snapshot tries to lock the tables
COMPILE_DEFINITION_DATE DATE

Compile definition date
DESCRIPTION VARCHAR2 (50)
Designator Description
USE_NEW_PLANNER NUMBER

Use new planner code
DISABLE_DATE DATE

Master schedule disable date
CURR_FULL_PEGGING NUMBER

Current Full Pegging Code
CURR_ASSIGNMENT_SET_ID NUMBER

Current Assignment Set Identifier
CURR_SR_ASSIGNMENT_SET VARCHAR2 (30)
Assignment Set Name from mrp_assignmengt_sets
CURR_SR_ASSIGN_SET_DESC VARCHAR2 (80)
Assigment Set Description from mrp_assignment_sets
ORGANIZATION_SELECTION NUMBER

Selected Organization Code
ORGANIZATION_SELECTION_TEXT VARCHAR2 (4000)
Selected Organization
SCHEDULE_DESIGNATOR VARCHAR2 (10)
Master Schedule Identifier
SCHEDULE_DESC VARCHAR2 (50)
Designator description
OPERATION_SCHEDULE_TYPE NUMBER

Leadtime Offset Type
PLAN_TYPE NUMBER

Plan Type Code (MRP or MPS)
PLAN_TYPE_TEXT VARCHAR2 (4000)
Plan Type
OVERWRITE_OPTION NUMBER

Whether to overwrite the existing plan
APPEND_PLANNED_ORDERS NUMBER

Whether or not to append planned orders at the end of the plan.
SCHEDULE_TYPE NUMBER

Schedule Type Code
SCHEDULE_TYPE_DESC VARCHAR2 (4000)
Schedule Type
CUTOFF_DATE DATE

Cutoff Date
PART_INCLUDE_TYPE NUMBER

Include all parts or only msed
PLANNING_TIME_FENCE_FLAG NUMBER

Consider Time fences
DEMAND_TIME_FENCE_FLAG NUMBER

Consider demand time fences
CONSIDER_RESERVATIONS NUMBER

Plan Material Reservations
PLAN_SAFETY_STOCK NUMBER

Plan Safety Stock
CONSIDER_WIP NUMBER

Consider Work in Process
CONSIDER_PO NUMBER

Consider PO
SNAPSHOT_LOCK NUMBER

Flag to determine whether snapshot should try to lock the table.
ASSIGNMENT_SET_ID NUMBER

Assignment Set identifier
SR_ASSIGNMENT_SET VARCHAR2 (30)
Assignment Set Name
SR_ASSIGN_SET_DESC VARCHAR2 (80)
Assignment Set Description
FULL_PEGGING NUMBER

Full Pegging Flag
EXPLOSION_START_DATE DATE

Explosion start date and time
EXPLOSION_COMPLETION_DATE DATE

Explosion completion date and time
DATA_START_DATE DATE

Data snapshot start date and time
DATA_COMPLETION_DATE DATE

Data snapshot completion date and time
PLAN_START_DATE DATE

Planner start date and time
PLAN_COMPLETION_DATE DATE

Planner completion date and time
CRP_PLAN_START_DATE DATE

CRP plan start date
CRP_PLAN_COMPLETION_DATE DATE

CRP Planner Completion date and time
CURR_RESERVATION_LEVEL NUMBER

Current reservation level
CURR_HARD_PEGGING_LEVEL NUMBER

Current hard pegging level
RESERVATION_LEVEL NUMBER

Option which determines at what level is supply reserved against demand
HARD_PEGGING_LEVEL NUMBER

Flag which determines pegging granularity of planned orders
CURR_PLAN_CAPACITY_FLAG NUMBER

Current plan capacity flag
CURR_SIMULATION_SET VARCHAR2 (10)
Current simulation set
CURR_BILL_OF_RESOURCES VARCHAR2 (10)
Current bill of resource
PLAN_CAPACITY_FLAG NUMBER

Plan capacity flag
SIMULATION_SET VARCHAR2 (10)
Simulation set name
BILL_OF_RESOURCES VARCHAR2 (10)
Bill of resource name
Query Text

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


SELECT ROW_ID
,      ORGANIZATION_ID
,      PLANNED_ORGANIZATION
,      COMPILE_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CURR_SCHEDULE_DESIGNATOR
,      CURR_SCHEDULE_DESC
,      CURR_OPERATION_SCHEDULE_TYPE
,      CURR_PLAN_TYPE
,      CURR_PLAN_TYPE_TEXT
,      CURR_OVERWRITE_OPTION
,      CURR_APPEND_PLANNED_ORDERS
,      CURR_SCHEDULE_TYPE
,      CURR_SCHEDULE_TYPE_DESC
,      ANCHOR_DATE
,      CURR_CUTOFF_DATE
,      CURR_PART_INCLUDE_TYPE
,      CURR_PLANNING_TIME_FENCE_FLAG
,      CURR_DEMAND_TIME_FENCE_FLAG
,      CURR_CONSIDER_RESERVATIONS
,      CURR_PLAN_SAFETY_STOCK
,      CURR_CONSIDER_WIP
,      CURR_CONSIDER_PO
,      CURR_SNAPSHOT_LOCK
,      COMPILE_DEFINITION_DATE
,      DESCRIPTION
,      USE_NEW_PLANNER
,      DISABLE_DATE
,      CURR_FULL_PEGGING
,      CURR_ASSIGNMENT_SET_ID
,      CURR_SR_ASSIGNMENT_SET
,      CURR_SR_ASSIGN_SET_DESC
,      ORGANIZATION_SELECTION
,      ORGANIZATION_SELECTION_TEXT
,      SCHEDULE_DESIGNATOR
,      SCHEDULE_DESC
,      OPERATION_SCHEDULE_TYPE
,      PLAN_TYPE
,      PLAN_TYPE_TEXT
,      OVERWRITE_OPTION
,      APPEND_PLANNED_ORDERS
,      SCHEDULE_TYPE
,      SCHEDULE_TYPE_DESC
,      CUTOFF_DATE
,      PART_INCLUDE_TYPE
,      PLANNING_TIME_FENCE_FLAG
,      DEMAND_TIME_FENCE_FLAG
,      CONSIDER_RESERVATIONS
,      PLAN_SAFETY_STOCK
,      CONSIDER_WIP
,      CONSIDER_PO
,      SNAPSHOT_LOCK
,      ASSIGNMENT_SET_ID
,      SR_ASSIGNMENT_SET
,      SR_ASSIGN_SET_DESC
,      FULL_PEGGING
,      EXPLOSION_START_DATE
,      EXPLOSION_COMPLETION_DATE
,      DATA_START_DATE
,      DATA_COMPLETION_DATE
,      PLAN_START_DATE
,      PLAN_COMPLETION_DATE
,      CRP_PLAN_START_DATE
,      CRP_PLAN_COMPLETION_DATE
,      CURR_RESERVATION_LEVEL
,      CURR_HARD_PEGGING_LEVEL
,      RESERVATION_LEVEL
,      HARD_PEGGING_LEVEL
,      CURR_PLAN_CAPACITY_FLAG
,      CURR_SIMULATION_SET
,      CURR_BILL_OF_RESOURCES
,      PLAN_CAPACITY_FLAG
,      SIMULATION_SET
,      BILL_OF_RESOURCES
FROM APPS.MRP_PLAN_PARAMETERS_V;

Dependencies

[top of page]

APPS.MRP_PLAN_PARAMETERS_V references the following:

SchemaAPPS
SynonymMRP_ASSIGNMENT_SETS
ViewMRP_DESIGNATORS_VIEW
PL/SQL PackageMRP_GET_PROJECT - show dependent code
ViewMRP_ORGANIZATIONS_V
SynonymMRP_PARAMETERS
SynonymMRP_PLANS
SynonymMRP_SCHEDULE_DESIGNATORS

APPS.MRP_PLAN_PARAMETERS_V is not referenced by any database object