JE French Deductible VAT Declaration

Description
Categories: BI Publisher
Application: European Localizations
Source: French Deductible VAT Declaration Report
Short Name: JEFRTXDC_XMLP
DB package: JE_ZZ_AUDIT_AP_PKG
    SELECT     jg_info_v1                     ven_name
              ,jg_info_v2                     ven_no
              ,jg_info_v3                     inv_type
              ,jg_info_n1                     tax_amt
              ,jg_info_n2                     rec_per
              ,jg_info_v4                     company
              ,jg_info_v5                     acc_no
              ,jg_info_n3                     tax_rate
              ,jg_info_v6                     tax_id
              ,jg_info_v7                     offset_tax_rate_code
              ,jg_info_v8                     tax_type
              ,jg_info_v9                     inv_no
              ,TO_CHAR(jg_info_d1,'DD-MON-RRRR')                     acc_date
              ,jg_info_n4                     invoice_id
              ,TO_CHAR(jg_info_d2,'DD-MON-RRRR')                     cancelled_date
              ,jg_info_n5                     item_line_cnt
              ,jg_info_n6                     charge_dist_id
              ,TO_CHAR(jg_info_d3,'DD-MON-RRRR')                      check_void_date
              ,jg_info_n7                     pay_amt
              ,jg_info_v10                    line_type_lookup_code
              ,jg_info_v11                    line_type_lookup_code_item
              ,jg_info_v12                    line_type_lookup_code_prepay
              ,jg_info_v13                    reversal_flag_item
              ,jg_info_v14                    reversal_flag_pay
              ,jg_info_v15                    reversal_flag_prepay
              ,jg_info_n8                     parent_reversal_id
              ,jg_info_n9                     base_amount
              ,jg_info_n10                    invoice_amount
              ,TO_CHAR(jg_info_d4,'DD-MON-RRRR')                     void_date
              ,TO_CHAR(jg_info_d5,'DD-MON-RRRR')                     future_pay_due_date
              ,TO_CHAR(jg_info_d6,'DD-MON-RRRR')                     check_date
              ,jg_info_v16                    payment_status_flag
              ,TO_CHAR(jg_info_d7,'DD-MON-RRRR')                     accounting_date
              ,jg_info_n11                    reversal_inv_pmt_id
              ,jg_info_v17                    c_company
    FROM JG_ZZ_VAT_TRX_GT JVGT
    WHERE (jg_info_v30 is null or jg_info_v30 <> 'H')
  --AND    DECODE('''' || :P_COMPANY || '''', NULL, ' 1 ', jg_info_v10 ) = DECODE('''' || :P_COMPANY || '''', --NULL, ' 1 ', '''' || :P_COMPANY || '''')
    ORDER BY   company
              ,tax_type
              ,tax_rate
              ,acc_no
              ,rec_per
              ,tax_amt
Parameter Name SQL text Validation
Calling Report
 
Chart of Accounts ID
 
LOV Oracle
FND_NUMBER_2
 
Number
FND_NUMBER_1
 
Number
Declaration Date
 
Date
Balancing Segment
 
Ledger
 
LOV Oracle
Legal Entity
 
LOV Oracle
Declaration Period
 
LOV Oracle
Reporting Identifier
 
LOV Oracle
Report By VAT Entity?
 
LOV Oracle