[Home] [Help]
View: BIC_CUSLIST_V
Product: | BIC - Customer Intelligence (obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT C.PARTY_ID
, C.CUSTOMER_CATEGORY_FK
, C.MARKET_SEGMENT_FK
, C.COUNTRY
, C.CITY
, C.STATE
, DECODE(PA.PARTY_TYPE
, 'PERSON'
, PA.PERSON_LAST_NAME||' '||PA.PERSON_FIRST_NAME
, 'ORGANIZATION'
, PA.PARTY_NAME) CUSTOMER_NAME
, AD.ADDRESS LOCATION
FROM BIC_DIMV_CUSTOMERS C
, HZ_PARTIES PA
, HZ_PARTY_SITES PS
, BIC_ADDRESS_V AD
WHERE C.PARTY_ID = PA.PARTY_ID
AND PA.PARTY_ID = PS.PARTY_ID (+)
AND PS.IDENTIFYING_ADDRESS_FLAG (+) = 'Y'
AND PS.LOCATION_ID = AD.LOCATION_ID (+) WITH READ ONLY
Columns
Name |
PARTY_ID |
CUSTOMER_CATEGORY_FK |
MARKET_SEGMENT_FK |
COUNTRY |
CITY |
STATE |
CUSTOMER_NAME |
LOCATION |