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

VIEW: APPS.MSD_PLAN_TYPE_VIEWS_V

Object Details
Object Name: MSD_PLAN_TYPE_VIEWS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Mapping between Plan type and Planning Server Views.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_TYPE VARCHAR2 (30) Yes Plan Type
VIEW_TYPE VARCHAR2 (30) Yes View Type
VIEW_NAME VARCHAR2 (30) Yes View Name
LOB_FLAG VARCHAR2 (30)
Line of Business Flag
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.
REQUEST_ID NUMBER

Enhanced Who column.
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column.
PROGRAM_ID NUMBER

Enhanced Who column.
PROGRAM_UPDATE_DATE DATE

Enhanced Who column.
Query Text

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


SELECT PLAN_TYPE
,      VIEW_TYPE
,      VIEW_NAME
,      LOB_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.MSD_PLAN_TYPE_VIEWS_V;

Dependencies

[top of page]

APPS.MSD_PLAN_TYPE_VIEWS_V references the following:

SchemaAPPS
SynonymMSD_PLAN_TYPE_VIEWS

APPS.MSD_PLAN_TYPE_VIEWS_V is not referenced by any database object