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


VIEW: APPS.POS_PO_LIST_USERS_V

Object Details
Object Name: POS_PO_LIST_USERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_PO_LIST_USERS_V
ViewPOS.POS_PO_LIST_USERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (10) Yes
FIRST_NAME VARCHAR2 (150)
LAST_NAME VARCHAR2 (150) Yes
FULL_NAME VARCHAR2 (240)
WORK_TELEPHONE VARCHAR2 (4000)
USER_NAME VARCHAR2 (100)
MAILSTOP VARCHAR2 (45)
ORGANIZATION_NAME VARCHAR2 (240) Yes
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
LOCATION_CODE VARCHAR2 (60)
DEFAULT_CODE_COMBINATION_ID NUMBER (15)
COST_CENTER VARCHAR2 (4000)
Query Text

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


SELECT PERSON_ID
,      FIRST_NAME
,      LAST_NAME
,      FULL_NAME
,      WORK_TELEPHONE
,      USER_NAME
,      MAILSTOP
,      ORGANIZATION_NAME
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE_CATEGORY
,      LOCATION_CODE
,      DEFAULT_CODE_COMBINATION_ID
,      COST_CENTER
FROM APPS.POS_PO_LIST_USERS_V;

Dependencies

[top of page]

APPS.POS_PO_LIST_USERS_V references the following:

SchemaAPPS
SynonymFND_USER
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
PL/SQL PackagePOS_GET - show dependent code
SynonymPO_REQUISITION_HEADERS

APPS.POS_PO_LIST_USERS_V is not referenced by any database object