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


VIEW: APPS.AS_PERSONS_ACTIVE_V

Object Details
Object Name: AS_PERSONS_ACTIVE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAS.AS_PERSONS_ACTIVE_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (10) Yes Person identifier
FIRST_NAME VARCHAR2 (150)
First name of the person
LAST_NAME VARCHAR2 (150) Yes Last name of the person
FIRST_AND_LAST_NAME VARCHAR2 (301)
Full name of the person
JOB_TITLE VARCHAR2 (700)
Job title of the person
TITLE VARCHAR2 (80)
Title of the person
WORK_TELEPHONE VARCHAR2 (60)
Work phone of the person
EMAIL_ADDRESS VARCHAR2 (240)
Email address of the person
EMPLOYEE_NUMBER VARCHAR2 (30)
Query Text

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


SELECT PERSON_ID
,      FIRST_NAME
,      LAST_NAME
,      FIRST_AND_LAST_NAME
,      JOB_TITLE
,      TITLE
,      WORK_TELEPHONE
,      EMAIL_ADDRESS
,      EMPLOYEE_NUMBER
FROM APPS.AS_PERSONS_ACTIVE_V;

Dependencies

[top of page]

APPS.AS_PERSONS_ACTIVE_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_API - show dependent code
ViewHR_LOOKUPS
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_JOBS

APPS.AS_PERSONS_ACTIVE_V is not referenced by any database object