[Home] [Help] [Dependency Information]
Object Name: | MSD_DP_USERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_DP_USERS_V |
Subobject Name: | |
Status: | VALID |
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.
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. |
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;
|
|
|