ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470A551A9E05362FB09050512Y SELECT A.JL_INFO_V1 SUPPLIER_NAME, A.JL_INFO_V2 TAXPAYER_ID, A.JL_INFO_V3 SIM_REG_CONT_TYPE, A.JL_INFO_N6 THRESHOLD, A.JL_INFO_V6 INVOICE_NUM, TO_CHAR(A.JL_INFO_D1,'DD-MON-YYYY') INVOICE_DATE, A.JL_INFO_V7 INVOICE_STATUS, A.JL_INFO_V8 DGI_TYPE, A.JL_INFO_N4 INVOICE_AMT, A.JL_INFO_N5 INV_AMT_EXC_TAX, A.JL_INFO_V9 THRESHOLD_MET FROM JL_ZZ_INFO_T A WHERE A.JL_INFO_V9 = 'N' AND A.JL_INFO_V4 = 'N' AND A.JL_INFO_V5 = 'N' AND :P_REPORT_MODE = '02' AND NOT EXISTS (SELECT 1 FROM JL_ZZ_INFO_T B WHERE A.JL_INFO_N1 = B.JL_INFO_N1 AND B.JL_INFO_V9 = 'Y') ORDER BY A.JL_INFO_V1,A.JL_INFO_D1,A.JL_INFO_N3 JL JLARMTBT_XMLP PTB JL Faturamento de Monotributistas Argentinos vs. Relatório de Verificação de Limite Imported from BI Publisher Application: Localizações da América Latina Source: Faturamento de Monotributistas Argentinos vs. Relatório de Verificação de Limite Short Name: JLARMTBT_XMLP DB package: JL_ZZ_AP_MONOTRIB_AWT_PKG US JL Argentine Monotributistas Billing vs. Threshold Verification Imported from BI Publisher Application: Latin America Localizations Source: Argentine Monotributistas Billing vs. Threshold Verification Report Short Name: JLARMTBT_XMLP DB package: JL_ZZ_AP_MONOTRIB_AWT_PKG BI Publisher :p_debug_log :p_legal_entity_id :p_org_id :p_report_date :p_report_mode :p_sob_id :p_supplier_id :p_supplier_name :p_taxpayer_id 1 -20 :p_sob_id Char fnd_profile.value('GL_SET_OF_BKS_ID') PTB ID do Conj. Livros ID do Conj. Livros US Set of Books ID Set of Books ID 2 -10 :p_org_id Char fnd_profile.value('ORG_ID') PTB ID da Organização ID da Organização US Organization ID Organization ID 3 10 :p_report_mode LOV Oracle JLAR_MONOTRIBUTO_REPORT_MODE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='JLAR_MONOTRIBUTO_REPORT_MODE' and nvl (start_date_active,sysdate)<=sysdate and nvl (end_date_active,sysdate)>=sysdate and enabled_flag='Y' order by value,description Y PTB Modo do Relatório Modo do Relatório US Report Mode Report Mode 4 20 :p_legal_entity_id LOV Oracle JLAR_MONOTRIBUTO_COMP_NAME Y select xle.legal_entity_id id, xle.name value, null description from xle_firstparty_information_v xle,hz_geographies hz where xle.geography_id=hz.geography_id and hz.geography_code='AR' order by xle.name Y PTB Nome da Empresa Nome da Empresa US Company Name Company Name 5 30 :p_supplier_id LOV Oracle JLAR_MONOTRIBUTO_SUPP_LIST Y select vendor_id id, vendor_name value, null description from ap_suppliers where global_attribute1='06' and global_attribute8 is not null order by vendor_name PTB Nome do Fornecedor Nome do Fornecedor US Supplier Name Supplier Name 6 40 :p_taxpayer_id LOV Oracle JLAR_MONOTRIBUTO_TAXPAYER_ID Y select nvl(individual_1099,num_1099) id, nvl(individual_1099,num_1099) value, null description from ap_suppliers where global_attribute1='06' and vendor_id=nvl(:$flex$.jlar_monotributo_supp_list,vendor_id) order by value,description SELECT nvl(individual_1099,num_1099) FROM po_vendors WHERE vendor_id = :$flex$.supplier_name PTB ID do Contribuinte ID do Contribuinte US Taxpayer ID Taxpayer ID 7 50 :p_report_date Date sysdate Y PTB Data da Emissão de Relatórios Data da Emissão de Relatórios US Reporting Date Reporting Date