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

VIEW: APPS.IGS_AD_PROSPECT_V

Object Details
Object Name: IGS_AD_PROSPECT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AD_PROSPECT_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Describes various person type instances of a person.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID of driving table
PERSON_ID NUMBER (15) Yes Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
PERSON_NUMBER VARCHAR2 (30) Yes Person number
FUNNEL_STATUS VARCHAR2 (30)
Funnel status
FUNNEL_STATUS_MEANING VARCHAR2 (80) Yes Meaning of funnel status code
PERSON_TYPE_CODE VARCHAR2 (30) Yes Person type code, for example faculty, student and others
SYSTEM_TYPE VARCHAR2 (30) Yes The system type associated with a person type
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      PERSON_NUMBER
,      FUNNEL_STATUS
,      FUNNEL_STATUS_MEANING
,      PERSON_TYPE_CODE
,      SYSTEM_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_AD_PROSPECT_V;

Dependencies

[top of page]

APPS.IGS_AD_PROSPECT_V references the following:

SchemaAPPS
ViewIGS_LOOKUP_VALUES
ViewIGS_PE_PERSON_BASE_V
SynonymIGS_PE_PERSON_TYPES
SynonymIGS_PE_TYP_INSTANCES_ALL
APPS.IGS_AD_PROSPECT_V is referenced by following:

SchemaAPPS
ViewIGR_I_PERSON_V
ViewIGS_AD_ENQ_PERSON_V