DBA Data[Home] [Help]

VIEW: APPS.GL_BUD_REC_BATCHES_V

Source

View Text - Preformatted

SELECT /* $Header: glgvw.odf 120.39 2011/02/18 13:08:22 sommukhe ship $ */ b.status STATUS, r.name NAME, r.ledger_id LEDGER_ID, b.budget_version_id BUDGET_VERSION_ID, b.recurring_batch_id RECURRING_BATCH_ID, b.last_update_date LAST_UPDATE_DATE, b.last_updated_by LAST_UPDATED_BY, b.rowid ROW_ID FROM gl_budget_batches b, gl_recurring_batches r WHERE b.recurring_batch_id = r.recurring_batch_id
View Text - HTML Formatted

SELECT /* $HEADER: GLGVW.ODF 120.39 2011/02/18 13:08:22 SOMMUKHE SHIP $ */ B.STATUS STATUS
, R.NAME NAME
, R.LEDGER_ID LEDGER_ID
, B.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.RECURRING_BATCH_ID RECURRING_BATCH_ID
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.ROWID ROW_ID
FROM GL_BUDGET_BATCHES B
, GL_RECURRING_BATCHES R
WHERE B.RECURRING_BATCH_ID = R.RECURRING_BATCH_ID