View: OKL_ACC_GEN_RULES_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_ACC_GEN_RULES_UV

View Text

SELECT AGRL.ID ID
, AGRL.SEGMENT SEGMENT
, AGRL.SEGMENT_NUMBER SEGMENT_NUMBER
, AGRL.AGR_ID AGR_ID
, AGR.AE_LINE_TYPE AE_LINE_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCOUNT_ENTRY_LINE_TYPE'
, AGR.AE_LINE_TYPE
, 540
, 0) ACCT_LINE_TYPE_MEANING
, AGRL.SOURCE SOURCE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING(('OKL_' || AGR.AE_LINE_TYPE)
, AGRL.SOURCE
, 540
, 0) SOURCE_MEANING
, AGRL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AGRL.CONSTANTS CONSTANTS
, AGRL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AGRL.ATTRIBUTE1 ATTRIBUTE1
, AGRL.ATTRIBUTE2 ATTRIBUTE2
, AGRL.ATTRIBUTE3 ATTRIBUTE3
, AGRL.ATTRIBUTE4 ATTRIBUTE4
, AGRL.ATTRIBUTE5 ATTRIBUTE5
, AGRL.ATTRIBUTE6 ATTRIBUTE6
, AGRL.ATTRIBUTE7 ATTRIBUTE7
, AGRL.ATTRIBUTE8 ATTRIBUTE8
, AGRL.ATTRIBUTE9 ATTRIBUTE9
, AGRL.ATTRIBUTE10 ATTRIBUTE10
, AGRL.ATTRIBUTE11 ATTRIBUTE11
, AGRL.ATTRIBUTE12 ATTRIBUTE12
, AGRL.ATTRIBUTE13 ATTRIBUTE13
, AGRL.ATTRIBUTE14 ATTRIBUTE14
, AGRL.ATTRIBUTE15 ATTRIBUTE15
, AGRL.CREATED_BY CREATED_BY
, AGRL.CREATION_DATE CREATION_DATE
, AGRL.LAST_UPDATED_BY LAST_UPDATED_BY
, AGRL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AGRL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_ACC_GEN_RULES AGR
, OKL_ACC_GEN_RUL_LNS AGRL
WHERE AGR.ID = AGRL.AGR_ID
AND AGR.SET_OF_BOOKS_ID = (SELECT OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID
FROM DUAL)

Columns