ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1563869E053B46B63588994 SELECT det.trx_id invoice_id, det.trx_date document_date, LPAD(ext.GDF_AP_INVOICES_ATT13, 2, '0') Document_Type, jl_ar_reports_pkg.get_formatted_docnum( det.trx_number ) Document_Num, NVL(det.currency_conversion_rate,1) Exchange_rate, RPAD(det.BILLING_TP_NAME, 25, ' ') Sup_Name, ext.numeric9 tax_amount, det.BILLING_TP_TAXPAYER_ID CUIT_number, det.tax_rate_id, JL_JLARPCFF_XMLP_PKG.cf_acc_dateformula(det.trx_id, det.tax_rate_id) CF_acc_date, JL_JLARPCFF_XMLP_PKG.cf_tax_amountformula(ext.numeric9) CF_Tax_Amount, JL_JLARPCFF_XMLP_PKG.cf_citi_recformula(JL_JLARPCFF_XMLP_PKG.cf_acc_dateformula(det.trx_id, det.tax_rate_id), JL_JLARPCFF_XMLP_PKG.cf_tax_amountformula(ext.numeric9), LPAD ( ext.GDF_AP_INVOICES_ATT13 , 2 , '0' ), jl_ar_reports_pkg.get_formatted_docnum ( det.trx_number ), det.trx_date, det.BILLING_TP_TAXPAYER_ID, RPAD ( det.BILLING_TP_NAME , 25 , ' ' )) CF_citi_rec FROM zx_rep_trx_jx_ext_t ext, zx_rep_context_t con, zx_rep_trx_detail_t det WHERE con.request_id = :p_conc_request_id AND det.request_id = con.request_id AND det.rep_context_id = con.rep_context_id AND ext.detail_tax_line_id = det.detail_tax_line_id GROUP BY det.trx_id, det.trx_date, ext.GDF_AP_INVOICES_ATT13, det.trx_number, det.currency_conversion_rate, det.BILLING_TP_NAME, det.BILLING_TP_TAXPAYER_ID, ext.numeric9, det.tax_rate_id ORDER BY det.trx_date,cuit_number,det.trx_number JL JLARPCFF_XML US JL Argentine Payables CITI Flat File - Legal - draft Application: Latin America Localizations Source: Argentine Payables CITI Flat File - Legal (XML) - Not Supported: Reserved For Future Use Short Name: JLARPCFF_XML DB package: JL_JLARPCFF_XMLP_PKG BI Publisher :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_organisation_name :p_book_type_code :p_conc_request_id :p_end_date :p_errbuf :p_legal_entity_id :p_legal_entity_name :p_reporting_entity_id :p_reporting_level :p_retcode :p_set_of_books_id :p_start_date :p_tax_type :p_transaction_letter_from :p_transaction_letter_to 1 10 :p_reporting_level LOV Oracle XLE_LEGAL_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' order by value,description US Reporting Level 2 20 :p_reporting_entity_id LOV Oracle XLE_LEGAL_REPORTING_CONTEXT Y select entity_id id, entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.xle_legal_reporting_level order by value,description US Reporting Context 3 30 :p_legal_entity_id LOV Oracle ZX_COMPANY_NAME Y select legal_entity_id id, legal_entity_name value, null description from gl_ledger_le_v where :$flex$.xle_legal_reporting_level='1000' and ledger_id=:$flex$.xle_legal_reporting_context order by value,description US Company Name 4 40 :p_start_date Date select sysdate from dual Y US Start Date 5 50 :p_end_date Date select sysdate from dual Y US End Date 6 60 :p_tax_type LOV Oracle JLZZ_AP_TAX_TYPE Y select lookup_code id, lookup_code value, displayed_field description from ap_lookup_codes where lookup_type='TAX TYPE' order by lookup_code Y US VAT Tax Type 7 70 :p_transaction_letter_from LOV Oracle JLAR_AR_DOCUMENT_LETTER Y select substr(lookup_code,1,1) id, substr(lookup_code,1,1) value, meaning description from fnd_lookups where lookup_type='JLAR_DOCUMENT_LETTER' and nvl(start_date_active,sysdate)<=sysdate and nvl(end_date_active,sysdate)>=sysdate and enabled_flag='Y' order by value,description A Y US Transaction Letter From 8 80 :p_transaction_letter_to LOV Oracle JLAR_AR_DOCUMENT_LETTER Y select substr(lookup_code,1,1) id, substr(lookup_code,1,1) value, meaning description from fnd_lookups where lookup_type='JLAR_DOCUMENT_LETTER' and nvl(start_date_active,sysdate)<=sysdate and nvl(end_date_active,sysdate)>=sysdate and enabled_flag='Y' order by value,description A Y US Transaction Letter To :$flex$.xle_legal_reporting_context Reporting Context Company Name :$flex$.xle_legal_reporting_level Reporting Level Company Name :$flex$.xle_legal_reporting_level Reporting Level Reporting Context