View: AS_SALES_LEAD_SCORECARD_RULE_V

View Text

SELECT ASLSR.SCORECARD_ID
, ASLSR.SCORE_RULE_ID
, ASRQ1.EQUAL_STRING COMPANY_NAME
, ASRQ2.EQUAL_STRING CONTACT_ROLE
, ASRQ3.EQUAL_STRING DECISION_TIMEFRAME
, ASRQ4.EQUAL_STRING SOURCE_PROMOTION
, ASRQ5.EQUAL_STRING CHANNEL
, ASRQ6.EQUAL_STRING BUDGET_STATUS
, ASRQ7.LOW_RANGE_VALUE BUDGET_AMOUNT_LOW_RANGE
, ASRQ7.HIGH_RANGE_VALUE BUDGET_AMOUNT_HIGH_RANGE
, ASRQ8.EQUAL_STRING VEHICLE_RESPONSE_CODE
, ASLSR.SCORE
, ASLSR.DESCRIPTION
FROM AS_SALES_LEAD_SCORECARD_RULE ASLSR
, AS_SCORECARD_RULES_QUAL_V ASRQ1
, AS_SCORECARD_RULES_QUAL_V ASRQ2
, AS_SCORECARD_RULES_QUAL_V ASRQ3
, AS_SCORECARD_RULES_QUAL_V ASRQ4
, AS_SCORECARD_RULES_QUAL_V ASRQ5
, AS_SCORECARD_RULES_QUAL_V ASRQ6
, AS_SCORECARD_RULES_QUAL_V ASRQ7
, AS_SCORECARD_RULES_QUAL_V ASRQ8FROM AS_SALES_LEAD_CARD_RULES ASLSR
, AS_SCORECARD_RULES_QUAL_V ASRQ1
, AS_SCORECARD_RULES_QUAL_V ASRQ2
, AS_SCORECARD_RULES_QUAL_V ASRQ3
, AS_SCORECARD_RULES_QUAL_V ASRQ4
, AS_SCORECARD_RULES_QUAL_V ASRQ5
, AS_SCORECARD_RULES_QUAL_V ASRQ6
, AS_SCORECARD_RULES_QUAL_V ASRQ7
, AS_SCORECARD_RULES_QUAL_V ASRQ8
WHERE (ASRQ1.SCORE_RULE_ID(+) = ASLSR.SCORE_RULE_ID
AND ASRQ1.COLUMN_NAME(+) = 'CUSTOMER_NAME')
AND (ASRQ2.SCORE_RULE_ID(+) = ASLSR.SCORE_RULE_ID
AND ASRQ2.COLUMN_NAME(+) = 'CONTACT_ROLE_CODE')
AND (ASRQ3.SCORE_RULE_ID(+) = ASLSR.SCORE_RULE_ID
AND ASRQ3.COLUMN_NAME(+) = 'DECISION_TIMEFRAME_CODE')
AND (ASRQ4.SCORE_RULE_ID(+) = ASLSR.SCORE_RULE_ID
AND ASRQ4.COLUMN_NAME(+) = 'SOURCE_PROMOTION_ID')
AND (ASRQ5.SCORE_RULE_ID(+) = ASLSR.SCORE_RULE_ID
AND ASRQ5.COLUMN_NAME(+) = 'CHANNEL_CODE')
AND (ASRQ6.SCORE_RULE_ID(+) = ASLSR.SCORE_RULE_ID
AND ASRQ6.COLUMN_NAME(+) = 'BUDGET_STATUS_CODE')
AND (ASRQ7.SCORE_RULE_ID(+) = ASLSR.SCORE_RULE_ID
AND ASRQ7.COLUMN_NAME(+) = 'BUDGET_AMOUNT')
AND (ASRQ8.SCORE_RULE_ID(+) = ASLSR.SCORE_RULE_ID
AND ASRQ8.COLUMN_NAME(+) = 'VEHICLE_RESPONSE_CODE')

Columns