AR_INVOICE_COUNT_TERMS_V
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: VIEW
Columns
| Name |
|---|
|
TERM_ID NUMBER_OF_TERMS |
Query
| SQL_Statement |
|---|
|
SELECT term_id term_id, count(*) number_of_terms FROM ra_terms_lines tl GROUP BY term_id UNION SELECT -1, 0 FROM AR_LOOKUPS WHERE LOOKUP_TYPE='ADDRESS_LABEL' AND LOOKUP_CODE ='ATTN_DEFAULT_MSG' |