Product: | BIC - Customer Intelligence(Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT S.PERIOD_START_DATE
, S.VALUE
, S.SCORE
, S.PARTY_ID CUSTOMER_FK
, S.PARTY_ID CUSTOMER_ID
, S.BUCKET_ID
, S.MEASURE_ID
, S.MEASURE_CODE
, NULL ORG_ID
, NULL ORG_FK
, NULL MEASURE_NAME
, NULL MEASURE_DESCRIPTION
, NULL MEASURE_WEIGHT
, NULL MEASURE_TIME_CODE
, P.CATEGORY_CODE CUSTOMER_CATEGORY_FK
, P.PARTY_ID
, P.PARTY_NAME
, P.CREATION_DATE
, P.ADDRESS1
, P.ADDRESS2
, P.ADDRESS3
, P.ADDRESS4
, P.CITY
, P.POSTAL_CODE
, P.STATE
, P.COUNTRY
, P.PROVINCE
, P.COUNTY
, P.EMAIL_ADDRESS
, A.MARKET_SEGMENT_ID MARKET_SEGMENT_FK
, NULL GEOGRAPHY_FK
, NULL REGION
, NULL AREA
, T.ACT_PERIOD_NAME
, T.START_DATE
, T.ACT_PERIOD_START_DATE
, T.ACT_PERIOD_END_DATE
, T.ACT_YEAR
, T.ACT_PERIOD_NUM
, T.ACT_QUARTER
, T.ACT_HALF_YEAR
, T.ACT_YEAR_START_DATE
, T.ACT_QUARTER_START_DATE
FROM AMS_PARTY_MARKET_SEGMENTS A
, BIC_DIMV_TIME T
, HZ_PARTIES P
, BIC_PARTY_SUMMARY S
WHERE S.PERIOD_START_DATE = T.START_DATE
AND S.PARTY_ID = P.PARTY_ID
AND P.PARTY_ID = A.PARTY_ID (+)
AND A.MARKET_SEGMENT_FLAG(+) = 'Y' WITH READ ONLY