[Home] [Help]
View: CS_CP_ADDRESSES_V
Product: | CS - Service |
Description: | Installed at / Ship To information of the Product |
Implementation/DBA Data: |
APPS.CS_CP_ADDRESSES_V
|
View Text
SELECT /*+ FIRST_ROWS */ PARTY_SITE.PARTY_SITE_ID LOCATION
, HL.DESCRIPTION DESCRIPTION
, HZP.PARTY_NAME PARTY_NAME
, PARTY_SITE.PARTY_SITE_NAME PARTY_SITE_NAME
, HL.ADDRESS1 ADDRESS1
, HL.ADDRESS2 ADDRESS2
, HL.ADDRESS3 ADDRESS3
, HL.ADDRESS4 ADDRESS4
, HL.CITY CITY
, HL.STATE STATE
, HL.POSTAL_CODE ZIP
, HL.COUNTRY COUNTRY
, HZP.PARTY_ID PARTY_ID
, HCA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PARTY_SITE.PARTY_SITE_NUMBER SITE_NUMBER
FROM HZ_LOCATIONS HL
, HZ_PARTIES HZP
, HZ_PARTY_SITES PARTY_SITE
, HZ_CUST_ACCOUNTS HCA
WHERE HL.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND PARTY_SITE.PARTY_ID = HCA.PARTY_ID
AND PARTY_SITE.PARTY_ID = HZP.PARTY_ID
AND PARTY_SITE.STATUS = 'A'
Columns
Name |
LOCATION |
DESCRIPTION |
PARTY_NAME |
PARTY_SITE_NAME |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
CITY |
STATE |
ZIP |
COUNTRY |
PARTY_ID |
CUST_ACCOUNT_ID |
SITE_NUMBER |