View: PSPBV_ENC_TRANS_CONTROLS

View Text

SELECT ENC_CONTROL_ID
, PAYROLL_ID
, TIME_PERIOD_ID
, GL_ENC_PERIOD_EXT_VALUE
, OGM_ENC_PERIOD_EXT_VALUE
, ENCUMBRANCE_DATE
, CI_SUMMARIZATION_OPTION
, TIME_SUMMARIZATION_OPTION
, NUMBER_OF_DR
, NUMBER_OF_CR
, TOTAL_DR_AMOUNT
, TOTAL_CR_AMOUNT
, GL_DR_AMOUNT
, GL_CR_AMOUNT
, OGM_DR_AMOUNT
, OGM_CR_AMOUNT
, ACTION_CODE
, RUN_ID
, BATCH_NAME
, SUMM_GL_DR_AMOUNT
, SUMM_GL_CR_AMOUNT
, SUMM_OGM_DR_AMOUNT
, SUMM_OGM_CR_AMOUNT
, BUSINESS_GROUP_ID
, ACTION_TYPE
, SET_OF_BOOKS_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSP_ENC_CONTROLS WITH READ ONLY

Columns