JA India - Fringe Benefits Schedule
Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India - Fringe Benefits Schedule Report
Short Name: JAIFBTSCH
DB package:
Source: India - Fringe Benefits Schedule Report
Short Name: JAIFBTSCH
DB package:
Run
JA India - Fringe Benefits Schedule and other Oracle EBS reports with Blitz Report™ on our demo environment
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') |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Legal Entity |
|
LOV Oracle | |
FBT Year |
|
LOV Oracle |