[Home] [Help]
View: XNC_ACTIVE_SUBSCRIPTION_V
Product: | XNC - Sales for Communications (Obsolete) |
Description: | This view gives active subscriptions for an account. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT DECODE(SYSTEM_ID
, NULL
, 'NO_SYSTEM'
, SYSTEM_ID) SYSTEM_ID
, SYSTEM_NAME
, ACCOUNT
, PARTY_ID
FROM XNC_PARTY_ACCT_INSTANCE ORDER BY PARTY_ID
Columns
Name |
SYSTEM_ID |
SYSTEM_NAME |
ACCOUNT |
PARTY_ID |