Product: | OKL - Lease and Finance Management |
---|---|
Description: | All Org view for Termination, restructure or repurchase quote lines |
Implementation/DBA Data: | APPS.OKL_TXL_QTE_LINES_ALL_V |
SELECT TQLB.ROWID ROW_ID
, TQLB.ID ID
, TQLB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TQLT.SFWT_FLAG SFWT_FLAG
, TQLB.QLT_CODE QLT_CODE
, TQLB.KLE_ID KLE_ID
, TQLB.STY_ID STY_ID
, TQLB.QTE_ID QTE_ID
, TQLB.LINE_NUMBER LINE_NUMBER
, TQLT.DESCRIPTION DESCRIPTION
, TQLB.AMOUNT AMOUNT
, TQLB.MODIFIED_YN MODIFIED_YN
, TQLB.TAXED_YN TAXED_YN
, TQLB.DEFAULTED_YN DEFAULTED_YN
, TQLB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TQLB.ATTRIBUTE1 ATTRIBUTE1
, TQLB.ATTRIBUTE2 ATTRIBUTE2
, TQLB.ATTRIBUTE3 ATTRIBUTE3
, TQLB.ATTRIBUTE4 ATTRIBUTE4
, TQLB.ATTRIBUTE5 ATTRIBUTE5
, TQLB.ATTRIBUTE6 ATTRIBUTE6
, TQLB.ATTRIBUTE7 ATTRIBUTE7
, TQLB.ATTRIBUTE8 ATTRIBUTE8
, TQLB.ATTRIBUTE9 ATTRIBUTE9
, TQLB.ATTRIBUTE10 ATTRIBUTE10
, TQLB.ATTRIBUTE11 ATTRIBUTE11
, TQLB.ATTRIBUTE12 ATTRIBUTE12
, TQLB.ATTRIBUTE13 ATTRIBUTE13
, TQLB.ATTRIBUTE14 ATTRIBUTE14
, TQLB.ATTRIBUTE15 ATTRIBUTE15
, TQLB.ORG_ID ORG_ID
, TQLB.REQUEST_ID REQUEST_ID
, TQLB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TQLB.PROGRAM_ID PROGRAM_ID
, TQLB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TQLB.CREATED_BY CREATED_BY
, TQLB.CREATION_DATE CREATION_DATE
, TQLB.LAST_UPDATED_BY LAST_UPDATED_BY
, TQLB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TQLB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TQLB.START_DATE START_DATE
, TQLB.PERIOD PERIOD
, TQLB.NUMBER_OF_PERIODS NUMBER_OF_PERIODS
, TQLB.LOCK_LEVEL_STEP LOCK_LEVEL_STEP
, TQLB.ADVANCE_OR_ARREARS ADVANCE_OR_ARREARS
, TQLB.YIELD_NAME YIELD_NAME
, TQLB.YIELD_VALUE YIELD_VALUE
, TQLB.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE
, TQLB.ASSET_VALUE ASSET_VALUE
, TQLB.RESIDUAL_VALUE RESIDUAL_VALUE
, TQLB.UNBILLED_RECEIVABLES UNBILLED_RECEIVABLES
, TQLB.ASSET_QUANTITY ASSET_QUANTITY
, TQLB.QUOTE_QUANTITY QUOTE_QUANTITY
, TQLB.SPLIT_KLE_ID SPLIT_KLE_ID
, TQLB.SPLIT_KLE_NAME SPLIT_KLE_NAME
, TQLB.CURRENCY_CODE CURRENCY_CODE
, TQLB.CURRENCY_CONVERSION_CODE CURRENCY_CONVERSION_CODE
, TQLB.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, TQLB.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, TQLB.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, TQLB.DUE_DATE DUE_DATE
, TQLB.TRY_ID TRY_ID
FROM OKL_TXL_QTE_LINES_ALL_B TQLB
, OKL_TXL_QUOTE_LINES_TL TQLT
WHERE TQLB.ID = TQLT.ID
AND TQLT.LANGUAGE = USERENV('LANG')