Product: | CSC - Customer Care |
---|---|
Description: | This view is the MLSed view based on CSC_PLAN_HEADERS_B and CSC_PLAN_HEADERS_TL used in lock row event of server side API's |
Implementation/DBA Data: | APPS.CSC_PLAN_HEADERS_VL |
SELECT PNHB.ROWID ROW_ID
, PNHB.PLAN_ID PLAN_ID
, PNHTL.NAME NAME
, PNHB.PLAN_GROUP_CODE PLAN_GROUP_CODE
, PNHB.ORIGINAL_PLAN_ID ORIGINAL_PLAN_ID
, PNHB.USE_FOR_CUST_ACCOUNT USE_FOR_CUST_ACCOUNT
, PNHB.END_USER_TYPE END_USER_TYPE
, 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
, 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
WHERE PNHB.PLAN_ID = PNHTL.PLAN_ID
AND PNHTL.LANGUAGE = USERENV('LANG')