VIEW: APPS.OKL_BOOK_CONTROLLER_TRX_V

Source

View Text - Preformatted

SELECT TRX.USER_ID USER_ID, TRX.ORG_ID ORG_ID, TRX.BATCH_NUMBER BATCH_NUMBER, TRX.PROCESSING_SRL_NUMBER PROCESSING_SRL_NUMBER, TRX.KHR_ID KHR_ID, TRX.PROGRAM_NAME PROGRAM_NAME, TRX.PROG_SHORT_NAME PROG_SHORT_NAME, TRX.CONC_REQ_ID CONC_REQ_ID, TRX.PROGRESS_STATUS PROGRESS_STATUS, FNDT.MEANING STATUS_MEANING, TRX.CREATED_BY CREATED_BY, TRX.CREATION_DATE CREATION_DATE, TRX.LAST_UPDATED_BY LAST_UPDATED_BY, TRX.LAST_UPDATE_DATE LAST_UPDATE_DATE, TRX.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , TRX.ACTIVE_FLAG FROM OKL_BOOK_CONTROLLER_TRX TRX,FND_LOOKUPS FNDT WHERE FNDT.LOOKUP_TYPE = 'OKL_BKG_CONTL_STATUS' AND FNDT.LOOKUP_CODE = TRX.PROGRESS_STATUS

View Text - HTML Formatted

SELECT TRX.USER_ID USER_ID
, TRX.ORG_ID ORG_ID
, TRX.BATCH_NUMBER BATCH_NUMBER
, TRX.PROCESSING_SRL_NUMBER PROCESSING_SRL_NUMBER
, TRX.KHR_ID KHR_ID
, TRX.PROGRAM_NAME PROGRAM_NAME
, TRX.PROG_SHORT_NAME PROG_SHORT_NAME
, TRX.CONC_REQ_ID CONC_REQ_ID
, TRX.PROGRESS_STATUS PROGRESS_STATUS
, FNDT.MEANING STATUS_MEANING
, TRX.CREATED_BY CREATED_BY
, TRX.CREATION_DATE CREATION_DATE
, TRX.LAST_UPDATED_BY LAST_UPDATED_BY
, TRX.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TRX.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TRX.ACTIVE_FLAG
FROM OKL_BOOK_CONTROLLER_TRX TRX
, FND_LOOKUPS FNDT
WHERE FNDT.LOOKUP_TYPE = 'OKL_BKG_CONTL_STATUS'
AND FNDT.LOOKUP_CODE = TRX.PROGRESS_STATUS