[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: |
APPS.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 |