FA Japanese Detail by Asset Type (Decrease Assets)
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
Application: Assets
Source: Japanese Detail by Asset Type (Decrease Assets) Report
Short Name: FADTXD
DB package: FA_JAPAN_DEP_TAX_DECREASE_PKG
Run
FA Japanese Detail by Asset Type (Decrease Assets) and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |