VIEW: FA.FA_DEPRN_TAX_ENTITIES#

Source

View Text - Preformatted

select LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME, ALTERNATE_LEGAL_ENTITY_NAME ALTERNATE_LEGAL_ENTITY_NAME, ADDRESS_LINE ADDRESS_LINE, ALTERNATE_ADDRESS_LINE ALTERNATE_ADDRESS_LINE, POSTAL_CODE POSTAL_CODE, PHONE PHONE, CEO_NAME CEO_NAME, ALTERNATE_CEO_NAME ALTERNATE_CEO_NAME, BUSINESS_TYPE BUSINESS_TYPE, TOTAL_CAPITAL_AMOUNT TOTAL_CAPITAL_AMOUNT, BUSINESS_ESTABLISHED_DATE BUSINESS_ESTABLISHED_DATE, CONTACT_NAME CONTACT_NAME, CONTACT_TITLE CONTACT_TITLE, CONTACT_PHONE CONTACT_PHONE, TAX_ACCOUNTANT_NAME TAX_ACCOUNTANT_NAME, TAX_ACCOUNTANT_PHONE TAX_ACCOUNTANT_PHONE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, BOOK_TYPE_CODE BOOK_TYPE_CODE, COMPANY_ID COMPANY_ID from "FA"."FA_DEPRN_TAX_ENTITIES"

View Text - HTML Formatted

SELECT LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, ALTERNATE_LEGAL_ENTITY_NAME ALTERNATE_LEGAL_ENTITY_NAME
, ADDRESS_LINE ADDRESS_LINE
, ALTERNATE_ADDRESS_LINE ALTERNATE_ADDRESS_LINE
, POSTAL_CODE POSTAL_CODE
, PHONE PHONE
, CEO_NAME CEO_NAME
, ALTERNATE_CEO_NAME ALTERNATE_CEO_NAME
, BUSINESS_TYPE BUSINESS_TYPE
, TOTAL_CAPITAL_AMOUNT TOTAL_CAPITAL_AMOUNT
, BUSINESS_ESTABLISHED_DATE BUSINESS_ESTABLISHED_DATE
, CONTACT_NAME CONTACT_NAME
, CONTACT_TITLE CONTACT_TITLE
, CONTACT_PHONE CONTACT_PHONE
, TAX_ACCOUNTANT_NAME TAX_ACCOUNTANT_NAME
, TAX_ACCOUNTANT_PHONE TAX_ACCOUNTANT_PHONE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, COMPANY_ID COMPANY_ID
FROM "FA"."FA_DEPRN_TAX_ENTITIES"