Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JAI_AP_TDS_F16_DTLS_V |
SELECT TDS_PAYMENTS.FORM16_HDR_ID FORM16_HDR_ID
, TDS_CERT.CERTIFICATE_NUM CERTIFICATE_NUM
, TDS_PAYMENTS.CERTIFICATE_LINE_NUM LINE_NUM
, TDS_PAYMENTS.PARENT_INVOICE_ID INVOICE_ID
, TDS_PAYMENTS.INVOICE_ID TDS_INVOICE_ID
, TDS_PAYMENTS.TAXABLE_BASIS INVOICE_AMOUNT
, TDS_PAYMENTS.TAXABLE_BASIS TAXABLE_BASIS
, TDS_PAYMENTS.TDS_TAX_RATE TDS_TAX_RATE
, TDS_PAYMENTS.TAX_AMOUNT TDS_INVOICE_AMT
, TDS_PAYMENTS.INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, BASE_INVOICES.ORG_ID ORG_ID
, TAX.STFORM_TYPE IT_CERTIFICATE_NUMBER
, TDS_CERT.CREATION_DATE CREATION_DATE
, TDS_CERT.CREATED_BY CREATED_BY
, TDS_CERT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TDS_CERT.LAST_UPDATED_BY LAST_UPDATED_BY
, TDS_CERT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TDS_CERT.FIN_YR FIN_YR
, TDS_PAYMENTS.INVOICE_DATE TDS_INV_DATE
, TDS_CERT.ORG_TAN_NUM ORG_TAN_NUM
, TAX.SURCHARGE_RATE SURCHARGE_RATE
, TAX.CESS_RATE CESS_RATE
, TAX.SH_CESS_RATE SH_CESS_RATE
, TDS_PAYMENTS.TAX_AUTHORITY_ID TAX_AUTHORITY_ID
FROM JAI_AP_TDS_INV_PAYMENTS TDS_PAYMENTS
, JAI_AP_TDS_F16_HDRS_ALL TDS_CERT
, AP_INVOICES_ALL BASE_INVOICES
, JAI_CMN_TAXES_ALL TAX
WHERE TDS_PAYMENTS.FORM16_HDR_ID = TDS_CERT.FORM16_HDR_ID
AND TDS_PAYMENTS.PARENT_INVOICE_ID = BASE_INVOICES.INVOICE_ID
AND TAX.TAX_ID = TDS_PAYMENTS.TDS_TAX_ID