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

VIEW: APPS.MSD_DP_USERS_V

Object Details
Object Name: MSD_DP_USERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_DP_USERS_V
Subobject Name:
Status: VALID

View Type

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


This view Specifies the various Users who have access to the Demand Plan.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DEMAND_PLAN_ID NUMBER

Demand Plan ID.
DEMAND_PLAN_NAME VARCHAR2 (30)
Demand Plan name.
ORGANIZATION_ID NUMBER

Demand planning organization ID.
ORGANIZATION_CODE VARCHAR2 (7)
Demand planning organization code.
ORGANIZATION_NAME VARCHAR2 (255)
Demand planning organization name.
USER_ID NUMBER (15)
The login user ID.
USER_NAME VARCHAR2 (100)
The login user name.
RESPONSIBILITY_ID NUMBER (15)
The responsibility (role) in which the user has logged in.
RESPONSIBILITY_KEY VARCHAR2 (30)
The responsibility key.
RESPONSIBILITY_NAME VARCHAR2 (100)
The responsibility name.
APPLICATION_ID NUMBER

The application to which the user has logged in.
APPLICATION_NAME VARCHAR2 (50)
The application name.
Query Text

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


SELECT DEMAND_PLAN_ID
,      DEMAND_PLAN_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      USER_ID
,      USER_NAME
,      RESPONSIBILITY_ID
,      RESPONSIBILITY_KEY
,      RESPONSIBILITY_NAME
,      APPLICATION_ID
,      APPLICATION_NAME
FROM APPS.MSD_DP_USERS_V;

Dependencies

[top of page]

APPS.MSD_DP_USERS_V references the following:

SchemaAPPS
SynonymFND_APPLICATION
PL/SQL PackageFND_DATE - show dependent code
PL/SQL PackageFND_MESSAGE - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
ViewFND_RESPONSIBILITY_VL
SynonymFND_USER
ViewFND_USER_RESP_GROUPS
SynonymMSC_TRADING_PARTNERS
ViewMSD_DEMAND_PLANS_V
APPS.MSD_DP_USERS_V is referenced by following:

SchemaAPPS
Package BodyODP - show dependent code