ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 31BB3FD9F1160ADFE06362FB090507D2 select a.cost cost , c.asset_id, b.block_id block_id1, d.start_date , d.end_date , d.slno, a.transaction_header_id_in , a.date_effective, JA_JAINYEDE_XMLP_PKG.cf_7formula(c.asset_id, b.block_id) CF_7, JA_JAINYEDE_XMLP_PKG.cf_3formula(c.asset_id, b.block_id, a.cost, d.slno, :BLOCK_ID, :RATE, :TYPE1, :OPENING_WDV, :CLOSING_WDV, :DEPN_OF_ASSETS, :TOTAL, :UNPLANNED_DEPN) CF_3, JA_JAINYEDE_XMLP_PKG.cf_8formula(a.cost, a.transaction_header_id_in, a.date_effective, c.asset_id) CF_8 from fa_books a, JAI_FA_AST_BLOCKS b, JAI_FA_AST_BLOCK_DTLS c, JAI_FA_AST_PERIOD_RATES d where a.asset_id = c.asset_id and b.block_id = c.block_id and a.book_type_code = b.book_type_code AND A.BOOK_TYPE_CODE = :BOOK_NAME and date_of_acquisition between d.start_date and d.end_date and TO_CHAR(b.start_date,'DD-MON-RRRR') between TO_CHAR(nvl(:start_date_n,b.start_date),'DD-MON-RRRR') and TO_CHAR(nvl(:end_date_n,b.year_ended),'DD-MON-RRRR') and TO_CHAR(d.year_start,'DD-MON-RRRR') = TO_CHAR(nvl(:start_date_n,d.year_start),'DD-MON-RRRR') and TO_CHAR(d.year_end,'DD-MON-RRRR') = TO_CHAR(nvl(:end_date_n,d.year_end),'DD-MON-RRRR') and A.date_ineffective is null and A.transaction_header_id_out is null and b.block_id=:block_id Y JA JAINYEDE_XML US JA India - Income Tax Act Fixed Asset Schedules Imported from BI Publisher Description: India - Income Tax Act Fixed Asset Schedules Application: Asia/Pacific Localizations Source: India - Income Tax Act Fixed Asset Schedules (XML) - Not Supported: Reserved For Future Use Short Name: JAINYEDE_XML DB package: JA_JAINYEDE_XMLP_PKG ZHS JA 印度 - 所得税帐户 - 固定资产明细表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 印度 - 所得税帐户 - 固定资产明细表 Application: 亚太地区本地化 Source: 印度 - 所得税帐户 - 固定资产明细表 (XML) - 不支持：已保留供将来使用 Short Name: JAINYEDE_XML DB package: JA_JAINYEDE_XMLP_PKG India Localization 1=1 :book_name :end_date :end_date_n :end_date_n1 :p_conc_request_id :p_context_value :start_date :start_date_n :start_date_n1 1 -10 :debugflag Char N US DebugFlag DebugFlag ZHS 调试标志 调试标志 2 10 :start_date LOV Oracle Ja_In_Fa_Start_Date Y select a.year_start id, a.year_start value, null description from jai_fa_ast_years a order by a.year_start Y US Start Date for depreciation ZHS 起始日期 折旧 3 20 :book_name LOV Oracle Book Name Y select book_type_code id, book_type_code value, null description from fa_book_controls where book_type_code in (select distinct book_type_code from jai_fa_ast_blocks) order by book_type_code Y US Book Name For Yede ZHS 账簿名称 适用于 Yede