JA India - Fringe Benefits Schedule

➜ Back to Library
Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
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
Download
Related Blitz Reports
JA India - Fringe Benefits Transaction Review PAY End of Year Reconciliation Summary Totals EGO Item Image Definition Data Template CZ Model Conversion XML Publisher Concurrent Program JA India - RG23C Part I Report - draft - draft JA India - Depreciation detail report - draft JA India - RG 23 D - draft JA India - RG1 Register - draft JA India - Return to Vendor - draft
Blitz Report™

Blitz Report™ provides multiple benefits: