JA India - Settlement Detail Report (XML Publisher)
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Asia/Pacific Localizations
Source: India - Settlement Detail Report (XML Publisher)
Short Name: JAINGSTR_XML
DB package: JAI_EXTRACT_PKG
Application: Asia/Pacific Localizations
Source: India - Settlement Detail Report (XML Publisher)
Short Name: JAINGSTR_XML
DB package: JAI_EXTRACT_PKG
Run
JA India - Settlement Detail Report (XML Publisher) and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT d.detail_tax_line_id report_header_id ,d.detail_tax_line_id detail_tax_line_id ,d.rep_context_id rep_context_id ,d.entity_code entity_code ,d.request_id request_id ,d.tax_regime_id tax_regime_id ,d.tax_regime_code tax_regime_code ,d.tax_regime_name tax_regime_name ,d.first_party_primary_reg_num tax_registration_num ,d.applied_from_trx_date settlement_period_from ,d.applied_to_trx_date settlement_period_to ,d.trx_date settlement_date ,d.posted_date last_settlement_date ,d.party_id organization_id ,d.party_name organization_name ,d.party_site_id location_id ,d.party_site_name location_code ,d.tax_authority_id tax_authority_id ,d.tax_authority_name tax_authority_name ,d.tax_authority_site_id tax_authority_site_id ,d.tax_authority_site_name tax_authority_site_code ,d.matched_amount rounded_amount ,d.liability_amount payable_amount ,d.trx_amount settlement_amount ,e.detail_tax_line_ext_id detail_tax_line_ext_id ,e.numeric1 org_id ,e.numeric2 settlement_template_id ,e.attribute1 org_name ,e.attribute2 template_name FROM jai_rep_trx_detail_t d ,jai_rep_trx_jx_ext_t e WHERE d.detail_tax_line_id = e.detail_tax_line_id AND d.entity_code = 'SETTLEMENT_HEADER' AND d.request_id = :P_CONC_REQUEST_ID ORDER BY d.tax_line_number |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Tax Regime |
|
LOV Oracle | |
| Tax Registration Number |
|
LOV Oracle | |
| Settlement Period From |
|
Date | |
| Settlement Period To |
|
Date |
