DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_DM_SOURCE_SCORE_CON_V

Object Details
Object Name: AMS_DM_SOURCE_SCORE_CON_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_DM_SOURCE_SCORE_CON_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_ID NUMBER
Yes
PARTY_ID NUMBER
Yes
ARC_USED_FOR_OBJECT VARCHAR2 (30) Yes
USED_FOR_OBJECT_ID NUMBER
Yes
GENDER VARCHAR2 (30)
ETHNICITY VARCHAR2 (60)
MARITAL_STATUS VARCHAR2 (30)
PERSONAL_INCOME NUMBER

HOH_FLAG VARCHAR2 (1)
HOUSEHOLD_INCOME NUMBER

HOUSEHOLD_SIZE NUMBER

APARTMENT_FLAG VARCHAR2 (1)
RENT_FLAG VARCHAR2 (1)
DEGREE_RECEIVED VARCHAR2 (1)
SCHOOL_TYPE VARCHAR2 (60)
INTEREST_ART_FLAG VARCHAR2 (1)
INTEREST_BOOKS_FLAG VARCHAR2 (1)
INTEREST_MOVIES_FLAG VARCHAR2 (1)
INTEREST_MUSIC_FLAG VARCHAR2 (1)
INTEREST_THEATER_FLAG VARCHAR2 (1)
INTEREST_TRAVEL_FLAG VARCHAR2 (1)
INTEREST_DRINK_FLAG VARCHAR2 (1)
INTEREST_SMOKE_FLAG VARCHAR2 (1)
EMPLOYED_FLAG VARCHAR2 (1)
YEARS_EMPLOYED NUMBER

OCCUPATION VARCHAR2 (60)
MILITARY_BRANCH VARCHAR2 (80)
RESIDENCE_TYPE VARCHAR2 (30)
RESIDENT_LENGTH NUMBER

PRESENCE_OF_CHILDREN NUMBER

COUNTRY VARCHAR2 (60)
STATE VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
ZIP_CODE VARCHAR2 (60)
REFERENCE_USE_FLAG VARCHAR2 (1)
GROSS_ANNUAL_INCOME NUMBER

DEBT_TO_INCOME_RATIO NUMBER

NUM_CREDIT_LINES NUMBER

NUM_TRADE_LINES NUMBER

NET_WORTH NUMBER

TOTAL_ASSETS NUMBER

TOT_DEBT_OUTSTANDING NUMBER

BANKRUPTCY_FLAG VARCHAR2 (1)
HIGH_RISK_FRAUD_FLAG VARCHAR2 (1)
GROSS_ANNUAL_SALES NUMBER

GROWTH_RATE_SALES_YEAR NUMBER

CURRENT_ASSETS NUMBER

CURRENT_LIABILITIES NUMBER

TOTAL_DEBTS NUMBER

CREDIT_CHECK_FLAG VARCHAR2 (1)
TOLERANCE NUMBER

DISCOUNT_TERMS_FLAG VARCHAR2 (1)
DUNNING_LETTERS_FLAG VARCHAR2 (1)
INTEREST_CHARGES_FLAG VARCHAR2 (1)
SEND_STATEMENTS_FLAG VARCHAR2 (1)
CREDIT_HOLD_FLAG VARCHAR2 (1)
CREDIT_RATING VARCHAR2 (60)
RISK_CODE VARCHAR2 (60)
AGE NUMBER

DAYS_SINCE_LAST_EVENT NUMBER

DAYS_SINCE_LAST_SCHOOL NUMBER

NUM_TIMES_TARGETED NUMBER

LAST_TARGETED_CHANNEL_CODE NUMBER

TIMES_TARGETED_MONTH NUMBER

TIMES_TARGETED_3_MONTHS NUMBER

TIMES_TARGETED_6_MONTHS NUMBER

TIMES_TARGETED_12_MONTHS NUMBER

DAYS_SINCE_LAST_TARGETED NUMBER

AVG_DISC_OFFERED NUMBER

NUM_TYPES_DISC_OFFERED NUMBER

NUM_TIMES_TARGETED_EMAIL NUMBER

NUM_TIMES_TARGETED_DIRECT NUMBER

NUM_TIMES_TARGETED_TELEMKT NUMBER

NUM_TGT_BY_OFFR_TYP1 NUMBER

NUM_TGT_BY_OFFR_TYP2 NUMBER

NUM_TGT_BY_OFFR_TYP3 NUMBER

NUM_TGT_BY_OFFR_TYP4 NUMBER

DAYS_SINCE_FIRST_CONTACT NUMBER

AVG_TALK_TIME NUMBER

AVG_ORDER_AMOUNT NUMBER

AVG_UNITS_PER_ORDER NUMBER

TOT_ORDER_AMOUNT_YEAR NUMBER

