Bug 6630

Done.

-- Make new report for TDS query as given below:-

Please help of Ms. Anushree Madam

QUERY FOR REPORT

SELECT
	  SUPPLIER_CODE 				SUPPLIER_CODE
	, PAN_NUMBER 					PAN_NUMBER
	, TDS_RATE 						TDS_RATE
	, SUM(NVL(TDS_BASE_AMOUNT,0)) 	TDS_BASE_AMOUNT
	, SUM(NVL(TDS_AMOUNT, 0 )) 		TDS_AMOUNT
FROM
	(
		SELECT
			  A.SPV_SPLR 			SUPPLIER_CODE
			, (
				SELECT PAN_NUMBER
				FROM ALL_SUPPLIERS
				WHERE SUPPLIER_CODE = A.SPV_SPLR
			   )PAN_NUMBER
			, A.TDS_RATE
			, A.TDS_BASE_AMOUNT
			, A.TDS_AMOUNT
		FROM SP_VOUCHERS A
		WHERE A.COMPANY IN (
								SELECT COMPANY_CODE
								FROM VW_COMPANIES
								WHERE STATUS = 'A' CONNECT BY PRIOR COMPANY_CODE = PARENT_COMPANY START WITH PARENT_COMPANY = PKG_CONTROLS.GET_FIRST_PARENT(:CO)
							)
		AND ( A.SUPPLIER_PURCHASE IS NOT NULL  AND  A.TDS_BASE_AMOUNT IS NOT NULL )
		AND SPV_DATE BETWEEN :P_QRY_BGN_DATE AND NVL(:P_QRY_END_DATE, :P_QRY_BGN_DATE)
		AND A.STATUS != 'A'

		UNION ALL

		SELECT
			  A.SUPPLIER_CODE 			SUPPLIER_CODE
			, (
				SELECT PAN_NUMBER
				FROM ALL_SUPPLIERS
				WHERE SUPPLIER_CODE = A.SUPPLIER_CODE
			   )PAN_NUMBER
			, A.TDS_RATE
			, A.TDS_BASE_AMOUNT
			, A.TDS_AMOUNT
		FROM ACCOUNTS_PAYABLE_VOUCHERS A
		WHERE A.COMPANY  IN (
								SELECT COMPANY_CODE
								FROM VW_COMPANIES
								WHERE STATUS = 'A' CONNECT BY PRIOR COMPANY_CODE = PARENT_COMPANY START WITH PARENT_COMPANY = PKG_CONTROLS.GET_FIRST_PARENT(:CO)
							)
		AND ( A.SUPPLIER_PURCHASE IS NOT NULL  AND  A.TDS_BASE_AMOUNT IS NOT NULL )
		AND VOUCHER_DATE BETWEEN :P_QRY_BGN_DATE AND NVL(:P_QRY_END_DATE, :P_QRY_BGN_DATE)
		AND A.STATUS != 'A'
	)
GROUP BY
		  SUPPLIER_CODE
		, PAN_NUMBER
		, TDS_RATE