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

TABLE: IEX.IEX_STRATEGIES_HISTORY

Object Details
Object Name: IEX_STRATEGIES_HISTORY
Object Type: TABLE
Owner: IEX
Subobject Name:
Status: VALID


Holds archived data of Strategies.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEX_STRATEGIES_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTRATEGY_ID
IEX_STRATEGIES_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELINQUENCY_ID
IEX_STRATEGIES_HISTORY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
ColumnSTATUS_CODE
IEX_STRATEGIES_HISTORY_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
ColumnOBJECT_TYPE
IEX_STRATEGIES_HISTORY_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJTF_OBJECT_ID
ColumnJTF_OBJECT_TYPE
ColumnSTATUS_CODE
IEX_STRATEGIES_HISTORY_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_ID
IEX_STRATEGIES_HISTORY_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
IEX_STRATEGIES_HISTORY_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_SITE_USE_ID
ColumnSTATUS_CODE
Columns
Name Datatype Length Mandatory Comments
STRATEGY_ID NUMBER (15) Yes Primarky Key
STATUS_CODE VARCHAR2 (30)
Stategy Status
STRATEGY_TEMPLATE_ID NUMBER (15)
Strategy Template ID
DELINQUENCY_ID NUMBER

Delinquency ID
OBJECT_TYPE VARCHAR2 (30)
Strategy Object Type(PARTY-ACCOUNT-BILL_TO-DELINQUENCY-LITIGATION-BANKRUPTCY)
OBJECT_ID NUMBER

Object ID corresponding to Strategy
CUST_ACCOUNT_ID NUMBER (15)
Account ID
PARTY_ID NUMBER (15)
Party ID
SCORE_VALUE NUMBER

Score Value of object when strategy created
NEXT_WORK_ITEM_ID NUMBER (15)
Work Item Template ID of next work item
USER_WORK_ITEM_YN VARCHAR2 (2)
Does the current work item added to strategy by collections agent manaully - Yes/No
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
OBJECT_VERSION_NUMBER NUMBER
Yes Standard HTML front end column
SECURITY_GROUP_ID NUMBER

Subscriber ID, for CRM Online Services use
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
CHECKLIST_STRATEGY_ID NUMBER

Associated checklist strategy ID
CHECKLIST_YN VARCHAR2 (6)
Flag to determine whether this is checklist strategy or not
STRATEGY_LEVEL NUMBER

strategy level for customer, account, site, delinquency - 10, 20, 30, 40 respectively
JTF_OBJECT_TYPE VARCHAR2 (30)
Strategy JTF Object Type(PARTY-IEX_ACCOUNT-IEX_BILLTO-IEX_DELINQUENCY-IEX_LITIGATION-IEX_BANKRUPTCY)
JTF_OBJECT_ID NUMBER (15)
Object ID
CUSTOMER_SITE_USE_ID NUMBER

Site Use Id,FK to HZ_CUST_SITE_USES_ALL
ORG_ID NUMBER

Operating Unit ID
HOLD_START_DATE DATE

Strategy Hold Start Date
HOLD_DAYS NUMBER

Strategy Hold Duration in Days
RELEASE_DATE DATE

Strategy Hold Release Date
Query Text

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


SELECT STRATEGY_ID
,      STATUS_CODE
,      STRATEGY_TEMPLATE_ID
,      DELINQUENCY_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      CUST_ACCOUNT_ID
,      PARTY_ID
,      SCORE_VALUE
,      NEXT_WORK_ITEM_ID
,      USER_WORK_ITEM_YN
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      LAST_UPDATE_DATE
,      PROGRAM_UPDATE_DATE
,      CHECKLIST_STRATEGY_ID
,      CHECKLIST_YN
,      STRATEGY_LEVEL
,      JTF_OBJECT_TYPE
,      JTF_OBJECT_ID
,      CUSTOMER_SITE_USE_ID
,      ORG_ID
,      HOLD_START_DATE
,      HOLD_DAYS
,      RELEASE_DATE
FROM IEX.IEX_STRATEGIES_HISTORY;

Dependencies

[top of page]

IEX.IEX_STRATEGIES_HISTORY does not reference any database object

IEX.IEX_STRATEGIES_HISTORY is referenced by following:

SchemaIEX
ViewIEX_STRATEGIES_HISTORY#