VIEW: APPS.OKL_STREAMS_V

Source

View Text - Preformatted

SELECT STMB.rowid ROW_ID, STMB.ID ID, STMB.TRANSACTION_NUMBER TRANSACTION_NUMBER, STMB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STMB.SGN_CODE SGN_CODE, STMB.SAY_CODE SAY_CODE, STMB.STY_ID STY_ID, STMB.KLE_ID KLE_ID, STMB.KHR_ID KHR_ID, STMB.ACTIVE_YN ACTIVE_YN, STMB.PURPOSE_CODE PURPOSE_CODE, STMB.DATE_CURRENT DATE_CURRENT, STMB.DATE_WORKING DATE_WORKING, STMB.DATE_HISTORY DATE_HISTORY, STMB.COMMENTS COMMENTS, STMB.CREATED_BY CREATED_BY, STMB.CREATION_DATE CREATION_DATE, STMB.LAST_UPDATED_BY LAST_UPDATED_BY, STMB.LAST_UPDATE_DATE LAST_UPDATE_DATE, STMB.PROGRAM_ID PROGRAM_ID, STMB.REQUEST_ID REQUEST_ID, STMB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, STMB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, STMB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , STMB.STM_ID STM_ID, STMB.SOURCE_ID SOURCE_ID, STMB.SOURCE_TABLE SOURCE_TABLE, STMB.TRX_ID , STMB.LINK_HIST_STREAM_ID FROM OKL_STREAMS STMB

View Text - HTML Formatted

SELECT STMB.ROWID ROW_ID
, STMB.ID ID
, STMB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, STMB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STMB.SGN_CODE SGN_CODE
, STMB.SAY_CODE SAY_CODE
, STMB.STY_ID STY_ID
, STMB.KLE_ID KLE_ID
, STMB.KHR_ID KHR_ID
, STMB.ACTIVE_YN ACTIVE_YN
, STMB.PURPOSE_CODE PURPOSE_CODE
, STMB.DATE_CURRENT DATE_CURRENT
, STMB.DATE_WORKING DATE_WORKING
, STMB.DATE_HISTORY DATE_HISTORY
, STMB.COMMENTS COMMENTS
, STMB.CREATED_BY CREATED_BY
, STMB.CREATION_DATE CREATION_DATE
, STMB.LAST_UPDATED_BY LAST_UPDATED_BY
, STMB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, STMB.PROGRAM_ID PROGRAM_ID
, STMB.REQUEST_ID REQUEST_ID
, STMB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, STMB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, STMB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, STMB.STM_ID STM_ID
, STMB.SOURCE_ID SOURCE_ID
, STMB.SOURCE_TABLE SOURCE_TABLE
, STMB.TRX_ID
, STMB.LINK_HIST_STREAM_ID
FROM OKL_STREAMS STMB