VIEW: AR.AR_CMGT_CASE_FOLDERS#

Source

View Text - Preformatted

select CASE_FOLDER_ID CASE_FOLDER_ID, CASE_FOLDER_NUMBER CASE_FOLDER_NUMBER, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, CREDIT_REQUEST_ID CREDIT_REQUEST_ID, CHECK_LIST_ID CHECK_LIST_ID, STATUS STATUS, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, PARTY_ID PARTY_ID, SCORE_MODEL_ID SCORE_MODEL_ID, SITE_USE_ID SITE_USE_ID, CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION, REVIEW_TYPE REVIEW_TYPE, CREDIT_ANALYST_ID CREDIT_ANALYST_ID, TYPE TYPE, DISPLAY_FLAG DISPLAY_FLAG, CREATION_DATE_TIME CREATION_DATE_TIME, LAST_UPDATED LAST_UPDATED, LIMIT_CURRENCY LIMIT_CURRENCY, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, REVIEW_CYCLE REVIEW_CYCLE, REQUEST_ID REQUEST_ID, PREVIOUS_CREDIT_ANALYST_ID PREVIOUS_CREDIT_ANALYST_ID, ORIGINAL_CREDIT_ANALYST_ID ORIGINAL_CREDIT_ANALYST_ID from "AR"."AR_CMGT_CASE_FOLDERS"

View Text - HTML Formatted

SELECT CASE_FOLDER_ID CASE_FOLDER_ID
, CASE_FOLDER_NUMBER CASE_FOLDER_NUMBER
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, CREDIT_REQUEST_ID CREDIT_REQUEST_ID
, CHECK_LIST_ID CHECK_LIST_ID
, STATUS STATUS
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PARTY_ID PARTY_ID
, SCORE_MODEL_ID SCORE_MODEL_ID
, SITE_USE_ID SITE_USE_ID
, CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION
, REVIEW_TYPE REVIEW_TYPE
, CREDIT_ANALYST_ID CREDIT_ANALYST_ID
, TYPE TYPE
, DISPLAY_FLAG DISPLAY_FLAG
, CREATION_DATE_TIME CREATION_DATE_TIME
, LAST_UPDATED LAST_UPDATED
, LIMIT_CURRENCY LIMIT_CURRENCY
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, REVIEW_CYCLE REVIEW_CYCLE
, REQUEST_ID REQUEST_ID
, PREVIOUS_CREDIT_ANALYST_ID PREVIOUS_CREDIT_ANALYST_ID
, ORIGINAL_CREDIT_ANALYST_ID ORIGINAL_CREDIT_ANALYST_ID
FROM "AR"."AR_CMGT_CASE_FOLDERS"