VIEW: APPS.GL_AUTO_ALLOC_BATCHES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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