View: OKL_PRTFL_LINES_V

Product:	OKL - Lease and Finance Management
Description:	The profile defines a strategy that determines the action(s) to be taken when a contract reaches the end of term and a budget amount that is the amount of revenue (excluding contract yield) expected to be received at the end of the contract
Implementation/DBA Data:	APPS.OKL_PRTFL_LINES_V

View Text

SELECT PFLB.ROWID ROW_ID
, PFLB.ID ID
, PFLT.SFWT_FLAG SFWT_FLAG
, PFLB.BUDGET_AMOUNT BUDGET_AMOUNT
, PFLB.DATE_STRATEGY_EXECUTED DATE_STRATEGY_EXECUTED
, PFLB.DATE_STRATEGY_EXECUTION_DUE DATE_STRATEGY_EXECUTION_DUE
, PFLB.DATE_BUDGET_AMOUNT_LAST_REVIEW DATE_BUDGET_AMOUNT_LAST_REVIEW
, PFLB.TRX_STATUS_CODE TRX_STATUS_CODE
, PFLB.ASSET_TRACK_STRATEGY_CODE ASSET_TRACK_STRATEGY_CODE
, PFLB.PFC_ID PFC_ID
, PFLB.TMB_ID TMB_ID
, PFLB.KLE_ID KLE_ID
, PFLB.FMA_ID FMA_ID
, PFLT.COMMENTS COMMENTS
, PFLB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PFLB.REQUEST_ID REQUEST_ID
, PFLB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PFLB.PROGRAM_ID PROGRAM_ID
, PFLB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PFLB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PFLB.ATTRIBUTE1 ATTRIBUTE1
, PFLB.ATTRIBUTE2 ATTRIBUTE2
, PFLB.ATTRIBUTE3 ATTRIBUTE3
, PFLB.ATTRIBUTE4 ATTRIBUTE4
, PFLB.ATTRIBUTE5 ATTRIBUTE5
, PFLB.ATTRIBUTE6 ATTRIBUTE6
, PFLB.ATTRIBUTE7 ATTRIBUTE7
, PFLB.ATTRIBUTE8 ATTRIBUTE8
, PFLB.ATTRIBUTE9 ATTRIBUTE9
, PFLB.ATTRIBUTE10 ATTRIBUTE10
, PFLB.ATTRIBUTE11 ATTRIBUTE11
, PFLB.ATTRIBUTE12 ATTRIBUTE12
, PFLB.ATTRIBUTE13 ATTRIBUTE13
, PFLB.ATTRIBUTE14 ATTRIBUTE14
, PFLB.ATTRIBUTE15 ATTRIBUTE15
, PFLB.CREATED_BY CREATED_BY
, PFLB.CREATION_DATE CREATION_DATE
, PFLB.LAST_UPDATED_BY LAST_UPDATED_BY
, PFLB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PFLB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PFLB.CURRENCY_CODE
, PFLB.CURRENCY_CONVERSION_CODE
, PFLB.CURRENCY_CONVERSION_TYPE
, PFLB.CURRENCY_CONVERSION_RATE
, PFLB.CURRENCY_CONVERSION_DATE
FROM OKL_PRTFL_LINES_B PFLB
, OKL_PRTFL_LINES_TL PFLT
WHERE PFLB.ID = PFLT.ID
AND PFLT.LANGUAGE = USERENV('LANG')

Columns