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.

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

VIEW: APPS.AMS_DM_SOURCE_SCORE_BUS_V

Object Details

Object Name:	AMS_DM_SOURCE_SCORE_BUS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_DM_SOURCE_SCORE_BUS_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SOURCE_ID	NUMBER		Yes
PARTY_ID	NUMBER		Yes
ARC_USED_FOR_OBJECT	VARCHAR2	(30)	Yes
USED_FOR_OBJECT_ID	NUMBER		Yes
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
NET_PROFIT	NUMBER
TANGIBLE_NET_PROFIT	NUMBER
CAPITAL_AMOUNT	NUMBER
CAPITAL_TYPE_INDICATOR	VARCHAR2	(30)
ACCOUNTS_RECEIVABLE	NUMBER
RETAINED_EARNINGS	NUMBER
PAYDEX_SCORE_YEAR	NUMBER
PAYDEX_SCORE_3_MONTH_AGO	NUMBER
INDUSTRY_PAYDEX_MEDIAN	NUMBER
GLOBAL_FAILURE_SCORE	VARCHAR2	(5)
DNB_SCORE	VARCHAR2	(5)
OUT_OF_BUSINESS_FLAG	VARCHAR2	(1)
CUSTOMER_QUALITY_RANK	NUMBER
FORTUNE_500_RANK	NUMBER
NUM_OF_EMPLOYEES	NUMBER
LEGAL_STATUS	VARCHAR2	(30)
YEAR_ESTABLISHED	NUMBER
SIC_CODE1	VARCHAR2	(30)
MINORITY_BUSINESS_FLAG	VARCHAR2	(1)
SMALL_BUSINESS_FLAG	VARCHAR2	(1)
WOMEN_OWNED_BUS_FLAG	VARCHAR2	(1)
GOV_ORG_FLAG	VARCHAR2	(1)
HQ_SUBSIDIARY_FLAG	VARCHAR2	(1)
FOREIGN_OWNED_FLAG	VARCHAR2	(1)
IMPORT_EXPORT_BUS_FLAG	VARCHAR2	(1)
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)
DAYS_SINCE_LAST_EVENT	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
,      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
,      NET_PROFIT
,      TANGIBLE_NET_PROFIT
,      CAPITAL_AMOUNT
,      CAPITAL_TYPE_INDICATOR
,      ACCOUNTS_RECEIVABLE
,      RETAINED_EARNINGS
,      PAYDEX_SCORE_YEAR
,      PAYDEX_SCORE_3_MONTH_AGO
,      INDUSTRY_PAYDEX_MEDIAN
,      GLOBAL_FAILURE_SCORE
,      DNB_SCORE
,      OUT_OF_BUSINESS_FLAG
,      CUSTOMER_QUALITY_RANK
,      FORTUNE_500_RANK
,      NUM_OF_EMPLOYEES
,      LEGAL_STATUS
,      YEAR_ESTABLISHED
,      SIC_CODE1
,      MINORITY_BUSINESS_FLAG
,      SMALL_BUSINESS_FLAG
,      WOMEN_OWNED_BUS_FLAG
,      GOV_ORG_FLAG
,      HQ_SUBSIDIARY_FLAG
,      FOREIGN_OWNED_FLAG
,      IMPORT_EXPORT_BUS_FLAG
,      CREDIT_CHECK_FLAG
,      TOLERANCE
,      DISCOUNT_TERMS_FLAG
,      DUNNING_LETTERS_FLAG
,      INTEREST_CHARGES_FLAG
,      SEND_STATEMENTS_FLAG
,      CREDIT_HOLD_FLAG
,      CREDIT_RATING
,      RISK_CODE
,      DAYS_SINCE_LAST_EVENT
,      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_BUS_V;

Dependencies

[top of page]

APPS.AMS_DM_SOURCE_SCORE_BUS_V references the following:

APPS: AMS_DM_PARTY_DETAILS; AMS_DM_PARTY_DETAILS_TIME; AMS_DM_SOURCE

APPS.AMS_DM_SOURCE_SCORE_BUS_V is not referenced by any database object