VIEW: CSC.CSC_PROF_GROUPS_B#

Source

View Text - Preformatted

select GROUP_ID GROUP_ID, GROUP_NAME_CODE GROUP_NAME_CODE, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, USE_IN_CUSTOMER_DASHBOARD USE_IN_CUSTOMER_DASHBOARD, PARTY_TYPE PARTY_TYPE, SEEDED_FLAG SEEDED_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF, UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID, UPGRADED_STATUS_FLAG UPGRADED_STATUS_FLAG, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID, APPLICATION_ID APPLICATION_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "CSC"."CSC_PROF_GROUPS_B"

View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, GROUP_NAME_CODE GROUP_NAME_CODE
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, USE_IN_CUSTOMER_DASHBOARD USE_IN_CUSTOMER_DASHBOARD
, PARTY_TYPE PARTY_TYPE
, SEEDED_FLAG SEEDED_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, UPGRADED_STATUS_FLAG UPGRADED_STATUS_FLAG
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID
, APPLICATION_ID APPLICATION_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "CSC"."CSC_PROF_GROUPS_B"