[Home] [Help] [Dependency Information]
Object Name: | AMS_DM_PARTY_ATTRIBUTES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_DM_PARTY_ATTRIBUTES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | Yes | Party identifier. | |
GROSS_ANNUAL_INCOME | NUMBER | Gross Annual Income | ||
DEBT_TO_INCOME_RATIO | NUMBER | Debt To Income Ratio | ||
NET_WORTH | NUMBER | Net Worth | ||
TOTAL_ASSETS | NUMBER | Total Assets | ||
TOT_DEBT_OUTSTANDING | NUMBER | Tot Debt Outstanding | ||
GROSS_ANNUAL_SALES | NUMBER | Gross Annual Sales | ||
CURRENT_ASSETS | NUMBER | Current Assets | ||
CURRENT_LIABILITIES | NUMBER | Current Liabilities | ||
NET_PROFIT | NUMBER | Net Profit | ||
ACCOUNTS_RECEIVABLE | NUMBER | Accounts Receivable | ||
RETAINED_EARNINGS | NUMBER | Retained Earnings | ||
THIRD_PARTY_FLAG | VARCHAR2 | (240) | Third Party Flag | |
DAYS_SINCE_LAST_EVENT | NUMBER | Days Since Last Event | ||
NUM_TIMES_TARGETED | NUMBER | Num Times Targeted | ||
LAST_TARGETED_CHANNEL_CODE | NUMBER | Last Targeted Channel Code | ||
TIMES_TARGETED_MONTH | NUMBER | Times Targeted Month | ||
TIMES_TARGETED_3_MONTHS | NUMBER | Times Targeted 3 Months | ||
TIMES_TARGETED_6_MONTHS | NUMBER | Times Targeted 6 Months | ||
TIMES_TARGETED_9_MONTHS | NUMBER | TIMES_TARGETED_9_MONTHS | ||
TIMES_TARGETED_12_MONTHS | NUMBER | Times Targeted 12 Months | ||
DAYS_SINCE_LAST_TARGETED | NUMBER | Days Since Last Targeted | ||
AVG_DISC_OFFERED | NUMBER | Avg Disc Offered | ||
NUM_TYPES_DISC_OFFERED | NUMBER | Num Types Disc Offered | ||
DAYS_SINCE_FIRST_CONTACT | NUMBER | Days Since First Contact | ||
NUM_TIMES_TARGETED_EMAIL | NUMBER | Num Times Targeted Email | ||
NUM_TIMES_TARGETED_TELEMKT | NUMBER | Num Times Targeted Telemkt | ||
NUM_TIMES_TARGETED_DIRECT | NUMBER | Num Times Targeted Direct | ||
NUM_TGT_BY_OFFR_TYP1 | NUMBER | Num Tgt By Offr Typ1 | ||
NUM_TGT_BY_OFFR_TYP2 | NUMBER | Num Tgt By Offr Typ2 | ||
NUM_TGT_BY_OFFR_TYP3 | NUMBER | Num Tgt By Offr Typ3 | ||
NUM_TGT_BY_OFFR_TYP4 | NUMBER | Num Tgt By Offr Typ4 | ||
AVG_TALK_TIME | NUMBER | Avg Talk Time | ||
AVG_ORDER_AMOUNT | NUMBER | Avg Order Amount | ||
AVG_UNITS_PER_ORDER | NUMBER | Avg Units Per Order | ||
TOT_ORDER_AMOUNT_YEAR | NUMBER | Tot Order Amount Year | ||
TOT_ORDER_AMOUNT_9_MONTHS | NUMBER | Tot Order Amount 9 Months | ||
TOT_ORDER_AMOUNT_6_MONTHS | NUMBER | Tot Order Amount 6 Months | ||
TOT_ORDER_AMOUNT_3_MONTHS | NUMBER | Tot Order Amount 3 Months | ||
TOT_NUM_ORDERS_YEAR | NUMBER | Tot Num Orders Year | ||
TOT_NUM_ORDER_9_MONTHS | NUMBER | Tot Num Order 9 Months | ||
TOT_NUM_ORDER_6_MONTHS | NUMBER | TOT_NUM_ORDER_6_MONTHS | ||
TOT_NUM_ORDER_3_MONTHS | NUMBER | Tot Num Order 3 Months | ||
NUM_OF_SR_YEAR | NUMBER | Num Of Sr Year | ||
NUM_OF_SR_6_MONTHS | NUMBER | Num Of Sr 6 Months | ||
NUM_OF_SR_3_MONTHS | NUMBER | Num Of Sr 3 Months | ||
NUM_OF_SR_1_MONTH | NUMBER | Num Of Sr 1 Month | ||
AVG_RESOLVE_DAYS_YEAR | NUMBER | Avg Resolve Days Year | ||
AVG_RESOLVE_DAYS_6_MONTHS | NUMBER | Avg Resolve Days 6 Months | ||
AVG_RESOLVE_DAYS_3_MONTHS | NUMBER | Avg Resolve Days 3 Months | ||
AVG_RESOLVE_DAYS_1_MONTH | NUMBER | Avg Resolve Days 1 Month | ||
ORDER_LINES_DELIVERED | NUMBER | Order Lines Delivered | ||
ORDER_LINES_ONTIME | NUMBER | Order Lines Ontime | ||
ORDER_QTY_CUMUL | NUMBER | Order Qty Cumul | ||
ORDER_RECENCY | NUMBER | Order Recency | ||
PAYMENTS | NUMBER | Payments | ||
RETURNS | NUMBER | Returns | ||
RETURN_BY_VALUE | NUMBER | Return By Value | ||
RETURN_BY_VALUE_PCT | NUMBER | Return By Value Pct | ||
ONTIME_PAYMENTS | NUMBER | Ontime Payments | ||
ONTIME_SHIP_PCT | NUMBER | Ontime Ship Pct | ||
CLOSED_SRS | NUMBER | Closed Srs | ||
COGS | NUMBER | Cogs | ||
CONTRACTS_CUML | NUMBER | Contracts Cuml | ||
CONTRACT_AMT | NUMBER | Contract Amt | ||
CONTRACT_DURATION | NUMBER | Contract Duration | ||
INACTIVE_CONTRACTS | NUMBER | Inactive Contracts | ||
OPEN_CONTRACTS | NUMBER | Open Contracts | ||
NEW_CONTRACTS | NUMBER | New Contracts | ||
RENEWED_CONTRACTS | NUMBER | Renewed Contracts | ||
ESCALATED_SRS | NUMBER | Escalated Srs | ||
FIRST_CALL_CL_RATE | NUMBER | First Call Cl Rate | ||
NUM_OF_COMPLAINTS | NUMBER | Num Of Complaints | ||
NUM_OF_INTERACTIONS | NUMBER | Num Of Interactions | ||
NUM_OF_TRANSFERS | NUMBER | Num Of Transfers | ||
OPEN_SRS | NUMBER | Open Srs | ||
PCT_CALL_REWORK | NUMBER | Pct Call Rework | ||
PRODUCTS | NUMBER | Products | ||
REFERALS | NUMBER | Referals | ||
REOPENED_SRS | NUMBER | Reopened Srs | ||
SALES | NUMBER | Sales | ||
TOTAL_SR_RESPONSE_TIME | NUMBER | Total Sr Response Time | ||
PCT_FIRST_CLOSED_SRS | NUMBER | Pct First Closed Srs | ||
AVG_COMPLAINTS | NUMBER | Avg Complaints | ||
AVG_HOLD_TIME | NUMBER | Avg Hold Time | ||
AVG_LEN_OF_EMP | NUMBER | Avg Len Of Emp | ||
AVG_TRANSFERS_PER_SR | NUMBER | Avg Transfers Per Sr | ||
AVG_WORKLOAD | NUMBER | Avg Workload | ||
TOT_CALLS | NUMBER | Tot Calls | ||
CALL_LENGTH | NUMBER | Call Length | ||
SEEDED_TARGET | VARCHAR2 | (0) | Seeded Target |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, GROSS_ANNUAL_INCOME
, DEBT_TO_INCOME_RATIO
, NET_WORTH
, TOTAL_ASSETS
, TOT_DEBT_OUTSTANDING
, GROSS_ANNUAL_SALES
, CURRENT_ASSETS
, CURRENT_LIABILITIES
, NET_PROFIT
, ACCOUNTS_RECEIVABLE
, RETAINED_EARNINGS
, THIRD_PARTY_FLAG
, DAYS_SINCE_LAST_EVENT
, NUM_TIMES_TARGETED
, LAST_TARGETED_CHANNEL_CODE
, TIMES_TARGETED_MONTH
, TIMES_TARGETED_3_MONTHS
, TIMES_TARGETED_6_MONTHS
, TIMES_TARGETED_9_MONTHS
, TIMES_TARGETED_12_MONTHS
, DAYS_SINCE_LAST_TARGETED
, AVG_DISC_OFFERED
, NUM_TYPES_DISC_OFFERED
, DAYS_SINCE_FIRST_CONTACT
, NUM_TIMES_TARGETED_EMAIL
, NUM_TIMES_TARGETED_TELEMKT
, NUM_TIMES_TARGETED_DIRECT
, NUM_TGT_BY_OFFR_TYP1
, NUM_TGT_BY_OFFR_TYP2
, NUM_TGT_BY_OFFR_TYP3
, NUM_TGT_BY_OFFR_TYP4
, 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
, 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
, SEEDED_TARGET
FROM APPS.AMS_DM_PARTY_ATTRIBUTES_V;
APPS.AMS_DM_PARTY_ATTRIBUTES_V is not referenced by any database object
|
|
|