[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_LOR_DTLS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGF_SL_LOR_DTLS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Obsolete
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LAR_ROWID | ROWID | (10) | Row identifier for loan application record | |
| LOAN_ID | NUMBER | (15) | Yes | Identifier for loans |
| BASE_ID | NUMBER | (10) | Yes | Identifier for student financial aid record |
| AWARD_ID | NUMBER | (15) | Yes | Identifier for award |
| STUDENT_ID | NUMBER | (15) | Yes | Person identifier |
| FUND_ID | NUMBER | (15) | Yes | Identifier for fund |
| SEQ_NUM | NUMBER | (15) | Indicates number of loans of current system loan type for current processing year | |
| LOR_ROWID | ROWID | (10) | Row identifier for originated loan | |
| ORIGINATION_ID | NUMBER | (15) | Yes | Identifier for loan origination |
| LOAN_NUMBER | VARCHAR2 | (30) | Unique identifier for Direct Loan or CommonLine loan | |
| CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calender type. Used within operating unit. |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates unique identifier for award year calender instance |
| CI_START_DT | DATE | Yes | Indicates award year start date | |
| CI_END_DT | DATE | Yes | Indicates award year end date | |
| CI_ALTERNATE_CODE | VARCHAR2 | (10) | Indicates alternate short reference code for identifying award year calendar instance | |
| LOAN_TYPE | VARCHAR2 | (30) | Yes | Indicates loan type |
| LOAN_TYPE_NUM | VARCHAR2 | (70) | Indicates number of loans of particular type given to student within year | |
| FUND_SOURCE | VARCHAR2 | (30) | Yes | Indicates unique code for each fund source |
| FUND_TYPE | VARCHAR2 | (30) | Yes | Indicates classification of fund |
| SYS_FUND_TYPE | VARCHAR2 | (30) | Yes | Indicates seeded system fund type |
| FED_FUND_CODE | VARCHAR2 | (30) | Yes | Indicates federal fund code |
| LOAN_AMT_OFFERED | NUMBER | (12) | Indicates loan amount offered | |
| LOAN_AMT_ACCEPTED | NUMBER | (12) | Indicates loan amount accepted | |
| LOAN_PER_BEGIN_DATE | DATE | Yes | Indicates loan period begin date | |
| LOAN_PER_END_DATE | DATE | Yes | Indicates loan period end date | |
| LOAN_STATUS | VARCHAR2 | (30) | Yes | Indicates loan status |
| LOAN_STATUS_DATE | DATE | Indicates date on which loan status changed | ||
| LOAN_CHG_STATUS | VARCHAR2 | (30) | Indicates whether loan changes are pending | |
| LOAN_CHG_STATUS_DATE | DATE | Indicates date on which loan change status changed | ||
| ACTIVE | VARCHAR2 | (1) | Yes | Indicator that specifies whether loan is active. Setting check box to inactive prevents use of loan in new or modified records. |
| ACTIVE_DATE | DATE | Yes | Indicates date on which loan was activated or inactivated | |
| BORW_DETRM_CODE | VARCHAR2 | (30) | For borrower's determination for payee for the excess credit amount.Valid values are Pay to Borrower,Pay to Student and Place on Account | |
| BORW_DETRM | VARCHAR2 | (80) | Description of borrower determination code. | |
| SCH_CERT_DATE | DATE | Indicates date on which school certified loan | ||
| ORIG_STATUS_FLAG | VARCHAR2 | (30) | Indicates loan origination status | |
| ORIG_BATCH_ID | VARCHAR2 | (40) | Indicates batch identifier for loan originated | |
| ORIG_BATCH_DATE | DATE | Indicates date on which loan originated | ||
| CHG_BATCH_ID | VARCHAR2 | (0) | Batch identifier for loan origination details changes | |
| ORIG_ACK_DATE | DATE | Indicates date on which origination acknowledgement was received from external processor | ||
| CREDIT_OVERRIDE | VARCHAR2 | (30) | Indicates credit decision returned by external processor | |
| CREDIT_DECISION_DATE | DATE | Indicates last date on which credit decision was updated | ||
| REQ_SERIAL_LOAN_CODE | VARCHAR2 | (30) | Indicates serial loan code requested by student | |
| ACT_SERIAL_LOAN_CODE | VARCHAR2 | (30) | Indicates serial loan code requested by student | |
| PNOTE_DELIVERY_CODE | VARCHAR2 | (30) | Indicates promissory note delivery code | |
| PNOTE_STATUS | VARCHAR2 | (30) | Indicates promissory note status | |
| PNOTE_STATUS_DATE | DATE | Indicates date on which promissory note status was changed by service provider | ||
| PNOTE_ID | VARCHAR2 | (30) | Identifier for promissory note status | |
| PNOTE_PRINT_IND | VARCHAR2 | (30) | Indicates promissory note print indicator | |
| PNOTE_ACCEPT_AMT | NUMBER | (12) | Indicates total anticipated disbursement gross amount | |
| PNOTE_ACCEPT_DATE | DATE | Indicates date on which total anticipated disbursement gross amount was accepted | ||
| PNOTE_BATCH_ID | VARCHAR2 | (40) | Promissory Note Batch Identifier | |
| PNOTE_ACK_DATE | DATE | Promissory Note Acknowledgement Date | ||
| PNOTE_MPN_IND | VARCHAR2 | (30) | Master Promissory Note Indicator | |
| UNSUB_ELIG_FOR_HEAL | VARCHAR2 | (30) | Indicates that student is eligible for additional unsubsidized funds in case of health professions | |
| DISCLOSURE_PRINT_IND | VARCHAR2 | (30) | Indicates whether LOC should print disclosure | |
| ORIG_FEE_PERCT | NUMBER | (6) | Indicates origination fee percentage | |
| BORW_CONFIRM_IND | VARCHAR2 | (30) | Indicates borrower's loan confirmation | |
| BORW_INTEREST_IND | VARCHAR2 | (30) | Indicates whether borrower intends to pay interest on loan while in school, grace, or deferment | |
| BORW_OUTSTD_LOAN_CODE | VARCHAR2 | (30) | Indicates whether borrower has outstanding federal student loans | |
| UNSUB_ELIG_FOR_DEPNT | VARCHAR2 | (30) | Indicates student is eligible for additional unsubsidized funds | |
| GUARANTEE_AMT | NUMBER | (12) | Indicates guarantee amount | |
| GUARANTEE_DATE | DATE | Indicates guarantee date | ||
| GUARNT_AMT_REDN_CODE | VARCHAR2 | (10) | Indicates whether guarantee fee was reduced from loan amount requested or school certified loan | |
| GUARNT_STATUS_CODE | VARCHAR2 | (30) | Indicates status of loan with respect to lender | |
| GUARNT_STATUS_DATE | DATE | Indicates date on which guarantee status was changed by service provider | ||
| LEND_APPRV_DENIED_CODE | VARCHAR2 | (30) | Indicates whether lender approved or denied loan | |
| LEND_APPRV_DENIED_DATE | DATE | Indicates date on which lender approved or denied loan | ||
| LEND_STATUS_CODE | VARCHAR2 | (30) | Indicates loan status with respect to lender | |
| LEND_STATUS_DATE | DATE | Indicates date on which lender status was changed by service provider | ||
| GUARNT_ADJ_IND | VARCHAR2 | (30) | Indicates whether guarantee amount has been adjusted and is different from school amount | |
| GRADE_LEVEL_CODE | VARCHAR2 | (30) | Indicates student's grade level code at time loan originated | |
| ENROLLMENT_CODE | VARCHAR2 | (30) | Indicates student's enrollment status at time loan originated | |
| ANTICIP_COMPL_DATE | DATE | Indicates anticipated date student will complete program at school | ||
| BORW_LENDER_ID | VARCHAR2 | (0) | Identifier for lender either by default or as chosen by borrower | |
| DUNS_BORW_LENDER_ID | VARCHAR2 | (0) | Indicates DUNS number assigned by US Department of Education to borrower's lender | |
| GUARANTOR_ID | VARCHAR2 | (0) | Indicates guarantor identifier for borrower's lender | |
| DUNS_GUARNT_ID | VARCHAR2 | (0) | Indicates DUNS number assigned by US Department of Education to guarantor | |
| PRC_TYPE_CODE | VARCHAR2 | (30) | Indicates processing type for CommonLine loan | |
| CL_SEQ_NUMBER | NUMBER | (15) | Indicates value assigned by guarantor at time of guarantee or by lender in case of blanket guarantee for CommonLine loan | |
| LAST_RESORT_LENDER | VARCHAR2 | (30) | Indicates whether lender is eligible lender of last resort for which value is updated by service provider | |
| LENDER_ID | VARCHAR2 | (0) | Indicates unique 6-character identification code assigned by US Department of Education to lender associated with loan as reported by borrower | |
| DUNS_LENDER_ID | VARCHAR2 | (0) | Indicates DUNS number assigned to lender by US Department of Education | |
| LEND_NON_ED_BRC_ID | VARCHAR2 | (0) | Indicates unique identification code assigned by entity other than US Department of Education to lender's branch office | |
| RECIPIENT_ID | VARCHAR2 | (0) | Identifier for recipient | |
| RECIPIENT_TYPE | VARCHAR2 | (0) | Indicates recipient type | |
| DUNS_RECIP_ID | VARCHAR2 | (0) | Indicates DUNS number assigned by US Department of Education to recipien | |
| RECIP_NON_ED_BRC_ID | VARCHAR2 | (0) | Indicates unique identification code assigned by entity other than US Department of Education to branch office receiving file | |
| REC_TYPE_IND | VARCHAR2 | (30) | Indicates application type of loan record | |
| CL_LOAN_TYPE | VARCHAR2 | (30) | Indicates CommonLine loan type requested by borrower | |
| CL_REC_STATUS | VARCHAR2 | (30) | Indicates type of record or status of CommonLine loan or application | |
| CL_REC_STATUS_LAST_UPDATE | DATE | Indicates date on which CommonLine loan status was last updated by external processor | ||
| ALT_PROG_TYPE_CODE | VARCHAR2 | (30) | Indicates specific category of alternative loans | |
| ALT_APPL_VER_CODE | NUMBER | (15) | Indicates version of alternate loan | |
| MPN_CONFIRM_CODE | VARCHAR2 | (30) | Indicates that service provider can confirm that valid master promissory note exists at time of certification | |
| RESP_TO_ORIG_CODE | VARCHAR2 | (30) | Indicates record is sent to originator in response to originator's application send record | |
| APPL_LOAN_PHASE_CODE | VARCHAR2 | (30) | Indicates application status | |
| APPL_LOAN_PHASE_CODE_CHG | DATE | Indicates date on which application or loan phase code was last updated | ||
| APPL_SEND_ERROR_CODES | VARCHAR2 | (0) | Indicates error codes experienced while processing application send record | |
| TOT_OUTSTD_STAFFORD | NUMBER | (12) | Indicates total amount of outstanding Stafford or supplemental loan for students as known by sender | |
| TOT_OUTSTD_PLUS | NUMBER | (12) | Indicates total amount of outstanding PLUS as known by sender | |
| ALT_BORW_TOT_DEBT | NUMBER | (12) | Indicates total debt of alternative loan for borrower | |
| ACT_INTEREST_RATE | NUMBER | (12) | Indicates latest interest rate of loan while student is still enrolled in school | |
| SERVICE_TYPE_CODE | VARCHAR2 | (10) | Indicates how disbursement funds are handled for CommonLine loans | |
| REV_NOTICE_OF_GUARNT | VARCHAR2 | (30) | Indicates whether revised notice of guarantee is issued to borrower | |
| SCH_REFUND_AMT | NUMBER | (12) | Indicates total amount of loan refunded by school. Amount must be cumulative and should be updated each time school refund occurs, if applicable, but does not include cancellations. | |
| SCH_REFUND_DATE | DATE | Indicates effective date of refund to lender | ||
| UNIQ_LAYOUT_VEND_CODE | VARCHAR2 | (30) | Indicates vendor who owns unique field layout included for CommonLine loan | |
| UNIQ_LAYOUT_IDENT_CODE | VARCHAR2 | (30) | Indicates vendor who owns unique field layout included for CommonLine loan | |
| P_PERSON_ID | NUMBER | (15) | Identifier for parent or alternate borrower from TCA | |
| P_SSN | VARCHAR2 | (20) | Indicates parent borrower's SSN | |
| P_SSN_CHG_DATE | VARCHAR2 | (0) | Indicates date on which parent borrower's SSN last changed | |
| P_LAST_NAME | VARCHAR2 | (150) | Indicates parent borrower's last name | |
| P_FIRST_NAME | VARCHAR2 | (150) | Indicates parent borrower's first name | |
| P_MIDDLE_NAME | VARCHAR2 | (60) | Indicates parent borrower's middle name | |
| P_FULL_NAME | VARCHAR2 | (450) | Indicates parent borrower's full name | |
| P_PERMT_ADDR1 | VARCHAR2 | (240) | Indicates parent borrower's permanent address line 1 | |
| P_PERMT_ADDR2 | VARCHAR2 | (240) | Indicates parent borrower's permanent address line 2 | |
| P_PERMT_CITY | VARCHAR2 | (60) | Indicates parent borrower's permanent city | |
| P_PERMT_STATE | VARCHAR2 | (60) | Indicates parent borrower's permanent state | |
| P_PERMT_ZIP | VARCHAR2 | (60) | Indicates 5-digit zip code of parent borrower's permanent address | |
| P_PERMT_ADDR_CHG_DATE | DATE | Indicates date on which parent borrower's permanent address last changed | ||
| P_EMAIL_ADDR | VARCHAR2 | (2000) | Indicates parent borrower's e-mail address | |
| P_DATE_OF_BIRTH | DATE | Indicates parent borrower's date of birth | ||
| P_DOB_CHG_DATE | VARCHAR2 | (0) | Indicates date on which parent borrower's date of birth last changed | |
| P_DEFAULT_STATUS | VARCHAR2 | (30) | Indicates parent borrower's default or refund status on Title IV loans | |
| P_LICENSE_NUM | VARCHAR2 | (60) | Indicates parent borrower's license number | |
| P_LICENSE_STATE | VARCHAR2 | (30) | Indicates state which issued license to parent borrower | |
| P_CITIZENSHIP_STATUS | VARCHAR2 | (30) | Indicates parent borrower's citizenship status | |
| P_ALIEN_REG_NUM | VARCHAR2 | (30) | Indicates parent borrower's alien registration number or passport number | |
| P_STATE_OF_LEGAL_RES | VARCHAR2 | (30) | Indicates parent borrower's state of legal residence | |
| P_LEGAL_RES_DATE | DATE | Indicates date when parent borrower became legal resident | ||
| P_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates whether parent borrower signed note | |
| P_SIGNATURE_DATE | DATE | Indicates date school received signed promissory note | ||
| S_SSN | VARCHAR2 | (20) | Indicates student borrower's SSN | |
| S_SSN_CHG_DATE | VARCHAR2 | (0) | Indicates date on which student borrower's SSN last changed | |
| S_LAST_NAME | VARCHAR2 | (150) | Indicates student borrower's last name | |
| S_FIRST_NAME | VARCHAR2 | (150) | Indicates student borrower's first name | |
| S_MIDDLE_NAME | VARCHAR2 | (60) | Indicates student borrower's middle name | |
| S_FULL_NAME | VARCHAR2 | (450) | Indicates student borrower's full name | |
| S_PERMT_ADDR1 | VARCHAR2 | (240) | Indicates student borrower's permanent address line 1 | |
| S_PERMT_ADDR2 | VARCHAR2 | (240) | Indicates student borrower's permanent address line 2 | |
| S_PERMT_CITY | VARCHAR2 | (60) | Indicates student borrower's permanent address city | |
| S_PERMT_STATE | VARCHAR2 | (60) | Indicates student borrower's permanent address state | |
| S_PERMT_ZIP | VARCHAR2 | (60) | Indicates 5-digit zip code of student borrower's permanent address | |
| S_PERMT_ADDR_CHG_DATE | DATE | Indicates date on which student borrower's permanent address last changed | ||
| S_LOCAL_ADDR1 | VARCHAR2 | (240) | Indicates student borrower's local address line 1 | |
| S_LOCAL_ADDR2 | VARCHAR2 | (240) | Indicates student borrower's local address line 2 | |
| S_LOCAL_CITY | VARCHAR2 | (60) | Indicates student borrower's local address city | |
| S_LOCAL_STATE | VARCHAR2 | (60) | Indicates student borrower's permanent address state | |
| S_LOCAL_ZIP | VARCHAR2 | (60) | Indicates 5-digit zip code of student borrower's local address | |
| S_LOCAL_ADDR_CHG_DATE | VARCHAR2 | (0) | Indicates date on which student borrower's local address last changed | |
| S_EMAIL_ADDR | VARCHAR2 | (2000) | Indicates student borrower's e-mail address | |
| S_DATE_OF_BIRTH | DATE | Indicates student borrower's date of birth | ||
| S_DOB_CHG_DATE | VARCHAR2 | (0) | Indicates date on which student borrower's date of birth last changed | |
| S_DEFAULT_STATUS | VARCHAR2 | (30) | Indicates student borrower's default or refund status on Title IV loans | |
| S_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates whether student signed note | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| PROGRAM_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent programs | ||
| LOAN_AMT_PAID | NUMBER | (12) | Indicates the Loan Paid Amount | |
| ELEC_MPN_IND | VARCHAR2 | (30) | Indicates if there is any Electronic Master Promissory Note | |
| BORR_SIGN_IND | VARCHAR2 | (30) | Indicates if the Loan Borrower has signed the Promissory Note | |
| STUD_SIGN_IND | VARCHAR2 | (30) | Indicates if the Student for whom the Loan is borrowed has signed the Promissory Note. | |
| BORR_CREDIT_AUTH_CODE | VARCHAR2 | (30) | Indicates if the Borrower has given authentication to check his / her Credit Status before a Loan is guaranteed. |
Cut, paste (and edit) the following text to query this object:
SELECT LAR_ROWID
, LOAN_ID
, BASE_ID
, AWARD_ID
, STUDENT_ID
, FUND_ID
, SEQ_NUM
, LOR_ROWID
, ORIGINATION_ID
, LOAN_NUMBER
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, CI_START_DT
, CI_END_DT
, CI_ALTERNATE_CODE
, LOAN_TYPE
, LOAN_TYPE_NUM
, FUND_SOURCE
, FUND_TYPE
, SYS_FUND_TYPE
, FED_FUND_CODE
, LOAN_AMT_OFFERED
, LOAN_AMT_ACCEPTED
, LOAN_PER_BEGIN_DATE
, LOAN_PER_END_DATE
, LOAN_STATUS
, LOAN_STATUS_DATE
, LOAN_CHG_STATUS
, LOAN_CHG_STATUS_DATE
, ACTIVE
, ACTIVE_DATE
, BORW_DETRM_CODE
, BORW_DETRM
, SCH_CERT_DATE
, ORIG_STATUS_FLAG
, ORIG_BATCH_ID
, ORIG_BATCH_DATE
, CHG_BATCH_ID
, ORIG_ACK_DATE
, CREDIT_OVERRIDE
, CREDIT_DECISION_DATE
, REQ_SERIAL_LOAN_CODE
, ACT_SERIAL_LOAN_CODE
, PNOTE_DELIVERY_CODE
, PNOTE_STATUS
, PNOTE_STATUS_DATE
, PNOTE_ID
, PNOTE_PRINT_IND
, PNOTE_ACCEPT_AMT
, PNOTE_ACCEPT_DATE
, PNOTE_BATCH_ID
, PNOTE_ACK_DATE
, PNOTE_MPN_IND
, UNSUB_ELIG_FOR_HEAL
, DISCLOSURE_PRINT_IND
, ORIG_FEE_PERCT
, BORW_CONFIRM_IND
, BORW_INTEREST_IND
, BORW_OUTSTD_LOAN_CODE
, UNSUB_ELIG_FOR_DEPNT
, GUARANTEE_AMT
, GUARANTEE_DATE
, GUARNT_AMT_REDN_CODE
, GUARNT_STATUS_CODE
, GUARNT_STATUS_DATE
, LEND_APPRV_DENIED_CODE
, LEND_APPRV_DENIED_DATE
, LEND_STATUS_CODE
, LEND_STATUS_DATE
, GUARNT_ADJ_IND
, GRADE_LEVEL_CODE
, ENROLLMENT_CODE
, ANTICIP_COMPL_DATE
, BORW_LENDER_ID
, DUNS_BORW_LENDER_ID
, GUARANTOR_ID
, DUNS_GUARNT_ID
, PRC_TYPE_CODE
, CL_SEQ_NUMBER
, LAST_RESORT_LENDER
, LENDER_ID
, DUNS_LENDER_ID
, LEND_NON_ED_BRC_ID
, RECIPIENT_ID
, RECIPIENT_TYPE
, DUNS_RECIP_ID
, RECIP_NON_ED_BRC_ID
, REC_TYPE_IND
, CL_LOAN_TYPE
, CL_REC_STATUS
, CL_REC_STATUS_LAST_UPDATE
, ALT_PROG_TYPE_CODE
, ALT_APPL_VER_CODE
, MPN_CONFIRM_CODE
, RESP_TO_ORIG_CODE
, APPL_LOAN_PHASE_CODE
, APPL_LOAN_PHASE_CODE_CHG
, APPL_SEND_ERROR_CODES
, TOT_OUTSTD_STAFFORD
, TOT_OUTSTD_PLUS
, ALT_BORW_TOT_DEBT
, ACT_INTEREST_RATE
, SERVICE_TYPE_CODE
, REV_NOTICE_OF_GUARNT
, SCH_REFUND_AMT
, SCH_REFUND_DATE
, UNIQ_LAYOUT_VEND_CODE
, UNIQ_LAYOUT_IDENT_CODE
, P_PERSON_ID
, P_SSN
, P_SSN_CHG_DATE
, P_LAST_NAME
, P_FIRST_NAME
, P_MIDDLE_NAME
, P_FULL_NAME
, P_PERMT_ADDR1
, P_PERMT_ADDR2
, P_PERMT_CITY
, P_PERMT_STATE
, P_PERMT_ZIP
, P_PERMT_ADDR_CHG_DATE
, P_EMAIL_ADDR
, P_DATE_OF_BIRTH
, P_DOB_CHG_DATE
, P_DEFAULT_STATUS
, P_LICENSE_NUM
, P_LICENSE_STATE
, P_CITIZENSHIP_STATUS
, P_ALIEN_REG_NUM
, P_STATE_OF_LEGAL_RES
, P_LEGAL_RES_DATE
, P_SIGNATURE_CODE
, P_SIGNATURE_DATE
, S_SSN
, S_SSN_CHG_DATE
, S_LAST_NAME
, S_FIRST_NAME
, S_MIDDLE_NAME
, S_FULL_NAME
, S_PERMT_ADDR1
, S_PERMT_ADDR2
, S_PERMT_CITY
, S_PERMT_STATE
, S_PERMT_ZIP
, S_PERMT_ADDR_CHG_DATE
, S_LOCAL_ADDR1
, S_LOCAL_ADDR2
, S_LOCAL_CITY
, S_LOCAL_STATE
, S_LOCAL_ZIP
, S_LOCAL_ADDR_CHG_DATE
, S_EMAIL_ADDR
, S_DATE_OF_BIRTH
, S_DOB_CHG_DATE
, S_DEFAULT_STATUS
, S_SIGNATURE_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LOAN_AMT_PAID
, ELEC_MPN_IND
, BORR_SIGN_IND
, STUD_SIGN_IND
, BORR_CREDIT_AUTH_CODE
FROM APPS.IGF_SL_LOR_DTLS_V;
APPS
IGF_AP_PERSON_V
IGF_AW_AWARD_V
IGF_AW_GEN
- show dependent code
IGF_SL_ADDR_V
IGF_SL_LOANS
IGF_SL_LOR
IGF_SL_PLUS_BORW
IGS_EN_GEN_003
- show dependent code
IGS_EN_GEN_007
- show dependent code
IGS_GE_GEN_002
- show dependent code
IGS_LOOKUPS_VIEW
APPS.IGF_SL_LOR_DTLS_V is not referenced by any database object
|
|
|
|