[Home] [Help]
View: XNC_ACCT_PARTIES_V
Product: | XNC - Sales for Communications (Obsolete) |
Description: | XNC_ACCT_PARTIES_V retrieves limited party details for a customer account. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CUST_ACCOUNT_ID
, PARTY.PARTY_ID
, PARTY_NUMBER
, PARTY_NAME
, PARTY_TYPE
, VALIDATED_FLAG
, PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME
, PERSON_LAST_NAME
, ORG_ID
FROM ASO_I_PARTIES_V PARTY
, JTF_CUST_ACCOUNTS_V ACCT
WHERE PARTY.PARTY_ID = ACCT.PARTY_ID
Columns
Name |
CUST_ACCOUNT_ID |
PARTY_ID |
PARTY_NUMBER |
PARTY_NAME |
PARTY_TYPE |
VALIDATED_FLAG |
PERSON_FIRST_NAME |
PERSON_MIDDLE_NAME |
PERSON_LAST_NAME |
ORG_ID |