View: OKL_AEL_GL_QTE_V

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

View Text

SELECT Q.QUOTE_NUMBER
, Q.DATE_EFFECTIVE_FROM
, Q.DATE_EFFECTIVE_TO
, Q.QTP_CODE
, K.CONTRACT_NUMBER
, Q.QST_CODE
, NVL2 (QPT.CPL_ID
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME (KPR.JTOT_OBJECT1_CODE
, KPR.OBJECT1_ID1
, KPR.OBJECT1_ID2)
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME (QPT.PARTY_JTOT_OBJECT1_CODE
, QPT.PARTY_OBJECT1_ID1
, QPT.PARTY_OBJECT1_ID2)) RECIPIENT_NAME
, TCL.ID
, TCN.TRX_NUMBER
, TCN.CURRENCY_CODE
, TCN.DATE_TRANSACTION_OCCURRED
, TCN.TSU_CODE
, AVL.NAME
, FMA.NAME
, STY.CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE)
, TRY.TRX_TYPE_CLASS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_TYPE_CLASS'
, TRY.TRX_TYPE_CLASS)
, AEL.ACCOUNTED_DR
, AEL.ACCOUNTED_CR
, REF.JE_HEADER_ID
, REF.JE_LINE_NUM
, 540 APPLICATION_ID
, AEH.SET_OF_BOOKS_ID
, AEH.ORG_ID
, AEH.AE_HEADER_ID AEH_ID
, AEL.AE_LINE_ID AEL_ID
, AEL.AE_LINE_TYPE_CODE ACCT_LINE_TYPE
, AEL.THIRD_PARTY_ID THIRD_PARTY_ID
, AEL.SUBLEDGER_DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, 'OKLECL' AEL_TABLE
, AEL.ENTERED_DR ENTERED_DR
, AEL.ENTERED_CR ENTERED_CR
, AEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AEL.CURRENCY_CODE
, AEL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, AEL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, AEL.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, AEL.SUBLEDGER_DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, AEH.GL_TRANSFER_FLAG GL_TRANSFER_STATUS
, AEH.AE_CATEGORY JE_CATEGORY
, AEH.ACCOUNTING_DATE ACCOUNTING_DATE
, JC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, AEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AEL.LAST_UPDATED_BY LAST_UPDATED_BY
, AEL.CREATION_DATE CREATION_DATE
, AEL.CREATED_BY CREATED_BY
, AEL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AEL.REQUEST_ID REQUEST_ID
, AEL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AEL.PROGRAM_ID PROGRAM_ID
, AEL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AET.EVENT_NUMBER ACCOUNTING_EVENT_NUMBER
, AET.EVENT_TYPE_CODE ACCOUNTING_EVENT_TYPE
, AEL.AE_LINE_NUMBER ACCOUNTING_LINE_NUMBER
, AEH.ACCOUNTING_ERROR_CODE AEH_ACCOUNTING_ERROR_CODE
, AEL.ACCOUNTING_ERROR_CODE AEL_ACCOUNTING_ERROR_CODE
, AEL.SOURCE_ID
, AEL.SOURCE_TABLE
FROM OKL_TRX_CONTRACTS_ALL TCN
, OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_TRX_QUOTES_ALL_B Q
, OKC_K_HEADERS_B K
, OKL_QUOTE_PARTIES QPT
, OKC_K_PARTY_ROLES_B KPR
, OKL_TRX_TYPES_B TRY
, OKL_AE_TEMPLATES_ALL AVL
, OKL_FORMULAE_B FMA
, OKL_STRM_TYPE_V STY
, OKL_ACC_EVENTS_ALL AET
, OKL_AE_HEADERS_ALL AEH
, OKL_AE_LINES_ALL AEL
, GL_IMPORT_REFERENCES REF
, GL_JE_CATEGORIES_VL JC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE TCN.QTE_ID = Q.ID(+)
AND TCN.KHR_ID = K.ID
AND TCN.TCN_TYPE = 'TMT'
AND TCN.ID = TCL.TCN_ID
AND TCN.QTE_ID = QPT.QTE_ID(+)
AND QPT.QPT_CODE(+) = 'RECIPIENT'
AND QPT.CPL_ID = KPR.ID(+)
AND TCN.TRY_ID = TRY.ID
AND AEL.REFERENCE1 = AVL.ID
AND AVL.STY_ID = STY.ID
AND AVL.FMA_ID = FMA.ID(+)
AND TCL.ID = AET.SOURCE_ID
AND AEH.ACCOUNTING_EVENT_ID = AET.ACCOUNTING_EVENT_ID
AND AEH.AE_CATEGORY = 'TERMINATION'
AND AEL.AE_HEADER_ID = AEH.AE_HEADER_ID
AND AEL.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE(+)
AND REF.GL_SL_LINK_ID = AEL.GL_SL_LINK_ID
AND JC.JE_CATEGORY_NAME = AEH.AE_CATEGORY
AND REF.GL_SL_LINK_TABLE = 'OKLECL'

Columns