JA India GSTR-3 Return

Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India GSTR-3 Return Report
Short Name: JAIGSTR3
DB package:
Run JA India GSTR-3 Return and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT NULL pdcash,
                        TAX_LIABILITY_AMT tax_val,
                        NULL txpd,
                        lines.CREDIT_TO_BE_ADJUSTED itc
                 FROM JAI_STL_TRX_HDRS_V hdr, JAI_STL_TRX_LINES_V lines
                 WHERE hdr.STL_HDR_ID = lines.STL_HDR_ID
                 AND TO_CHAR (TRUNC (hdr.settlement_date), 'MONYYYY') LIKE :P_PERIOD_NAME
				 AND REGISTRATION_NUM = :P_FIRST_PTY_REG_NUM
Parameter Name SQL text Validation
Tax Regime
 
LOV Oracle
Registration Number
 
LOV Oracle
Return Period(MONYYYY)
 
Char
IGST Interest Paid
 
Number
SGST Interest Paid
 
Number
CGST Interest Paid
 
Number
CESS Interest Paid
 
Number
SGST LateFee Paid
 
Number
CGST LateFee Paid
 
Number