VIEW: APPS.AR_INVOICE_COUNT_TERMS_V

Source

View Text - Preformatted

SELECT term_id term_id, count(*) number_of_terms FROM ra_terms_lines tl GROUP BY term_id UNION SELECT -1, 0 FROM dual

View Text - HTML Formatted

SELECT TERM_ID TERM_ID
, COUNT(*) NUMBER_OF_TERMS
FROM RA_TERMS_LINES TL GROUP BY TERM_ID UNION SELECT -1
, 0
FROM DUAL