Product: | OKL - Lease and Finance Management |
---|---|
Description: | Book Controller transaction View |
Implementation/DBA Data: | APPS.OKL_BOOK_CONTROLLER_TRX_V |
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