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.

VIEW: OKL.OKL_PAYMENTS_INTERFACE#

Source

View Text - Preformatted


select CONTRACT_NUMBER_OLD CONTRACT_NUMBER_OLD, LINE_NUMBER LINE_NUMBER, ASSET_NUMBER ASSET_NUMBER, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE, PAYMENT_SCHEDULE_NUMBER PAYMENT_SCHEDULE_NUMBER, PAYMENT_FREQUENCY_CODE PAYMENT_FREQUENCY_CODE, ARREARS_FLAG ARREARS_FLAG, ADVANCE_PAYMENTS ADVANCE_PAYMENTS, PAYMENT_AMOUNT PAYMENT_AMOUNT, START_DATE START_DATE, NUMBER_OF_PERIODS NUMBER_OF_PERIODS, RATE RATE, COMMENTS COMMENTS, STUB_DAYS STUB_DAYS, STUB_AMOUNT STUB_AMOUNT, STREAM_PURPOSE_CODE STREAM_PURPOSE_CODE from "OKL"."OKL_PAYMENTS_INTERFACE"

View Text - HTML Formatted

SELECT CONTRACT_NUMBER_OLD CONTRACT_NUMBER_OLD
, LINE_NUMBER LINE_NUMBER
, ASSET_NUMBER ASSET_NUMBER
, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, PAYMENT_SCHEDULE_NUMBER PAYMENT_SCHEDULE_NUMBER
, PAYMENT_FREQUENCY_CODE PAYMENT_FREQUENCY_CODE
, ARREARS_FLAG ARREARS_FLAG
, ADVANCE_PAYMENTS ADVANCE_PAYMENTS
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, START_DATE START_DATE
, NUMBER_OF_PERIODS NUMBER_OF_PERIODS
, RATE RATE
, COMMENTS COMMENTS
, STUB_DAYS STUB_DAYS
, STUB_AMOUNT STUB_AMOUNT
, STREAM_PURPOSE_CODE STREAM_PURPOSE_CODE
FROM "OKL"."OKL_PAYMENTS_INTERFACE"