eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: CSC.CSC_PROF_BLOCKS_B#

Source

View Text - Preformatted


select BLOCK_ID BLOCK_ID, BLOCK_NAME_CODE BLOCK_NAME_CODE, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, SEEDED_FLAG SEEDED_FLAG, OBJECT_CODE OBJECT_CODE, SQL_STMNT_FOR_DRILLDOWN SQL_STMNT_FOR_DRILLDOWN, SQL_STMNT SQL_STMNT, SELECT_CLAUSE SELECT_CLAUSE, CURRENCY_CODE CURRENCY_CODE, FROM_CLAUSE FROM_CLAUSE, WHERE_CLAUSE WHERE_CLAUSE, ORDER_BY_CLAUSE ORDER_BY_CLAUSE, OTHER_CLAUSE OTHER_CLAUSE, 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, BLOCK_LEVEL BLOCK_LEVEL, BATCH_SQL_STMNT BATCH_SQL_STMNT, ZD_EDITION_NAME ZD_EDITION_NAME from "CSC"."CSC_PROF_BLOCKS_B"

View Text - HTML Formatted

SELECT BLOCK_ID BLOCK_ID
, BLOCK_NAME_CODE BLOCK_NAME_CODE
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, SEEDED_FLAG SEEDED_FLAG
, OBJECT_CODE OBJECT_CODE
, SQL_STMNT_FOR_DRILLDOWN SQL_STMNT_FOR_DRILLDOWN
, SQL_STMNT SQL_STMNT
, SELECT_CLAUSE SELECT_CLAUSE
, CURRENCY_CODE CURRENCY_CODE
, FROM_CLAUSE FROM_CLAUSE
, WHERE_CLAUSE WHERE_CLAUSE
, ORDER_BY_CLAUSE ORDER_BY_CLAUSE
, OTHER_CLAUSE OTHER_CLAUSE
, 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
, BLOCK_LEVEL BLOCK_LEVEL
, BATCH_SQL_STMNT BATCH_SQL_STMNT
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "CSC"."CSC_PROF_BLOCKS_B"