JA India - Settlement Detail Report (XML Publisher)

Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India - Settlement Detail Report (XML Publisher)
Short Name: JAINGSTR_XML
DB package: JAI_EXTRACT_PKG
          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
Settlement Mode
 
Settlement Period To
 
Date
Settlement Period From
 
Date
Tax Registration Number
 
LOV Oracle
Tax Regime
 
LOV Oracle
Ask a question