[Home] [Help] [Dependency Information]
Object Name: | CSC_PLAN_SEARCH_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_PLAN_SEARCH_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used to perfom search operations on the plans module. It consists of an overall view of all the plans and their association to customers.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | (15) | References PARTY_ID of HZ_PARTIES | |
PLAN_ID | NUMBER | (15) | References PLAN_ID of CSC_PLAN_HEADERS_B | |
PLAN_NAME | VARCHAR2 | (90) | The name of the plan from CSC_PLAN_HEADES_TL | |
PARTY_NAME | VARCHAR2 | (360) | Party Name | |
PARTY_NUMBER | VARCHAR2 | (30) | Party Number | |
CUST_ACCOUNT_ID | NUMBER | (15) | Customer Account Identifier | |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Account Number | |
ACCOUNT_NAME | VARCHAR2 | (240) | Account Name | |
ACCOUNT_STATUS | VARCHAR2 | (240) | References LOOKUP_CODE description from AR_LOOKUPS when LOOKUP_TYPE is CODE_STATUS, possible values are "Active" and "Inactive" | |
PLAN_STATUS_CODE | VARCHAR2 | (30) | References LOOKUP_CODE of CSC_LOOKUPS. Values are ''Applied'', ''Removed'', ''Disabled'' | |
PLAN_STATUS | VARCHAR2 | (80) | Quickcode meaning for plan status code | |
START_DATE_ACTIVE | DATE | Effective start date | ||
END_DATE_ACTIVE | DATE | Effective end date | ||
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 the plan group code | |
USE_FOR_CUST_ACCOUNT | VARCHAR2 | (3) | 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) | 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 | |
CUSTOMIZED_PLAN | VARCHAR2 | (3) | Identifier which if 'Y', the plan is customized |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, PLAN_ID
, PLAN_NAME
, PARTY_NAME
, PARTY_NUMBER
, CUST_ACCOUNT_ID
, ACCOUNT_NUMBER
, ACCOUNT_NAME
, ACCOUNT_STATUS
, PLAN_STATUS_CODE
, PLAN_STATUS
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PLAN_GROUP_CODE
, GROUP_NAME
, USE_FOR_CUST_ACCOUNT
, END_USER_TYPE
, END_USER_TYPE_MEANING
, CUSTOMIZED_PLAN
FROM APPS.CSC_PLAN_SEARCH_V;
APPS.CSC_PLAN_SEARCH_V is not referenced by any database object
|
|
|