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: IPA.IPA_INTEREST_BATCHES#

Source

View Text - Preformatted


select INTEREST_BATCH_ID INTEREST_BATCH_ID, INTEREST_APPLIED INTEREST_APPLIED, GL_PERIOD GL_PERIOD, PERIOD_BEGIN_DATE PERIOD_BEGIN_DATE, PERIOD_END_DATE PERIOD_END_DATE, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, EXPENDITURE_TASK_ID EXPENDITURE_TASK_ID, STATUS STATUS, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, RATE_TYPE RATE_TYPE, REVERSAL_DATE REVERSAL_DATE, PROJECT_ID PROJECT_ID, BATCH_ID BATCH_ID from "IPA"."IPA_INTEREST_BATCHES"

View Text - HTML Formatted

SELECT INTEREST_BATCH_ID INTEREST_BATCH_ID
, INTEREST_APPLIED INTEREST_APPLIED
, GL_PERIOD GL_PERIOD
, PERIOD_BEGIN_DATE PERIOD_BEGIN_DATE
, PERIOD_END_DATE PERIOD_END_DATE
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EXPENDITURE_TASK_ID EXPENDITURE_TASK_ID
, STATUS STATUS
, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, RATE_TYPE RATE_TYPE
, REVERSAL_DATE REVERSAL_DATE
, PROJECT_ID PROJECT_ID
, BATCH_ID BATCH_ID
FROM "IPA"."IPA_INTEREST_BATCHES"