Product: | BIC - Customer Intelligence (obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CS.PERIOD_START_DATE
, CS.VALUE
, CS.CUSTOMER_FK
, CS.BUCKET_ID
, CS.MEASURE_ID
, CS.MEASURE_CODE
, CS.ORG_FK
, CS.ORG_ID
, CS.MEASURE_NAME
, CS.MEASURE_DESCRIPTION
, CS.MEASURE_WEIGHT
, CS.MEASURE_TIME_CODE
, CS.ACCOUNT_NUMBER
, CS.CUST_ORG_ID
, NULL ORG_NAME
, CS.CUSTOMER_CATEGORY_FK
, CS.MARKET_SEGMENT_FK
, CS.ACQUIRED_DATE
, CS.CUSTOMER_ID
, CS.PARTY_ID
, CS.ACCOUNT_NAME
, CS.GEOGRAPHY_FK
, CS.REGION
, CS.AREA
, CS.COUNTRY
, CS.ACT_PERIOD_NAME
, CS.START_DATE
, CS.ACT_PERIOD_START_DATE
, CS.ACT_PERIOD_END_DATE
, CS.ACT_YEAR
, CS.ACT_PERIOD_NUM
, CS.ACT_QUARTER
, CS.ACT_HALF_YEAR
, CS.ACT_YEAR_START_DATE
, CS.ACT_QUARTER_START_DATE
, DECODE(PA.PARTY_TYPE
, 'PERSON'
, PA.PERSON_LAST_NAME||' '||PA.PERSON_FIRST_NAME
, 'ORGANIZATION'
, PA.PARTY_NAME) CUSTOMER_NAME
, AD.ADDRESS LOCATION
FROM BIC_CUSTOMER_SUMMARY_V CS
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PA
, HZ_PARTY_SITES PS
, BIC_ADDRESS_V AD
WHERE CS.CUSTOMER_ID = CA.CUST_ACCOUNT_ID
AND CA.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