[Home] [Help]
View: XNC_H_SUBSCRIPTION_V
Product: | XNC - Sales for Communications (Obsolete) |
Description: | This view gives subscription for expired products |
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_H ORDER BY PARTY_ID
Columns
Name |
SYSTEM_ID |
SYSTEM_NAME |
ACCOUNT |
PARTY_ID |