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

TABLE: AMS.AMS_DM_PARTY_DETAILS_TIME

Object Details
Object Name: AMS_DM_PARTY_DETAILS_TIME
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_DM_PARTY_DETAILS_TIME
Subobject Name:
Status: VALID


AMS_DM_GEN_STG table is populated by the OMO Mining Collection pack. The table is truncated after each run. When populated the table contains generic details for parties in the AMS_DM_DRV_STG table.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_DM_PARTY_DETAILS_TIME_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Yes Party identifier.
CREATED_BY NUMBER

Standard WHO column.
CREATION_DATE DATE

Standard WHO column.
LAST_UPDATED_BY NUMBER

Standard WHO column.
LAST_UPDATE_DATE DATE

Standard WHO column.
LAST_UPDATE_LOGIN NUMBER

Standard WHO column.
OBJECT_VERSION_NUMBER NUMBER

This column is used for locking purposes.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
AGE NUMBER

Age
DAYS_SINCE_LAST_SCHOOL NUMBER

Number of days since last attended school.
DAYS_SINCE_LAST_EVENT NUMBER

Number of days since last attended an event.
NUM_TIMES_TARGETED NUMBER

Number of times targeted.
LAST_TARGETED_CHANNEL_CODE NUMBER

Last targeted channel.
TIMES_TARGETED_MONTH NUMBER

Number of times targeted in the last month.
TIMES_TARGETED_3_MONTHS NUMBER

Number of times targeted in the last 3 months.
TIMES_TARGETED_6_MONTHS NUMBER

Number of times targeted in the last 6 months.
TIMES_TARGETED_9_MONTHS NUMBER

Number of times targeted in the last 9 months.
TIMES_TARGETED_12_MONTHS NUMBER

Number of times targeted in the last 12 months.
DAYS_SINCE_LAST_TARGETED NUMBER

Number of days since the last time targeted.
AVG_DISC_OFFERED NUMBER

Average discount offered.
NUM_TYPES_DISC_OFFERED NUMBER

Number of types of discounts offered.
DAYS_SINCE_FIRST_CONTACT NUMBER

Number of days since the first contact.
DAYS_SINCE_ACCT_ESTABLISHED NUMBER

Number of days since account established.
DAYS_SINCE_ACCT_TERM NUMBER

Number of days since account terms.
DAYS_SINCE_ACCT_ACTIVATION NUMBER

Number of days since account activation.
DAYS_SINCE_ACCT_SUSPENDED NUMBER

Number of days since the account was suspended.
NUM_TIMES_TARGETED_EMAIL NUMBER

Number of times targeted by email.
NUM_TIMES_TARGETED_TELEMKT NUMBER

Number of times targeted by telemarketing.
NUM_TIMES_TARGETED_DIRECT NUMBER

Number of times targeted by direct mail.
NUM_TGT_BY_OFFR_TYP1 NUMBER

Number of times targeted by offer 1.
NUM_TGT_BY_OFFR_TYP2 NUMBER

Number of times targeted by offer 2.
NUM_TGT_BY_OFFR_TYP3 NUMBER

Number of times targeted by offer 3.
NUM_TGT_BY_OFFR_TYP4 NUMBER

Number of times targeted by offer 4.
AVG_TALK_TIME NUMBER

Average talk time.
AVG_ORDER_AMOUNT NUMBER

Average order amount.
AVG_UNITS_PER_ORDER NUMBER

Averge units per order.
TOT_ORDER_AMOUNT_YEAR NUMBER

Total order amount in the past year.
TOT_ORDER_AMOUNT_9_MONTHS NUMBER

Total order amount in the past 9 months.
TOT_ORDER_AMOUNT_6_MONTHS NUMBER

Total order amount in the past 6 months.
TOT_ORDER_AMOUNT_3_MONTHS NUMBER

Total order amount in the past 3 months.
TOT_NUM_ORDERS_YEAR NUMBER

Total number of orders in the past year.
TOT_NUM_ORDER_9_MONTHS NUMBER

Total number of orders in the past 9 months.
TOT_NUM_ORDER_6_MONTHS NUMBER

Total number of orders in the past 6 months.
TOT_NUM_ORDER_3_MONTHS NUMBER

Total number of orders in the past 3 months.
NUM_OF_SR_YEAR NUMBER

Number of service requests in the past year.
NUM_OF_SR_6_MONTHS NUMBER

Number of service requests in the past 6 months.
NUM_OF_SR_3_MONTHS NUMBER

Number of service requests in the past 3 months.
NUM_OF_SR_1_MONTH NUMBER

Number of service requests in the past month.
AVG_RESOLVE_DAYS_YEAR NUMBER

Average number of days to resolve in the past year.
AVG_RESOLVE_DAYS_6_MONTHS NUMBER

Average number of days to resolve in the past 6 months.
AVG_RESOLVE_DAYS_3_MONTHS NUMBER

Average number of days to resolve in the past 3 months.
AVG_RESOLVE_DAYS_1_MONTH NUMBER

Average number of days to resolve in the past month.
ORDER_LINES_DELIVERED NUMBER

Number of order lines delivered.
ORDER_LINES_ONTIME NUMBER

Number of order lines delivered on time.
ORDER_QTY_CUMUL NUMBER

Cumulative order quantity.
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 percentage value.
ONTIME_PAYMENTS NUMBER

On time payments.
ONTIME_SHIP_PCT NUMBER

Ontime ship percentage.
CLOSED_SRS NUMBER

Closed service requests.
COGS NUMBER

Cost of goods.
CONTRACTS_CUML NUMBER

Cumulative contracts.
CONTRACT_AMT NUMBER

Contract amount.
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 service requests.
FIRST_CALL_CL_RATE NUMBER

First call close rate.
NUM_OF_COMPLAINTS NUMBER

Number of complaints.
NUM_OF_INTERACTIONS NUMBER

Number of interactions.
NUM_OF_TRANSFERS NUMBER

Number of transfers.
OPEN_SRS NUMBER

Open service requests.
PCT_CALL_REWORK NUMBER

Percentage of calls reworked.
PRODUCTS NUMBER

Products.
REFERALS NUMBER

Referrals.
REOPENED_SRS NUMBER

Re-opened service requests.
SALES NUMBER

Sales.
TOTAL_SR_RESPONSE_TIME NUMBER

Total service request response time.
PCT_FIRST_CLOSED_SRS NUMBER

Percentage of first closed service requests.
AVG_COMPLAINTS NUMBER

Average complaints.
AVG_HOLD_TIME NUMBER

Average hold time.
AVG_LEN_OF_EMP NUMBER

Average length of employment.
AVG_TRANSFERS_PER_SR NUMBER

Average transfers per service request.
AVG_WORKLOAD NUMBER

Average workload.
TOT_CALLS NUMBER

Total calls.
CALL_LENGTH NUMBER

Call length.
PROFITABILITY NUMBER

Profitability.
Query Text

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


SELECT PARTY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      AGE
,      DAYS_SINCE_LAST_SCHOOL
,      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
,      DAYS_SINCE_ACCT_ESTABLISHED
,      DAYS_SINCE_ACCT_TERM
,      DAYS_SINCE_ACCT_ACTIVATION
,      DAYS_SINCE_ACCT_SUSPENDED
,      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
,      PROFITABILITY
FROM AMS.AMS_DM_PARTY_DETAILS_TIME;

Dependencies

[top of page]

AMS.AMS_DM_PARTY_DETAILS_TIME does not reference any database object

AMS.AMS_DM_PARTY_DETAILS_TIME is referenced by following:

SchemaAMS
ViewAMS_DM_PARTY_DETAILS_TIME#