DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.CSC_CUST_PLANS_V

Object Details
Object Name: CSC_CUST_PLANS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSC.CSC_CUST_PLANS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is based on CSC_CUST_PLANS. It contains detailed information about all the plans that have customers attached to it.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
PLAN_ID NUMBER (15) Yes References PLAN_ID of CSC_PLAN_HEADERS_B.
CUST_PLAN_ID NUMBER (15) Yes Unique identifier of customer plan
PARTY_ID NUMBER (15) Yes References PARTY_ID of HZ_PARTIES
CUST_ACCOUNT_ID NUMBER (15)
References CUST_ACCOUNT_ID of HZ_CUST_ACCOUNTS.
PLAN_NAME VARCHAR2 (90) Yes Plan name
PLAN_GROUP_CODE VARCHAR2 (30)
References LOOKUP_CODE of CSC_LOOKUPS. This specifies the lookup code of the group to which plan belongs
GROUP_NAME VARCHAR2 (80)
Quickcode meaning for plan group code
PARTY_NUMBER VARCHAR2 (30) Yes Party number
PARTY_NAME VARCHAR2 (360) Yes Party name
PARTY_TYPE VARCHAR2 (30) Yes Type of party. This is limited to person, organization, group or relationship
MEANING VARCHAR2 (80) Yes Description of party type. This is limited to person, organization, group or relationship
ACCOUNT_NUMBER VARCHAR2 (30)
Account number
ACCOUNT_NAME VARCHAR2 (240)
Account name
START_DATE_ACTIVE DATE

Effective start date
END_DATE_ACTIVE DATE

Effective end date
CUSTOMIZED_PLAN VARCHAR2 (3) Yes Identifier which if 'Y', the plan is customized
USE_FOR_CUST_ACCOUNT VARCHAR2 (3) Yes Identifier which if 'Y' allows a plan to be added to a customer account
END_USER_TYPE VARCHAR2 (30)
This column gets its value from the CSC lookup type CSC_END_USER_TYPE. It is used to identify the users of an application. Plans are defined for specific users of an applications; its outcome will be visible only to those type of users. If this column has a NULL value, the plan outcomes will be visible to all users.The valid lookup codes are: CUST - Customer facing application AGENT - Agent facing application.
END_USER_TYPE_MEANING VARCHAR2 (80) Yes The description (meaning) of the application's end user type from CSC_LOOKUPS. LOOKUP_TYPE = CSC_END_USER_TYPE LOOKUP_CODES CUST - Customer facing application. AGENT - Agent facing application
PLAN_STATUS_CODE VARCHAR2 (30) Yes References LOOKUP_CODE of CSC_LOOKUPS. Values are ''Applied'', ''Removed'', ''Disabled''
PLAN_STATUS_MEANING VARCHAR2 (80) Yes Quickcode meaning for plan status code
MANUAL_FLAG VARCHAR2 (3) Yes If 'Y' then Assignment Engine cannot remove customer from plan portfolio else if 'N' it can remove
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last update date of this record by a concurrent program
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
USER_NAME VARCHAR2 (100) Yes Name of the user who added the plan to a customer
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield Segment Column
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield Structure Defining column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Version number of the record
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      PLAN_ID
,      CUST_PLAN_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      PLAN_NAME
,      PLAN_GROUP_CODE
,      GROUP_NAME
,      PARTY_NUMBER
,      PARTY_NAME
,      PARTY_TYPE
,      MEANING
,      ACCOUNT_NUMBER
,      ACCOUNT_NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CUSTOMIZED_PLAN
,      USE_FOR_CUST_ACCOUNT
,      END_USER_TYPE
,      END_USER_TYPE_MEANING
,      PLAN_STATUS_CODE
,      PLAN_STATUS_MEANING
,      MANUAL_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      USER_NAME
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      OBJECT_VERSION_NUMBER
FROM APPS.CSC_CUST_PLANS_V;

Dependencies

[top of page]

APPS.CSC_CUST_PLANS_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
SynonymCSC_CUST_PLANS
ViewCSC_LOOKUPS
ViewCSC_PLAN_HEADERS_VL
SynonymFND_USER
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
APPS.CSC_CUST_PLANS_V is referenced by following:

SchemaAPPS
ViewCSC_PLAN_SEARCH_V