View: CSC_CUST_PLANS_V

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

View Text

SELECT CPN.ROWID ROW_ID
, CPN.PLAN_ID PLAN_ID
, CPN.CUST_PLAN_ID CUST_PLAN_ID
, CPN.PARTY_ID PARTY_ID
, CPN.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PNHV.NAME PLAN_NAME
, PNHV.PLAN_GROUP_CODE PLAN_GROUP_CODE
, CL1.MEANING GROUP_NAME
, HP.PARTY_NUMBER PARTY_NUMBER
, HP.PARTY_NAME PARTY_NAME
, HP.PARTY_TYPE PARTY_TYPE
, HCAA.ACCOUNT_NUMBER ACCOUNT_NUMBER
, HCAA.ACCOUNT_NAME ACCOUNT_NAME
, CPN.START_DATE_ACTIVE START_DATE_ACTIVE
, CPN.END_DATE_ACTIVE END_DATE_ACTIVE
, PNHV.CUSTOMIZED_PLAN CUSTOMIZED_PLAN
, PNHV.USE_FOR_CUST_ACCOUNT USE_FOR_CUST_ACCOUNT
, PNHV.END_USER_TYPE END_USER_TYPE
, CL3.MEANING END_USER_TYPE_MEANING
, CPN.PLAN_STATUS_CODE PLAN_STATUS_CODE
, CL2.MEANING PLAN_STATUS_MEANING
, CPN.MANUAL_FLAG MANUAL_FLAG
, CPN.REQUEST_ID REQUEST_ID
, CPN.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CPN.PROGRAM_ID PROGRAM_ID
, CPN.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CPN.CREATION_DATE CREATION_DATE
, CPN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CPN.CREATED_BY CREATED_BY
, CPN.LAST_UPDATED_BY LAST_UPDATED_BY
, FNDU.USER_NAME USER_NAME
, CPN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CPN.ATTRIBUTE1 ATTRIBUTE1
, CPN.ATTRIBUTE2 ATTRIBUTE2
, CPN.ATTRIBUTE3 ATTRIBUTE3
, CPN.ATTRIBUTE4 ATTRIBUTE4
, CPN.ATTRIBUTE5 ATTRIBUTE5
, CPN.ATTRIBUTE6 ATTRIBUTE6
, CPN.ATTRIBUTE7 ATTRIBUTE7
, CPN.ATTRIBUTE8 ATTRIBUTE8
, CPN.ATTRIBUTE9 ATTRIBUTE9
, CPN.ATTRIBUTE10 ATTRIBUTE10
, CPN.ATTRIBUTE11 ATTRIBUTE11
, CPN.ATTRIBUTE12 ATTRIBUTE12
, CPN.ATTRIBUTE13 ATTRIBUTE13
, CPN.ATTRIBUTE14 ATTRIBUTE14
, CPN.ATTRIBUTE15 ATTRIBUTE15
, CPN.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CPN.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM CSC_CUST_PLANS CPN
, CSC_PLAN_HEADERS_VL PNHV
, CSC_LOOKUPS CL1
, CSC_LOOKUPS CL2
, CSC_LOOKUPS CL3
, FND_USER FNDU
, HZ_PARTIES HP
, HZ_CUST_ACCOUNTS HCAA
WHERE CPN.PLAN_ID = PNHV.PLAN_ID
AND PNHV.PLAN_GROUP_CODE = CL1.LOOKUP_CODE (+)
AND CL1.LOOKUP_TYPE (+) = 'CSC_PLAN_GROUP'
AND CPN.PLAN_STATUS_CODE = CL2.LOOKUP_CODE
AND CL2.LOOKUP_TYPE = 'CSC_PLAN_STATUS'
AND CL3.LOOKUP_TYPE = 'CSC_END_USER_TYPE'
AND CL3.LOOKUP_CODE = PNHV.END_USER_TYPE
AND FNDU.USER_ID = CPN.LAST_UPDATED_BY
AND CPN.PARTY_ID = HP.PARTY_ID
AND CPN.CUST_ACCOUNT_ID = HCAA.CUST_ACCOUNT_ID (+)

Columns