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

VIEW: APPS.MRP_PLANS_SC_V

Object Details
Object Name: MRP_PLANS_SC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_PLANS_SC_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
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
COMPILE_DESIGNATOR VARCHAR2 (10)
MPS, MRP or DRP plan 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
CURR_SCHEDULE_DESIGNATOR VARCHAR2 (10)
Current schedule designator code
CURR_SCHEDULE_DESC VARCHAR2 (50)
Current schedule designator code
CURR_OPERATION_SCHEDULE_TYPE NUMBER
Yes Current leadtime offset type
CURR_PLAN_TYPE NUMBER
Yes Current planning code (MRP or MPS)
CURR_PLAN_TYPE_TEXT VARCHAR2 (80) Yes Current planning type meaning
CURR_OVERWRITE_OPTION NUMBER
Yes Current value of whether to overwrite the existing plan
CURR_APPEND_PLANNED_ORDERS NUMBER
Yes Current value of whether or not to append planned orders at the end of the plan
CURR_SCHEDULE_TYPE NUMBER

Current schedule type
CURR_SCHEDULE_TYPE_DESC VARCHAR2 (80)
Current schedule type meaning
PLAN_HORIZON DATE
Yes Current cutoff date
CURR_PART_INCLUDE_TYPE NUMBER
Yes Current include all parts on only msed
CURR_PLANNING_TIME_FENCE_FLAG NUMBER
Yes Current consider planning time fences
CURR_DEMAND_TIME_FENCE_FLAG NUMBER
Yes Current consider demand time fences
CURR_CONSIDER_RESERVATIONS NUMBER
Yes Current plan material reservations
CURR_PLAN_SAFETY_STOCK NUMBER
Yes Current plan safety stock
CURR_CONSIDER_WIP NUMBER
Yes Current consider work in process
CURR_CONSIDER_PO NUMBER
Yes Current consider purchase orders
CURR_SNAPSHOT_LOCK NUMBER
Yes Current value of the flag that determines whether the Snapshot tries to lock tables
COMPILE_DEFINITION_DATE DATE
Yes Compile definition date
SCHEDULE_DESIGNATOR VARCHAR2 (10)
Master schedule identifier
SCHEDULE_DESCRIPTION VARCHAR2 (50)
Schedule designator description
OPERATION_SCHEDULE_TYPE NUMBER

Lead time offset type
PLAN_TYPE NUMBER

Planning type code (MRP or MPS)
PLAN_TYPE_TEXT VARCHAR2 (80) Yes Plan type meaning
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
SCHEDULE_TYPE_TEXT VARCHAR2 (80)
Schedule type meaning
CUTOFF_DATE DATE

Cutoff date
PART_INCLUDE_TYPE NUMBER

Include app parts on only msed
PLANNING_TIME_FENCE_FLAG NUMBER

Consider planning 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 purchase orders
SNAPSHOT_LOCK NUMBER

Flag to determine whether the Snapshot should try to lock tables
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 completion date and time
CRP_PLAN_COMPLETION_DATE DATE

CRP planner completion date and time
PLAN_COMPLETION_DATE DATE

Planner completion date and time
CRP_PLAN_START_DATE DATE

CRP planner start date and time
CURRENT_PLANNER_LEVEL NUMBER

Level currently being planned by the MRP Planner Workers
PLANNER_BATCH_NUMBER NUMBER

Batch number currently being planned by the Planner Workers
DESCRIPTION VARCHAR2 (50)
Complie description
UPDATE_BOM NUMBER

Should the Snapshot update the MRP_PENDING_ENG_CHANGES and operation offset % information (Internal use only)
DEMAND_CLASS VARCHAR2 (30)
Demand class
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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
DISABLE_DATE DATE

Master schedule disable date
USE_NEW_PLANNER NUMBER

Use new planner code
CURR_FULL_PEGGING NUMBER

Current full pegging code
FULL_PEGGING NUMBER

Full pegging code
ORGANIZATION_SELECTION NUMBER

Selected organization code
ORGANIZATION_SELECTION_TEXT VARCHAR2 (80)
Selected organization
PLANNED_ORGANIZATION NUMBER

Planned organization identifier
CURR_RESERVATION_LEVEL NUMBER

Current reservation level for the plan: Project, Task or Planning Group
CURR_PLAN_CAPACITY_FLAG NUMBER

Current flag to indicate plan capacity(Y/N)
CURR_SIMULATION_SET VARCHAR2 (10)
Current simulation set name
CURR_BILL_OF_RESOURCES VARCHAR2 (10)
Current bill of resource name
PLAN_CAPACITY_FLAG NUMBER

Plan capacity flag(Y/N)
SIMULATION_SET VARCHAR2 (10)
Simulation set name
BILL_OF_RESOURCES VARCHAR2 (10)
Bill of resource name
PRODUCTION NUMBER

Production flag
Query Text

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


SELECT ROW_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      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
,      PLAN_HORIZON
,      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
,      SCHEDULE_DESIGNATOR
,      SCHEDULE_DESCRIPTION
,      OPERATION_SCHEDULE_TYPE
,      PLAN_TYPE
,      PLAN_TYPE_TEXT
,      OVERWRITE_OPTION
,      APPEND_PLANNED_ORDERS
,      SCHEDULE_TYPE
,      SCHEDULE_TYPE_TEXT
,      CUTOFF_DATE
,      PART_INCLUDE_TYPE
,      PLANNING_TIME_FENCE_FLAG
,      DEMAND_TIME_FENCE_FLAG
,      CONSIDER_RESERVATIONS
,      PLAN_SAFETY_STOCK
,      CONSIDER_WIP
,      CONSIDER_PO
,      SNAPSHOT_LOCK
,      EXPLOSION_START_DATE
,      EXPLOSION_COMPLETION_DATE
,      DATA_START_DATE
,      DATA_COMPLETION_DATE
,      PLAN_START_DATE
,      CRP_PLAN_COMPLETION_DATE
,      PLAN_COMPLETION_DATE
,      CRP_PLAN_START_DATE
,      CURRENT_PLANNER_LEVEL
,      PLANNER_BATCH_NUMBER
,      DESCRIPTION
,      UPDATE_BOM
,      DEMAND_CLASS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DISABLE_DATE
,      USE_NEW_PLANNER
,      CURR_FULL_PEGGING
,      FULL_PEGGING
,      ORGANIZATION_SELECTION
,      ORGANIZATION_SELECTION_TEXT
,      PLANNED_ORGANIZATION
,      CURR_RESERVATION_LEVEL
,      CURR_PLAN_CAPACITY_FLAG
,      CURR_SIMULATION_SET
,      CURR_BILL_OF_RESOURCES
,      PLAN_CAPACITY_FLAG
,      SIMULATION_SET
,      BILL_OF_RESOURCES
,      PRODUCTION
FROM APPS.MRP_PLANS_SC_V;

Dependencies

[top of page]

APPS.MRP_PLANS_SC_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
ViewMRP_DESIGNATORS_VIEW
ViewMRP_ORGANIZATIONS_V
SynonymMRP_PLANS
SynonymMRP_SCHEDULE_DESIGNATORS
SynonymMTL_PARAMETERS
APPS.MRP_PLANS_SC_V is referenced by following:

SchemaAPPS
Package BodyMRP_EXP_WF - show dependent code