VIEW: APPS.IPA_INTEREST_BATCHES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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