VIEW: APPS.GL_RECURRING_HEADERS_V

Source

View Text - Preformatted

SELECT head.ROWID ROW_ID, head.RECURRING_HEADER_ID RECURRING_HEADER_ID, head.LAST_UPDATE_DATE LAST_UPDATE_DATE, head.LAST_UPDATED_BY LAST_UPDATED_BY, head.LEDGER_ID LEDGER_ID, lgr.NAME LEDGER_NAME, head.NAME NAME, head.JE_CATEGORY_NAME JE_CATEGORY_NAME, cat.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME, dct.USER_CONVERSION_TYPE USER_CONVERSION_TYPE, head.ENABLED_FLAG ENABLED_FLAG, head.ALLOCATION_FLAG ALLOCATION_FLAG, head.CURRENCY_CODE CURRENCY_CODE, head.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, head.CREATION_DATE CREATION_DATE, head.CREATED_BY CREATED_BY, head.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, head.RECURRING_BATCH_ID RECURRING_BATCH_ID, head.PERIOD_TYPE PERIOD_TYPE, head.LAST_EXECUTED_PERIOD_NAME LAST_EXECUTED_PERIOD_NAME, head.LAST_EXECUTED_DATE LAST_EXECUTED_DATE, head.START_DATE_ACTIVE START_DATE_ACTIVE, head.END_DATE_ACTIVE END_DATE_ACTIVE, head.ATTRIBUTE1 ATTRIBUTE1, head.ATTRIBUTE2 ATTRIBUTE2, head.ATTRIBUTE3 ATTRIBUTE3, head.ATTRIBUTE4 ATTRIBUTE4, head.ATTRIBUTE5 ATTRIBUTE5, head.ATTRIBUTE6 ATTRIBUTE6, head.ATTRIBUTE7 ATTRIBUTE7, head.ATTRIBUTE8 ATTRIBUTE8, head.ATTRIBUTE9 ATTRIBUTE9, head.ATTRIBUTE10 ATTRIBUTE10, head.CONTEXT CONTEXT FROM gl_je_categories cat, gl_recurring_headers head, gl_ledgers lgr, gl_daily_conversion_types dct WHERE head.JE_CATEGORY_NAME = cat.JE_CATEGORY_NAME AND head.ledger_id = lgr.ledger_id AND dct.conversion_type(+) = head.currency_conversion_type

View Text - HTML Formatted

SELECT HEAD.ROWID ROW_ID
, HEAD.RECURRING_HEADER_ID RECURRING_HEADER_ID
, HEAD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HEAD.LAST_UPDATED_BY LAST_UPDATED_BY
, HEAD.LEDGER_ID LEDGER_ID
, LGR.NAME LEDGER_NAME
, HEAD.NAME NAME
, HEAD.JE_CATEGORY_NAME JE_CATEGORY_NAME
, CAT.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, DCT.USER_CONVERSION_TYPE USER_CONVERSION_TYPE
, HEAD.ENABLED_FLAG ENABLED_FLAG
, HEAD.ALLOCATION_FLAG ALLOCATION_FLAG
, HEAD.CURRENCY_CODE CURRENCY_CODE
, HEAD.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, HEAD.CREATION_DATE CREATION_DATE
, HEAD.CREATED_BY CREATED_BY
, HEAD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, HEAD.RECURRING_BATCH_ID RECURRING_BATCH_ID
, HEAD.PERIOD_TYPE PERIOD_TYPE
, HEAD.LAST_EXECUTED_PERIOD_NAME LAST_EXECUTED_PERIOD_NAME
, HEAD.LAST_EXECUTED_DATE LAST_EXECUTED_DATE
, HEAD.START_DATE_ACTIVE START_DATE_ACTIVE
, HEAD.END_DATE_ACTIVE END_DATE_ACTIVE
, HEAD.ATTRIBUTE1 ATTRIBUTE1
, HEAD.ATTRIBUTE2 ATTRIBUTE2
, HEAD.ATTRIBUTE3 ATTRIBUTE3
, HEAD.ATTRIBUTE4 ATTRIBUTE4
, HEAD.ATTRIBUTE5 ATTRIBUTE5
, HEAD.ATTRIBUTE6 ATTRIBUTE6
, HEAD.ATTRIBUTE7 ATTRIBUTE7
, HEAD.ATTRIBUTE8 ATTRIBUTE8
, HEAD.ATTRIBUTE9 ATTRIBUTE9
, HEAD.ATTRIBUTE10 ATTRIBUTE10
, HEAD.CONTEXT CONTEXT
FROM GL_JE_CATEGORIES CAT
, GL_RECURRING_HEADERS HEAD
, GL_LEDGERS LGR
, GL_DAILY_CONVERSION_TYPES DCT
WHERE HEAD.JE_CATEGORY_NAME = CAT.JE_CATEGORY_NAME
AND HEAD.LEDGER_ID = LGR.LEDGER_ID
AND DCT.CONVERSION_TYPE(+) = HEAD.CURRENCY_CONVERSION_TYPE