View: OKL_PRTFL_CNTRCTS_V

Product:	OKL - Leasing and Finance Management
Description:	Contract activation triggers the generation of a portfolio management strategy profile. The profile defines a strategy that determines the action to be taken when a contract reaches the end of term and a budget amount that is the amount of
Implementation/DBA Data:	APPS.OKL_PRTFL_CNTRCTS_V

View Text

SELECT PFCB.ROWID ROW_ID
, PFCB.ID ID
, PFCB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PFCT.SFWT_FLAG SFWT_FLAG
, PFCB.LINE_LEVEL_YN LINE_LEVEL_YN
, PFCB.KHR_ID KHR_ID
, PFCT.NAME NAME
, PFCT.DESCRIPTION DESCRIPTION
, PFCB.REQUEST_ID REQUEST_ID
, PFCB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PFCB.PROGRAM_ID PROGRAM_ID
, PFCB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PFCB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PFCB.ATTRIBUTE1 ATTRIBUTE1
, PFCB.ATTRIBUTE2 ATTRIBUTE2
, PFCB.ATTRIBUTE3 ATTRIBUTE3
, PFCB.ATTRIBUTE4 ATTRIBUTE4
, PFCB.ATTRIBUTE5 ATTRIBUTE5
, PFCB.ATTRIBUTE6 ATTRIBUTE6
, PFCB.ATTRIBUTE7 ATTRIBUTE7
, PFCB.ATTRIBUTE8 ATTRIBUTE8
, PFCB.ATTRIBUTE9 ATTRIBUTE9
, PFCB.ATTRIBUTE10 ATTRIBUTE10
, PFCB.ATTRIBUTE11 ATTRIBUTE11
, PFCB.ATTRIBUTE12 ATTRIBUTE12
, PFCB.ATTRIBUTE13 ATTRIBUTE13
, PFCB.ATTRIBUTE14 ATTRIBUTE14
, PFCB.ATTRIBUTE15 ATTRIBUTE15
, PFCB.CREATED_BY CREATED_BY
, PFCB.CREATION_DATE CREATION_DATE
, PFCB.LAST_UPDATED_BY LAST_UPDATED_BY
, PFCB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PFCB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_PRTFL_CNTRCTS_B PFCB
, OKL_PRTFL_CNTRCTS_TL PFCT
WHERE PFCB.ID = PFCT.ID
AND PFCT.LANGUAGE = USERENV('LANG')

Columns