JA India - Fringe Benefits Schedule

Description

Application: Asia/Pacific Localizations
Source: India - Fringe Benefits Schedule Report
Short Name: JAIFBTSCH
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

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')