VIEW: APPS.GL_AUTO_ALLOC_BAT_HIST_DET_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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