eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGW_PROPOSAL_PERSONS_V

Object Details

Object Name:	IGW_PROPOSAL_PERSONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGW.IGW_PROPOSAL_PERSONS_V
Subobject Name:
Status:	VALID

View Type

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

IGW_PROPOSAL_PERSONS_V displays details of the personnel involved on the proposal.

[View Source]

Columns

Name	Datatype	Length	Comments
PROPOSAL_ID	NUMBER	(15)	Proposal identifier
PROPOSAL_NUMBER	VARCHAR2	(30)	Proposal number
PERSON_ID	VARCHAR2	(60)	Person identifier
PERSON_PARTY_ID	NUMBER	(15)	Person party identifier
PROPOSAL_ROLE_CODE	VARCHAR2	(30)	Role of person on proposal
FIRST_NAME	VARCHAR2	(150)	Person's first name
MIDDLE_NAMES	VARCHAR2	(60)	Person's middle names
LAST_NAME	VARCHAR2	(150)	Person's last name
FULL_NAME	VARCHAR2	(450)	Person's full name
TITLE	VARCHAR2	(30)	Person's title
SUFFIX	VARCHAR2	(30)	Suffix used by the person
LAST_FIRST_MIDDLE_NAME	VARCHAR2	(364)	Person's name in last, first, and middle format
FIRST_MIDDLE_LAST_NAME	VARCHAR2	(393)	Person's name in first, middle, and last format
ORGANIZATION_NAME	CHAR	(14)	Applicant organization
ROLE_NAME	VARCHAR2	(13)	Role of person on the proposal
DEGREES	VARCHAR2	(14)	Degrees earned by the person
JOB_NAME	VARCHAR2	(9)	Person's job title
BIRTH_DATE	DATE		Person's date of birth
SSN	VARCHAR2	(30)	Person's social security number
PI_FLAG	VARCHAR2	(1)	Proposal Manager indicator. Possible values are Y or N.
KEY_PERSON_FLAG	VARCHAR2	(1)	Flag indicates whether the person has a key responsibility in the proposal. Possible values are Y or N.
PERCENT_EFFORT	NUMBER		Percentage of time that person devotes to the proposal
SEX	VARCHAR2	(30)	Sex
EMAIL_ADDRESS	VARCHAR2	(2000)	Email Address
WORK_PHONE	VARCHAR2	(50)	Work Phone
WORK_FAX	CHAR	(4)	Work Fax Number
ADDRESS_LINE_1	VARCHAR2	(240)	First Address Line
ADDRESS_LINE_2	VARCHAR2	(240)	Second Address Line
ADDRESS_LINE_3	VARCHAR2	(240)	Third Address Line
TOWN_OR_CITY	VARCHAR2	(60)	Town or City
STATE	VARCHAR2	(120)	State
POSTAL_CODE	VARCHAR2	(60)	Postal Code

Query Text

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


SELECT PROPOSAL_ID
,      PROPOSAL_NUMBER
,      PERSON_ID
,      PERSON_PARTY_ID
,      PROPOSAL_ROLE_CODE
,      FIRST_NAME
,      MIDDLE_NAMES
,      LAST_NAME
,      FULL_NAME
,      TITLE
,      SUFFIX
,      LAST_FIRST_MIDDLE_NAME
,      FIRST_MIDDLE_LAST_NAME
,      ORGANIZATION_NAME
,      ROLE_NAME
,      DEGREES
,      JOB_NAME
,      BIRTH_DATE
,      SSN
,      PI_FLAG
,      KEY_PERSON_FLAG
,      PERCENT_EFFORT
,      SEX
,      EMAIL_ADDRESS
,      WORK_PHONE
,      WORK_FAX
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      STATE
,      POSTAL_CODE
FROM APPS.IGW_PROPOSAL_PERSONS_V;

Dependencies

[top of page]

APPS.IGW_PROPOSAL_PERSONS_V references the following:

APPS: HR_GENERAL - show dependent code; HR_LOCATIONS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; HZ_PARTIES; HZ_PERSON_PROFILES; IGW_PROPOSALS_ALL; IGW_PROP_PERSONS; PER_ASSIGNMENTS_X; PER_PEOPLE_X

APPS.IGW_PROPOSAL_PERSONS_V is not referenced by any database object