FND Design Data [Home] [Help]

View: AR_INVOICE_COUNT_TERMS_V

Product: AR - Receivables
Description: Collects the number of payment dates defined for a transaction
Implementation/DBA Data: ViewAPPS.AR_INVOICE_COUNT_TERMS_V
View Text

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

Columns

Name
TERM_ID
NUMBER_OF_TERMS