[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_DISB_LTR_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGF_SL_DISB_LTR_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Stores persons loan details used for correspondence
| 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 | This field used in TCA to distinguish the party_id's i.e. if the party_id is for a PERSON, ORGANIZATION or PARTY_RELATIONSHIP. This field would always return 'PERSON' as it's value, in this case |
| 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 String for Award Calendar & Sequence Number | |
| CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Award Calendar Type |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Award Calendar Instance |
| AWARD_YEAR_ALTERNATE_CODE | VARCHAR2 | (10) | Alternate Code for Award Year | |
| LETTER_ID | VARCHAR2 | (34) | Letter Identifier | |
| DISB_NAME | VARCHAR2 | (80) | Disbursement Description | |
| DISB_AMT | NUMBER | Disbursement Amount | ||
| DISB_DATE | VARCHAR2 | (11) | Disbursement Date |
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
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, AWARD_YEAR_ALTERNATE_CODE
, LETTER_ID
, DISB_NAME
, DISB_AMT
, DISB_DATE
FROM APPS.IGF_SL_DISB_LTR_V;
APPS
HZ_PARTIES
IGF_AP_FA_BASE_REC_ALL
IGF_AW_AWARD_ALL
IGF_AW_FUND_CAT_ALL
IGF_AW_FUND_MAST_ALL
IGF_DB_AWD_DISB_DTL_ALL
IGF_GR_GEN
- show dependent code
IGS_CA_INST_ALL
IGS_CO_GEN_003
- show dependent code
IGS_PE_ALT_PERS_ID
IGS_PE_HZ_PARTIES
IGS_PE_PERSON_ID_TYP
APPS
IGS_CO_SUBMIT
- show dependent code
|
|
|
|