JL Argentine Monotributistas Billing vs. Threshold Verification
Description
Categories: BI Publisher
Columns: Supplier Name, Taxpayer Id, Sim Reg Cont Type, Threshold, Invoice Num, Invoice Date, Invoice Status, Dgi Type, Invoice Amt, Inv Amt Exc Tax ...
Columns: Supplier Name, Taxpayer Id, Sim Reg Cont Type, Threshold, Invoice Num, Invoice Date, Invoice Status, Dgi Type, Invoice Amt, Inv Amt Exc Tax ...
Application: Latin America Localizations
Source: Argentine Monotributistas Billing vs. Threshold Verification Report
Short Name: JLARMTBT_XMLP
DB package: JL_ZZ_AP_MONOTRIB_AWT_PKG
Source: Argentine Monotributistas Billing vs. Threshold Verification Report
Short Name: JLARMTBT_XMLP
DB package: JL_ZZ_AP_MONOTRIB_AWT_PKG
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Report Mode |
|
LOV Oracle | |
Company Name |
|
LOV Oracle | |
Supplier Name |
|
LOV Oracle | |
Taxpayer ID |
|
LOV Oracle | |
Reporting Date |
|
Date | |
Set of Books ID |
|
||
Organization ID |
|