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]

TABLE: AMS.AMS_DM_AGG_STG

Object Details

Object Name:	AMS_DM_AGG_STG
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_DM_AGG_STG
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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_DM_AGG_STG_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PARTY_ID

Columns

Name	Datatype	Mandatory	Comments
PARTY_ID	NUMBER	Yes	Column used to join with AMS_DM_DRV_STG.
AGE	NUMBER		Calculated age.
DAYS_SINCE_LAST_SCHOOL	NUMBER		Calculated days since last attended school.
DAYS_SINCE_LAST_EVENT	NUMBER		Calculated days since last attended an event.
NUM_TIMES_TARGETED	NUMBER		Calculated 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_12_MONTHS	NUMBER		Number of times targeted in the last 12 months.
DAYS_SINCE_LAST_TARGETED	NUMBER		Number of days since last 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 first contacted.
DAYS_SINCE_ACCT_ESTABLISHED	NUMBER		Number of days since the account was established.
DAYS_SINCE_ACCT_TERM	NUMBER		Number of days since the account was terminated.
DAYS_SINCE_ACCT_ACTIVATION	NUMBER		Number of days since the account was activated.
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 type 1.
NUM_TGT_BY_OFFR_TYP2	NUMBER		Number of times targeted by offer type 2.
NUM_TGT_BY_OFFR_TYP3	NUMBER		Number of times targeted by offer type 3.
NUM_TGT_BY_OFFR_TYP4	NUMBER		Number of times targeted by offer type 4.

Query Text

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


SELECT PARTY_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_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
FROM AMS.AMS_DM_AGG_STG;

Dependencies

[top of page]

AMS.AMS_DM_AGG_STG does not reference any database object

AMS.AMS_DM_AGG_STG is referenced by following:

APPS: AMS_DM_AGG_STG