eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MRP_DESIGNATORS_VIEW

Object Details

Object Name:	MRP_DESIGNATORS_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_DESIGNATORS_VIEW
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	Comments
DESIGNATOR	VARCHAR2	(10)	Designator code
ORGANIZATION_ID	NUMBER		Organization 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
DESCRIPTION	VARCHAR2	(50)	Designator description
DESIGNATOR_TYPE	NUMBER		Type of designator
DISABLE_DATE	DATE		Disable date
MPS_RELIEF	NUMBER		Relief code
USE_NEW_PLANNER	NUMBER		Flag to indicate memory based planner
ORGANIZATION_SELECTION	NUMBER		Selected organization code
PRODUCTION	NUMBER		Production flag

Query Text

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


SELECT DESIGNATOR
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      DESIGNATOR_TYPE
,      DISABLE_DATE
,      MPS_RELIEF
,      USE_NEW_PLANNER
,      ORGANIZATION_SELECTION
,      PRODUCTION
FROM APPS.MRP_DESIGNATORS_VIEW;

Dependencies

[top of page]

APPS.MRP_DESIGNATORS_VIEW references the following:

APPS: MRP_DESIGNATORS; MRP_SCHEDULE_DESIGNATORS

APPS.MRP_DESIGNATORS_VIEW is referenced by following:

APPS: BOM_MIXED_MODEL_MAP_PVT - show dependent code; FLM_SEQ_DEMAND_PLAN_ORDERS_V; MRP_BOM_PLAN_NAME_LOV_V; MRP_LOAD_PARAMETERS_V; MRP_PLANS_SC_V; MRP_PLAN_PARAMETERS_V; MRP_PLAN_SCHED_V; MRP_SRS_SCHED_LOAD_SOURCE_V; MRP_SUB_INVENTORIES_V; MRP_UNSCHEDULED_ORDERS_V; MRP_UPDATE_MRP_INFO_PK - show dependent code; MRP_WFS_FORM_FLOW_SCHEDULE - show dependent code; OKE_AMG_GRP - show dependent code; OKE_DELIVERABLE_PVT - show dependent code