View: GL_AUTO_ALLOC_BATCHES_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_AUTO_ALLOC_BATCHES_V

View Text

SELECT GLB.ROWID ROW_ID
, GLB.ALLOCATION_SET_ID
, GLB.BATCH_ID
, GLB.BATCH_TYPE_CODE
, GLB.LAST_UPDATE_DATE
, GLB.LAST_UPDATED_BY
, GLB.LAST_UPDATE_LOGIN
, GLB.CREATION_DATE
, GLB.CREATED_BY
, GLB.STEP_NUMBER
, GLB.OWNER
, GLB.ALLOCATION_METHOD_CODE
, GLB.ATTRIBUTE1
, GLB.ATTRIBUTE2
, GLB.ATTRIBUTE3
, GLB.ATTRIBUTE4
, GLB.ATTRIBUTE5
, GLB.ATTRIBUTE6
, GLB.ATTRIBUTE7
, GLB.ATTRIBUTE8
, GLB.ATTRIBUTE9
, GLB.ATTRIBUTE10
, GLB.ATTRIBUTE11
, GLB.ATTRIBUTE12
, GLB.ATTRIBUTE13
, GLB.ATTRIBUTE14
, GLB.ATTRIBUTE15
, GLB.CONTEXT
, LKP.MEANING TYPE
, SUBSTR(GL_AUTO_ALLOC_VW_PKG.GET_BATCH_NAME(GLB.BATCH_TYPE_CODE
, GLB.BATCH_ID)
, 1
, 150) NAME
, SUBSTR(GL_AUTO_ALLOC_VW_PKG.GET_OWNER_DSP(GLB.OWNER)
, 1
, 240) OWNER_DSP
FROM GL_AUTO_ALLOC_BATCHES GLB
, GL_LOOKUPS LKP
WHERE LKP.LOOKUP_TYPE = 'AUTOALLOCATION'
AND LKP.LOOKUP_CODE = GLB.BATCH_TYPE_CODE

Columns