SELECT decode(length(jeiteitl.vat_registration_num),13,substr(jeiteitl.vat_registration_num,3,11),
jeiteitl.vat_registration_num) PARTY_VAT_REG_NUM
,substr(jeiteitl.vat_registration_num,0,2) PARTY_COUNTRY_CODE
,jeiteitl.tax_payer_id TAX_PAYER_ID
,jeiteitl.party_type PARTY_TYPE
,jeiteitl.party_name PARTY_NAME
,jeiteitl.indv_party_first_name INDV_PARTY_FIRST_NAME
,jeiteitl.indv_party_last_name INDV_PARTY_LAST_NAME
,jeiteitl.party_address PARTY_ADDRESS
,jeiteitl.party_zip PARTY_ZIP
,jeiteitl.party_city PARTY_CITY
,jeiteitl.party_province PARTY_PROVINCE
,jeiteitl.party_country PARTY_COUNTRY
,jeiteitl.party_pe_address PARTY_PE_ADDRESS
,jeiteitl.party_pe_zip PARTY_PE_ZIP
,jeiteitl.party_pe_city PARTY_PE_CITY
,jeiteitl.party_pe_province PARTY_PE_PROVINCE
,jeiteitl.party_pe_country PARTY_PE_COUNTRY
,jeiteitl.inv_document_type INV_DOCUMENT_TYPE
,to_char(jeiteitl.trx_date,'RRRR-MM-DD') TRX_DATE
,to_char(jeiteitl.gl_date,'RRRR-MM-DD') GL_DATE
,jeiteitl.trx_num TRX_NUM
,jeiteitl.vat_not_exposed_flag VAT_NOT_EXPOSED
,trim(to_char(jeiteitl.taxable_amt,'99999999990.99')) TAXABLE_AMT
,trim(to_char(jeiteitl.tax_amt,'99999999990.99')) TAX_AMT
,trim(to_char(jeiteitl.taxable_amt+jeiteitl.tax_amt,'99999999990.99')) TOTAL_AMT
,trim(to_char(jeiteitl.tax_rate,'990.99')) TAX_RATE
,jeiteitl.nature_of_vat NATURE_OF_VAT
,jeiteitl.offset_flag OFFSET_FLAG
FROM je_it_ele_inv_trx_lines jeiteitl
WHERE jeiteitl.request_id = :P_REQUEST_ID
AND jeiteitl.rec_type = 'R'
AND jeiteitl.eft_num = :P_EFT_NUM
ORDER BY party_name,party_address,trx_date,trx_num |