FA Japanese Detail by Asset Type (Decrease Assets)

select  CEO_NAME
       ,ALTERNATE_CEO_NAME
       ,LEGAL_ENTITY_NAME
       ,ALTERNATE_LEGAL_ENTITY_NAME
       ,ADDRESS_LINE
       ,ALTERNATE_ADDRESS_LINE
       ,POSTAL_CODE
       ,PHONE
       ,BUSINESS_TYPE
       ,TOTAL_CAPITAL_AMOUNT
       ,BUSINESS_ESTABLISHED_DATE
       ,to_char(BUSINESS_ESTABLISHED_DATE,'YYYY') BUSINESS_ESTABLISHED_DATE_YEAR
       ,to_char(BUSINESS_ESTABLISHED_DATE,'MM') BUSINESS_ESTABLISHED_DATE_MON
       ,CONTACT_NAME
       ,CONTACT_TITLE
       ,CONTACT_PHONE
       ,TAX_ACCOUNTANT_NAME
       ,TAX_ACCOUNTANT_PHONE
       ,to_char(sysdate,'MM') H_TODAY_MONTH
       ,to_char(sysdate,'DD') H_TODAY_DAY
from FA_DEPRN_TAX_ENTITIES
where book_type_code = :P_BOOK