View: RA_BATCHES_V

Product:	AR - Receivables
Description:	(Release 115)
Implementation/DBA Data:	APPS.RA_BATCHES_V

View Text

SELECT /* PURPOSE: THE VIEW RA_BATCHES_V IS FOR USE AS A BASE TABLE FOR */ /* ORACLE FORMS 4.5 PROGRAMS (RELEASE 10G) */ /* FORM USE: BATCH (ARXTWBAT
, PART OF ARXTWMAIN FORM) */ BATCH.ROWID
, BATCH.BATCH_ID
, BATCH.SET_OF_BOOKS_ID
, BATCH.LAST_UPDATE_DATE
, BATCH.LAST_UPDATED_BY
, BATCH.CREATION_DATE
, BATCH.CREATED_BY
, BATCH.LAST_UPDATE_LOGIN
, BATCH.NAME
, BATCH.BATCH_DATE
, BATCH.GL_DATE
, ARPT_SQL_FUNC_UTIL.GET_PERIOD_NAME(BATCH.GL_DATE)
, AL_STATUS.MEANING
, BATCH.STATUS
, BATCH.TYPE
, BATCH.BATCH_SOURCE_ID
, BS.NAME
, BATCH.CURRENCY_CODE
, BATCH.EXCHANGE_RATE_TYPE
, DCT.USER_CONVERSION_TYPE
, BATCH.EXCHANGE_DATE
, BATCH.EXCHANGE_RATE
, BATCH.CONTROL_COUNT
, BATCH.CONTROL_AMOUNT
, ARP_TRX_SUM_UTIL.GET_BATCH_SUMMARY(BATCH.BATCH_ID
, 'COUNT')
, ARP_TRX_SUM_UTIL.GET_BATCH_SUMMARY(BATCH.BATCH_ID
, 'SUM')
, BATCH.COMMENTS
, NVL(BATCH.PURGED_CHILDREN_FLAG
, 'N')
, BATCH.ATTRIBUTE_CATEGORY
, BATCH.ATTRIBUTE1
, BATCH.ATTRIBUTE2
, BATCH.ATTRIBUTE3
, BATCH.ATTRIBUTE4
, BATCH.ATTRIBUTE5
, BATCH.ATTRIBUTE6
, BATCH.ATTRIBUTE7
, BATCH.ATTRIBUTE8
, BATCH.ATTRIBUTE9
, BATCH.ATTRIBUTE10
, BATCH.ATTRIBUTE11
, BATCH.ATTRIBUTE12
, BATCH.ATTRIBUTE13
, BATCH.ATTRIBUTE14
, BATCH.ATTRIBUTE15
, BATCH.REQUEST_ID
, BATCH.PROGRAM_APPLICATION_ID
, BATCH.PROGRAM_ID
, BATCH.PROGRAM_UPDATE_DATE
, BATCH.ORG_ID
FROM GL_DAILY_CONVERSION_TYPES DCT
, RA_BATCHES BATCH
, RA_BATCH_SOURCES_ALL BS
, AR_LOOKUPS AL_STATUS
WHERE AL_STATUS.LOOKUP_TYPE(+) = 'BATCH_STATUS'
AND AL_STATUS.LOOKUP_CODE(+) = BATCH.STATUS
AND NVL(BATCH.TYPE
, 'INV') <> 'BR' /* 19-APR-2000 J RAUTIAINEN BR IMPLEMENTATION */
AND BATCH.EXCHANGE_RATE_TYPE = DCT.CONVERSION_TYPE (+)
AND BATCH.BATCH_SOURCE_ID = BS.BATCH_SOURCE_ID(+)
AND BATCH.ORG_ID = BS.ORG_ID

Columns