Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JAI_WCT_CERT_DTLS_V |
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