CMP_MKT_VND_SURVEYS

Details

Schema: FUSION
Object owner: CMP
Object type: VIEW

Columns

Name
MKT_SURVEY_ID MKT_SURVEY_CODE MKT_SURVEY_NAME COMPENSATION_COVERAGE INDUSTRY_COVERAGE GEOGRAPHIC_COVERAGE JOB_COVERAGE NOTES VENDOR_ID STATUS APPROX_NUM_COMPANIES SURVEY_FEE_PARTICIPANT SURVEY_FEE_NON_ARTICIPANT MISC_1 MISC_2 MISC_3 COUNTRY LOCATION INDUSTRY GROUPS TEN_PERCENT TWENTY_FIVE_PERCENT FIFTY_PERCENT SEVENTY_FIVE_PERCENT NINTY_PERCENT AVERAGE_MEAN CURRENCY PARTICIPATING_COMPANIES PARTICIPATING_INCUMBANTS MISC_NUMBER_1 MISC_NUMBER_1_DATA MISC_NUMBER_2 MISC_NUMBER_2_DATA MISC_NUMBER_3 MISC_NUMBER_3_DATA MISC_NUMBER_4 MISC_NUMBER_4_DATA MISC_TEXT_1 MISC_TEXT_1_DATA MISC_TEXT_2 MISC_TEXT_2_DATA MISC_TEXT_3 MISC_TEXT_3_DATA PART_FEE_CURRENCY_CODE NON_PART_FEE_CURRENCY_CODE BUSINESS_GROUP_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN MISC_NUMBER_1_DATA2 MISC_NUMBER_2_DATA2 MISC_NUMBER_3_DATA2 MISC_NUMBER_4_DATA2 TWENTY_PERCENT THIRTY_PERCENT FORTY_PERCENT SIXTY_PERCENT SEVENTY_PERCENT EIGHTY_PERCENT ONE_HUNDRED_PERCENT

Name

MKT_SURVEY_ID

MKT_SURVEY_CODE

MKT_SURVEY_NAME

COMPENSATION_COVERAGE

INDUSTRY_COVERAGE

GEOGRAPHIC_COVERAGE

JOB_COVERAGE

NOTES

VENDOR_ID

STATUS

APPROX_NUM_COMPANIES

SURVEY_FEE_PARTICIPANT

SURVEY_FEE_NON_ARTICIPANT

MISC_1

MISC_2

MISC_3

COUNTRY

LOCATION

INDUSTRY

GROUPS

TEN_PERCENT

TWENTY_FIVE_PERCENT

FIFTY_PERCENT

SEVENTY_FIVE_PERCENT

NINTY_PERCENT

AVERAGE_MEAN

CURRENCY

PARTICIPATING_COMPANIES

PARTICIPATING_INCUMBANTS

MISC_NUMBER_1

MISC_NUMBER_1_DATA

MISC_NUMBER_2

MISC_NUMBER_2_DATA

MISC_NUMBER_3

MISC_NUMBER_3_DATA

MISC_NUMBER_4

MISC_NUMBER_4_DATA

MISC_TEXT_1

MISC_TEXT_1_DATA

MISC_TEXT_2

MISC_TEXT_2_DATA

MISC_TEXT_3

MISC_TEXT_3_DATA

PART_FEE_CURRENCY_CODE

NON_PART_FEE_CURRENCY_CODE

BUSINESS_GROUP_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

MISC_NUMBER_1_DATA2

MISC_NUMBER_2_DATA2

MISC_NUMBER_3_DATA2

MISC_NUMBER_4_DATA2

TWENTY_PERCENT

THIRTY_PERCENT

FORTY_PERCENT

SIXTY_PERCENT

SEVENTY_PERCENT

EIGHTY_PERCENT

ONE_HUNDRED_PERCENT

Query

