View: GL_RECURRING_HEADERS_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_RECURRING_HEADERS_V

View Text

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

Columns