VIEW: APPS.RA_BATCHES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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