VIEW: AR.AR_CMGT_GUARANTOR_DATA#

Source

View Text - Preformatted

select DATAPOINT_ID DATAPOINT_ID, 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, COUNTRY COUNTRY, TAX_NUMBER TAX_NUMBER, REFERENCE_NAME REFERENCE_NAME, CONTACT_NAME CONTACT_NAME, ADDRESS ADDRESS, PHONE_NUMBER PHONE_NUMBER, CITY CITY, FAX_NUMBER FAX_NUMBER, STATE STATE, EMAIL EMAIL, POSTAL_CODE POSTAL_CODE, PROVINCE PROVINCE, URL URL, CURRENCY CURRENCY, GUARANTEED_AMOUNT GUARANTEED_AMOUNT, FUNDING_AVAILABLE_FROM FUNDING_AVAILABLE_FROM, FUNDING_AVAILABLE_TO FUNDING_AVAILABLE_TO, CASE_FOLDER_ID CASE_FOLDER_ID, NOTES NOTES, GUARANTOR_CREDIT_REQUEST_ID GUARANTOR_CREDIT_REQUEST_ID, ASSET_CLASS_CODE ASSET_CLASS_CODE, ASSET_TYPE_CODE ASSET_TYPE_CODE, DESCRIPTION DESCRIPTION, QUANTITY QUANTITY, UOM_CODE UOM_CODE, REFERENCE_TYPE REFERENCE_TYPE, ASSET_IDENTIFIER ASSET_IDENTIFIER, APPRAISER APPRAISER, APPRAISER_PHONE APPRAISER_PHONE, VALUATION VALUATION, VALUATION_METHOD_CODE VALUATION_METHOD_CODE, VALUATION_DATE VALUATION_DATE, ACQUISITION_DATE ACQUISITION_DATE, PARTY_ID PARTY_ID, CONTACT_PARTY_ID CONTACT_PARTY_ID, CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION, REVIEW_TYPE REVIEW_TYPE from "AR"."AR_CMGT_GUARANTOR_DATA"

View Text - HTML Formatted

SELECT DATAPOINT_ID DATAPOINT_ID
, 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
, COUNTRY COUNTRY
, TAX_NUMBER TAX_NUMBER
, REFERENCE_NAME REFERENCE_NAME
, CONTACT_NAME CONTACT_NAME
, ADDRESS ADDRESS
, PHONE_NUMBER PHONE_NUMBER
, CITY CITY
, FAX_NUMBER FAX_NUMBER
, STATE STATE
, EMAIL EMAIL
, POSTAL_CODE POSTAL_CODE
, PROVINCE PROVINCE
, URL URL
, CURRENCY CURRENCY
, GUARANTEED_AMOUNT GUARANTEED_AMOUNT
, FUNDING_AVAILABLE_FROM FUNDING_AVAILABLE_FROM
, FUNDING_AVAILABLE_TO FUNDING_AVAILABLE_TO
, CASE_FOLDER_ID CASE_FOLDER_ID
, NOTES NOTES
, GUARANTOR_CREDIT_REQUEST_ID GUARANTOR_CREDIT_REQUEST_ID
, ASSET_CLASS_CODE ASSET_CLASS_CODE
, ASSET_TYPE_CODE ASSET_TYPE_CODE
, DESCRIPTION DESCRIPTION
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
, REFERENCE_TYPE REFERENCE_TYPE
, ASSET_IDENTIFIER ASSET_IDENTIFIER
, APPRAISER APPRAISER
, APPRAISER_PHONE APPRAISER_PHONE
, VALUATION VALUATION
, VALUATION_METHOD_CODE VALUATION_METHOD_CODE
, VALUATION_DATE VALUATION_DATE
, ACQUISITION_DATE ACQUISITION_DATE
, PARTY_ID PARTY_ID
, CONTACT_PARTY_ID CONTACT_PARTY_ID
, CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION
, REVIEW_TYPE REVIEW_TYPE
FROM "AR"."AR_CMGT_GUARANTOR_DATA"