JA India - Fringe Benefits Schedule
Description
- Categories
- BI Publisher
- Application
- Asia/Pacific Localizations
- Source
- India - Fringe Benefits Schedule Report
- Short Name
- JAIFBTSCH
DB package:
SQL 27 lines
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') |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Legal Entity | LOV Oracle | |
| FBT Year | LOV Oracle |