[Home] [Help]
[Dependency Information]
Object Name: | IGF_AW_PER_LIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Stores person details used for correspondence
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Party identifier, This field is used by the system internally for identification |
PARTY_NAME | VARCHAR2 | (360) | Yes | Name of this party |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number for this party |
PARTY_TYPE | VARCHAR2 | (30) | Yes | The party type can only be Person, Organization, Group or Relationship. |
ADDRESS_LINE1 | VARCHAR2 | (240) | First line of the Identifying address | |
ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of the Identifying address | |
ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of the Identifying address | |
ADDRESS_LINE4 | VARCHAR2 | (240) | Fourth line of the Identifying address | |
ANALYSIS_FY | VARCHAR2 | (5) | Fiscal year that financial information is based on | |
CATEGORY_CODE | VARCHAR2 | (30) | User-definable category. Lookup type is CUSTOMER_CATEGORY | |
CITY | VARCHAR2 | (60) | City of the Identifying address | |
COMPETITOR_FLAG | VARCHAR2 | (1) | Indicates if a party is a competitor. Y for a party that is a competitor, N or null for a party that is not a competitor | |
COUNTRY | VARCHAR2 | (60) | The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address. | |
COUNTY | VARCHAR2 | (60) | County of the Identifying address | |
CURR_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue this fiscal year | ||
CUSTOMER_KEY | VARCHAR2 | (500) | Derived key used to facilitate fuzzy searches | |
DO_NOT_MAIL_FLAG | VARCHAR2 | (1) | No longer used | |
DUNS_NUMBER | NUMBER | The DUNS number, a unique, nine-digit identification number assigned to business entities by Dun & Bradstreet | ||
EMAIL_ADDRESS | VARCHAR2 | (2000) | E-mail address | |
EMPLOYEES_TOTAL | NUMBER | Total number of employees | ||
FISCAL_YEAREND_MONTH | VARCHAR2 | (30) | Month in which fiscal year ends for organization | |
GROUP_TYPE | VARCHAR2 | (30) | Lookup for group type | |
GSA_INDICATOR_FLAG | VARCHAR2 | (1) | Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA. | |
HQ_BRANCH_IND | VARCHAR2 | (30) | Status of this site. Identifies if the location is the headquarters, a branch, or a single location. | |
JGZZ_FISCAL_CODE | VARCHAR2 | (20) | Taxpayer identification number. Used in Europe to identify customers. Also known as the fiscal code or NIF. | |
PREFERRED_GIVEN_NAME | VARCHAR2 | (240) | An alias or other name by which a party is known | |
KNOWN_AS2 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
KNOWN_AS3 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
KNOWN_AS4 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
KNOWN_AS5 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
LANGUAGE_NAME | VARCHAR2 | (4) | Standard name for a language | |
LAST_ORDERED_DATE | DATE | Date of the most recent order | ||
MISSION_STATEMENT | VARCHAR2 | (2000) | Corporate charter of organization | |
NEXT_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for next fiscal year | ||
ORGANIZATION_NAME_PHONETIC | VARCHAR2 | (320) | Japanese Kana, or phonetic representation of organization name | |
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Yes | Customer identifier from foreign system. May not be unique. |
PERSON_ACADEMIC_TITLE | VARCHAR2 | (30) | Academic title that is part of a person's name, such as Dr. John Smith. | |
GIVEN_NAMES | VARCHAR2 | (150) | First name of the person | |
PERSON_FIRST_NAME_PHONETIC | VARCHAR2 | (60) | Phonetic representation of the person's first name | |
PERSON_IDEN_TYPE | VARCHAR2 | (30) | Lookup representing most common personal identification number in a country. For example, Social Security Number in the US | |
PERSON_IDENTIFIER | VARCHAR2 | (60) | Identity reference field for things like Social Security, tax identity number, or driver's license number. | |
SURNAME | VARCHAR2 | (150) | Last or surname of the person | |
PERSON_LAST_NAME_PHONETIC | VARCHAR2 | (60) | Phonetic representation of the person's last name | |
MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the person | |
SUFFIX | VARCHAR2 | (30) | Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix. | |
PREFIX | VARCHAR2 | (30) | Salutary introduction, such as Mr. or Herr | |
PERSON_PREVIOUS_LAST_NAME | VARCHAR2 | (150) | Previous last or surname of the person | |
TITLE | VARCHAR2 | (60) | A professional or family title. For example, Don or The Right Honorable. | |
POSTAL_CODE | VARCHAR2 | (60) | Postal Code of the Identifying address | |
PROVINCE | VARCHAR2 | (60) | Province of the Identifying address | |
REFERENCE_USE_FLAG | VARCHAR2 | (1) | Indicates if customer has agreed to be a reference. Y for customer who is referencable, N or null for a nonreferencable customer | |
SALUTATION | VARCHAR2 | (60) | Phrase used to address a party in any correspondence. | |
SIC_CODE | VARCHAR2 | (30) | Standard Industry Classification (SIC) code | |
SIC_CODE_TYPE | VARCHAR2 | (30) | Version of Standard Industry Classification (SIC) code | |
STATE | VARCHAR2 | (60) | State of the Identifying address | |
STATUS | VARCHAR2 | (1) | Yes | Party status flag. |
TAX_NAME | VARCHAR2 | (60) | No longer used | |
TAX_REFERENCE | VARCHAR2 | (50) | Taxpayer registration number, also known as the VAT number. | |
THIRD_PARTY_FLAG | VARCHAR2 | (1) | Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory. | |
TOTAL_NUM_OF_ORDERS | NUMBER | Total number of orders through the last ordered date | ||
TOTAL_ORDERED_AMOUNT | NUMBER | Total amount ordered through the last ordered date | ||
URL | VARCHAR2 | (2000) | Uniform resource locator | |
VALIDATED_FLAG | VARCHAR2 | (1) | Indicates if the party was validated. Y for a validated party, N for a party that is not validated. | |
WH_UPDATE_DATE | DATE | No longer used | ||
YEAR_ESTABLISHED | NUMBER | (4) | Year that the organization began doing business | |
PERSON_SSN | VARCHAR2 | (20) | Person SSN Number | |
AWARD_YEAR | VARCHAR2 | (17) | Award Year |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, PARTY_NAME
, PERSON_NUMBER
, PARTY_TYPE
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, ADDRESS_LINE4
, ANALYSIS_FY
, CATEGORY_CODE
, CITY
, COMPETITOR_FLAG
, COUNTRY
, COUNTY
, CURR_FY_POTENTIAL_REVENUE
, CUSTOMER_KEY
, DO_NOT_MAIL_FLAG
, DUNS_NUMBER
, EMAIL_ADDRESS
, EMPLOYEES_TOTAL
, FISCAL_YEAREND_MONTH
, GROUP_TYPE
, GSA_INDICATOR_FLAG
, HQ_BRANCH_IND
, JGZZ_FISCAL_CODE
, PREFERRED_GIVEN_NAME
, KNOWN_AS2
, KNOWN_AS3
, KNOWN_AS4
, KNOWN_AS5
, LANGUAGE_NAME
, LAST_ORDERED_DATE
, MISSION_STATEMENT
, NEXT_FY_POTENTIAL_REVENUE
, ORGANIZATION_NAME_PHONETIC
, ORIG_SYSTEM_REFERENCE
, PERSON_ACADEMIC_TITLE
, GIVEN_NAMES
, PERSON_FIRST_NAME_PHONETIC
, PERSON_IDEN_TYPE
, PERSON_IDENTIFIER
, SURNAME
, PERSON_LAST_NAME_PHONETIC
, MIDDLE_NAME
, SUFFIX
, PREFIX
, PERSON_PREVIOUS_LAST_NAME
, TITLE
, POSTAL_CODE
, PROVINCE
, REFERENCE_USE_FLAG
, SALUTATION
, SIC_CODE
, SIC_CODE_TYPE
, STATE
, STATUS
, TAX_NAME
, TAX_REFERENCE
, THIRD_PARTY_FLAG
, TOTAL_NUM_OF_ORDERS
, TOTAL_ORDERED_AMOUNT
, URL
, VALIDATED_FLAG
, WH_UPDATE_DATE
, YEAR_ESTABLISHED
, PERSON_SSN
, AWARD_YEAR
FROM APPS.IGF_AW_PER_LIST_V;
APPS.IGF_AW_PER_LIST_V is not referenced by any database object
|
|
|