View: CSC_PLAN_HEADERS_V

Product:	CSC - Customer Care
Description:	This view is based on CSC_PLAN_HEADRES_B & CSC_PLAN_HEADRES_TL used in the client code
Implementation/DBA Data:	APPS.CSC_PLAN_HEADERS_V

View Text

SELECT PNHB.ROWID ROW_ID
, PNHB.PLAN_ID PLAN_ID
, PNHTL.NAME NAME
, CCPN.PARTY_ID PARTY_ID
, PNHB.PLAN_GROUP_CODE PLAN_GROUP_CODE
, PNHB.ORIGINAL_PLAN_ID ORIGINAL_PLAN_ID
, CLGR.MEANING GROUP_NAME
, PNHB.USE_FOR_CUST_ACCOUNT USE_FOR_CUST_ACCOUNT
, PNHB.END_USER_TYPE END_USER_TYPE
, CLEU.MEANING END_USER_TYPE_MEANING
, PNHB.CUSTOMIZED_PLAN CUSTOMIZED_PLAN
, PNHTL.DESCRIPTION DESCRIPTION
, PNHB.START_DATE_ACTIVE START_DATE_ACTIVE
, PNHB.END_DATE_ACTIVE END_DATE_ACTIVE
, PNHB.PROFILE_CHECK_ID PROFILE_CHECK_ID
, CPC.CHECK_NAME PROFILE_CHECK_NAME
, PNHB.RELATIONAL_OPERATOR RELATIONAL_OPERATOR
, PNHB.CRITERIA_VALUE_LOW CRITERIA_VALUE_LOW
, PNHB.CRITERIA_VALUE_HIGH CRITERIA_VALUE_HIGH
, PNHB.CREATION_DATE CREATION_DATE
, PNHB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PNHB.CREATED_BY CREATED_BY
, PNHB.LAST_UPDATED_BY LAST_UPDATED_BY
, PNHB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PNHB.ATTRIBUTE1 ATTRIBUTE1
, PNHB.ATTRIBUTE2 ATTRIBUTE2
, PNHB.ATTRIBUTE3 ATTRIBUTE3
, PNHB.ATTRIBUTE4 ATTRIBUTE4
, PNHB.ATTRIBUTE5 ATTRIBUTE5
, PNHB.ATTRIBUTE6 ATTRIBUTE6
, PNHB.ATTRIBUTE7 ATTRIBUTE7
, PNHB.ATTRIBUTE8 ATTRIBUTE8
, PNHB.ATTRIBUTE9 ATTRIBUTE9
, PNHB.ATTRIBUTE10 ATTRIBUTE10
, PNHB.ATTRIBUTE11 ATTRIBUTE11
, PNHB.ATTRIBUTE12 ATTRIBUTE12
, PNHB.ATTRIBUTE13 ATTRIBUTE13
, PNHB.ATTRIBUTE14 ATTRIBUTE14
, PNHB.ATTRIBUTE15 ATTRIBUTE15
, PNHB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PNHB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM CSC_PLAN_HEADERS_B PNHB
, CSC_PLAN_HEADERS_TL PNHTL
, CSC_CUSTOMIZED_PLANS CCPN
, CSC_PROF_CHECKS_VL CPC
, CSC_LOOKUPS CLGR
, CSC_LOOKUPS CLEU
WHERE PNHB.PLAN_ID = PNHTL.PLAN_ID
AND PNHTL.LANGUAGE = USERENV('LANG')
AND PNHTL.PLAN_ID = CCPN.PLAN_ID (+)
AND PNHB.PLAN_GROUP_CODE = CLGR.LOOKUP_CODE (+)
AND CLGR.LOOKUP_TYPE (+) = 'CSC_PLAN_GROUP'
AND PNHB.PROFILE_CHECK_ID = CPC.CHECK_ID
AND PNHB.END_USER_TYPE = CLEU.LOOKUP_CODE (+)
AND CLEU.LOOKUP_TYPE (+) = 'CSC_END_USER_TYPE'

Columns