FA Japanese Detail by Asset Type (Decrease Assets)

Description
Categories: BI Publisher
Columns: 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 ...
Application: Assets
Source: Japanese Detail by Asset Type (Decrease Assets) Report
Short Name: FADTXD
DB package: FA_JAPAN_DEP_TAX_DECREASE_PKG
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
Parameter Name SQL text Validation
Request ID
 
Number
Book
 
LOV Oracle
Year
 
Number
State
 
Location Structure ID
 
Number