eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: LNS.LNS_FUNDING_ADVICES#

Source

View Text - Preformatted


select FUNDING_ADVICE_ID FUNDING_ADVICE_ID, LOAN_ID LOAN_ID, ADVICE_NUMBER ADVICE_NUMBER, SUBMISSION_DATE SUBMISSION_DATE, AMOUNT AMOUNT, CURRENCY CURRENCY, DESCRIPTION DESCRIPTION, DUE_DATE DUE_DATE, INVOICE_ID INVOICE_ID, INVOICE_NUMBER INVOICE_NUMBER, PAYMENT_METHOD PAYMENT_METHOD, STATUS STATUS, PAYEE_ID PAYEE_ID, PAYEE_SITE_ID PAYEE_SITE_ID, SITE_CONTACT_ID SITE_CONTACT_ID, BANK_BRANCH_ID BANK_BRANCH_ID, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, AUTOFUNDING_FLAG AUTOFUNDING_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, FUNDING_DATE FUNDING_DATE from "LNS"."LNS_FUNDING_ADVICES"

View Text - HTML Formatted

SELECT FUNDING_ADVICE_ID FUNDING_ADVICE_ID
, LOAN_ID LOAN_ID
, ADVICE_NUMBER ADVICE_NUMBER
, SUBMISSION_DATE SUBMISSION_DATE
, AMOUNT AMOUNT
, CURRENCY CURRENCY
, DESCRIPTION DESCRIPTION
, DUE_DATE DUE_DATE
, INVOICE_ID INVOICE_ID
, INVOICE_NUMBER INVOICE_NUMBER
, PAYMENT_METHOD PAYMENT_METHOD
, STATUS STATUS
, PAYEE_ID PAYEE_ID
, PAYEE_SITE_ID PAYEE_SITE_ID
, SITE_CONTACT_ID SITE_CONTACT_ID
, BANK_BRANCH_ID BANK_BRANCH_ID
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, AUTOFUNDING_FLAG AUTOFUNDING_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FUNDING_DATE FUNDING_DATE
FROM "LNS"."LNS_FUNDING_ADVICES"