ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1593869E053B46B63588994 Select NVL(actg.accounting_date, det.gl_date) perception_date, det.BILLING_TP_TAXPAYER_ID perception_agent_cuit, det.trx_number doc_num, lpad(substr(det.TAX_REGIME_CODE,1,3),3,'0') DGI_Tax_regime_code , abs(SUM(NVL(det.tax_amt_funcl_curr, det.tax_amt))) perception_amount, JL_JLARPPTF_XMLP_PKG.c_perception_amt_charformula(abs ( SUM ( NVL ( det.tax_amt_funcl_curr , det.tax_amt ) ) )) C_Perception_amt_char, JL_JLARPPTF_XMLP_PKG.doc_numberformula(det.trx_number) DOC_NUMBER FROM zx_rep_context_t con, zx_rep_trx_detail_t det, ZX_REP_ACTG_EXT_T actg 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 actg.detail_tax_line_id(+) = det.detail_tax_line_id GROUP BY actg.accounting_date, det.billing_tp_taxpayer_id, det.trx_number, det.tax_regime_code, det.trx_date, det.trx_type_id, det.gl_date ORDER BY det.trx_date, det.trx_type_id, det.trx_number Y JL JLARPPTF_XML US JL Argentine Payables Perceptions Taken Flat File - draft Application: Latin America Localizations Source: Argentine Payables Perceptions Taken Flat File (XML) - Not Supported: Reserved For Future Use Short Name: JLARPPTF_XML DB package: JL_JLARPPTF_XMLP_PKG BI Publisher :applications_template_report :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_void :c_nls_yes :c_report_start_date :p_conc_request_id :p_debug_switch :p_errbuf :p_gl_date_from :p_gl_date_to :p_legal_entity_id :p_legal_entity_name :p_min_precision :p_reporting_entity_id :p_reporting_level :p_retcode :p_set_of_books_id :p_trace_switch :p_vat_percep_tax_type 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_gl_date_from Date select sysdate from dual Y US Start Date 5 50 :p_gl_date_to Date select sysdate from dual Y US End Date 6 60 :p_vat_percep_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 Perception Tax Type