Product: | BIC - Customer Intelligence (obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT S.PERIOD_START_DATE
, S.ORDER_QTY_CUML
, S.PRODUCTS
, S.ORDER_AMT
, S.ORDER_NUM
, S.ORDER_QTY
, S.REFERALS
, S.CONTRACTS_CUML
, S.INTERAC_CUML
, S.ON_TIME_PAYMENT_RATE
, S.ASSOCIATION_YRS
, 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 WITH READ ONLY