ORA-00904 invalid IDENTIFIER IS COMING WHEN EXECUTING THE MIDDLE SCALAR
896798Nov 23 2011 — edited Dec 30 2011 SELECT (SELECT tran_descn FROM TRANCODEINFO WHERE tran_code = a.txn_type
) AS txn_type, a.tot,
*(*
SELECT COUNT () FROM (*_
SELECT f.txn_auth_id FROM FINGERTXNLOG f WHERE f.bank_id = '515' AND f.txn_date_time BETWEEN_
TO_DATE ('2011-03-01 00:00:00','YY/MM/DD HH24:MI:SS') AND TO_DATE ('2011-11-17 23:59:59','YY/MM/DD HH24:MI:SS')_
AND f.txn_status = 'C' AND f.txn_type = 'BV' AND f.txn_type = a.txn_type AND f.terminal_id = NVL('',f.terminal_id)_
*) a*
)
AS succ_records FROM (
SELECT f.txn_type , COUNT (f.txn_auth_id) AS tot FROM FINGERTXNLOG f WHERE f.bank_id = '515' AND f.txn_date_time BETWEEN
TO_DATE ('2011-03-01 00:00:00','YY/MM/DD HH24:MI:SS') AND TO_DATE ('2011-11-17 23:59:59','YY/MM/DD HH24:MI:SS')
AND f.txn_type = 'BV' AND f.terminal_id = NVL('',f.terminal_id) GROUP BY f.txn_type
) a