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