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

VIEW: APPS.MRP_SCHEDULE_DESIGNATORS_V

Object Details
Object Name: MRP_SCHEDULE_DESIGNATORS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_SCHEDULE_DESIGNATORS_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 ID
SCHEDULE_DESIGNATOR VARCHAR2 (10) Yes Master schedule identifier
ORGANIZATION_ID NUMBER

Organization identifier
OWNING_ORGANIZATION_ID NUMBER
Yes Owning organization identifier
SCHEDULE_TYPE NUMBER
Yes Schedule type: MDS/MPS
MPS_RELIEF NUMBER
Yes Perform MPS relief against this designator
INVENTORY_ATP_FLAG NUMBER
Yes ATP supply flag
DESCRIPTION VARCHAR2 (50)
Description
DISABLE_DATE DATE

Schedule disable date
DEMAND_CLASS VARCHAR2 (30)
Schedule demand class
USE_NEW_PLANNER NUMBER

Planned by the new planner?
PRODUCTION NUMBER

Production schedule?
ORGANIZATION_SELECTION NUMBER

Organization selection in multi-org environment
Query Text

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


SELECT ROW_ID
,      SCHEDULE_DESIGNATOR
,      ORGANIZATION_ID
,      OWNING_ORGANIZATION_ID
,      SCHEDULE_TYPE
,      MPS_RELIEF
,      INVENTORY_ATP_FLAG
,      DESCRIPTION
,      DISABLE_DATE
,      DEMAND_CLASS
,      USE_NEW_PLANNER
,      PRODUCTION
,      ORGANIZATION_SELECTION
FROM APPS.MRP_SCHEDULE_DESIGNATORS_V;

Dependencies

[top of page]

APPS.MRP_SCHEDULE_DESIGNATORS_V references the following:

SchemaAPPS
ViewMRP_ORGANIZATIONS_V
SynonymMRP_SCHEDULE_DESIGNATORS

APPS.MRP_SCHEDULE_DESIGNATORS_V is not referenced by any database object