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

VIEW: APPS.PQH_POS_ROLES

Object Details
Object Name: PQH_POS_ROLES
Object Type: VIEW
Owner: APPS
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
NAME VARCHAR2 (44)
Name of the Role (POS concatenated with POSITION_ID)
DISPLAY_NAME VARCHAR2 (240)
Position Name
DESCRIPTION VARCHAR2 (240)
Position Name
NOTIFICATION_PREFERENCE VARCHAR2 (4000)
Default Notification Preference ("QUERY')
LANGUAGE VARCHAR2 (30)
NLS Language
TERRITORY VARCHAR2 (30)
NLS Territory
EMAIL_ADDRESS VARCHAR2 (0)
eMail Address
FAX VARCHAR2 (0)
Fax Number
ORIG_SYSTEM CHAR (3)
Originating System ('POS')
ORIG_SYSTEM_ID NUMBER (15) Yes Identifier (POSITION_ID)
START_DATE DATE

Start Date
STATUS CHAR (6)
Status (Active)
EXPIRATION_DATE DATE

Expiry Date
SECURITY_GROUP_ID VARCHAR2 (0)
Striping Sec Grp Identifier
USER_FLAG CHAR (1)
User Flag (N)
PARTITION_ID NUMBER

WF Partition (Position = 4)
Query Text

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


SELECT NAME
,      DISPLAY_NAME
,      DESCRIPTION
,      NOTIFICATION_PREFERENCE
,      LANGUAGE
,      TERRITORY
,      EMAIL_ADDRESS
,      FAX
,      ORIG_SYSTEM
,      ORIG_SYSTEM_ID
,      START_DATE
,      STATUS
,      EXPIRATION_DATE
,      SECURITY_GROUP_ID
,      USER_FLAG
,      PARTITION_ID
FROM APPS.PQH_POS_ROLES;

Dependencies

[top of page]

APPS.PQH_POS_ROLES references the following:

SchemaAPPS
SynonymFND_LANGUAGES
SynonymFND_TERRITORIES
SynonymHR_LOCATIONS_ALL
SynonymPER_ALL_POSITIONS
PL/SQL PackageWF_PREF - show dependent code
APPS.PQH_POS_ROLES is referenced by following:

SchemaPUBLIC
SynonymPQH_POS_ROLES