VIEW: AR.AR_CMGT_CREDIT_REQUESTS#

Source

View Text - Preformatted

select CREDIT_REQUEST_ID CREDIT_REQUEST_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, APPLICATION_NUMBER APPLICATION_NUMBER, APPLICATION_DATE APPLICATION_DATE, REQUESTOR_TYPE REQUESTOR_TYPE, REQUESTOR_ID REQUESTOR_ID, REVIEW_TYPE REVIEW_TYPE, CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION, CHECK_LIST_ID CHECK_LIST_ID, CREDIT_ANALYST_ID CREDIT_ANALYST_ID, LIMIT_AMOUNT LIMIT_AMOUNT, LIMIT_CURRENCY LIMIT_CURRENCY, TRX_AMOUNT TRX_AMOUNT, TRX_CURRENCY TRX_CURRENCY, CREDIT_CHECK_RULE_ID CREDIT_CHECK_RULE_ID, TERM_LENGTH TERM_LENGTH, CREDIT_TYPE CREDIT_TYPE, PARTY_ID PARTY_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID, SITE_USE_ID SITE_USE_ID, CONTACT_PARTY_ID CONTACT_PARTY_ID, STOCK_EXCHANGE STOCK_EXCHANGE, CURRENT_STOCK_PRICE CURRENT_STOCK_PRICE, STOCK_CURRENCY STOCK_CURRENCY, MARKET_CAPITALIZATION MARKET_CAPITALIZATION, MARKET_CAP_MONETARY_UNIT MARKET_CAP_MONETARY_UNIT, PENDING_LITIGATIONS PENDING_LITIGATIONS, BOND_RATING BOND_RATING, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME, ENTITY_TYPE ENTITY_TYPE, CASE_FOLDER_NUMBER CASE_FOLDER_NUMBER, SCORE_MODEL_ID SCORE_MODEL_ID, ATTACHMENT_FLAG ATTACHMENT_FLAG, STATUS STATUS, REQUEST_ID REQUEST_ID, SOURCE_NAME SOURCE_NAME, SOURCE_USER_ID SOURCE_USER_ID, SOURCE_RESP_ID SOURCE_RESP_ID, SOURCE_RESP_APPLN_ID SOURCE_RESP_APPLN_ID, SOURCE_SECURITY_GROUP_ID SOURCE_SECURITY_GROUP_ID, SOURCE_ORG_ID SOURCE_ORG_ID, SOURCE_COLUMN1 SOURCE_COLUMN1, SOURCE_COLUMN2 SOURCE_COLUMN2, SOURCE_COLUMN3 SOURCE_COLUMN3, NOTES NOTES, REVIEW_CYCLE REVIEW_CYCLE, PARENT_CREDIT_REQUEST_ID PARENT_CREDIT_REQUEST_ID, CREDIT_REQUEST_TYPE CREDIT_REQUEST_TYPE, RECOMMENDATION_NAME RECOMMENDATION_NAME, REASON_CODE REASON_CODE from "AR"."AR_CMGT_CREDIT_REQUESTS"

View Text - HTML Formatted

SELECT CREDIT_REQUEST_ID CREDIT_REQUEST_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, APPLICATION_NUMBER APPLICATION_NUMBER
, APPLICATION_DATE APPLICATION_DATE
, REQUESTOR_TYPE REQUESTOR_TYPE
, REQUESTOR_ID REQUESTOR_ID
, REVIEW_TYPE REVIEW_TYPE
, CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION
, CHECK_LIST_ID CHECK_LIST_ID
, CREDIT_ANALYST_ID CREDIT_ANALYST_ID
, LIMIT_AMOUNT LIMIT_AMOUNT
, LIMIT_CURRENCY LIMIT_CURRENCY
, TRX_AMOUNT TRX_AMOUNT
, TRX_CURRENCY TRX_CURRENCY
, CREDIT_CHECK_RULE_ID CREDIT_CHECK_RULE_ID
, TERM_LENGTH TERM_LENGTH
, CREDIT_TYPE CREDIT_TYPE
, PARTY_ID PARTY_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, SITE_USE_ID SITE_USE_ID
, CONTACT_PARTY_ID CONTACT_PARTY_ID
, STOCK_EXCHANGE STOCK_EXCHANGE
, CURRENT_STOCK_PRICE CURRENT_STOCK_PRICE
, STOCK_CURRENCY STOCK_CURRENCY
, MARKET_CAPITALIZATION MARKET_CAPITALIZATION
, MARKET_CAP_MONETARY_UNIT MARKET_CAP_MONETARY_UNIT
, PENDING_LITIGATIONS PENDING_LITIGATIONS
, BOND_RATING BOND_RATING
, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, ENTITY_TYPE ENTITY_TYPE
, CASE_FOLDER_NUMBER CASE_FOLDER_NUMBER
, SCORE_MODEL_ID SCORE_MODEL_ID
, ATTACHMENT_FLAG ATTACHMENT_FLAG
, STATUS STATUS
, REQUEST_ID REQUEST_ID
, SOURCE_NAME SOURCE_NAME
, SOURCE_USER_ID SOURCE_USER_ID
, SOURCE_RESP_ID SOURCE_RESP_ID
, SOURCE_RESP_APPLN_ID SOURCE_RESP_APPLN_ID
, SOURCE_SECURITY_GROUP_ID SOURCE_SECURITY_GROUP_ID
, SOURCE_ORG_ID SOURCE_ORG_ID
, SOURCE_COLUMN1 SOURCE_COLUMN1
, SOURCE_COLUMN2 SOURCE_COLUMN2
, SOURCE_COLUMN3 SOURCE_COLUMN3
, NOTES NOTES
, REVIEW_CYCLE REVIEW_CYCLE
, PARENT_CREDIT_REQUEST_ID PARENT_CREDIT_REQUEST_ID
, CREDIT_REQUEST_TYPE CREDIT_REQUEST_TYPE
, RECOMMENDATION_NAME RECOMMENDATION_NAME
, REASON_CODE REASON_CODE
FROM "AR"."AR_CMGT_CREDIT_REQUESTS"