[Home] [Help]
[Dependency Information]
VIEW: APPS.AMS_USER_ORG_V
Object Details
Object Name: | AMS_USER_ORG_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_USER_ORG_V
|
---|
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
USER_ID |
NUMBER |
(15) |
Yes |
|
USER_NAME |
VARCHAR2 |
(100) |
Yes |
|
USER_ORG_ID |
NUMBER |
(15) |
Yes |
|
USER_ORG_NAME |
VARCHAR2 |
(240) |
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT USER_ID
, USER_NAME
, USER_ORG_ID
, USER_ORG_NAME
FROM APPS.AMS_USER_ORG_V;
Dependencies
[top of page]
APPS.AMS_USER_ORG_V references the following:
-
APPS
-
FND_DATE
- show dependent code
-
FND_PROFILE_OPTIONS
-
FND_PROFILE_OPTION_VALUES
-
FND_USER
-
FND_USER_RESP_GROUPS
-
HR_OPERATING_UNITS
APPS.AMS_USER_ORG_V is referenced by following:
-
APPS
-
AMS_LOOKUP_SALES_V