View: CSC_SEARCH_DUMMY_V

Product:	CSC - Customer Care
Description:	This view has been created for Contact Center search window to act as a placeholder for the Search Grid metadata
Implementation/DBA Data:	APPS.CSC_SEARCH_DUMMY_V

View Text

SELECT NULL PER_TITLE
, NULL PER_FULL_NAME
, NULL PER_FIRST_NAME
, NULL PER_LAST_NAME
, NULL PER_FIRST_NAME_PHONETIC
, NULL PER_LAST_NAME_PHONETIC
, 0 PER_PARTY_ID
, SYSDATE PER_LAST_UPDATE_DATE
, NULL CONT_PARTY_NUMBER
, 0 CONT_PARTY_ID
, SYSDATE CONT_LAST_UPDATE_DATE
, NULL RELATION_MEAING
, NULL RELATION_CODE
, 0 RELATIONSHIP_ID
, SYSDATE RELATION_LAST_UPDATE_DATE
, NULL CUST_PARTY_NAME
, NULL CUST_FIRST_NAME
, NULL CUST_LAST_NAME
, NULL CUST_FIRST_NAME_PHONETIC
, NULL CUST_LAST_NAME_PHONETIC
, NULL CUST_PARTY_TYPE
, NULL CUST_PARTY_NUMBER
, 0 CUST_PARTY_ID
, SYSDATE CUST_LAST_UPDATE_DATE
, NULL ACCOUNT_NUMBER
, NULL ACCOUNT_NAME
, 0 CUST_ACCOUNT_ID
, SYSDATE ACCT_LAST_UPDATE_DATE
, NULL PHONE_COUNTRY_CODE
, NULL PHONE_AREA_CODE
, NULL PHONE_NUMBER
, NULL PHONE_LINE_TYPE
, 0 PHONE_ID
, SYSDATE PHONE_LAST_UPDATE_DATE
, NULL EMAIL
, 0 EMAIL_ID
, SYSDATE EMAIL_LAST_UPDATE_DATE
, NULL URL
, 0 URL_ID
, SYSDATE URL_LAST_UPDATE_DATE
, NULL SITE_NAME
, 0 SITE_ID
, SYSDATE SITE_LAST_UPDATE_DATE
, NULL ADDRESS
, NULL ADDRESS1
, NULL ADDRESS2
, NULL ADDRESS3
, NULL ADDRESS4
, NULL CITY
, NULL STATE
, NULL POSTAL_CODE
, NULL PROVINCE
, NULL COUNTY
, NULL COUNTRY
, 0 LOCATION_ID
, SYSDATE LOC_LAST_UPDATE_DATE
FROM DUAL

Columns