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


VIEW: APPS.ICX_PO_LIST_USERS_V

Object Details
Object Name: ICX_PO_LIST_USERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_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)
Work telephone number
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)
Cost center
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.ICX_PO_LIST_USERS_V;

Dependencies

[top of page]

APPS.ICX_PO_LIST_USERS_V references the following:

SchemaAPPS
SynonymFND_USER
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageICX_GET - show dependent code
ViewPER_ASSIGNMENTS_F
ViewPER_PEOPLE_F
SynonymPO_REQUISITION_HEADERS

APPS.ICX_PO_LIST_USERS_V is not referenced by any database object