FA Japanese Detail by Asset Type (Decrease Assets)

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
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 NameSQL textValidation
Request ID
 
Number
Book
 
LOV Oracle
Year
 
Number
State
 
Char
Download
Related Blitz Reports
XLA Distribution Links Summary EOS GL Account Analysis GL Account Analysis 11g GL Account Distribution Analysis 11g FA Japanese Depreciable Assets Tax Summary GL Account Distribution Analysis GL SLA Drillback Diagnostic FA Tax Preference - draft FA Japanese Detail by Asset Type (Addition/All Assets) Report 180 Characters
Blitz Report™