eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.JAI_AP_TDS_F16_DTLS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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