VIEW: APPS.JAI_WCT_CERT_DTLS_V

Source

View Text - Preformatted

SELECT jatp.ORG_TAN_NUM , jatp.FIN_YEAR , jatp.CERTIFICATE_NUM , jatp.CERTIFICATE_LINE_NUM , jatp.TDS_SECTION , jatp.CHECK_DATE , jatp.CHECK_AMOUNT , jatp.PAYMENT_AMOUNT , jatp.TDS_TAX_RATE , jatp.TAXABLE_BASIS , jatp.TAX_AMOUNT , jatp.TAX_AUTHORITY_ID , jatp.TAX_AUTHORITY_SITE_ID , jatp.VENDOR_ID , jatp.VENDOR_SITE_ID , jatp.OPERATING_UNIT_ID , jatp.FORM16_HDR_ID , jatp.TDS_TAX_ID , jatp.TDS_PAYMENT_ID , jatp.INVOICE_ID , jatp.CHECK_ID , jatp.INVOICE_PAYMENT_ID , jatp.PREPAY_INVOICE_ID , jatp.PARENT_INVOICE_ID , jatp.THRESHOLD_TRX_ID FROM JAI_AP_TDS_INV_PAYMENTS jatp, JAI_CMN_TAXES_ALL jcta WHERE jatp.tds_tax_id = jcta.tax_id AND jcta.section_type = 'WCT_SECTION' AND jatp.form16_hdr_id IS NOT NULL

View Text - HTML Formatted

SELECT JATP.ORG_TAN_NUM
, JATP.FIN_YEAR
, JATP.CERTIFICATE_NUM
, JATP.CERTIFICATE_LINE_NUM
, JATP.TDS_SECTION
, JATP.CHECK_DATE
, JATP.CHECK_AMOUNT
, JATP.PAYMENT_AMOUNT
, JATP.TDS_TAX_RATE
, JATP.TAXABLE_BASIS
, JATP.TAX_AMOUNT
, JATP.TAX_AUTHORITY_ID
, JATP.TAX_AUTHORITY_SITE_ID
, JATP.VENDOR_ID
, JATP.VENDOR_SITE_ID
, JATP.OPERATING_UNIT_ID
, JATP.FORM16_HDR_ID
, JATP.TDS_TAX_ID
, JATP.TDS_PAYMENT_ID
, JATP.INVOICE_ID
, JATP.CHECK_ID
, JATP.INVOICE_PAYMENT_ID
, JATP.PREPAY_INVOICE_ID
, JATP.PARENT_INVOICE_ID
, JATP.THRESHOLD_TRX_ID
FROM JAI_AP_TDS_INV_PAYMENTS JATP
, JAI_CMN_TAXES_ALL JCTA
WHERE JATP.TDS_TAX_ID = JCTA.TAX_ID
AND JCTA.SECTION_TYPE = 'WCT_SECTION'
AND JATP.FORM16_HDR_ID IS NOT NULL