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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 
 
 Char
Download
 
Related Blitz Reports
XLA Distribution Links Summary GL Account Analysis (Distributions) EOS GL Account Analysis GL Account Analysis 11g GL Account Analysis (Distributions) 11g FA Japanese Depreciable Assets Tax Summary GL SLA Drillback Diagnostic FA Tax Preference - draft FA Japanese Detail by Asset Type (Addition/All Assets) Report 180 Characters
Blitz Report™

Blitz Report™ provides multiple benefits: