[Home] [Help] [Dependency Information]
Object Name: | AMS_DM_SOURCE_MODEL_CON_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_DM_SOURCE_MODEL_CON_V |
Subobject Name: | |
Status: | VALID |
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) |
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_MODEL_CON_V;
APPS.AMS_DM_SOURCE_MODEL_CON_V is not referenced by any database object
|
|
|