eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BIC_PMF_SUMMARY_V

Product:	BIC - Customer Intelligence (obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT S.PERIOD_START_DATE
, S.VALUE
, S.CUSTOMER_ID CUSTOMER_FK
, S.BUCKET_ID
, S.MEASURE_ID
, S.MEASURE_CODE
, S.ORG_ID ORG_FK
, S.ORG_ID ORG_ID
, NULL ORG_NAME
, NULL MEASURE_NAME
, NULL MEASURE_DESCRIPTION
, NULL MEASURE_WEIGHT
, NULL MEASURE_TIME_CODE
, C.ACCOUNT_NUMBER
, NULL CUST_ORG_ID
, P.CATEGORY_CODE CUSTOMER_CATEGORY_FK
, A.MARKET_SEGMENT_ID MARKET_SEGMENT_FK
, C.ACCOUNT_ESTABLISHED_DATE ACQUIRED_DATE
, C.CUST_ACCOUNT_ID CUSTOMER_ID
, C.PARTY_ID
, C.ACCOUNT_NAME
, NULL GEOGRAPHY_FK
, P.COUNTRY
, P.STATE
, P.CITY
, T.PERIOD_SET_NAME
, T.PERIOD_NAME
, T.START_DATE
, T.END_DATE
, T.PERIOD_YEAR
, T.PERIOD_NUM
, T.QUARTER_NUM
, T.YEAR_START_DATE
, T.QUARTER_START_DATE
FROM HZ_CUST_ACCOUNTS C
, HZ_PARTIES P
, GL_PERIODS T
, BIC_CUSTOMER_SUMMARY_ALL S
, AMS_PARTY_MARKET_SEGMENTS A
WHERE C.PARTY_ID = P.PARTY_ID
AND S.PERIOD_START_DATE BETWEEN T.START_DATE
AND T.END_DATE
AND S.CUSTOMER_ID = C.CUST_ACCOUNT_ID
AND C.PARTY_ID = A.PARTY_ID (+)
AND A.MARKET_SEGMENT_FLAG(+) = 'Y' WITH READ ONLY

Columns

Name
PERIOD_START_DATE
VALUE
CUSTOMER_FK
BUCKET_ID
MEASURE_ID
MEASURE_CODE
ORG_FK
ORG_ID
ORG_NAME
MEASURE_NAME
MEASURE_DESCRIPTION
MEASURE_WEIGHT
MEASURE_TIME_CODE
ACCOUNT_NUMBER
CUST_ORG_ID
CUSTOMER_CATEGORY_FK
MARKET_SEGMENT_FK
ACQUIRED_DATE
CUSTOMER_ID
PARTY_ID
ACCOUNT_NAME
GEOGRAPHY_FK
COUNTRY
STATE
CITY
PERIOD_SET_NAME
PERIOD_NAME
START_DATE
END_DATE
PERIOD_YEAR
PERIOD_NUM
QUARTER_NUM
YEAR_START_DATE
QUARTER_START_DATE