[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_MIS_ITMS_LTR_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGF_AP_MIS_ITMS_LTR_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used to return the missing items (missing documents) which are required for Financial Aid processing
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Party identifier |
| 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 | |
| PERSON_NAME_ADDRESS | VARCHAR2 | (4000) | Concatenated field which includes the Address Lines , postal code , city and the country | |
| 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) | Field returns the flag as 'Y' or 'N' . If 'N' the mail can be sent to the student else no mail is to be sent to the student | |
| DUNS_NUMBER | NUMBER | The DUNS number, a unique, nine-digit identification number assigned to business entities by Dun & Bradstreet | ||
| EMAIL_ADDRESS | VARCHAR2 | (2000) | This field contains the e-mail address of the student | |
| EMPLOYEES_TOTAL | NUMBER | Total number of employees in an Organization | ||
| 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) | Provides the fiscal code for an organization. This code is used in some European countries | |
| 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) | This field contains the mission statement of the 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 | Unique party identifier from foreign or legacy system |
| 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 referenceable,N or null for a nonreferenceable 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) | The name for the party that is recognized by the tax authority | |
| TAX_REFERENCE | VARCHAR2 | (50) | Taxpayer identification 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 | Date when the record was entered or changed in a data warehouse | ||
| YEAR_ESTABLISHED | NUMBER | (4) | Year that the organization began doing business | |
| PERSON_SSN | VARCHAR2 | (20) | Person SSN Number | |
| TODAYS_DATE | VARCHAR2 | (16) | Today's Date | |
| AWARD_YEAR | VARCHAR2 | (4000) | Concatenated field which includes the Award Calendar Type and the Calendar Instance sequence number | |
| LETTER_ID | VARCHAR2 | (33) | Letter Identification | |
| ITEM_CODE | VARCHAR2 | (10) | Yes | Item Code for the item's in the to do table |
| ITEM_MESSAGE | VARCHAR2 | (240) | Correspondence Message | |
| CUSTOM_TEXT | VARCHAR2 | (4000) | Customized Text | |
| CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Award Calendar Type |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Award Calendar Instance |
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
, PERSON_NAME_ADDRESS
, 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
, TODAYS_DATE
, AWARD_YEAR
, LETTER_ID
, ITEM_CODE
, ITEM_MESSAGE
, CUSTOM_TEXT
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
FROM APPS.IGF_AP_MIS_ITMS_LTR_V;
APPS
HZ_PARTIES
IGF_AP_FA_BASE_REC_ALL
IGF_AP_ST_CORR_TEXT
IGF_AP_TD_ITEM_INST_ALL
IGF_AP_TD_ITEM_MST_ALL
IGF_AW_GEN_004
- show dependent code
IGF_GR_GEN
- show dependent code
IGS_CO_GEN_003
- show dependent code
IGS_PE_ALT_PERS_ID
IGS_PE_HZ_PARTIES
IGS_PE_PERSON_ID_TYP
APPS
IGF_AW_GEN_004
- show dependent code
|
|
|
|