JA India - Fringe Benefits Transaction Review

➜ Back to Library
Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India - Fringe Benefits Transaction Review Report
Short Name: JAIFBTREV
DB package:
Run JA India - Fringe Benefits Transaction Review and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT 
               TL_fbt_tax_amount          
             , TL_surcharge_amount        
             , TL_edu_cess_amount         
             , TL_sh_cess_amount          
             , TL_fbt_tax_amount
               + TL_surcharge_amount
               + TL_edu_cess_amount
               + TL_sh_cess_amount        TL_TAX_TOTAL
             FROM 
             (
               SELECT 
                 ROUND(SUM(jfr.fbt_tax_amount)      ,:G_PRECISION)      TL_FBT_TAX_AMOUNT     
               , ROUND(SUM(jfr.fbt_surcharge_amount),:G_PRECISION)      TL_SURCHARGE_AMOUNT   
               , ROUND(SUM(jfr.fbt_edu_cess_amount) ,:G_PRECISION)      TL_EDU_CESS_AMOUNT    
               , ROUND(SUM(jfr.fbt_sh_cess_amount)  ,:G_PRECISION)      TL_SH_CESS_AMOUNT                 
               FROM jai_fbt_repository           jfr,
                    ja_lookups                   jl
              WHERE jfr.legal_entity_id    = :p_legal_entity_id
                AND jfr.fringe_benefit_type_code =NVL(:p_fringe_benefit_type_code, jfr.fringe_benefit_type_code)
                AND jl.lookup_type         = 'JAI_INDIA_FB_TYPES'
                AND jl.lookup_code         = jfr.fringe_benefit_type_code
                AND ( (    jfr.source in ('Others','Payables')                  
                       AND jfr.invoice_date >=  NVL(trunc(:p_period_start_date), jfr.period_start_date)     
                       AND jfr.invoice_date <=  NVL(trunc(:p_period_end_date)  , jfr.period_end_date)
                      )
                      OR 
                      (    jfr.manual_flag = 'Y'                  
                       AND jfr.period_start_date >=  NVL(trunc(:p_period_start_date), jfr.period_start_date)     
                       AND jfr.period_end_date   <=  NVL(trunc(:p_period_end_date)  , jfr.period_end_date)
                      )
                    )                                           
             )
Parameter Name SQL text Validation
Legal Entity 
 
 LOV Oracle
FBT Year 
 
 LOV Oracle
Period Start Date 
 
 LOV Oracle
Period End Date 
 
 LOV Oracle
Benefit Type 
 
 LOV Oracle
Download
Related Blitz Reports
JA India - Fringe Benefits Schedule JA India - PLA Register - draft JA India - Income Tax Act Fixed Asset Schedules - draft JA India - Total Sales - draft JA India - Commerical Invoice For AR - draft JA India - Service Tax - draft JA India - Purchases Report- Not Supported: Reserved For Future Use JA India - ST Forms Customer - draft JA India - Outside Processing Challan - draft
Blitz Report™

Blitz Report™ provides multiple benefits: