JL Argentine Monotributistas Billing vs. Threshold Verification
Description
Categories: BI Publisher
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
Application: Latin America Localizations
Source: Argentine Monotributistas Billing vs. Threshold Verification Report
Short Name: JLARMTBT_XMLP
DB package: JL_ZZ_AP_MONOTRIB_AWT_PKG
Run
JL Argentine Monotributistas Billing vs. Threshold Verification and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |