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

VIEW: AMS.AMS_DM_PARTY_DETAILS_TIME#

Object Details
Object Name: AMS_DM_PARTY_DETAILS_TIME#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Yes
CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

OBJECT_VERSION_NUMBER NUMBER

SECURITY_GROUP_ID NUMBER

AGE NUMBER

DAYS_SINCE_LAST_SCHOOL NUMBER

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_9_MONTHS NUMBER

TIMES_TARGETED_12_MONTHS NUMBER

DAYS_SINCE_LAST_TARGETED NUMBER

AVG_DISC_OFFERED NUMBER

NUM_TYPES_DISC_OFFERED NUMBER

DAYS_SINCE_FIRST_CONTACT NUMBER

DAYS_SINCE_ACCT_ESTABLISHED NUMBER

DAYS_SINCE_ACCT_TERM NUMBER

DAYS_SINCE_ACCT_ACTIVATION NUMBER

DAYS_SINCE_ACCT_SUSPENDED NUMBER

NUM_TIMES_TARGETED_EMAIL NUMBER

NUM_TIMES_TARGETED_TELEMKT NUMBER

NUM_TIMES_TARGETED_DIRECT 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

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

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

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# references the following:

SchemaAMS
TableAMS_DM_PARTY_DETAILS_TIME
AMS.AMS_DM_PARTY_DETAILS_TIME# is referenced by following:

SchemaAPPS
SynonymAMS_DM_PARTY_DETAILS_TIME