VIEW: APPS.CSC_SEARCH_DUMMY_V

Source

View Text - Preformatted

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, 0 per_obj_ver_number, null cont_party_number, 0 cont_party_id, 0 cont_obj_ver_number, null relation_meaing, null relation_code, 0 relationship_id, 0 relation_obj_ver_number, 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, 0 cust_obj_ver_number, null account_number, null account_name, 0 cust_account_id, 0 acct_obj_ver_number, null phone_country_code, null phone_area_code, null phone_number, null phone_line_type, 0 phone_id, 0 phone_obj_ver_number, null email, 0 email_id, 0 email_obj_ver_number, null url, 0 url_id, 0 url_obj_ver_number, null site_name, 0 site_id, 0 site_obj_ver_number, 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,0 loc_obj_ver_number FROM dual

View Text - HTML Formatted

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
, 0 PER_OBJ_VER_NUMBER
, NULL CONT_PARTY_NUMBER
, 0 CONT_PARTY_ID
, 0 CONT_OBJ_VER_NUMBER
, NULL RELATION_MEAING
, NULL RELATION_CODE
, 0 RELATIONSHIP_ID
, 0 RELATION_OBJ_VER_NUMBER
, 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
, 0 CUST_OBJ_VER_NUMBER
, NULL ACCOUNT_NUMBER
, NULL ACCOUNT_NAME
, 0 CUST_ACCOUNT_ID
, 0 ACCT_OBJ_VER_NUMBER
, NULL PHONE_COUNTRY_CODE
, NULL PHONE_AREA_CODE
, NULL PHONE_NUMBER
, NULL PHONE_LINE_TYPE
, 0 PHONE_ID
, 0 PHONE_OBJ_VER_NUMBER
, NULL EMAIL
, 0 EMAIL_ID
, 0 EMAIL_OBJ_VER_NUMBER
, NULL URL
, 0 URL_ID
, 0 URL_OBJ_VER_NUMBER
, NULL SITE_NAME
, 0 SITE_ID
, 0 SITE_OBJ_VER_NUMBER
, 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
, 0 LOC_OBJ_VER_NUMBER
FROM DUAL