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

VIEW: APPS.AMS_DM_PARTY_ATTRIBUTES_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.AMS_DM_PARTY_ATTRIBUTES_V references the following:

SchemaAPPS
SynonymAMS_DM_PARTY_DETAILS
SynonymAMS_DM_PARTY_DETAILS_TIME

APPS.AMS_DM_PARTY_ATTRIBUTES_V is not referenced by any database object