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 |
