CSC Views (79)

CSC - Customer Care — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
CSC_ACCOUNT_BALI_V	View for ACCOUNTS tab based on HZ_CUST_ACCOUNTS and AR_LOOKUPS
CSC_ACCOUNT_OVERVIEW_V	CSC_ACCOUNT_OVERVIEW_V retrieves an overview of the customer account.
CSC_ACCT_RELATIONSHIP_V	CSC_ACCT_RELATIONSHIP_V retrieves related accounts for a customer account.
CSC_ACCT_SITE_USES_V
CSC_ACTIVITIES_V	View of JTF_IH_ACTIVITIES. This view is used to get activities for an interaction
CSC_BILLING_PREFERENCES_V	CSC_BILLING_PREFERENCES_V retrieves billing preferences for a customer account.
CSC_COLOR_CODES_V	View of CSC_COLOR_CODES. This view is used in Customer Profile Setup form - Preferences tab.
CSC_CONDITION_EXPRESSION_V
CSC_CONDITION_FUNCTION_V
CSC_CONDITION_HEADERS_V	Defines a Condition to be evaluated upon the occurrence of an Action.
CSC_CONDITION_LINES_V	view on okc_condition_lines_v
CSC_CONDITION_LINE_DETAILS_V	Each Condition Line expresses a Boolean condition. Multiple Condition Lines may be and'd or or'd together and nested using parenthesis.
CSC_CONDITION_OUTCOMES_V	Registration of a PL/SQL process or a workflow with the application for use as an OUTCOME, CONTRACT PROCESS, QA PROCESS, or FUNCTION in a C
CSC_CONTACT_RESTRICTIONS_V
CSC_CUSTOMERS_AUDIT_HIST_V	View of CSC_CUSTOMERS_AUDIT_HIST. This view is used in Customer Override Criticallity form.
CSC_CUSTOMERS_V	View of CSC_CUSTOMERS. This view is used in Customer Override Criticallity form.
CSC_CUSTOMER_PROFILE_DB_V	Internal View used in Dashboard
CSC_CUSTOMER_PROFILE_V	Internal View used in Profile form
CSC_CUSTOMER_RESPONSE_V	Contains Relationship information, Subject (Caller) and Object (Person/Group/Organization) information
CSC_CUST_ACCOUNTS_ROLES_V	This view retrieves the list of contacts for a given account
CSC_CUST_ACCT_SITES_V
CSC_CUST_PLANS_AUDIT_V	This view is based on CSC_CUST_PLANS_AUDIT used in lock row event of server side API's
CSC_CUST_PLANS_V	This view is based on CSC_CUST_PLANS used in lock row event of server side API's
CSC_CUST_PROFILE_CREDIT_V
CSC_FND_ALL_COLUMNS_V	View to get column properties in FND_COLUMNS
CSC_GS_CONTACTS_V	View of HZ_CONTACTS_POINTS. This view is used to get only the contact details of customers
CSC_GS_CUSTOMERS_GEN_V	View used to perform search operation on customer information in the contact center form.
CSC_GS_CUSTOMERS_GRP_V	View used to perform search operation on customer information in the contact center form.
CSC_GS_CUSTOMERS_ORG_ADV_V	View used to perform search operation on customer information in the contact center form.
CSC_GS_CUSTOMERS_ORG_V	View used to perform search operation on customer information in the contact center form.
CSC_GS_CUSTOMERS_PER_ADV_V	View used to perform search operation on customer information in the contact center form.
CSC_GS_CUSTOMERS_PER_V	View used to perform search operation on customer information in the contact center form.
CSC_GS_CUSTOMERS_V	View used to perform search operation on customer information in the contact center form.
CSC_HZ_CONTACT_POINTS_V	View of HZ_CONTACT_POINTS, HZ_PARTIES. This view is used to get contact details along with customers details
CSC_HZ_EDUCATION_V	View of HZ_EDUCATION. This view is used to get Education details of a party
CSC_HZ_EMPLOYMENT_HISTORY_V	View of HZ_EMPLOYEE_HISTORY. This view is used to get employee history details.
CSC_HZ_LOCATIONS_V	View of HZ_LOCATIONS. This view is used to get Location details.
CSC_HZ_ORG_PROFILES_V	View of HZ_ORGANIZATION, HZ_PARTIES. This view is used to get organization details of a party
CSC_HZ_PARTIES_CONT_INFO_V	Contact Information for a customer
CSC_HZ_PARTIES_CONT_PTS_REL_V	This view has been specifically designed for Contact Center Search window. Gives Customer Party, Contact Party and Relationship Party inform
CSC_HZ_PARTIES_INFO_V	Party information along with the country name
CSC_HZ_PARTIES_REL_V	Gives Customer Party, Contact Party and Relationship Party information
CSC_HZ_PARTIES_SELF_NEW_V	View of HZ_PARTIES, HZ_RELATIONSHIPS. This view is used in Contact center form to get party relationships details along with self party rela
CSC_HZ_PARTIES_SELF_V	View of HZ_PARTIES, HZ_PARTY_RELATIONSHIPS. This view is used in Contact center form to get party relationships details along with self part
CSC_HZ_PARTIES_SRCH_REL_V	This view has been specifically designed for Contact Center Search window. Gives Customer Party, Contact Party and Relationship Party inform
CSC_HZ_PARTIES_V	View of HZ_PARTIES, HZ_PARTY_RELATIONSHIPS. This view is used to get party relationships details
CSC_HZ_PARTY_ACCOUNTS_V	Account and Role information of a Party
CSC_HZ_PARTY_LOCATIONS_V	View of HZ_LOCATIONS. This view is used to get party locations details
CSC_HZ_PARTY_RELATIONSHIPS_V	View of HZ_RELATIONSHIPS. View is used to get party relationship details.
CSC_HZ_PARTY_SITES_V	View of HZ_LOCATIONS, HZ_PARTY_SITES. Links party to physical locations
CSC_HZ_PERSON_INTEREST_V	View of HZ_PERSON_INTEREST. This view is used to get person interests
CSC_HZ_PER_PROFILES_V	View of HZ_PERSON_PROFILES, HZ_PARTY_RELATIONSHIPS. Detailed information about a party. Refer to base table for details.
CSC_HZ_PHONES_V	View to concatenate Area code and Phone number and display as a single column
CSC_INTERACTIONS_V	View of JTF_IH_INTERACTIONS . This view is used to get Inteaction details for a party.
CSC_LOOKUPS	Group of Lookup Types and Lookup Codes used in Customer Care
CSC_PLAN_ENABLE_SETUP_V	This view is based on CSC_PLAN_ENABLE_SETUP used in lock row event of server side API's
CSC_PLAN_HEADERS_V	This view is based on CSC_PLAN_HEADRES_B & CSC_PLAN_HEADRES_TL used in the client code
CSC_PLAN_HEADERS_VL	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
CSC_PLAN_LINES_V	This view is based on CSC_PLAN_LINES used in lock row event of server side API's
CSC_PLAN_SEARCH_V	This view is used to perfom serarch operation on the plans module.
CSC_PROFILE_CATEGORY_DB_V	Internal View used in Dashboard
CSC_PROF_BLOCKS_VL	This view is the MLSed view based on CSC_PROF_BLOCKS_B and CSC_PROF_BLOCKS_TL. This view is used in Customer Profile Setup form- Profile Che
CSC_PROF_BLOCK_RESULTS_V	View of CSC_PROF_BLOCK_RESULTS. This view will give us information on the result of the Profile Check Variables when the Profile Engine is r
CSC_PROF_CATEGORY_LOOKUPS_V	View joining csc_prof_group_categories and csc_lookups
CSC_PROF_CHECKS_VL	This view is the MLSed view based on CSC_PROF_CHECKS_B and CSC_PROF_CHECKS_TL. This view is used in Customer Profile Setup form- Profile Che
CSC_PROF_CHECK_RATINGS_V	View of CSC_PROF_CHECK_RATINGS. This view is used in Customer Profile Setup form - Profile Checks tab.
CSC_PROF_CHECK_RESULTS_V	View of CSC_PROF_CHECK_RESULTS. This view will give us information on the result and grade of the Check Variables when the Profile Engine is
CSC_PROF_CHECK_RULES_VL	This view is the MLSed view based on CSC_PROF_CHECK_RULES_B and CSC_PROF_CHECK_RULES_TL. This view is used in Customer Profile Setup form- P
CSC_PROF_DRILLDOWN_V	View of CSC_PROF_DRILLDOWN. This view is used in to Contact Center form - Dashboard tab and Profile form.
CSC_PROF_GROUPS_VL	This view is the MLSed view based on CSC_PROF_GROUPS_B and CSC_PROF_GROUPS_TL. This view is used in Customer Profile Setup form- Profile Gro
CSC_PROF_GROUP_CATEGORIES_V	View of CSC_PROF_GROUP_CATEGORIES. This view is used in Customer Profile Setup form - Profile Groups tab and Dashboard Groups tab.
CSC_PROF_GROUP_CHECKS_V	View of CSC_PROF_GROUP_CHECKS. This view is used in Customer Profile Setup form - Profile Groups tab and Dashboard Groups tab.
CSC_PROF_MODULE_GROUPS_V	View of CSC_PROF_MODULE_GROUPS. This view is used in Customer Profile Setup form - Preferences tab.
CSC_PROF_RESULTS_V	Internal View used in Profile form
CSC_PROF_TABLE_COLUMNS_VL	This view is the MLSed view based on CSC_PROF_TABLE_COLUMNS_VL and CSC_PROF_TABLE_COLUMNS_TL. This view is used in Customer Profile Setup fo
CSC_REVERSE_PHONE_V	Gives reverse phone number from HZ_CONTACT_POINTS table
CSC_SEARCH_DUMMY_V	This view has been created for Contact Center search window to act as a placeholder for the Search Grid metadata
CSC_SR_KB_NOTE_LINKS_V	This view combines JTF notes with knowledge management element links and set links. Used by Oracle Support for integration from Service Req
CSC_SUSPENSION_ACTIVITY_V	AST_SUSPENSION_ACTIVITY_V retrieves suspension activity for a customer account.