ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1123869E053B46B63588994 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 Y JE JEITIELF_XMLP AR JE ملف التسجيل الإلكتروني للفواتير لإيطاليا Application: المحليات الأوروبية Source: ملف التسجيل الإلكتروني للفواتير لإيطاليا Short Name: JEITIELF_XMLP DB package: JE_IT_ELE_INV_REPORT_PKG D JE Elektronische Rechnungslistendatei für Italien Application: Europäische Lokalisierungen Source: Elektronische Rechnungslistendatei für Italien Short Name: JEITIELF_XMLP DB package: JE_IT_ELE_INV_REPORT_PKG F JE Fichier de liste électronique des factures pour l'Italie Application: European Localizations Source: Fichier de liste électronique des factures pour l'Italie Short Name: JEITIELF_XMLP DB package: JE_IT_ELE_INV_REPORT_PKG US JE Invoice Electronic Listing File for Italy Application: European Localizations Source: Invoice Electronic Listing File for Italy Short Name: JEITIELF_XMLP DB package: JE_IT_ELE_INV_REPORT_PKG BI Publisher :p_eft_num :p_request_id :p_source :p_trans_ident_num :p_transmission_prog_num :p_transmission_type :p_vat_rep_entity_id