TOT_ORDER_AMOUNT_9_MONTHS NUMBER

TOT_ORDER_AMOUNT_6_MONTHS NUMBER

TOT_ORDER_AMOUNT_3_MONTHS NUMBER

TOT_NUM_ORDERS_YEAR NUMBER

TOT_NUM_ORDER_9_MONTHS NUMBER

TOT_NUM_ORDER_6_MONTHS NUMBER

TOT_NUM_ORDER_3_MONTHS NUMBER

DAYS_SINCE_ACCT_ESTABLISHED NUMBER

DAYS_SINCE_ACCT_TERM NUMBER

DAYS_SINCE_ACCT_ACTIVATION NUMBER

DAYS_SINCE_ACCT_SUSPENDED NUMBER

NUM_OF_SR_YEAR NUMBER

NUM_OF_SR_6_MONTHS NUMBER

NUM_OF_SR_3_MONTHS NUMBER

NUM_OF_SR_1_MONTH NUMBER

AVG_RESOLVE_DAYS_YEAR NUMBER

AVG_RESOLVE_DAYS_6_MONTHS NUMBER

AVG_RESOLVE_DAYS_3_MONTHS NUMBER

AVG_RESOLVE_DAYS_1_MONTH NUMBER

ORDER_LINES_DELIVERED NUMBER

ORDER_LINES_ONTIME NUMBER

ORDER_QTY_CUMUL NUMBER

ORDER_RECENCY NUMBER

PAYMENTS NUMBER

RETURNS NUMBER

RETURN_BY_VALUE NUMBER

RETURN_BY_VALUE_PCT NUMBER

ONTIME_PAYMENTS NUMBER

ONTIME_SHIP_PCT NUMBER

CLOSED_SRS NUMBER

COGS NUMBER

CONTRACTS_CUML NUMBER

CONTRACT_AMT NUMBER

CONTRACT_DURATION NUMBER

INACTIVE_CONTRACTS NUMBER

OPEN_CONTRACTS NUMBER

NEW_CONTRACTS NUMBER

RENEWED_CONTRACTS NUMBER

ESCALATED_SRS NUMBER

FIRST_CALL_CL_RATE NUMBER

NUM_OF_COMPLAINTS NUMBER

NUM_OF_INTERACTIONS NUMBER

NUM_OF_TRANSFERS NUMBER

OPEN_SRS NUMBER

PCT_CALL_REWORK NUMBER

PRODUCTS NUMBER

REFERALS NUMBER

REOPENED_SRS NUMBER

SALES NUMBER

TOTAL_SR_RESPONSE_TIME NUMBER

PCT_FIRST_CLOSED_SRS NUMBER

AVG_COMPLAINTS NUMBER

AVG_HOLD_TIME NUMBER

AVG_LEN_OF_EMP NUMBER

AVG_TRANSFERS_PER_SR NUMBER

AVG_WORKLOAD NUMBER

TOT_CALLS NUMBER

CALL_LENGTH NUMBER

PROFITABILITY NUMBER

