[Home] [Help] [Dependency Information]
Object Name: | IGW_PI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGW.IGW_PI_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
IGW_PI_V displays details of the Proposal Manager. Details include name, address, gender, degrees, date of birth, social security number, and job name.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPOSAL_ID | NUMBER | (15) | Yes | Proposal identifier |
PROPOSAL_NUMBER | VARCHAR2 | (30) | Yes | Proposal number |
ORGANIZATION_ID | NUMBER | (15) | Organization identifier | |
PROPOSAL_TYPE_CODE | VARCHAR2 | (30) | Yes | Proposal type code |
ORIGINAL_PROPOSAL_NUMBER | VARCHAR2 | (30) | Original proposal number | |
AWARD_NUMBER | VARCHAR2 | (15) | Award number | |
PERSON_ID | NUMBER | (10) | Yes | Person identifier |
FULL_NAME | VARCHAR2 | (240) | Full name | |
LAST_NAME | VARCHAR2 | (150) | Yes | Last name |
FIRST_NAME | VARCHAR2 | (150) | First name | |
MIDDLE_NAMES | VARCHAR2 | (60) | Middle name | |
TITLE | VARCHAR2 | (30) | Title, such as Mr., Mrs., or Dr. | |
SUFFIX | VARCHAR2 | (30) | Suffix after the last name, such as Sr., or Jr. | |
LAST_FIRST_MIDDLE_NAME | VARCHAR2 | (363) | Last name, first name, and middle name of the Adminstrative Offical. Names are separated with commas. | |
FIRST_MIDDLE_LAST_NAME | VARCHAR2 | (393) | First name, middle name, and last name. Names are separated with commas. | |
DATE_OF_BIRTH | DATE | Date of birth | ||
NATIONAL_IDENTIFIER | VARCHAR2 | (30) | Social security number | |
SEX | VARCHAR2 | (30) | Gender | |
ETHNIC_GROUP | VARCHAR2 | (80) | Ethnic group | |
JOB_NAME | VARCHAR2 | (4000) | Job name | |
DEGREES | VARCHAR2 | (4000) | Degrees. Only the first three degrees are displayed. | |
ADDRESS_LINE1 | VARCHAR2 | (240) | First address line | |
ADDRESS_LINE2 | VARCHAR2 | (240) | Second address line | |
ADDRESS_LINE3 | VARCHAR2 | (240) | Third address line | |
POSTAL_CODE | VARCHAR2 | (30) | Postal code | |
REGION_1 | VARCHAR2 | (120) | Primary region in which address is located | |
REGION_2 | VARCHAR2 | (120) | Subregion of Region 1 in which address is located | |
REGION_3 | VARCHAR2 | (120) | Subregion of Region 2 in which address is located | |
TOWN_OR_CITY | VARCHAR2 | (30) | Town or city | |
WORK_PHONE | VARCHAR2 | (4000) | Work phone | |
WORK_FAX | VARCHAR2 | (4000) | Work fax | |
EMAIL_ADDRESS | VARCHAR2 | (240) | E-mail address |
Cut, paste (and edit) the following text to query this object:
SELECT PROPOSAL_ID
, PROPOSAL_NUMBER
, ORGANIZATION_ID
, PROPOSAL_TYPE_CODE
, ORIGINAL_PROPOSAL_NUMBER
, AWARD_NUMBER
, PERSON_ID
, FULL_NAME
, LAST_NAME
, FIRST_NAME
, MIDDLE_NAMES
, TITLE
, SUFFIX
, LAST_FIRST_MIDDLE_NAME
, FIRST_MIDDLE_LAST_NAME
, DATE_OF_BIRTH
, NATIONAL_IDENTIFIER
, SEX
, ETHNIC_GROUP
, JOB_NAME
, DEGREES
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, POSTAL_CODE
, REGION_1
, REGION_2
, REGION_3
, TOWN_OR_CITY
, WORK_PHONE
, WORK_FAX
, EMAIL_ADDRESS
FROM APPS.IGW_PI_V;
APPS.IGW_PI_V is not referenced by any database object
|
|
|