[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 |