View: GL_AUTO_ALLOC_BAT_HIST_DET_V

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

View Text

SELECT D.ROWID ROW_ID
, D.REQUEST_ID
, D.PARENT_REQUEST_ID
, D.STEP_NUMBER
, D.PROGRAM_NAME_CODE
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.CREATION_DATE
, D.CREATED_BY
, D.STATUS_CODE
, D.RUN_MODE
, CPT.USER_CONCURRENT_PROGRAM_NAME PROGRAM_NAME
FROM FND_CONCURRENT_PROGRAMS_TL CPT
, FND_CONCURRENT_PROGRAMS CP
, GL_AUTO_ALLOC_BAT_HIST_DET D
WHERE CP.APPLICATION_ID IN (101
, 275)
AND CP.CONCURRENT_PROGRAM_NAME = D.PROGRAM_NAME_CODE
AND CPT.LANGUAGE=USERENV('LANG')
AND CPT.APPLICATION_ID = CP.APPLICATION_ID
AND CPT.CONCURRENT_PROGRAM_ID = CP.CONCURRENT_PROGRAM_ID

Columns