FND Design Data [Home] [Help]

View: XNC_PVT_PARTY_SITE_USES_V

Product: XNC - Sales for Communications (Obsolete)
Description: This View defines the relationship between a Party Site and the Site Usage( Bill_To, Ship_To).The Primary_Per_Type defines whether the site is a Primary one for the Site Usage.
Implementation/DBA Data: Not implemented in this database
View Text

SELECT PARTY_SITE_USE_ID
, PARTY_SITE_ID
, SITE_USE_TYPE
, PRIMARY_PER_TYPE
FROM HZ_PARTY_SITE_USES
WHERE NVL(STATUS
, 'A') = 'A'

Columns

Name
PARTY_SITE_USE_ID
PARTY_SITE_ID
SITE_USE_TYPE
PRIMARY_PER_TYPE