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

TABLE: PO.PO_USER_PREFERENCES

Object Details
Object Name: PO_USER_PREFERENCES
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_USER_PREFERENCES
Subobject Name:
Status: VALID


This table stores the fnd user preference information accross Purchasing, IProcurement and Sourcing. Currently the default address preferences for the user is stored.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_USER_PREFERENCES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFND_USER_ID
ColumnFUNCTIONAL_AREA
Columns
Name Datatype Length Mandatory Comments
USER_PREFERENCE_ID NUMBER

Unique identifier
FND_USER_ID NUMBER

the fnd login user for whom the preference is applicable
PREFERENCE_TYPE VARCHAR2 (100)
The type of the preference. Can take values OFFICE_ADDRESS, CONTRACT_OFFICER
FUNCTIONAL_AREA VARCHAR2 (30)
The application for which the preference is applicable. Valid values - PURCHASING, SOURCING, REQUISITIONS
ADDRESS_TYPE VARCHAR2 (30)
For office addresses, it indicates the office type. Is driven by the lookup type PO UDA Address Types
LOCATION_ID NUMBER

Office location. Populated for Office address preference type. hr_locations_all.location_idReferences
CONTACT_ID NUMBER

Office Contact. Populated for Office address preference type.
ATTRIBUTE_CATEGORY VARCHAR2 (100)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
DFF column
ATTRIBUTE17 VARCHAR2 (150)
DFF column
ATTRIBUTE18 VARCHAR2 (150)
DFF column
ATTRIBUTE19 VARCHAR2 (150)
DFF column
ATTRIBUTE20 VARCHAR2 (150)
DFF column
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CLM_CONTRACT_OFFICER NUMBER

Default Contracting Officer
Query Text

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


SELECT USER_PREFERENCE_ID
,      FND_USER_ID
,      PREFERENCE_TYPE
,      FUNCTIONAL_AREA
,      ADDRESS_TYPE
,      LOCATION_ID
,      CONTACT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CLM_CONTRACT_OFFICER
FROM PO.PO_USER_PREFERENCES;

Dependencies

[top of page]

PO.PO_USER_PREFERENCES does not reference any database object

PO.PO_USER_PREFERENCES is referenced by following:

SchemaPO
ViewPO_USER_PREFERENCES#