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

VIEW: APPS.WF_POS_ROLES

Object Details
Object Name: WF_POS_ROLES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.WF_POS_ROLES
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


Bulk Sync Directory Service Role View for Orig System POS


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (44)
Internal name
DISPLAY_NAME VARCHAR2 (240)
Name displayed to user
DESCRIPTION VARCHAR2 (240)
Description
NOTIFICATION_PREFERENCE CHAR (5)
Preferred notification delivery method
LANGUAGE VARCHAR2 (30)
Language
TERRITORY VARCHAR2 (30)
Territory
EMAIL_ADDRESS VARCHAR2 (0)
E-mail address
FAX VARCHAR2 (0)
Fax number
ORIG_SYSTEM CHAR (3)
Original system name
ORIG_SYSTEM_ID NUMBER (15) Yes Unique identifier for the role in the above system
START_DATE DATE

Date
STATUS CHAR (6)
Indicated if available to participate in a workflow process
EXPIRATION_DATE DATE

Date workflow expires
SECURITY_GROUP_ID VARCHAR2 (0)
Security Group ID
USER_FLAG CHAR (1)
Indicates whether this is a user or not.
PARTITION_ID NUMBER

This ID associates a particular orig system to determine which partition this orig system should be in.
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.WF_POS_ROLES;

Dependencies

[top of page]

APPS.WF_POS_ROLES references the following:

SchemaAPPS
SynonymFND_LANGUAGES
SynonymFND_TERRITORIES
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_POSITIONS

APPS.WF_POS_ROLES is not referenced by any database object