SQL_Statement
SELECT B.MKT_SURVEY_ID, B.MKT_SURVEY_CODE, T.MKT_SURVEY_NAME, T.COMPENSATION_COVERAGE, T.INDUSTRY_COVERAGE, T.GEOGRAPHIC_COVERAGE, T.JOB_COVERAGE, T.NOTES, B.VENDOR_ID, B.STATUS, B.APPROX_NUM_COMPANIES, B.SURVEY_FEE_PARTICIPANT, B.SURVEY_FEE_NON_ARTICIPANT, B.MISC_1, B.MISC_2, B.MISC_3, B.COUNTRY, B.LOCATION, B.INDUSTRY, B.GROUPS, B.TEN_PERCENT, B.TWENTY_FIVE_PERCENT, B.FIFTY_PERCENT, B.SEVENTY_FIVE_PERCENT, B.NINTY_PERCENT, B.AVERAGE_MEAN, B.CURRENCY, B.PARTICIPATING_COMPANIES, B.PARTICIPATING_INCUMBANTS, B.MISC_NUMBER_1, B.MISC_NUMBER_1_DATA, B.MISC_NUMBER_2, B.MISC_NUMBER_2_DATA, B.MISC_NUMBER_3, B.MISC_NUMBER_3_DATA, B.MISC_NUMBER_4, B.MISC_NUMBER_4_DATA, B.MISC_TEXT_1, B.MISC_TEXT_1_DATA, B.MISC_TEXT_2, B.MISC_TEXT_2_DATA, B.MISC_TEXT_3, B.MISC_TEXT_3_DATA, B.PART_FEE_CURRENCY_CODE, B.NON_PART_FEE_CURRENCY_CODE, B.BUSINESS_GROUP_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.MISC_NUMBER_1_DATA2, B.MISC_NUMBER_2_DATA2, B.MISC_NUMBER_3_DATA2, B.MISC_NUMBER_4_DATA2, B.TWENTY_PERCENT, B.THIRTY_PERCENT, B.FORTY_PERCENT, B.SIXTY_PERCENT, B.SEVENTY_PERCENT, B.EIGHTY_PERCENT, B.ONE_HUNDRED_PERCENT FROM CMP_MKT_VND_SURVEYS_B B, CMP_MKT_VND_SURVEYS_TL T WHERE B.MKT_SURVEY_ID = T.MKT_SURVEY_ID AND T.LANGUAGE = USERENV('LANG') AND B.BUSINESS_GROUP_ID = T.BUSINESS_GROUP_ID

SQL_Statement

SELECT

B.MKT_SURVEY_ID,

B.MKT_SURVEY_CODE,

T.MKT_SURVEY_NAME,

T.COMPENSATION_COVERAGE,

T.INDUSTRY_COVERAGE,

T.GEOGRAPHIC_COVERAGE,

T.JOB_COVERAGE,

T.NOTES,

B.VENDOR_ID,

B.STATUS,

B.APPROX_NUM_COMPANIES,

B.SURVEY_FEE_PARTICIPANT,

B.SURVEY_FEE_NON_ARTICIPANT,

B.MISC_1,

B.MISC_2,

B.MISC_3,

B.COUNTRY,

B.LOCATION,

B.INDUSTRY,

B.GROUPS,

B.TEN_PERCENT,

B.TWENTY_FIVE_PERCENT,

B.FIFTY_PERCENT,

B.SEVENTY_FIVE_PERCENT,

B.NINTY_PERCENT,

B.AVERAGE_MEAN,

B.CURRENCY,

B.PARTICIPATING_COMPANIES,

B.PARTICIPATING_INCUMBANTS,

B.MISC_NUMBER_1,

B.MISC_NUMBER_1_DATA,

B.MISC_NUMBER_2,

B.MISC_NUMBER_2_DATA,

B.MISC_NUMBER_3,

B.MISC_NUMBER_3_DATA,

B.MISC_NUMBER_4,

B.MISC_NUMBER_4_DATA,

B.MISC_TEXT_1,

B.MISC_TEXT_1_DATA,

B.MISC_TEXT_2,

B.MISC_TEXT_2_DATA,

B.MISC_TEXT_3,

B.MISC_TEXT_3_DATA,

B.PART_FEE_CURRENCY_CODE,

B.NON_PART_FEE_CURRENCY_CODE,

B.BUSINESS_GROUP_ID,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.MISC_NUMBER_1_DATA2,

B.MISC_NUMBER_2_DATA2,

B.MISC_NUMBER_3_DATA2,

B.MISC_NUMBER_4_DATA2,

B.TWENTY_PERCENT,

B.THIRTY_PERCENT,

B.FORTY_PERCENT,

B.SIXTY_PERCENT,

B.SEVENTY_PERCENT,

B.EIGHTY_PERCENT,

B.ONE_HUNDRED_PERCENT

FROM

CMP_MKT_VND_SURVEYS_B B,

CMP_MKT_VND_SURVEYS_TL T

WHERE

B.MKT_SURVEY_ID = T.MKT_SURVEY_ID AND T.LANGUAGE = USERENV('LANG') AND B.BUSINESS_GROUP_ID = T.BUSINESS_GROUP_ID