TARGET_VALUE VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SOURCE_ID
,      PARTY_ID
,      ARC_USED_FOR_OBJECT
,      USED_FOR_OBJECT_ID
,      GENDER
,      ETHNICITY
,      MARITAL_STATUS
,      PERSONAL_INCOME
,      HOH_FLAG
,      HOUSEHOLD_INCOME
,      HOUSEHOLD_SIZE
,      APARTMENT_FLAG
,      RENT_FLAG
,      DEGREE_RECEIVED
,      SCHOOL_TYPE
,      INTEREST_ART_FLAG
,      INTEREST_BOOKS_FLAG
,      INTEREST_MOVIES_FLAG
,      INTEREST_MUSIC_FLAG
,      INTEREST_THEATER_FLAG
,      INTEREST_TRAVEL_FLAG
,      INTEREST_DRINK_FLAG
,      INTEREST_SMOKE_FLAG
,      EMPLOYED_FLAG
,      YEARS_EMPLOYED
,      OCCUPATION
,      MILITARY_BRANCH
,      RESIDENCE_TYPE
,      RESIDENT_LENGTH
,      PRESENCE_OF_CHILDREN
,      COUNTRY
,      STATE
,      PROVINCE
,      COUNTY
,      ZIP_CODE
,      REFERENCE_USE_FLAG
,      GROSS_ANNUAL_INCOME
,      DEBT_TO_INCOME_RATIO
,      NUM_CREDIT_LINES
,      NUM_TRADE_LINES
,      NET_WORTH
,      TOTAL_ASSETS
,      TOT_DEBT_OUTSTANDING
,      BANKRUPTCY_FLAG
,      HIGH_RISK_FRAUD_FLAG
,      GROSS_ANNUAL_SALES
,      GROWTH_RATE_SALES_YEAR
,      CURRENT_ASSETS
,      CURRENT_LIABILITIES
,      TOTAL_DEBTS
,      CREDIT_CHECK_FLAG
,      TOLERANCE
,      DISCOUNT_TERMS_FLAG
,      DUNNING_LETTERS_FLAG
,      INTEREST_CHARGES_FLAG
,      SEND_STATEMENTS_FLAG
,      CREDIT_HOLD_FLAG
,      CREDIT_RATING
,      RISK_CODE
,      AGE
,      DAYS_SINCE_LAST_EVENT
,      DAYS_SINCE_LAST_SCHOOL
,      NUM_TIMES_TARGETED
,      LAST_TARGETED_CHANNEL_CODE
,      TIMES_TARGETED_MONTH
,      TIMES_TARGETED_3_MONTHS
,      TIMES_TARGETED_6_MONTHS
,      TIMES_TARGETED_12_MONTHS
,      DAYS_SINCE_LAST_TARGETED
,      AVG_DISC_OFFERED
,      NUM_TYPES_DISC_OFFERED
,      NUM_TIMES_TARGETED_EMAIL
,      NUM_TIMES_TARGETED_DIRECT
,      NUM_TIMES_TARGETED_TELEMKT
,      NUM_TGT_BY_OFFR_TYP1
,      NUM_TGT_BY_OFFR_TYP2
,      NUM_TGT_BY_OFFR_TYP3
,      NUM_TGT_BY_OFFR_TYP4
,      DAYS_SINCE_FIRST_CONTACT
,      AVG_TALK_TIME
,      AVG_ORDER_AMOUNT
,      AVG_UNITS_PER_ORDER
,      TOT_ORDER_AMOUNT_YEAR
,      TOT_ORDER_AMOUNT_9_MONTHS
,      TOT_ORDER_AMOUNT_6_MONTHS
,      TOT_ORDER_AMOUNT_3_MONTHS
,      TOT_NUM_ORDERS_YEAR
,      TOT_NUM_ORDER_9_MONTHS
,      TOT_NUM_ORDER_6_MONTHS
,      TOT_NUM_ORDER_3_MONTHS
,      DAYS_SINCE_ACCT_ESTABLISHED
,      DAYS_SINCE_ACCT_TERM
,      DAYS_SINCE_ACCT_ACTIVATION
,      DAYS_SINCE_ACCT_SUSPENDED
,      NUM_OF_SR_YEAR
,      NUM_OF_SR_6_MONTHS
,      NUM_OF_SR_3_MONTHS
,      NUM_OF_SR_1_MONTH
,      AVG_RESOLVE_DAYS_YEAR
,      AVG_RESOLVE_DAYS_6_MONTHS
,      AVG_RESOLVE_DAYS_3_MONTHS
,      AVG_RESOLVE_DAYS_1_MONTH
,      ORDER_LINES_DELIVERED
,      ORDER_LINES_ONTIME
,      ORDER_QTY_CUMUL
,      ORDER_RECENCY
,      PAYMENTS
,      RETURNS
,      RETURN_BY_VALUE
,      RETURN_BY_VALUE_PCT
,      ONTIME_PAYMENTS
,      ONTIME_SHIP_PCT
,      CLOSED_SRS
,      COGS
,      CONTRACTS_CUML
,      CONTRACT_AMT
,      CONTRACT_DURATION
,      INACTIVE_CONTRACTS
,      OPEN_CONTRACTS
,      NEW_CONTRACTS
,      RENEWED_CONTRACTS
,      ESCALATED_SRS
,      FIRST_CALL_CL_RATE
,      NUM_OF_COMPLAINTS
,      NUM_OF_INTERACTIONS
,      NUM_OF_TRANSFERS
,      OPEN_SRS
,      PCT_CALL_REWORK
,      PRODUCTS
,      REFERALS
,      REOPENED_SRS
,      SALES
,      TOTAL_SR_RESPONSE_TIME
,      PCT_FIRST_CLOSED_SRS
,      AVG_COMPLAINTS
,      AVG_HOLD_TIME
,      AVG_LEN_OF_EMP
,      AVG_TRANSFERS_PER_SR
,      AVG_WORKLOAD
,      TOT_CALLS
,      CALL_LENGTH
,      PROFITABILITY
,      TARGET_VALUE
FROM APPS.AMS_DM_SOURCE_SCORE_CON_V;

Dependencies

[top of page]

APPS.AMS_DM_SOURCE_SCORE_CON_V references the following:

SchemaAPPS
SynonymAMS_DM_PARTY_DETAILS
SynonymAMS_DM_PARTY_DETAILS_TIME
SynonymAMS_DM_SOURCE

APPS.AMS_DM_SOURCE_SCORE_CON_V is not referenced by any database object