Product: | BIC - Customer Intelligence (obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT S.PERIOD_START_DATE
, S.LOYALTY
, S.SATISFACTION
, S.SALES
, S.COGS
, S.PROFITABILITY
, S.PARTY_ID
, S.ORG_ID ORG_ID
, P.CATEGORY_CODE CUSTOMER_CATEGORY_FK
, 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
, S.MARKET_SEGMENT_ID MARKET_SEGMENT_FK
, 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 BIC_DIMV_TIME T
, HZ_PARTIES P
, BIC_PARTY_SUMM S
WHERE S.PERIOD_START_DATE = T.START_DATE
AND S.PARTY_ID = P.PARTY_ID