GL Other - Value Added Tax
Description
- Categories
- BI Publisher
- Application
- General Ledger
- Source
- Other - Value Added Tax (XML)
- Short Name
- GLXRLVAT_XML
- DB package
- GL_GLXRLVAT_XMLP_PKG
Imported from BI Publisher
VAT report by period,currency and tax code
VAT report by period,currency and tax code
SQL 33 lines
select null FLEX_DATA_ALL, gjl.tax_code TAX_CODE, gjl.invoice_date INVOICE_DATE, gjl.invoice_identifier INVOICE_NUMBER, gjl.entered_dr RECEIPT_AMOUNT, gjl.entered_cr PAYMENT_AMOUNT, gjl.invoice_amount INVOICE_AMOUNT, gjb.name BATCH_NAME, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_FIELD_ALL from gl_code_combinations gcc, gl_je_batches gjb, gl_je_headers gjh, gl_je_lines gjl where gjl.period_name=:P_PERIOD_NAME and gjl.tax_code = decode( :P_TAX_CODE, null, gjl.tax_code,:P_TAX_CODE ) and nvl( gjl.tax_code, ' ') <> ' ' and gjl.ledger_id =:P_LEDGER_ID and gjh.je_header_id = gjl.je_header_id and gjh.currency_code = :P_CURRENCY_CODE and gjb.je_batch_id = gjh.je_batch_id and gjb.status = 'P' and gcc.code_combination_id = gjl.code_combination_id &WHERE_DAS order by gjl.tax_code, gjl.invoice_date, gjl.invoice_identifier, &FLEX_ORDERBY_ALL |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger | LOV Oracle | |
| Period | LOV Oracle | |
| Currency | LOV Oracle | |
| Tax Code | LOV Oracle |