ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0B43869E053B46B63588994 SELECT a.cost cost , c.asset_id, c.asset_number, decode(:p_type, 'Summary', null, 'Detail', c.asset_number) asset_number1, b.block_id block_id1, d.start_date start_date1, d.end_date end_date1, d.slno, e.description, a.transaction_header_id_in , a.date_effective, JA_JAINASST_XMLP_PKG.cf_5formula(c.asset_id, b.block_id) CF_5, JA_JAINASST_XMLP_PKG.cf_additions_costformula(a.cost, a.transaction_header_id_in, a.date_effective, c.asset_id) cf_additions_cost FROM fa_books a, JAI_FA_AST_BLOCKS b, jai_fa_ast_block_dtls c, JAI_FA_AST_PERIOD_RATES d, fa_additions e WHERE a.asset_id = c.asset_id AND e.asset_id = a.asset_id AND ( ( c.asset_type = 'CAPITALIZED' AND a.capitalize_flag = 'YES' ) OR c.asset_type = 'EXPENSED' ) AND a.book_type_code = nvl(:book_name,a.book_type_code) AND a.book_type_code = b.book_type_code AND to_char(b.block_id) = c.block_id AND a.cost > nvl(d.exempt_upto,0) AND a.date_ineffective is null AND a.transaction_header_id_out is null AND c.date_of_acquisition BETWEEN d.start_date AND d.end_date AND b.start_date BETWEEN nvl(:start_date,b.start_date) AND nvl(:end_date,b.year_ended) AND d.year_start = nvl(:start_date,d.year_start) AND d.year_end = nvl(:end_date,d.year_end) UNION SELECT a.cost cost , c.asset_id, c.asset_number, decode(:p_type, 'Summary', null, 'Detail', c.asset_number) asset_number1, b.block_id, d.start_date, d.end_date, d.slno, e.description, a.transaction_header_id_in , a.date_effective, JA_JAINASST_XMLP_PKG.cf_5formula(c.asset_id, b.block_id) CF_5, JA_JAINASST_XMLP_PKG.cf_additions_costformula(a.cost, a.transaction_header_id_in, a.date_effective, c.asset_id) cf_additions_cost FROM fa_books a, JAI_FA_AST_BLOCKS b, jai_fa_ast_block_dtls c, JAI_FA_AST_PERIOD_RATES d, fa_additions e WHERE a.asset_id = c.asset_id AND e.asset_id = a.asset_id AND ( ( c.asset_type = 'CAPITALIZED' AND a.capitalize_flag = 'YES' ) OR c.asset_type = 'EXPENSED' ) and a.book_type_code = nvl(:book_name,a.book_type_code) and to_char(b.block_id) = c.block_id and a.cost<= nvl(d.exempt_upto,0) and a.date_ineffective is null and a.transaction_header_id_out is null and a.date_placed_in_service between d.start_date and d.end_date and a.book_type_code = b.book_type_code and b.start_date between nvl(:start_date,b.start_date) and nvl(:end_date,b.year_ended) and d.year_start = nvl(:start_date,d.year_start) and d.year_end =nvl(:end_date,d.year_end) UNION SELECT a.cost cost , a.asset_id, c.asset_number, decode(:p_type, 'Summary', null, 'Detail', c.asset_number) asset_number1, b.block_id block_id1, d.start_date, d.end_date, d.slno , e.description, a.transaction_header_id_in , a.date_effective, JA_JAINASST_XMLP_PKG.cf_5formula(c.asset_id, b.block_id) CF_5, JA_JAINASST_XMLP_PKG.cf_additions_costformula(a.cost, a.transaction_header_id_in, a.date_effective, c.asset_id) cf_additions_cost FROM fa_books a,JAI_FA_AST_BLOCKS b, jai_fa_ast_block_dtls c,JAI_FA_AST_PERIOD_RATES d,fa_additions e WHERE a.asset_id = c.asset_id and e.asset_id = a.asset_id and a.book_type_code = nvl(:book_name,a.book_type_code) and a.book_type_code = b.book_type_code and to_char(b.block_id) = c.block_id and a.cost > nvl(d.exempt_upto,0) and a.date_ineffective is null and a.transaction_header_id_out is null and c.date_of_acquisition between d.start_date and d.end_date and b.start_date between nvl(:start_date,b.start_date) and nvl(:end_date,b.year_ended) and d.year_start = nvl(:start_date,d.year_start) and d.year_end =nvl(:end_date,d.year_end) UNION SELECT a.cost cost , a.asset_id,c.asset_number,decode(:p_type, 'Summary', null, 'Detail', c.asset_number) asset_number1,b.block_id,d.start_date,d.end_date,d.slno , e.description, a.transaction_header_id_in , a.date_effective, JA_JAINASST_XMLP_PKG.cf_5formula(c.asset_id, b.block_id) CF_5, JA_JAINASST_XMLP_PKG.cf_additions_costformula(a.cost, a.transaction_header_id_in, a.date_effective, c.asset_id) cf_additions_cost FROM fa_books a,JAI_FA_AST_BLOCKS b,jai_fa_ast_block_dtls c,JAI_FA_AST_PERIOD_RATES d,fa_additions e WHERE a.asset_id = c.asset_id and e.asset_id = a.asset_id and a.book_type_code = nvl(:book_name,a.book_type_code) and to_char(b.block_id) = c.block_id and a.cost<= nvl(d.exempt_upto,0) and a.date_ineffective is null and a.transaction_header_id_out is null and a.date_placed_in_service between d.start_date and d.end_date and a.book_type_code = b.book_type_code and b.start_date between nvl(:start_date,b.start_date) and nvl(:end_date,b.year_ended) and d.year_start = nvl(:start_date,d.year_start) and d.year_end =nvl(:end_date,d.year_end) and b.block_id=:block_id JA JAINASST_XML US JA India - Depreciation detail report - draft Application: Asia/Pacific Localizations Source: India - Depreciation detail report (XML) - Not Supported: Reserved For Future Use Short Name: JAINASST_XML DB package: JA_JAINASST_XMLP_PKG ZHS JA 印度 - 折旧明细报表- 不支持：已保留供将来使用 Application: 亚太地区本地化 Source: 印度 - 折旧明细报表 (XML) - 不支持：已保留供将来使用 Short Name: JAINASST_XML DB package: JA_JAINASST_XMLP_PKG BI Publisher :block_id :book_name :end_date :lend_date :lstart_date :p_conc_request_id :p_context_value :p_type :start_date 1 10 :start_date LOV Oracle JA_IN_FA_VS_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 desc Y US Start Date ZHS 起始日期 2 20 :end_date LOV Oracle JA_IN_FA_VS_END_DATE Y select a.year_end id, a.year_end value, null description from jai_fa_ast_years a order by a.year_end desc Y US End Date ZHS 终止日期 3 30 :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 ZHS 账簿名称 4 40 :p_type LOV Oracle Type Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1021384 order by ffvv.flex_value Y US Level Of Detail ZHS 明细程度