[Home] [Help]
View: XNC_PVT_PARTIES_V
Product: | XNC - Sales for Communications (Obsolete) |
Description: | XNC_PVT_PARTIES_V retrieves Active Party Information |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PARTY_ID
, PARTY_NAME
, PARTY_TYPE
, PERSON_FIRST_NAME
, PERSON_LAST_NAME
, PERSON_MIDDLE_NAME
, ADDRESS1
, CITY
FROM HZ_PARTIES
WHERE STATUS = 'A'
Columns
Name |
PARTY_ID |
PARTY_NAME |
PARTY_TYPE |
PERSON_FIRST_NAME |
PERSON_LAST_NAME |
PERSON_MIDDLE_NAME |
ADDRESS1 |
CITY |