View: CSC_PLAN_LINES_V

Product:	CSC - Customer Care
Description:	This view is based on CSC_PLAN_LINES used in lock row event of server side API's
Implementation/DBA Data:	APPS.CSC_PLAN_LINES_V

View Text

SELECT PNL.ROWID ROW_ID
, PNL.LINE_ID LINE_ID
, PNL.PLAN_ID PLAN_ID
, PNL.CONDITION_ID CONDITION_ID
, CNH.NAME CONDITION_NAME
, CNH.CNH_TYPE CONDITION_TYPE
, PNL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PNL.CREATION_DATE CREATION_DATE
, PNL.LAST_UPDATED_BY LAST_UPDATED_BY
, PNL.CREATED_BY CREATED_BY
, PNL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PNL.ATTRIBUTE1 ATTRIBUTE1
, PNL.ATTRIBUTE2 ATTRIBUTE2
, PNL.ATTRIBUTE3 ATTRIBUTE3
, PNL.ATTRIBUTE4 ATTRIBUTE4
, PNL.ATTRIBUTE5 ATTRIBUTE5
, PNL.ATTRIBUTE6 ATTRIBUTE6
, PNL.ATTRIBUTE7 ATTRIBUTE7
, PNL.ATTRIBUTE8 ATTRIBUTE8
, PNL.ATTRIBUTE9 ATTRIBUTE9
, PNL.ATTRIBUTE10 ATTRIBUTE10
, PNL.ATTRIBUTE11 ATTRIBUTE11
, PNL.ATTRIBUTE12 ATTRIBUTE12
, PNL.ATTRIBUTE13 ATTRIBUTE13
, PNL.ATTRIBUTE14 ATTRIBUTE14
, PNL.ATTRIBUTE15 ATTRIBUTE15
, PNL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PNL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM CSC_PLAN_LINES PNL
, OKC_CONDITION_HEADERS_V CNH
WHERE PNL.CONDITION_ID = CNH.ID

Columns