VIEW: GL.GL_RECURRING_HEADERS#

Source

View Text - Preformatted

select RECURRING_HEADER_ID RECURRING_HEADER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LEDGER_ID LEDGER_ID, NAME NAME, JE_CATEGORY_NAME JE_CATEGORY_NAME, ENABLED_FLAG ENABLED_FLAG, ALLOCATION_FLAG ALLOCATION_FLAG, CURRENCY_CODE CURRENCY_CODE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RECURRING_BATCH_ID RECURRING_BATCH_ID, PERIOD_TYPE PERIOD_TYPE, LAST_EXECUTED_PERIOD_NAME LAST_EXECUTED_PERIOD_NAME, LAST_EXECUTED_DATE LAST_EXECUTED_DATE, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, CONTEXT CONTEXT, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE from "GL"."GL_RECURRING_HEADERS"

View Text - HTML Formatted

SELECT RECURRING_HEADER_ID RECURRING_HEADER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LEDGER_ID LEDGER_ID
, NAME NAME
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, ENABLED_FLAG ENABLED_FLAG
, ALLOCATION_FLAG ALLOCATION_FLAG
, CURRENCY_CODE CURRENCY_CODE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RECURRING_BATCH_ID RECURRING_BATCH_ID
, PERIOD_TYPE PERIOD_TYPE
, LAST_EXECUTED_PERIOD_NAME LAST_EXECUTED_PERIOD_NAME
, LAST_EXECUTED_DATE LAST_EXECUTED_DATE
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, CONTEXT CONTEXT
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
FROM "GL"."GL_RECURRING_HEADERS"