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_INTEREST_BATCHES_V

Product:	IPA - Capital Resource Logistics - Projects
Description:
Implementation/DBA Data:	APPS.IPA_INTEREST_BATCHES_V

View Text

SELECT IB.INTEREST_BATCH_ID
, IB.BATCH_ID
, IB.PROJECT_ID
, P.SEGMENT1
, IB.RATE_TYPE
, IB.INTEREST_APPLIED
, IB.STATUS
, IB.GL_PERIOD
, IB.PERIOD_BEGIN_DATE
, IB.PERIOD_END_DATE
, IB.EXPENDITURE_ITEM_DATE
, IB.EXPENDITURE_TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, IB.REVERSAL_DATE
FROM IPA_INTEREST_BATCHES IB
, PA_PROJECTS P
, PA_TASKS T
WHERE P.PROJECT_ID = IB.PROJECT_ID
AND T.TASK_ID = IB.EXPENDITURE_TASK_ID

Columns

Name
INTEREST_BATCH_ID
BATCH_ID
PROJECT_ID
PROJECT_NUMBER
RATE_TYPE
INTEREST_APPLIED
STATUS
GL_PERIOD
PERIOD_BEGIN_DATE
PERIOD_END_DATE
EXPENDITURE_ITEM_DATE
EXPENDITURE_TASK_ID
TASK_NUMBER
TASK_NAME
REVERSAL_DATE