Product: | CSC - Customer Care |
---|---|
Description: | This view is based on CSC_PLAN_ENABLE_SETUP used in lock row event of server side API's |
Implementation/DBA Data: | APPS.CSC_PLAN_ENABLE_SETUP_V |
SELECT CPES.ENABLE_SETUP_ID ENABLE_SETUP_ID
, CPES.FUNCTION_ID FUNCTION_ID
, FFV.USER_FUNCTION_NAME USER_FUNCTION_NAME
, CPES.START_DATE_ACTIVE START_DATE_ACTIVE
, CPES.END_DATE_ACTIVE END_DATE_ACTIVE
, FFV.FUNCTION_NAME FUNCTION_NAME
, FFV.TYPE FUNCTION_TYPE
, FFV.APPLICATION_ID APPLICATION_ID
, FAV.APPLICATION_NAME APPLICATION_NAME
, CPES.ON_INSERT_ENABLE_FLAG ON_INSERT_ENABLE_FLAG
, CPES.ON_UPDATE_ENABLE_FLAG ON_UPDATE_ENABLE_FLAG
, CPES.CUSTOM1_ENABLE_FLAG CUSTOM1_ENABLE_FLAG
, CPES.CUSTOM2_ENABLE_FLAG CUSTOM2_ENABLE_FLAG
, CPES.CREATION_DATE CREATION_DATE
, CPES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CPES.CREATED_BY CREATED_BY
, CPES.LAST_UPDATED_BY LAST_UPDATED_BY
, CPES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CPES.ATTRIBUTE1 ATTRIBUTE1
, CPES.ATTRIBUTE2 ATTRIBUTE2
, CPES.ATTRIBUTE3 ATTRIBUTE3
, CPES.ATTRIBUTE4 ATTRIBUTE4
, CPES.ATTRIBUTE5 ATTRIBUTE5
, CPES.ATTRIBUTE6 ATTRIBUTE6
, CPES.ATTRIBUTE7 ATTRIBUTE7
, CPES.ATTRIBUTE8 ATTRIBUTE8
, CPES.ATTRIBUTE9 ATTRIBUTE9
, CPES.ATTRIBUTE10 ATTRIBUTE10
, CPES.ATTRIBUTE11 ATTRIBUTE11
, CPES.ATTRIBUTE12 ATTRIBUTE12
, CPES.ATTRIBUTE13 ATTRIBUTE13
, CPES.ATTRIBUTE14 ATTRIBUTE14
, CPES.ATTRIBUTE15 ATTRIBUTE15
, CPES.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CPES.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM CSC_PLAN_ENABLE_SETUP CPES
, FND_FORM_FUNCTIONS_VL FFV
, FND_APPLICATION_VL FAV
WHERE CPES.FUNCTION_ID = FFV.FUNCTION_ID
AND FFV.APPLICATION_ID = FAV.APPLICATION_ID