ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0A33869E053B46B63588994Y SELECT SUM(amt) free_tkt_amt , SUM(fb) free_tkt_fb FROM ( SELECT SUM(NVL(jfr.converted_amount,0)) amt , SUM(NVL(jfr.converted_amount,0)*jfr.taxable_basis/100) fb FROM jai_fbt_repository jfr WHERE jfr.legal_entity_id=:p_legal_entity_id AND jfr.invoice_date>=:period_start_date AND jfr.invoice_date<=:period_end_date AND jfr.fringe_benefit_type_code=:FREE_TKT_CODE AND jfr.manual_flag='N' UNION SELECT SUM(NVL(jfr.distribution_amt,0)) amt , SUM(NVL(jfr.distribution_amt,0)*jfr.taxable_basis/100) fb FROM jai_fbt_repository jfr WHERE jfr.legal_entity_id=:p_legal_entity_id AND jfr.period_start_date>=:period_start_date AND jfr.period_end_date<=:period_end_date AND jfr.fringe_benefit_type_code=:FREE_TKT_CODE AND jfr.manual_flag='Y') JA JAIFBTSCH US JA India - Fringe Benefits Schedule Application: Asia/Pacific Localizations Source: India - Fringe Benefits Schedule Report Short Name: JAIFBTSCH DB package: ZHS JA 印度 - 附加福利分摊计划报表 Application: 亚太地区本地化 Source: 印度 - 附加福利分摊计划报表 Short Name: JAIFBTSCH DB package: BI Publisher :free_tkt_code :p_legal_entity_id :period_end_date :period_start_date 1 10 :p_legal_entity_id LOV Oracle JAI_FBT_LEGAL_ENTITY Y select legal_entity_id id, name value, null description from xle_entity_profiles where legal_entity_id in (select organization_id from jai_rgm_parties,jai_fbt_setup_headers where organization_type='LE' and organization_id=legal_entity_id and regime_id in (select regime_id from jai_rgm_definitions where regime_code='FBT') ) order by value,description Y US Legal Entity ZHS 法人主体 2 20 :p_fbt_year LOV Oracle JAI_FBT_YEAR Y select fbt_year id, fbt_year value, null description from jai_fbt_setup_headers where legal_entity_id=:$flex$.jai_fbt_legal_entity order by value,description Y US FBT Year ZHS FBT 年度