Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - IEX Tables and Views

TABLE - IEX.IEX_AG_DN_XREF
TABLE - IEX.IEX_APP_PREFERENCES_B
TABLE - IEX.IEX_APP_PREFERENCES_TL
TABLE - IEX.IEX_ASSIGNMENTS
TABLE - IEX.IEX_BALI_FILTERS
TABLE - IEX.IEX_BANKRUPTCIES
TABLE - IEX.IEX_CASES_ALL_B
TABLE - IEX.IEX_CASES_TL
TABLE - IEX.IEX_CASE_CONTACTS
TABLE - IEX.IEX_CASE_DEFINITIONS
TABLE - IEX.IEX_CASE_OBJECTS
TABLE - IEX.IEX_CGI_SWITCHES
TABLE - IEX.IEX_CHANGED_ACCOUNTS_ALL
TABLE - IEX.IEX_CHECKLIST_ITEMS_B
TABLE - IEX.IEX_CHECKLIST_ITEMS_TL
TABLE - IEX.IEX_COSTS
TABLE - IEX.IEX_CUST_STATUS_RULES
TABLE - IEX.IEX_CU_STS_RL_LINES
TABLE - IEX.IEX_DELINQUENCIES_ALL
TABLE - IEX.IEX_DEL_ASSETS
TABLE - IEX.IEX_DEL_BUFFERS
TABLE - IEX.IEX_DEL_PAY_XREF
TABLE - IEX.IEX_DEL_STATUSES
TABLE - IEX.IEX_DEL_THIRD_PARTIES
TABLE - IEX.IEX_DISPUTES
TABLE - IEX.IEX_DLN_UWQ_SUMMARY
TABLE - IEX.IEX_DUNNINGS
TABLE - IEX.IEX_DUNNING_PLANS_B
TABLE - IEX.IEX_DUNNING_PLANS_TL
TABLE - IEX.IEX_DUNNING_PROFILES
TABLE - IEX.IEX_DUNNING_TRANSACTIONS
TABLE - IEX.IEX_EXCLUSION_HIST_B
TABLE - IEX.IEX_EXCLUSION_HIST_TL
TABLE - IEX.IEX_EXT_AGNCY_B
TABLE - IEX.IEX_EXT_AGNCY_TL
TABLE - IEX.IEX_LITIGATIONS
TABLE - IEX.IEX_METRIC_RATINGS
TABLE - IEX.IEX_METRIC_SUMMARIES_ALL
TABLE - IEX.IEX_OBJECT_FILTERS
TABLE - IEX.IEX_OPEN_INT_HST
TABLE - IEX.IEX_PAYMENTS
TABLE - IEX.IEX_PAY_OKL_XREF
TABLE - IEX.IEX_PAY_RECEIPT_XREF
TABLE - IEX.IEX_PRD_APPL_XREF
TABLE - IEX.IEX_PRD_OKL_XREF
TABLE - IEX.IEX_PRD_RECEIPT_XREF
TABLE - IEX.IEX_PROMISE_DETAILS
TABLE - IEX.IEX_QUERY_STRINGS
TABLE - IEX.IEX_QUERY_TEMP_XREF
TABLE - IEX.IEX_QUESTIONNAIRE_ITEMS
TABLE - IEX.IEX_REPOSSESSIONS
TABLE - IEX.IEX_REPOS_OBJECTS
TABLE - IEX.IEX_SCORES
TABLE - IEX.IEX_SCORE_COMPONENTS
TABLE - IEX.IEX_SCORE_COMP_DET
TABLE - IEX.IEX_SCORE_COMP_PARAMS
TABLE - IEX.IEX_SCORE_COMP_TYPES_B
TABLE - IEX.IEX_SCORE_COMP_TYPES_TL
TABLE - IEX.IEX_SCORE_HISTORIES
TABLE - IEX.IEX_STRATEGIES
TABLE - IEX.IEX_STRATEGY_TEMPLATES_B
TABLE - IEX.IEX_STRATEGY_TEMPLATES_TL
TABLE - IEX.IEX_STRATEGY_TEMPLATE_GROUPS
TABLE - IEX.IEX_STRATEGY_TYPES
TABLE - IEX.IEX_STRATEGY_USER_ITEMS
TABLE - IEX.IEX_STRATEGY_WORK_ITEMS
TABLE - IEX.IEX_STRATEGY_WORK_SKILLS
TABLE - IEX.IEX_STRATEGY_WORK_TEMP_XREF
TABLE - IEX.IEX_STRY_TEMP_WORK_ITEMS_B
TABLE - IEX.IEX_STRY_TEMP_WORK_ITEMS_TL
TABLE - IEX.IEX_STRY_WORK_TYPES
TABLE - IEX.IEX_SWITCH_DATA
TABLE - IEX.IEX_WEB_ASSISTS
TABLE - IEX.IEX_WEB_SEARCHES
TABLE - IEX.IEX_WRITEOFFS
TABLE - IEX.IEX_WRITEOFF_CONTRACTS
TABLE - IEX.IEX_WRITEOFF_INVOICES
TABLE - IEX.IEX_WRITEOFF_OBJECTS
TABLE - IEX.IEX_XML_QUERIES
TABLE - IEX.IEX_XML_REQUEST_HISTORIES

Table: IEX_AG_DN_XREF

Description: Cross reference between aging/dunning/Fulfillment
Primary Key: IEX_AG_DN_XREF_PK
  1. AG_DN_XREF_ID
Comments

Cross reference between aging/dunning/Fulfillment

Indexes
Index Type Tablespace Column
IEX_AG_DN_XREF_U1 UNIQUE APPS_TS_SEED AG_DN_XREF_ID
Columns
Name Datatype Length Mandatory Comments
AG_DN_XREF_ID NUMBER
Y Primary Key field.
PROGRAM_ID NUMBER

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
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
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_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
AGING_BUCKET_ID NUMBER

Foreign key to AR_AGING_BUCKETS
AGING_BUCKET_LINE_ID NUMBER

Foreign Key to AR_AGING_BUCKET_LINES
CALLBACK_FLAG VARCHAR2 (1)
Indicates if a callback should be generated.
CALLBACK_DAYS NUMBER

Indicate how long to wait for creating a callback.
FM_METHOD VARCHAR2 (10)
Indicates the fulfillment method to be used to send the dunning.
SCORE_RANGE_LOW NUMBER

Low end of the score range where this applies.
SCORE_RANGE_HIGH NUMBER

High end of the score range where this applies.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
TEMPLATE_ID NUMBER

Foreign key to fulfillment templates.
DUNNING_LEVEL VARCHAR2 (30)
DUNNING_LEVEL is for Party Account or Delinquencies
XDO_TEMPLATE_ID NUMBER

Foreign key to XML Publisher templates.
DUNNING_PLAN_ID NUMBER (10)
Foreign key to iex_dunning_plans_b
RANGE_OF_DUNNING_LEVEL_FROM NUMBER

Dunning level start value for this dunning letter
RANGE_OF_DUNNING_LEVEL_TO NUMBER

Dunning level end value for this dunning letter
MIN_DAYS_BETWEEN_DUNNING NUMBER

Minimum number of days before Receivables increments an item to next dunning level
INVOICE_COPIES VARCHAR2 (1)
Indicates whether copies of invoices is included with each dunning letter

[top of page]

IEX.IEX_AG_DN_XREF does not reference any database object

IEX.IEX_AG_DN_XREF is referenced by following:

IEX
VIEW - IEX_AG_DN_XREF#

[top of page]

Table: IEX_APP_PREFERENCES_B

Description: Collection Preferences Table
Primary Key: IEX_APP_PREFERENCES_PK
  1. PREFERENCE_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_APP_PREFERENCES_B_U1 UNIQUE APPS_TS_SEED PREFERENCE_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
PREFERENCE_ID NUMBER (15) Y
PREFERENCE_NAME VARCHAR2 (30) Y
PREFERENCE_VALUE VARCHAR2 (80)
ENABLED_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

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

Operating Unit
COLLECTIONS_METHOD VARCHAR2 (240)
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_APP_PREFERENCES_B does not reference any database object

IEX.IEX_APP_PREFERENCES_B is referenced by following:

IEX
VIEW - IEX_APP_PREFERENCES_B#

[top of page]

Table: IEX_APP_PREFERENCES_TL

Description: Translation Table for IEX_APP_PREFERENCES_B
Primary Key: IAPTL_PK
  1. PREFERENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEX_APP_PREFERENCES_TL.PREFERENCE_ID %
Comments

Translation Table for IEX_APP_PREFERENCES_B

Indexes
Index Type Tablespace Column
IEX_APP_PREFERENCES_TL_U1 UNIQUE APPS_TS_SEED PREFERENCE_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
PREFERENCE_ID NUMBER (15) Y Primary Key
USER_NAME VARCHAR2 (100) Y Language code of the record from which this was copied during the upgrade
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LANGUAGE VARCHAR2 (4) Y Language code of the text in report_heading1 and report_heading2
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).
SOURCE_LANG VARCHAR2 (4) Y Language code of the record from which this was copied during the upgrade
SECURITY_GROUP_ID NUMBER (15)
Hosting Standard Column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_APP_PREFERENCES_TL does not reference any database object

IEX.IEX_APP_PREFERENCES_TL is referenced by following:

IEX
VIEW - IEX_APP_PREFERENCES_TL#

[top of page]

Table: IEX_ASSIGNMENTS

Description: New Assignments Table for Temporary Resource handling
Primary Key: IASG_PK
  1. ASSIGNMENT_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_ASSIGNMENTS_U1 UNIQUE APPS_TS_TX_IDX ASSIGNMENT_ID
IEX_ASSIGNMENTS_N1 NONUNIQUE APPS_TS_TX_IDX ALT_EMPLOYEE_ID
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER (15) Y
EMPLOYEE_ID NUMBER (15)
Resource ID of Collector
RESOURCE_ID NUMBER (15)
Resource ID of Collector
ALT_EMPLOYEE_ID NUMBER (15)
Backup or Replacement Collector Resource ID
ALT_RESOURCE_ID NUMBER (15)
Backup or Replacement Collector Resource ID
START_DATE DATE

Start Date of the Assignment
END_DATE DATE

End Date of the Assignment
OBJECT_ID VARCHAR2 (240)
Assignment Object ID
OBJECT_TYPE VARCHAR2 (240)
Assignment Object Type
OBJECT_VERSION VARCHAR2 (240)
Assignment Object Version for Updates
SECURITY_GROUP_ID VARCHAR2 (240)
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
DELETED_FLAG VARCHAR2 (3)

[top of page]

IEX.IEX_ASSIGNMENTS does not reference any database object

IEX.IEX_ASSIGNMENTS is referenced by following:

IEX
VIEW - IEX_ASSIGNMENTS#

[top of page]

Table: IEX_BALI_FILTERS

Description: This entity holds information on the additional filters created on any bali spread tables. It will hold the column name , column value and the bali data source per user.
Primary Key: IEX_BALI_FILTERS_PK1
  1. BALI_FILTER_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_BALI_FILTERS_U1 UNIQUE APPS_TS_TX_IDX BALI_FILTER_ID
IEX_BALI_FILTERS_N1 NONUNIQUE APPS_TS_TX_IDX BALI_USER_ID
BALI_FILTER_NAME
Columns
Name Datatype Length Mandatory Comments
BALI_FILTER_ID NUMBER
Y Primary Key Column
BALI_FILTER_NAME VARCHAR2 (100) Y Filter name - user entered
BALI_DATASOURCE VARCHAR2 (100) Y Name of the bali data source. This is the name under which the bali is registered.
BALI_USER_ID NUMBER (15) Y User who created the filter criteria's
BALI_COL_ALIAS VARCHAR2 (30) Y Column name of the bali.
BALI_COL_DATA_TYPE VARCHAR2 (30) Y Data type of the Column.
BALI_COL_LABEL_TEXT VARCHAR2 (80) Y Column desc of the bali.
BALI_COL_CONDITION_CODE VARCHAR2 (30) Y Filter Condition Code. possible value are =, <>, LIKE , CONTAINS , > , < based on the column data type.
BALI_COL_CONDITION_VALUE VARCHAR2 (30) Y Filter Condition value. possible value are =, <>, LIKE , CONTAINS , > , < based on the column data type.
BALI_COL_VALUE VARCHAR2 (100) Y Filter Condition value. possible value are =, <>, LIKE , CONTAINS , > , < based on the column data type.
RIGHT_PARENTHESIS_CODE VARCHAR2 (100)
Right parenthesis place holder
LEFT_PARENTHESIS_CODE VARCHAR2 (100)
left parenthesis place holder
BOOLEAN_OPERATOR_CODE VARCHAR2 (100)
Boolean operator code- Possible Values are 'AND ' , 'OR'
OBJECT_VERSION_NUMBER NUMBER (9) Y Column used for locking records during updates.
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

IEX.IEX_BALI_FILTERS does not reference any database object

IEX.IEX_BALI_FILTERS is referenced by following:

IEX
VIEW - IEX_BALI_FILTERS#

[top of page]

Table: IEX_BANKRUPTCIES

Description: This entity keeps information on Bankrupt cases. Bankruptcy information such the category, the jurisdiction, date initiated, court proceedings, trustee, debtor, and collection invoicing flags
Primary Key: IEX_BANKRUPTCIES_PK
  1. BANKRUPTCY_ID
Comments

This entity keeps information on Bankrupt cases. Bankruptcy information such the category, the jurisdiction, date initiated, court proceedings, trustee, debtor, and collection invoicing flags

Indexes
Index Type Tablespace Column
IEX_BANKRUPTCIES_U1 UNIQUE APPS_TS_TX_IDX BANKRUPTCY_ID
IEX_BANKRUPTCIES_N1 NONUNIQUE APPS_TS_TX_IDX CAS_ID
IEX_BANKRUPTCIES_N2 NONUNIQUE APPS_TS_TX_IDX DELINQUENCY_ID
IEX_BANKRUPTCIES_N3 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
IEX_BANKRUPTCIES_N4 NONUNIQUE APPS_TS_TX_IDX COUNSEL_CONTACT_ID
IEX_BANKRUPTCIES_N5 NONUNIQUE APPS_TS_TX_IDX COURT_ID
IEX_BANKRUPTCIES_N6 NONUNIQUE APPS_TS_TX_IDX FIRM_CONTACT_ID
IEX_BANKRUPTCIES_N7 NONUNIQUE APPS_TS_TX_IDX TRUSTEE_CONTACT_ID
IEX_BANKRUPTCIES_N8 NONUNIQUE APPS_TS_TX_IDX SYS_NC00072$
Columns
Name Datatype Length Mandatory Comments
BANKRUPTCY_ID NUMBER
Y Bankruptcy Identifier
CAS_ID NUMBER

Foreign Key to Iex_cases_b table
DELINQUENCY_ID NUMBER

Foreign Key to IEX_DELEINQUENCY table
PARTY_ID NUMBER
Y Party Filing for Bankruptcy
ACTIVE_FLAG VARCHAR2 (1) Y Indicates the State of a case whether it is active or on active. This is usedsince the record is not removed from the database.
TRUSTEE_CONTACT_ID NUMBER

The individual from the Trustee Organization who is assigned to the Bankruptcy Case.
COURT_ID NUMBER

Court or district where the filing was made.
FIRM_CONTACT_ID NUMBER

Law firm who is assigned to the Bankruptcy Case.
COUNSEL_CONTACT_ID NUMBER

Attorney who is assigned to the Bankruptcy Case.
OBJECT_VERSION_NUMBER NUMBER (9) Y For HTML support.
CHAPTER_CODE VARCHAR2 (30)
The Chapter under which the bankruptcy was filed. Eg. Chapter 7,9,11,12
ASSET_AMOUNT NUMBER

Asset value of the delinquency
ASSET_CURRENCY_CODE VARCHAR2 (30)
Currency of the Asset Valuation
PAYOFF_AMOUNT NUMBER

Payoff Amount
PAYOFF_CURRENCY_CODE VARCHAR2 (240)
Currency of the Payoff Valuation
BANKRUPTCY_FILE_DATE DATE

The Date the Bankruptcy was filed.
COURT_ORDER_DATE DATE

The date the court proceedings will be initiated.
FUNDING_DATE DATE

Date funding was allocated.
OBJECT_BAR_DATE DATE

For HTML support.
REPOSSESSION_DATE DATE

Date on which the delinquent item was repossessed
DISMISSAL_DATE DATE

Date on which court dismissed the Bankruptcy claim
DATE_341A DATE

341 is the first meeting of the creditors.It is mandatory meeting of the debitors and creditors usually held within a month of the filing of the bankruptcy.
DISCHARGE_DATE DATE

Date on which court dismissed the Bankruptcy claim
WITHDRAW_DATE DATE

Date on which debtor withdre bankruptcy claim
CLOSE_DATE DATE

Date on which the case was closed by the court.
PROCEDURE_CODE VARCHAR2 (30)
Procedures which the collector wishes to initiate like debt not reaffirmed and pending discharge, relieve from stay,place account on hold
MOTION_CODE VARCHAR2 (30)
Motions that can be filed based on the status of the caselike relief from stay,Motion for adequate protection,Consent Order
CHECKLIST_CODE VARCHAR2 (30)
Checklist or guidelines for collectors neede for a particular status or function like -Filing , contact, chapter etc.
CEASE_COLLECTIONS_YN VARCHAR2 (1)
Notify flag for turning an account from collections
TURN_OFF_INVOICING_YN VARCHAR2 (1)
Notify flag for turning normal cycle invoicing to off.
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
CREDIT_HOLD_REQUEST_FLAG VARCHAR2 (1)
Was credit hold requested Y/N?
CREDIT_HOLD_APPROVED_FLAG VARCHAR2 (1)
Was credit hold approved Y/N?
SERVICE_HOLD_REQUEST_FLAG VARCHAR2 (1)
Was service hold requested Y/N?
SERVICE_HOLD_APPROVED_FLAG VARCHAR2 (1)
Was service hold approved Y/N?
DISPOSITION_CODE VARCHAR2 (30)
Bankruptcy disposition. Lookup.
TURN_OFF_INVOICE_YN VARCHAR2 (1)
Stop invoicing when customer goes bankrupt?
NOTICE_ASSIGNMENT_YN VARCHAR2 (1)
Did we receive notice of assignment?
FILE_PROOF_CLAIM_YN VARCHAR2 (1)
Did we file proof of claim?
REQUEST_REPURCHASE_YN VARCHAR2 (1)
Should we request repurchase?
FEE_PAID_DATE DATE

Date have we paid the court fees.
REAFFIRMATION_DATE DATE

Date of the court reaffirmation for the bankruptcy
RELIEF_STAY_DATE DATE

Bankruptcy RELEIF date.
FILE_CONTACT_ID NUMBER

Contact foreign key.
CASE_NUMBER VARCHAR2 (100)
Case number in court.
COURT_CLERK_CONTACT_ID NUMBER

Contact ID foreign key for the court clerk.
CUST_ACCOUNT_ID NUMBER

Customer account ID
CUSTOMER_SITE_USE_ID NUMBER (22)
Customer Site Use ID
ORG_ID NUMBER

Operating Unit ID
APPROVAL_DATE DATE

Bankrutpcy Approval Date

[top of page]

IEX.IEX_BANKRUPTCIES does not reference any database object

IEX.IEX_BANKRUPTCIES is referenced by following:

IEX
VIEW - IEX_BANKRUPTCIES#

[top of page]

Table: IEX_CASES_ALL_B

Description: Details of the Case
Primary Key: IEX_CASES_ALL_B_PK
  1. CAS_ID
Comments

Details of the Case

Indexes
Index Type Tablespace Column
IEX_CASES_ALL_B_U1 UNIQUE APPS_TS_TX_IDX CAS_ID
IEX_CASES_ALL_B_N1 NONUNIQUE APPS_TS_TX_IDX STATUS_CODE
IEX_CASES_ALL_B_N2 NONUNIQUE APPS_TS_TX_IDX CLOSE_REASON
IEX_CASES_ALL_B_N3 NONUNIQUE APPS_TS_TX_IDX CASE_NUMBER
IEX_CASES_ALL_B_N4 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
Columns
Name Datatype Length Mandatory Comments
CAS_ID NUMBER
Y Case Identifier
CASE_NUMBER VARCHAR2 (240) Y The sequence number allocated for a Case in Collections module
ORIG_CAS_ID NUMBER

Original Case Identifier. This will be populated when a case is copied from a previous case.
PARTY_ID NUMBER
Y Party Id for a case
STATUS_CODE VARCHAR2 (240) Y Indicates the status of a case whether it is delinquent, pre-delinquent,current
CLOSE_REASON VARCHAR2 (240)
Indicates the reason for closing a case like bankruptcy,litigation,instruct repossession
CASE_STATE VARCHAR2 (240) Y Indicates the State of a case whether it is open or closed.
ACTIVE_FLAG VARCHAR2 (240) Y Indicates the State of a case whether it is active or on active. This is usedsince the record is not removed from the database.
OBJECT_VERSION_NUMBER NUMBER (9) Y Standard HTML front end column
CASE_ESTABLISHED_DATE DATE
Y The date when the Case was created in the system
CASE_CLOSING_DATE DATE

The date when the Case was created in the system
OWNER_RESOURCE_ID NUMBER

Ownerof the case ,Case collection agent
ACCESS_RESOURCE_ID NUMBER

Resource which can access the case. This could be a group or person
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ORG_ID NUMBER (15) Y Organization identifier
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
PREDICTED_RECOVERY_AMOUNT NUMBER

Predicted Recovery amount ( OKL specific) . This is the expected amount to be recovered for the case.
PREDICTED_CHANCE NUMBER

Predicted Chance ( OKL specific) . This is expected recovery % for the debt
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

IEX.IEX_CASES_ALL_B does not reference any database object

IEX.IEX_CASES_ALL_B is referenced by following:

IEX
VIEW - IEX_CASES_ALL_B#

[top of page]

Table: IEX_CASES_TL

Description: Translation Table for table IEX_CASES
Primary Key: IEX_CASES_TL_PK
  1. CAS_ID
  2. LANGUAGE
Comments

Translation Table for table IEX_CASES

Indexes
Index Type Tablespace Column
IEX_CASES_TL_U1 UNIQUE APPS_TS_TX_IDX CAS_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
CAS_ID NUMBER
Y Case Identifier
LANGUAGE VARCHAR2 (240) Y Language
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
ACTIVE_FLAG VARCHAR2 (240) Y Indicates if he case is active or not.
COMMENTS VARCHAR2 (240)
Comments about the Case
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

IEX.IEX_CASES_TL does not reference any database object

IEX.IEX_CASES_TL is referenced by following:

IEX
VIEW - IEX_CASES_TL#

[top of page]

Table: IEX_CASE_CONTACTS

Description: Holds information about the contacts defined for party playing a specific role in the collection process of a case.
Primary Key: IEX_CASE_CONTACTS_PK
  1. CAS_CONTACT_ID
Comments

Holds information about the contacts defined for party playing a specific role in the collection process of a case.

Indexes
Index Type Tablespace Column
IEX_CASE_CONTACTS_U1 UNIQUE APPS_TS_TX_IDX CAS_CONTACT_ID
IEX_CASE_CONTACTS_N1 NONUNIQUE APPS_TS_TX_IDX CONTACT_PARTY_ID
IEX_CASE_CONTACTS_N2 NONUNIQUE APPS_TS_TX_IDX ADDRESS_ID
IEX_CASE_CONTACTS_N3 NONUNIQUE APPS_TS_TX_IDX PHONE_ID
Columns
Name Datatype Length Mandatory Comments
CAS_CONTACT_ID NUMBER
Y Case Contact Indentifier
CONTACT_PARTY_ID NUMBER
Y The contact point for this case, the Agent handling it.
CAS_ID NUMBER
Y Foreign Key to IEX_CASES_B table
ADDRESS_ID NUMBER

Address Id of the contact
PHONE_ID NUMBER

Phone ID of the contact
OBJECT_VERSION_NUMBER NUMBER (9) Y Standard HTML front end column
ACTIVE_FLAG VARCHAR2 (240) Y A sequence to help in sorting.
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
PRIMARY_FLAG VARCHAR2 (240) Y Primary Contact
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

IEX.IEX_CASE_CONTACTS does not reference any database object

IEX.IEX_CASE_CONTACTS is referenced by following:

IEX
VIEW - IEX_CASE_CONTACTS#

[top of page]

Table: IEX_CASE_DEFINITIONS

Description: Hold information about the criteria which is used to identify a case.For example , a case (if it is contract) is uniquely identified by the private label, bill_to_address,currency and vendor progaram id.
Primary Key: IEX_CASE_DEFINITIONS_PK
  1. CASE_DEFINITION_ID
Comments

Hold information about the criteria which is used to identify a case.For example , a case (if it is contract) is uniquely identified by the private label, bill_to_address,currency and vendor progaram id.

Indexes
Index Type Tablespace Column
IEX_CASE_DEFINITIONS_U1 UNIQUE APPS_TS_TX_IDX CASE_DEFINITION_ID
IEX_CASE_DEFINITIONS_N1 NONUNIQUE APPS_TS_TX_IDX COLUMN_NAME
COLUMN_VALUE
TABLE_NAME
Columns
Name Datatype Length Mandatory Comments
CASE_DEFINITION_ID NUMBER
Y Case Definition Identifier
TABLE_NAME VARCHAR2 (30)
The From table of the case defintion
COLUMN_NAME VARCHAR2 (240) Y Column name of the case definition
COLUMN_VALUE VARCHAR2 (240) Y Column value of the case definition
ACTIVE_FLAG VARCHAR2 (240) Y Active flag
OBJECT_VERSION_NUMBER NUMBER (9) Y Standard HTML front end column
CAS_ID NUMBER
Y Foreign key to Iex_cases_b table
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

IEX.IEX_CASE_DEFINITIONS does not reference any database object

IEX.IEX_CASE_DEFINITIONS is referenced by following:

IEX
VIEW - IEX_CASE_DEFINITIONS#

[top of page]

Table: IEX_CASE_OBJECTS

Description: Hold information about the elements of a case. Example . It will hold object_code 'CONTRACTS' and
Primary Key: IEX_CASE_OBJECTS_PK
  1. CASE_OBJECT_ID
Comments

Hold information about the elements of a case. Example . It will hold object_code 'CONTRACTS' and
select_id "will be the primary key of the contract "i f the element of the case is a contract or if it is invoice, the object _code will be "INVOICE" and the select_id will be "primary key of the invoice"

Indexes
Index Type Tablespace Column
IEX_CASE_OBJECTS_U1 UNIQUE APPS_TS_TX_IDX OBJECT_CODE
OBJECT_ID
IEX_CASE_OBJECTS_U2 UNIQUE APPS_TS_TX_IDX CASE_OBJECT_ID
IEX_CASE_OBJECTS_N1 NONUNIQUE APPS_TS_TX_IDX CAS_ID
IEX_CASE_OBJECTS_N2 NONUNIQUE APPS_TS_TX_IDX OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
CASE_OBJECT_ID NUMBER
Y Case Object Identifier
OBJECT_ID NUMBER
Y Hold the value of the primary key for the case element
OBJECT_CODE VARCHAR2 (30) Y The sequence number allocated for a Case in Collections module
OBJECT_VERSION_NUMBER NUMBER (9) Y Standard HTML front end column
CAS_ID NUMBER
Y Foriegn key to Iex_cases_b table
ACTIVE_FLAG VARCHAR2 (240) Y Active flag
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ORG_ID NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
COLLECTIONS_ACTION VARCHAR2 (30)
Collections Action
DELINQUENCY_STATUS VARCHAR2 (30)
Delinquent Status

[top of page]

IEX.IEX_CASE_OBJECTS does not reference any database object

IEX.IEX_CASE_OBJECTS is referenced by following:

IEX
VIEW - IEX_CASE_OBJECTS#

[top of page]

Table: IEX_CGI_SWITCHES

Description: Metadata for query string switches
Primary Key: IEX_CGI_SWITCHES_PK
  1. CGI_SWITCH_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Columns
Name Datatype Length Mandatory Comments
SORT_ORDER NUMBER

Shows what order the switch appear on the string
CREATION_DATE DATE

Standard who column - date when this row was created.
IS_REQUIRED_YN VARCHAR2 (1)
Is it required or not?
SWITCH_CODE VARCHAR2 (240)
CGI switch code.i.e. http://www.bigyellow.com/cgi?f=firstname&l=lastname'f' and 'l' are switch codes
CGI_SWITCH_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
DATA_SEPARATOR VARCHAR2 (240)
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Hosting Standard Column
ENABLED_FLAG VARCHAR2 (1)
Is this enabled or not
SWITCH_TYPE VARCHAR2 (240)
CGI switch type
QUERY_STRING_ID NUMBER (15)
Query string identifier. Foreign key to IEX_QUERY_STRING
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

IEX.IEX_CGI_SWITCHES does not reference any database object

IEX.IEX_CGI_SWITCHES is referenced by following:

IEX
VIEW - IEX_CGI_SWITCHES#

[top of page]

Table: IEX_CHANGED_ACCOUNTS_ALL

Description: This table stores accounts that have new collectors assigned.
Comments

This table stores accounts that have new collectors assigned.

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15) Y Foreign key into HZ_PARTIES
ACCOUNT_ID NUMBER (15)
Foreign key into HZ_CUST_ACCOUNTS
SITE_USE_ID NUMBER (15)
Foreign key into HZ_CUST_SITE_USES_ALL
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - who updated this row.
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - who created this row.
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - who updated this row.
REQUEST_ID NUMBER

Concurrent request id.
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

PROGRAM_UPDATE_DATE
CHANGE_TYPE VARCHAR2 (30)
CHANGE_TYPE
PROCESSED_FLAG VARCHAR2 (1)
PROCESSED_FLAG
ORG_ID NUMBER

Organization identifier
OBJECT_VERSION_NUMBER NUMBER

Standard HTML front end column

[top of page]

IEX.IEX_CHANGED_ACCOUNTS_ALL does not reference any database object

IEX.IEX_CHANGED_ACCOUNTS_ALL is referenced by following:

IEX
VIEW - IEX_CHANGED_ACCOUNTS_ALL#

[top of page]

Table: IEX_CHECKLIST_ITEMS_B

Description: Store Checklist items for administration
Primary Key: IEX_CHECKLIST_ITEMS_B_PK
  1. CHECKLIST_ITEM_ID
Comments

Store Checklist items for administration

Indexes
Index Type Tablespace Column
IEX_CHECKLIST_ITEMS_U1 UNIQUE APPS_TS_TX_IDX CHECKLIST_ITEM_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
CHECKLIST_ITEM_ID NUMBER (15) Y PK of checklist item
CHECKLIST_ITEM_NAME VARCHAR2 (30) Y checklist item name
CHECKLIST_ITEM_TYPE VARCHAR2 (30)
checklist item type
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created 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).
STATUS VARCHAR2 (30)
task status
MANDATORY_FLAG VARCHAR2 (1)
Should this task be defined?
START_DATE_ACTIVE DATE

Start date when checklist item is active
END_DATE_ACTIVE DATE

End date when checklist item is active
CHECKLIST_PARENT_ITEM_ID NUMBER (15)
Master checklist item id
QUESTIONNAIRE_LINK VARCHAR2 (150)
URL to lauch questionnaire page
TASK_LINK VARCHAR2 (150)
URL to lauch update task page
TASK_LAST_MODIFIED_DATE DATE

Last date when task is modified
VIEW_LINK VARCHAR2 (150)
URL to lauch view task page
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_CHECKLIST_ITEMS_B does not reference any database object

IEX.IEX_CHECKLIST_ITEMS_B is referenced by following:

IEX
VIEW - IEX_CHECKLIST_ITEMS_B#

[top of page]

Table: IEX_CHECKLIST_ITEMS_TL

Description: Translation table of IEX_CHECKLIST_ITEMS_B
Primary Key: IEX_CHECKLIST_ITEMS_TL_PK
  1. CHECKLIST_ITEM_ID
  2. LANGUAGE
Comments

Translation table of IEX_CHECKLIST_ITEMS_B

Indexes
Index Type Tablespace Column
IEX_CHECKLIST_ITEMS_TL_U1 UNIQUE APPS_TS_TX_IDX CHECKLIST_ITEM_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
CHECKLIST_ITEM_ID NUMBER (15) Y PK of checklist item
LANGUAGE VARCHAR2 (4) Y Language Code for translation
SOURCE_LANG VARCHAR2 (4) Y Source Language Code for translation
CHECKLIST_ITEM_TEXT VARCHAR2 (2000) Y Translated Checklist item text
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created 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).
DESCRIPTION VARCHAR2 (2000)
Translated Checklist item description
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_CHECKLIST_ITEMS_TL does not reference any database object

IEX.IEX_CHECKLIST_ITEMS_TL is referenced by following:

IEX
VIEW - IEX_CHECKLIST_ITEMS_TL#

[top of page]

Table: IEX_COSTS

Description: Maintains the actual and budgeted costs for a case or delinquency
Primary Key: IEX_COSTS_PK
  1. COST_ID
Comments

Maintains the actual and budgeted costs for a case or a delinquency
The cost will either be for a case or a delinquency . So both case_id and delinquency_ id are kept optional and the rule will be enfored in the API to make one of them mandatory.

Indexes
Index Type Tablespace Column
IEX_COSTS_U1 UNIQUE APPS_TS_TX_IDX COST_ID
IEX_COSTS_N1 NONUNIQUE APPS_TS_TX_IDX COST_TYPE_CODE
IEX_COSTS_N2 NONUNIQUE APPS_TS_TX_IDX COST_ITEM_TYPE_CODE
IEX_COSTS_N3 NONUNIQUE APPS_TS_TX_IDX DELINQUENCY_ID
IEX_COSTS_N4 NONUNIQUE APPS_TS_TX_IDX CASE_ID
Columns
Name Datatype Length Mandatory Comments
COST_ID NUMBER
Y Cost Identifier
DELINQUENCY_ID NUMBER

Foreign Key to iex_delinquencies_all table
CASE_ID NUMBER

Foreign Key to Iex_Cases_b table
COST_TYPE_CODE VARCHAR2 (240) Y Cost type - Actual or Budgeted
COST_ITEM_TYPE_CODE VARCHAR2 (240) Y Cost item type - dunning letter mailed, dunning letter faxed, repossession , etc
COST_ITEM_TYPE_DESC VARCHAR2 (240)
Cost item type description
COST_ITEM_AMOUNT NUMBER

Holds the actual or budgeted cost
COST_ITEM_CURRENCY_CODE VARCHAR2 (15)
Actual or budgeted currency code
COST_ITEM_QTY NUMBER

Holds the budgeted quantity
COST_ITEM_DATE DATE

This will be target_date or planned for budgeted costs and will be cost_incurred date for actual costs. We are using the same columns for both typesof costs.
EXCHANGE_TYPE VARCHAR2 (240)
Exchange type for currency conversion .the amounts are always shown in functional currency. so we have to store the exchange type
EXCHANGE_RATE NUMBER

Exchange rate for currency conversion .the amounts are always shown in functional currency. so we have to store the exchange rate
FUNCTIONAL_AMOUNT NUMBER

Stores the cost_item_amount in functional amount based on the functional currency
EXCHANGE_DATE DATE

Exchange date for currency conversion .the amounts are always shown in functional currency. so we have to store the exchange date. this is the date on which the exchange was done
ACTIVE_FLAG VARCHAR2 (240) Y Active Flag
COST_ITEM_APPROVED VARCHAR2 (1) Y indicates if the cost item was approved or not
OBJECT_VERSION_NUMBER NUMBER (9) Y Standard HTML front end column
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

IEX.IEX_COSTS does not reference any database object

IEX.IEX_COSTS is referenced by following:

IEX
VIEW - IEX_COSTS#

[top of page]

Table: IEX_CUST_STATUS_RULES

Description: Stores rules on how to display Customer Status.
Comments

Stores rules on how to display Customer Status on the collections header. This is striped by universes created on iex_filters.

Indexes
Index Type Tablespace Column
IEX_CUST_STATUS_RULES_U1 UNIQUE APPS_TS_SEED STATUS_RULE_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
STATUS_RULE_ID NUMBER
Y Table primary key. Sequence.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
STATUS_RULE_NAME VARCHAR2 (40)
Na for the status rule.
START_DATE DATE

Valid dates.
STATUS_RULE_DESCRIPTION VARCHAR2 (80)
Description for the status rule.
END_DATE DATE

Valid dates.
JTF_OBJECT_CODE VARCHAR2 (25)
Object code from JTF_OBJECTS
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_CUST_STATUS_RULES does not reference any database object

IEX.IEX_CUST_STATUS_RULES is referenced by following:

IEX
VIEW - IEX_CUST_STATUS_RULES#

[top of page]

Table: IEX_CU_STS_RL_LINES

Description: Stores details on Customer Status Rules.
Comments

Stores details on Customer Status Rules.

Indexes
Index Type Tablespace Column
IEX_CU_STS_RL_LINES_U1 UNIQUE APPS_TS_SEED STATUS_RULE_LINE_ID
ZD_EDITION_NAME
IEX_CU_STS_RL_LINES_N1 NONUNIQUE APPS_TS_SEED STATUS_RULE_ID
DELINQUENCY_STATUS
Columns
Name Datatype Length Mandatory Comments
STATUS_RULE_LINE_ID NUMBER
Y Table primary key. Sequence.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

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

Foreign key to IEX_CUST_STATUS_RULES
DELINQUENCY_STATUS VARCHAR2 (30)
Delinquency status.
PRIORITY NUMBER

What is the priority of the status described on the DELINQUENCY_STATUS column.
ENABLED_FLAG VARCHAR2 (1)
Is this line enabled?
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_CU_STS_RL_LINES does not reference any database object

IEX.IEX_CU_STS_RL_LINES is referenced by following:

IEX
VIEW - IEX_CU_STS_RL_LINES#

[top of page]

Table: IEX_DELINQUENCIES_ALL

Description: Holds transaction data about customer delinquencies.
Primary Key: IEX_DELINQUENCIES_PK
  1. DELINQUENCY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEX_DEL_STATUSES.DEL_STATUS_ID IEX_DELINQUENCIES_ALL
IEX_DEL_PAY_XREF.DELINQUENCY_ID IEX_DELINQUENCIES_ALL
IEX_SCORE_HISTORIES.DEL_DELINQUENCY_ID IEX_DELINQUENCIES_ALL
Comments

Holds transaction data about customer delinquencies.

Indexes
Index Type Tablespace Column
IEX_DELINQUENCIES_ALL_U1 UNIQUE APPS_TS_TX_IDX DELINQUENCY_ID
IEX_DELINQUENCIES_ALL_U2 UNIQUE APPS_TS_TX_IDX PAYMENT_SCHEDULE_ID
IEX_DELINQUENCIES_ALL_U3 UNIQUE APPS_TS_TX_IDX CASE_ID
IEX_DELINQUENCIES_ALL_N1 NONUNIQUE APPS_TS_TX_IDX CUST_ACCOUNT_ID
STATUS
IEX_DELINQUENCIES_ALL_N2 NONUNIQUE APPS_TS_TX_IDX PARTY_CUST_ID
STATUS
IEX_DELINQUENCIES_ALL_N3 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_SITE_USE_ID
STATUS
IEX_DELINQUENCIES_ALL_N4 NONUNIQUE APPS_TS_TX_IDX STATUS
IEX_DELINQUENCIES_ALL_N5 NONUNIQUE APPS_TS_TX_IDX CUST_ACCOUNT_ID
TRANSACTION_ID
IEX_DELINQUENCIES_ALL_N6 NONUNIQUE APPS_TS_TX_IDX PARTY_CUST_ID
CREATION_DATE
IEX_DELINQUENCIES_ALL_N7 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
IEX_DELINQUENCIES_ALL_N8 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATE_DATE
ORG_ID
Columns
Name Datatype Length Mandatory Comments
DELINQUENCY_ID NUMBER
Y Primary key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

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

Customer ID of the debtor. FKey to HZ_PARTIES
PARTY_CLIENT_ID NUMBER

PArty ID of the customer that owns the debt. FKey to HZ_PARTIES
CUST_ACCOUNT_ID NUMBER

Account ID of the debtor. FKey to hz_party_accounts
TRANSACTION_ID NUMBER

FKey to AR_CUSTOMER_TRX_ALL
PAYMENT_SCHEDULE_ID NUMBER

FKey to ar_payment_schedules_all
AGING_BUCKET_LINE_ID NUMBER

FKey to ar_aging_bucket_lines
CASE_ID NUMBER

Case which this delinquency is part off
RESOURCE_ID NUMBER

Agent that works on this delinquency
DUNN_YN VARCHAR2 (10)
Should we send dunning?
AUTOASSIGN_YN VARCHAR2 (10)
Should we autoassign this delinquency?
STATUS VARCHAR2 (30)
What is the delinquency status
CAMPAIGN_SCHED_ID NUMBER

What marketing campaign are we working with
ORG_ID NUMBER

Organization identifier
UNPAID_REASON_CODE VARCHAR2 (240)
Lookup code for unpaid reason. User selectable.
STRATEGY_ID NUMBER

CREDIT_HOLD_REQUEST_FLAG VARCHAR2 (1)
Have we requested credit hold for this delinquency?
CREDIT_HOLD_APPROVED_FLAG VARCHAR2 (1)
Was the credit hold approved?
SERVICE_HOLD_REQUEST_FLAG VARCHAR2 (1)
Have we requested service hold for this delinquency?
SERVICE_HOLD_APPROVED_FLAG VARCHAR2 (1)
Was the service hold approved?
SCORE_VALUE NUMBER

Last score value for this delinquency.
SCORE_ID NUMBER

Score engine ID used to generate the value in SCORE_VALUE
SOURCE_PROGRAM_NAME VARCHAR2 (100)
SOURCE_PROGRAM_NAME
PREDICTED_RECOVERY_AMOUNT NUMBER

Predicted Recovery amount ( OKL specific) . This is the expected amount to be recovered for the case.
PREDICTED_CHANCE NUMBER

Predicted Chance ( OKL specific) . This is expected recovery % for the debt
UWQ_STATUS VARCHAR2 (30)
Status of this delinquency on UWQ. Active/Pending/Complete
UWQ_ACTIVE_DATE DATE

Date this delinquency will change into the Active bucket on UWQ.
UWQ_COMPLETE_DATE DATE

Date this delinquency moved into the COMPLETE bucket on UWQ.
CUSTOMER_SITE_USE_ID NUMBER

FK to HZ_CUST_SITE_USES_ALL
STAGED_DUNNING_LEVEL NUMBER

Dunning level of the item as printed on the dunning correspondence
DUNNING_LEVEL_OVERRIDE_DATE DATE

Dunning level override date from Transaction Tab in Collections

[top of page]

IEX.IEX_DELINQUENCIES_ALL does not reference any database object

IEX.IEX_DELINQUENCIES_ALL is referenced by following:

IEX
VIEW - IEX_DELINQUENCIES_ALL#

[top of page]

Table: IEX_DEL_ASSETS

Description: Cross reference for all assets assigned to a delinquency.
Primary Key: IEX_DEL_ASSETS_PK
  1. DEL_ASSET_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_DEL_ASSETS_U1 UNIQUE APPS_TS_TX_IDX DEL_ASSET_ID
Columns
Name Datatype Length Mandatory Comments
DEL_ASSET_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

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

Foreign key to the asset.
OBJECT_CODE VARCHAR2 (240) Y JTF_OBJECT code for the object assigne to the party.
OBJECT_ID NUMBER
Y JTF_OBJECT ID of the object assigned to the party.
DISPOSITION_CODE VARCHAR2 (30)
Code of the lookup with the description.
DISP_REASON_CODE VARCHAR2 (30)
Code of the lookup with the description.
ACTIVE_YN VARCHAR2 (1)
If the record has been deleted.
DELINQUENCY_ID NUMBER

Foreign key to IEX_DELINQUENCIES_ALL

[top of page]

IEX.IEX_DEL_ASSETS does not reference any database object

IEX.IEX_DEL_ASSETS is referenced by following:

IEX
VIEW - IEX_DEL_ASSETS#

[top of page]

Table: IEX_DEL_BUFFERS

Description:
Primary Key: DEL_BUFFER_ID_PK1
  1. DEL_BUFFER_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_DEL_BUFFERS_U1 UNIQUE APPS_TS_TX_IDX DEL_BUFFER_ID
IEX_DEL_BUFFERS_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
DEL_BUFFER_ID NUMBER
Y Primary Key
PARTY_CUST_ID NUMBER

foreign key to hz_parties.party_id
CUST_ACCOUNT_ID NUMBER

fk to hz_cust_accounts.customer_trx_id
PAYMENT_SCHEDULE_ID NUMBER

foreign key to ar_payment_schedules.payment_schedule_id
AGING_BUCKET_LINE_ID NUMBER

foreign_key to ar_aging_bucket_lines.bucket_line_id
CASE_ID NUMBER

foreign key to iex_cases_b_all
DELINQUENCY_STATUS VARCHAR2 (25)
delinquency_status from iex_lookups_V
OBJECT_VERSION_NUMBER NUMBER (9) Y Standard HTML front end column
ORG_ID NUMBER

Organization identifier
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
SCORE_OBJECT_ID NUMBER

SCORE_OBJECT_CODE VARCHAR2 (30)
SCORE_ID NUMBER

SCORE_VALUE NUMBER

[top of page]

IEX.IEX_DEL_BUFFERS does not reference any database object

IEX.IEX_DEL_BUFFERS is referenced by following:

IEX
VIEW - IEX_DEL_BUFFERS#

[top of page]

Table: IEX_DEL_PAY_XREF

Description: This table stores what delinquencies were paid by an A/R payment.
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEX_DEL_PAY_XREF.DELINQUENCY_ID IEX_DELINQUENCIES_ALL
IEX_DEL_PAY_XREF.PAYMENT_ID %
Comments

This table stores what delinquencies were paid by an A/R payment.

Indexes
Index Type Tablespace Column
IEX_DEL_PAY_XREF_U1 UNIQUE APPS_TS_TX_IDX DEL_PAY_ID
IEX_DEL_PAY_XREF_N1 NONUNIQUE APPS_TS_TX_IDX DELINQUENCY_ID
IEX_DEL_PAY_XREF_N2 NONUNIQUE APPS_TS_TX_IDX PAYMENT_ID
Columns
Name Datatype Length Mandatory Comments
DEL_PAY_ID NUMBER (15)
Primary key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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).
DELINQUENCY_ID NUMBER

FKey to iex_delinquencies_all
PAYMENT_ID NUMBER

FKey to iex_payments

[top of page]

IEX.IEX_DEL_PAY_XREF does not reference any database object

IEX.IEX_DEL_PAY_XREF is referenced by following:

IEX
VIEW - IEX_DEL_PAY_XREF#

[top of page]

Table: IEX_DEL_STATUSES

Description: delinquency score/ status configuration
Primary Key: IDE_PK
  1. DEL_STATUS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEX_DEL_STATUSES.DEL_STATUS_ID IEX_DELINQUENCIES_ALL
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_DEL_STATUSES_U1 UNIQUE APPS_TS_SEED DEL_STATUS_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
DEL_STATUS_ID NUMBER
Y Primary Key
OBJECT_VERSION_NUMBER NUMBER (9) Y Standard HTML front end column
SCORE_VALUE_LOW NUMBER
Y Score value range Low
SCORE_VALUE_HIGH NUMBER
Y Score value range High
DEL_STATUS VARCHAR2 (25) Y Status to give score within high/ low range
SCORE_ID NUMBER
Y foreign key to IEX_SCORES.Score_ID
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ORG_ID NUMBER (15)
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_DEL_STATUSES does not reference any database object

IEX.IEX_DEL_STATUSES is referenced by following:

IEX
VIEW - IEX_DEL_STATUSES#

[top of page]

Table: IEX_DEL_THIRD_PARTIES

Description: Cross reference for all third parties assigned to a delinquency.
Primary Key: IEX_DEL_THIRD_PARTIES_PK
  1. DEL_THIRD_PARTY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEX_DEL_THIRD_PARTIES.DELINQUENCY_ID %
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_DEL_THIRD_PARTIES_U1 UNIQUE APPS_TS_TX_IDX DEL_THIRD_PARTY_ID
Columns
Name Datatype Length Mandatory Comments
DEL_THIRD_PARTY_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
THIRD_PARTY_ID NUMBER
Y ID of the relationship between customer and 3rd party.
OBJECT_CODE VARCHAR2 (30) Y JTF_OBJECT code for the object assigne to the party.
OBJECT_ID NUMBER
Y JTF_OBJECT ID of the object assigned to the party.
DELINQUENCY_ID NUMBER

Foreign key to IEX_DELINQUENCIES_ALL
THIRD_PRT_REL_TYPE_ID NUMBER

What is the relationship between the third party and the user.
PARTY_ID NUMBER

CUST_ACCOUNT_ID NUMBER

SITE_USE_ID NUMBER

[top of page]

IEX.IEX_DEL_THIRD_PARTIES does not reference any database object

IEX.IEX_DEL_THIRD_PARTIES is referenced by following:

IEX
VIEW - IEX_DEL_THIRD_PARTIES#

[top of page]

Table: IEX_DISPUTES

Description: Holds data about all disputes processed through collections UI.
Primary Key: IEX_DISPUTES_PK
  1. DISPUTE_ID
Comments

Holds data about all disputes processed through collections UI.

Indexes
Index Type Tablespace Column
IEX_DISPUTES_U1 UNIQUE APPS_TS_TX_IDX DISPUTE_ID
Columns
Name Datatype Length Mandatory Comments
DISPUTE_ID NUMBER
Y Primary key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
CM_REQUEST_ID NUMBER
Y FKey to AR_CM_REQUESTS
DISPUTE_SECTION VARCHAR2 (25)
Section of the invoice disputed
CAMPAIGN_SCHED_ID NUMBER

What marketing campaign are we working on
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
DELINQUENCY_ID NUMBER

FKey to iex_delinquencies_all

[top of page]

IEX.IEX_DISPUTES does not reference any database object

IEX.IEX_DISPUTES is referenced by following:

IEX
VIEW - IEX_DISPUTES#

[top of page]

Table: IEX_DLN_UWQ_SUMMARY

Description: Summary table for universal work queue collections nodes
Comments

Summary table for universal work queue collections nodes

Indexes
Index Type Tablespace Column
IEX_DLN_UWQ_SUMMARY_N1 NONUNIQUE APPS_TS_TX_IDX SITE_USE_ID
IEX_DLN_UWQ_SUMMARY_N2 NONUNIQUE APPS_TS_TX_IDX COLLECTOR_ID
IEX_DLN_UWQ_SUMMARY_N3 NONUNIQUE APPS_TS_TX_IDX COLLECTOR_RESOURCE_ID
IEX_DLN_UWQ_SUMMARY_N4 NONUNIQUE APPS_TS_TX_IDX CUST_ACCOUNT_ID
IEX_DLN_UWQ_SUMMARY_N5 NONUNIQUE APPS_TS_TX_IDX WKITEM_RESOURCE_ID
IEX_DLN_UWQ_SUMMARY_N6 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATE_DATE
IEX_DLN_UWQ_SUMMARY_N7 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
IEX_DLN_UWQ_SUMMARY_N8 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
DLN_UWQ_SUMMARY_ID NUMBER

Delinqueny UWQ Summary ID
ORG_ID NUMBER

ORG ID
COLLECTOR_ID NUMBER

Collector ID
COLLECTOR_RESOURCE_ID NUMBER

Collector Resource ID
COLLECTOR_RES_TYPE VARCHAR2 (30)
Colletors Resource Type
IEU_OBJECT_FUNCTION VARCHAR2 (30)
IEU Object Function
IEU_OBJECT_PARAMETERS VARCHAR2 (2020)
IEU Object Parameters
IEU_MEDIA_TYPE_UUID VARCHAR2 (10)
Media Type UUID
IEU_PARAM_PK_COL VARCHAR2 (40)
Parameter Primary Key Column
IEU_PARAM_PK_VALUE VARCHAR2 (40)
IEU Parameter primary key value
RESOURCE_ID NUMBER

Resource ID
RESOURCE_TYPE VARCHAR2 (11)
Resource Type
PARTY_ID NUMBER

Party ID
PARTY_NAME VARCHAR2 (360)
Partyy Name
CUST_ACCOUNT_ID NUMBER

Account ID
ACCOUNT_NAME VARCHAR2 (240)
Account Name
ACCOUNT_NUMBER VARCHAR2 (30)
Account Number
SITE_USE_ID NUMBER

Site Use ID
LOCATION VARCHAR2 (60)
Location
CURRENCY VARCHAR2 (20)
Currency
OP_INVOICES_COUNT NUMBER

Invoice Count
OP_DEBIT_MEMOS_COUNT NUMBER

Debit Memo Count
OP_DEPOSITS_COUNT NUMBER

Deposit Count
OP_BILLS_RECEIVABLES_COUNT NUMBER

Bills Receivable Count
OP_CHARGEBACK_COUNT NUMBER

Chargeback Count
OP_CREDIT_MEMOS_COUNT NUMBER

Credit Memos Count
UNRESOLVED_CASH_COUNT NUMBER

Unsolved Cash Count
DISPUTED_INV_COUNT NUMBER

Disputed Invoice Count
BEST_CURRENT_RECEIVABLES NUMBER

Best Current Receivables
OP_INVOICES_VALUE NUMBER

Invoice Value
OP_DEBIT_MEMOS_VALUE NUMBER

Debit Memo Value
OP_DEPOSITS_VALUE NUMBER

Deposit Value
OP_BILLS_RECEIVABLES_VALUE NUMBER

Bills Receivable Value
OP_CHARGEBACK_VALUE NUMBER

Chargeback Value
OP_CREDIT_MEMOS_VALUE NUMBER

Credit Memo Value
UNRESOLVED_CASH_VALUE NUMBER

Unsolved Cash Value
RECEIPTS_AT_RISK_VALUE NUMBER

Receipt Risk Value
INV_AMT_IN_DISPUTE NUMBER

Dispute Invoice Amount
PENDING_ADJ_VALUE NUMBER

Pending Adjustment Value
PAST_DUE_INV_VALUE NUMBER

Past Due Invoice Value
PAST_DUE_INV_INST_COUNT NUMBER

Past Due Invoice Installment Count
LAST_PAYMENT_DATE DATE

Last Payment Date
LAST_PAYMENT_AMOUNT NUMBER

Last Payment Amount
LAST_PAYMENT_AMOUNT_CURR VARCHAR2 (20)
Last Payment Amount Curr
LAST_PAYMENT_NUMBER VARCHAR2 (30)
Last Payment Number
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATED_BY NUMBER

Last Updated By
CREATION_DATE DATE

Creation Date
CREATED_BY NUMBER

Created By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
NUMBER_OF_DELINQUENCIES NUMBER

Number of Delinquencies
ACTIVE_DELINQUENCIES NUMBER

Active Delinquencies
COMPLETE_DELINQUENCIES NUMBER

Complete Delinquencies
PENDING_DELINQUENCIES NUMBER

Pending Delinquencies
SCORE NUMBER

Score
ADDRESS1 VARCHAR2 (240)
Address1
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
COUNTY VARCHAR2 (60)
County
COUNTRY VARCHAR2 (80)
Country
PROVINCE VARCHAR2 (60)
Province
POSTAL_CODE VARCHAR2 (60)
Postal Code
PHONE_COUNTRY_CODE VARCHAR2 (10)
Phone Country Code
PHONE_AREA_CODE VARCHAR2 (10)
Phone Area Code
PHONE_NUMBER VARCHAR2 (40)
Phone Number
PHONE_EXTENSION VARCHAR2 (20)
Phone Extension
NUMBER_OF_BANKRUPTCIES NUMBER

Number of Bankrupcies
NUMBER_OF_PROMISES NUMBER

Number of Promise
BROKEN_PROMISE_AMOUNT NUMBER

Broken Promise Amount
PROMISE_AMOUNT NUMBER

Promise Amount
ACTIVE_PROMISES NUMBER

Active Promises
COMPLETE_PROMISES NUMBER

Complete Promises
PENDING_PROMISES NUMBER

Pending Promises
WORK_ITEM_ID NUMBER

Work Item Id
SCHEDULE_START DATE

Start Schedule
SCHEDULE_END DATE

End Schedule
WORK_TYPE VARCHAR2 (30)
Work Type
CATEGORY_TYPE VARCHAR2 (30)
Category Type
PRIORITY_TYPE VARCHAR2 (30)
Priority Type
WKITEM_RESOURCE_ID NUMBER

Work Item Resource ID
STRATEGY_ID NUMBER

Strategy ID
STRATEGY_TEMPLATE_ID NUMBER

Strategy Template ID
WORK_ITEM_TEMPLATE_ID NUMBER

Work Item Template ID
STATUS_CODE VARCHAR2 (30)
Status Code
START_TIME DATE

Start Time
END_TIME DATE

End time
WORK_ITEM_ORDER NUMBER

Work items displaying order
WKITEM_ESCALATED_YN VARCHAR2 (1)
Work items Escalated Yes/No
STR_STATUS VARCHAR2 (240)
STR Status
AGING_AMOUNT1 NUMBER

Aging Amount 1
AGING_AMOUNT2 NUMBER

Aging Amount 2
AGING_AMOUNT3 NUMBER

Aging Amount 3
AGING_AMOUNT4 NUMBER

Aging Amount 4
AGING_AMOUNT5 NUMBER

Aging Amount 5
AGING_AMOUNT6 NUMBER

Aging Amount 6
AGING_AMOUNT7 NUMBER

Aging Amount 7
AGING_COUNT1 NUMBER

Aging Count 1
AGING_COUNT2 NUMBER

Aging Count 2
AGING_COUNT3 NUMBER

Aging Count 3
AGING_COUNT4 NUMBER

Aging Count 4
AGING_COUNT5 NUMBER

Aging Count 5
AGING_COUNT6 NUMBER

Aging Count 6
AGING_COUNT7 NUMBER

Aging Count 7
CASES_COUNT NUMBER

Case Count
DEL_CASES_COUNT NUMBER

Delinquency Case Count
CONTRACTS_COUNT NUMBER

Contract Count
DEL_CONTRACTS_COUNT NUMBER

Delinquency Contract Count
COLLECTOR_RESOURCE_NAME VARCHAR2 (240)
Collector resource name
SCORE_ID NUMBER

Score ID
SCORE_NAME VARCHAR2 (240)
Score Name
BUSINESS_LEVEL VARCHAR2 (240)
Business Level
NET_BALANCE NUMBER

Net Balance
OBJECT_VERSION_NUMBER NUMBER

Standard HTML front end column.
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

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).

[top of page]

IEX.IEX_DLN_UWQ_SUMMARY does not reference any database object

IEX.IEX_DLN_UWQ_SUMMARY is referenced by following:

IEX
VIEW - IEX_DLN_UWQ_SUMMARY#

[top of page]

Table: IEX_DUNNINGS

Description: Holds data on all dunning transactions sent by the system.
Primary Key: IEX_DN_HISTORIES_S
  1. DUNNING_ID
Comments

Holds data on all dunning transactions sent by the system.

Indexes
Index Type Tablespace Column
IEX_DUNNINGS_U1 UNIQUE APPS_TS_TX_IDX DUNNING_ID
IEX_DUNNINGS_N1 NONUNIQUE APPS_TS_TX_IDX DELINQUENCY_ID
IEX_DUNNINGS_N2 NONUNIQUE APPS_TS_TX_IDX DUNNING_OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
DUNNING_ID NUMBER
Y Primary key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

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

Subscriber id, for CRM Online Services use
TEMPLATE_ID NUMBER

FKey to 1-1fulfillment template. What letter did we send.
DELINQUENCY_ID NUMBER

FKey to iex_delinquencies_all
STATUS VARCHAR2 (240)
Status of the dunnin Open or Closed
CALLBACK_YN VARCHAR2 (1)
Should we callback about this letter?
CALLBACK_DATE DATE

When will we callback.
CAMPAIGN_SCHED_ID NUMBER

What marketing campaign are we working on
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
OBJECT_TYPE VARCHAR2 (30)
What object on JTF_OBJECTS does this dunning reffers to.
OBJECT_ID NUMBER

ID of the object reffered on OBJECT_TYPE
DUNNING_METHOD VARCHAR2 (30)
What method did we use to send dunning.
AMOUNT_DUE_REMAINING NUMBER

Ammount due remaining on the delinquency.
CURRENCY_CODE VARCHAR2 (15)
Currency code for the amount remaining
DUNNING_OBJECT_ID NUMBER

What JFT_OBJECT are we sending dunning to.
DUNNING_LEVEL VARCHAR2 (30)
What dunning level are we using - Customer-Account-Bill_to_site-Delinquency
FFM_REQUEST_ID NUMBER

Fulfilment server Request ID
FINANCIAL_CHARGE NUMBER

Amount of the finance charge on this dunning.
LETTER_NAME VARCHAR2 (30)
Dunning letter name.
INTEREST_AMT NUMBER

Interest charged in the dunning
XML_REQUEST_ID NUMBER

ID of the request made to xml publisher
XML_TEMPLATE_ID NUMBER

ID of the XML publisher template used to create this dunning.
DUNNING_PLAN_ID NUMBER (10)
Foreign key to iex_dunning_plans_b
CONTACT_DESTINATION VARCHAR2 (240)
Contact who received the dunning.
CONTACT_PARTY_ID NUMBER

ID of the contact who received the dunning.
DELIVERY_STATUS VARCHAR2 (30)
Delivery Status
PARENT_DUNNING_ID NUMBER (15)
Parent Dunning ID
DUNNING_MODE VARCHAR2 (10)
Dunning mode (possible values Final/Preview)
CONFIRMATION_MODE VARCHAR2 (10)
Preview Action(possible values Confirmed/Rejected)
ORG_ID NUMBER

Organization identifier
AG_DN_XREF_ID NUMBER

Foreign key to AG_DN_XREF_ID table
CORRESPONDENCE_DATE DATE

Date of the correspondence
ADDT_XML_TEMPLATE_ID NUMBER

ID of the XML publisher template used to create this dunning.
ADDT_DELIVERY_STATUS VARCHAR2 (30)
Delivery Status for additional xml templalte
AS_OF_DATE DATE

As of date of dunning

[top of page]

IEX.IEX_DUNNINGS does not reference any database object

IEX.IEX_DUNNINGS is referenced by following:

IEX
VIEW - IEX_DUNNINGS#

[top of page]

Table: IEX_DUNNING_PLANS_B

Description: Collections dunning base table
Comments

Collections dunning base table

Columns
Name Datatype Length Mandatory Comments
DUNNING_PLAN_ID NUMBER (10) Y Primary key
START_DATE DATE

valid from this date
END_DATE DATE

Valid until this date
ENABLED_FLAG VARCHAR2 (1)
Signals enabled/disabled
AGING_BUCKET_ID NUMBER

ID of the aging bucket
SCORE_ID NUMBER

ID of the score
DUNNING_LEVEL VARCHAR2 (30)
Level at which we are sending dunning(Party/Account/BillTo/Delinquency)
OBJECT_VERSION_NUMBER NUMBER

Standard HTML front end column
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_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

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
GRACE_DAYS VARCHAR2 (1)
Indicates whether to use grace days when determining when dunning letters are sent
DUN_DISPUTED_ITEMS VARCHAR2 (1)
Indicates whether to include disputed invoices in this dunning letter set
INCLUDE_UNUSED_PAYMENTS_FLAG VARCHAR2 (1)
Indicates whether to include unapplied and on-account payments in all dunning letters in a dunning letter set
DUNNING_TYPE VARCHAR2 (30)
Possible values are DAYS_OVERDUE if dunning is based on days that items are past due, or STAGED_DUNNING if dunning is based on dunning levels.
INCLUDE_CURRENT VARCHAR2 (1)
Indicates whether invoices, debit memos, and chargebacks that are not yet delinquent are included in a dunning letter
DUNNING_LETTER_SET_ID NUMBER

AR Dunning Letter Set ID
MIG_DUNNING_LETTER_SET_ID NUMBER

Migrated Dunning Letter Set ID

[top of page]

IEX.IEX_DUNNING_PLANS_B does not reference any database object

IEX.IEX_DUNNING_PLANS_B is referenced by following:

IEX
VIEW - IEX_DUNNING_PLANS_B#

[top of page]

Table: IEX_DUNNING_PLANS_TL

Description: Collections dunning plan translated table
Comments

Collections dunning plan translated table

Columns
Name Datatype Length Mandatory Comments
DUNNING_PLAN_ID NUMBER (10) Y Primary Key
NAME VARCHAR2 (240)
Name assigned to the dunning plan
DESCRIPTION VARCHAR2 (240)
Description assigned to the dunning plan
LANGUAGE VARCHAR2 (240)
Language code
SOURCE_LANG VARCHAR2 (240)
The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard who column - date when this row was updated.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
GRACE_DAYS VARCHAR2 (1)
Indicates whether to use grace days when determining when dunning letters are sent
DUN_DISPUTED_ITEMS VARCHAR2 (1)
Indicates whether to include disputed invoices in this dunning letter set
INCLUDE_UNUSED_PAYMENTS_FLAG VARCHAR2 (1)
Indicates whether to include unapplied and on-account payments in all dunning letters in a dunning letter set
DUNNING_TYPE VARCHAR2 (30)
Possible values are DAYS_OVERDUE if dunning is based on days that items are past due, or STAGED_DUNNING if dunning is based on dunning levels.
INCLUDE_CURRENT VARCHAR2 (1)
Indicates whether invoices, debit memos, and chargebacks that are not yet delinquent are included in a dunning letter

[top of page]

IEX.IEX_DUNNING_PLANS_TL does not reference any database object

IEX.IEX_DUNNING_PLANS_TL is referenced by following:

IEX
VIEW - IEX_DUNNING_PLANS_TL#

[top of page]

Table: IEX_DUNNING_PROFILES

Description: OBSOLETED - Profile to save dunning info
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_DUNNING_PROFILES_U1 NONUNIQUE APPS_TS_TX_IDX DUNNING_PROFILE_ID
Columns
Name Datatype Length Mandatory Comments
DUNNING_PROFILE_ID NUMBER (25) Y Primary key
PARTY_ID NUMBER (25)
party id of customer
CUST_ACCOUNT_ID NUMBER (25)
customer account id
CUSTOMER_SITE_USE_ID NUMBER (25)
customer site use id
DELINQUENCY_ID NUMBER (25)
delinquency id
DEUNNING_LEVEL VARCHAR2 (20)
delinquency level
SEND_DUNNING VARCHAR2 (1)
send dunning
CREATION_DATE DATE
Y creation date
CREATED_BY NUMBER
Y created by
LAST_UPDATE_DATE DATE
Y last update date
LAST_UPDATED_BY NUMBER
Y last updated by
LAST_UPDATE_LOGIN NUMBER
Y last update login
OBJECT_VERSION_NUMBER NUMBER
Y object version number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

IEX.IEX_DUNNING_PROFILES does not reference any database object

IEX.IEX_DUNNING_PROFILES is referenced by following:

IEX
VIEW - IEX_DUNNING_PROFILES#

[top of page]

Table: IEX_DUNNING_TRANSACTIONS

Description: Collections dunning transaction table
Primary Key: IEX_DUNNING_TRANSACTIONS_PK
  1. DUNNING_TRX_ID
Comments

Collections dunning transaction table

Indexes
Index Type Tablespace Column
IEX_DUNNING_TRANSACTIONS_U1 UNIQUE APPS_TS_TX_IDX DUNNING_TRX_ID
IEX_DUNNING_TRANSACTIONS_I1 NONUNIQUE APPS_TS_TX_IDX DUNNING_ID
Columns
Name Datatype Length Mandatory Comments
DUNNING_TRX_ID NUMBER
Y Primary key
DUNNING_ID NUMBER

Foreign key to IEX_DUNNINGS table
CUST_TRX_ID NUMBER

Identifier of the customer trx id associated with this dunned record
PAYMENT_SCHEDULE_ID NUMBER

Identifier of the payment schedule associated with this dunned record
AG_DN_XREF_ID NUMBER

Foreign key to AG_DN_XREF_ID table
STAGE_NUMBER NUMBER

Dunning level of the item as printed on the dunning correspondence
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER

Standard column to support Fusion upgradation

[top of page]

IEX.IEX_DUNNING_TRANSACTIONS does not reference any database object

IEX.IEX_DUNNING_TRANSACTIONS is referenced by following:

IEX
VIEW - IEX_DUNNING_TRANSACTIONS#

[top of page]

Table: IEX_EXCLUSION_HIST_B

Description: Stores contracts that are excluded from delinquency reports
Primary Key: IEX_EXCLUSION_HIST_B_PK
  1. EXCLUSION_HISTORY_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_EXCLUSION_HIST_B_N01 NONUNIQUE APPS_TS_TX_IDX OBJECT1_ID1
OBJECT1_ID2
JTOT_OBJECT1_CODE
Columns
Name Datatype Length Mandatory Comments
EXCLUSION_HISTORY_ID NUMBER
Y
OBJECT1_ID1 VARCHAR2 (40) Y
OBJECT1_ID2 VARCHAR2 (200)
JTOT_OBJECT1_CODE VARCHAR2 (30) Y
EXCLUSION_REASON VARCHAR2 (30) Y
EFFECTIVE_START_DATE DATE
Y
EFFECTIVE_END_DATE DATE

CANCEL_REASON VARCHAR2 (30)
CANCELLED_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9) Y
ORG_ID NUMBER (15)
Organization identifier
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).

[top of page]

IEX.IEX_EXCLUSION_HIST_B does not reference any database object

IEX.IEX_EXCLUSION_HIST_B is referenced by following:

IEX
VIEW - IEX_EXCLUSION_HIST_B#

[top of page]

Table: IEX_EXCLUSION_HIST_TL

Description: Translation table for IEX_EXCLUSION_HIST_B
Primary Key: IEX_EXCLUSION_HIST_TL_PK
  1. EXCLUSION_HISTORY_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_EXCLUSION_HIST_TL_N01 NONUNIQUE APPS_TS_TX_IDX EXCLUSION_HISTORY_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
EXCLUSION_HISTORY_ID NUMBER
Y
EXCLUSION_COMMENT VARCHAR2 (2000)
CANCELLATION_COMMENT VARCHAR2 (2000)
LANGUAGE VARCHAR2 (240) Y
SOURCE_LANG VARCHAR2 (240) Y
SFWT_FLAG VARCHAR2 (240) Y
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).

[top of page]

IEX.IEX_EXCLUSION_HIST_TL does not reference any database object

IEX.IEX_EXCLUSION_HIST_TL is referenced by following:

IEX
VIEW - IEX_EXCLUSION_HIST_TL#

[top of page]

Table: IEX_EXT_AGNCY_B

Description: Stores External Agency Details
Primary Key: IEX_EXT_AGNCY_PK
  1. EXTERNAL_AGENCY_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_EXT_AGNCY_U01 UNIQUE APPS_TS_TX_IDX VENDOR_ID
VENDOR_SITE_ID
IEX_EXT_AGNCY_U02 UNIQUE APPS_TS_TX_IDX EXTERNAL_AGENCY_NAME
Columns
Name Datatype Length Mandatory Comments
EXTERNAL_AGENCY_ID NUMBER
Y
EXTERNAL_AGENCY_NAME VARCHAR2 (80) Y
VENDOR_ID NUMBER
Y
VENDOR_SITE_ID NUMBER
Y
RANK NUMBER (5) Y
EFFECTIVE_START_DATE DATE
Y
EFFECTIVE_END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9) Y
ORG_ID NUMBER (15)
Organization identifier
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).

[top of page]

IEX.IEX_EXT_AGNCY_B does not reference any database object

IEX.IEX_EXT_AGNCY_B is referenced by following:

IEX
VIEW - IEX_EXT_AGNCY_B#

[top of page]

Table: IEX_EXT_AGNCY_TL

Description: Translation table for IEX_EXT_AGNCY_B
Primary Key: IEX_EXT_AGNCY_TL_PK
  1. EXTERNAL_AGENCY_ID
  2. LANGUAGE
Comments
***** Warning: Oracle Internal Use Only *****

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

Columns
Name Datatype Length Mandatory Comments
EXTERNAL_AGENCY_ID NUMBER
Y
DESCRIPTION VARCHAR2 (2000)
LANGUAGE VARCHAR2 (240) Y
SOURCE_LANG VARCHAR2 (240) Y
SFWT_FLAG VARCHAR2 (240) Y
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).

[top of page]

IEX.IEX_EXT_AGNCY_TL does not reference any database object

IEX.IEX_EXT_AGNCY_TL is referenced by following:

IEX
VIEW - IEX_EXT_AGNCY_TL#

[top of page]

Table: IEX_LITIGATIONS

Description: Details for Litigation
Primary Key: ILT_PK
  1. LITIGATION_ID
Comments

Details for Litigation

Indexes
Index Type Tablespace Column
IEX_LITIGATIONS_U1 UNIQUE APPS_TS_TX_IDX LITIGATION_ID
IEX_LITIGATIONS_N1 NONUNIQUE APPS_TS_TX_IDX DELINQUENCY_ID
IEX_LITIGATIONS_N2 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
Columns
Name Datatype Length Mandatory Comments
LITIGATION_ID NUMBER
Y Litigation Identifier
DELINQUENCY_ID NUMBER

Delinquency ID for a Litigation
PARTY_ID NUMBER

Party ID for a Litigation
UNPAID_REASON_CODE VARCHAR2 (30)
Unpaid Reason Code for a Litigation. Foreign key to fnd_lookups.
JUDGEMENT_DATE DATE

Judgement Date.
DISPOSITION_CODE VARCHAR2 (30)
Disposition Code for a Litigation. Foreign key to fnd_lookups.
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
CREDIT_HOLD_REQUEST_FLAG VARCHAR2 (240)
Have we requested credit hold?
CREDIT_HOLD_APPROVED_FLAG VARCHAR2 (240)
Was the hold approved?
SERVICE_HOLD_REQUEST_FLAG VARCHAR2 (240)
Have we requested service hold?
SERVICE_HOLD_APPROVED_FLAG VARCHAR2 (240)
Was the hold approved?
SUGGESTION_APPROVED_FLAG VARCHAR2 (240)
Flag (Y/N) for the Approved status of Suggestion
DIRECT_SUIT_YN VARCHAR2 (1)
Is this a direct suit litigation?
REASON_CODE VARCHAR2 (30)
Waht is the reason for the suit? Lookup.
COURT_DATE DATE

Court date for the suit.
COURT_CASE_DISPOSITION_CODE VARCHAR2 (30)
Disposition for the litigation. Lookup.
JUDGEMENT_CODE VARCHAR2 (30)
Judgement from court. Lookup.
CUST_ACCOUNT_ID NUMBER

Account ID
CUSTOMER_SITE_USE_ID NUMBER

Customer Site Use ID
ORG_ID NUMBER

Org ID
CONTRACT_ID NUMBER

Contract ID
CONTRACT_NUMBER VARCHAR2 (250)
Contract Number

[top of page]

IEX.IEX_LITIGATIONS does not reference any database object

IEX.IEX_LITIGATIONS is referenced by following:

IEX
VIEW - IEX_LITIGATIONS#

[top of page]

Table: IEX_METRIC_RATINGS

Description: Rating range details for metric component types
Primary Key: IEX_METRIC_RATINGS_PK
  1. METRIC_RATING_ID
Comments

Rating range details for metric component types

Columns
Name Datatype Length Mandatory Comments
METRIC_RATING_ID NUMBER
Y Metric Rating Identifier
SCORE_COMP_TYPE_ID NUMBER

Score component type ID
LOW_FROM NUMBER

Start value of Low rating
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LOW_TO NUMBER

End value of Low rating
MEDIUM_FROM NUMBER

Start value of Medium rating
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
MEDIUM_TO NUMBER

End value of Medium rating
HIGH_FROM NUMBER

Start value of High rating
HIGH_TO NUMBER

End value of High rating
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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

[top of page]

IEX.IEX_METRIC_RATINGS does not reference any database object

IEX.IEX_METRIC_RATINGS is referenced by following:

IEX
VIEW - IEX_METRIC_RATINGS#

[top of page]

Table: IEX_METRIC_SUMMARIES_ALL

Description: Store metric summary batch information
Comments

Store metric summary batch information

Indexes
Index Type Tablespace Column
IEX_METRIC_SUMMARIES_ALL_N1 NONUNIQUE APPS_TS_TX_IDX OBJECT_ID
OBJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER

PK of objects(Party, Account, Billto, Deleinquency)
OBJECT_TYPE VARCHAR2 (240)
Type of objects(Party, Account, Billto, Deleinquency)
ORG_ID NUMBER

Organization identifier
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SCORE_COMP_TYPE_ID NUMBER

PK of Score Component types
METRIC_VALUE VARCHAR2 (1000)
metric result value created by metric batch
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
METRIC_RATING VARCHAR2 (10)
metric rating of metric batch processing

[top of page]

IEX.IEX_METRIC_SUMMARIES_ALL does not reference any database object

IEX.IEX_METRIC_SUMMARIES_ALL is referenced by following:

IEX
VIEW - IEX_METRIC_SUMMARIES_ALL#

[top of page]

Table: IEX_OBJECT_FILTERS

Description:
Primary Key: IEX_OBJ_FILT_PK
  1. OBJECT_FILTER_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_OBJECT_FILTERS UNIQUE APPS_TS_SEED OBJECT_FILTER_ID
ZD_EDITION_NAME
IEX_OBJECT_FILTERS_N1 NONUNIQUE APPS_TS_SEED OBJECT_FILTER_TYPE
Columns
Name Datatype Length Mandatory Comments
OBJECT_FILTER_ID NUMBER
Y
OBJECT_FILTER_TYPE VARCHAR2 (240) Y
OBJECT_FILTER_NAME VARCHAR2 (240) Y
OBJECT_ID NUMBER (25) Y
SELECT_COLUMN VARCHAR2 (30) Y Select column from entity_name
ENTITY_NAME VARCHAR2 (30) Y Table or view that defines universe
ACTIVE_FLAG VARCHAR2 (10) Y Active Universe YN field
OBJECT_VERSION_NUMBER NUMBER (9) Y Standard HTML front end column
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).
REQUEST_ID NUMBER (15)
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 (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_OBJECT_FILTERS does not reference any database object

IEX.IEX_OBJECT_FILTERS is referenced by following:

IEX
VIEW - IEX_OBJECT_FILTERS#

[top of page]

Table: IEX_OPEN_INT_HST

Description:
Primary Key: IEX_IOH_PK
  1. ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_IOH_N01 NONUNIQUE APPS_TS_ARCHIVE JTOT_OBJECT1_CODE
OBJECT1_ID1
OBJECT1_ID2
ACTION
STATUS
IEX_IOH_N02 NONUNIQUE APPS_TS_ARCHIVE JTOT_OBJECT1_CODE
OBJECT1_ID1
STATUS
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y
OBJECT1_ID1 VARCHAR2 (40) Y
OBJECT1_ID2 VARCHAR2 (200)
JTOT_OBJECT1_CODE VARCHAR2 (30) Y
ACTION VARCHAR2 (240) Y
STATUS VARCHAR2 (240) Y
COMMENTS VARCHAR2 (2000)
REQUEST_DATE DATE
Y
PROCESS_DATE DATE

EXT_AGNCY_ID NUMBER

REVIEW_DATE DATE

RECALL_DATE DATE

AUTOMATIC_RECALL_FLAG VARCHAR2 (1)
REVIEW_BEFORE_RECALL_FLAG VARCHAR2 (1)
OBJECT_VERSION_NUMBER NUMBER (9) Y
ORG_ID NUMBER (15)
Organization identifier
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).

[top of page]

IEX.IEX_OPEN_INT_HST does not reference any database object

IEX.IEX_OPEN_INT_HST is referenced by following:

IEX
VIEW - IEX_OPEN_INT_HST#

[top of page]

Table: IEX_PAYMENTS

Description: Holds data on all payments received by the system.
Primary Key: IEX_IEX_PAYMENTS_PK
  1. PAYMENT_ID
Comments

Holds data on all payments received by the system.

Indexes
Index Type Tablespace Column
IEX_PAYMENTS_U1 UNIQUE APPS_TS_TX_IDX PAYMENT_ID
IEX_PAYMENTS_N1 NONUNIQUE APPS_TS_TX_IDX CAMPAIGN_SCHED_ID
IEX_PAYMENTS_N2 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
IEX_PAYMENTS_N3 NONUNIQUE APPS_TS_TX_IDX PAYMENT_METHOD
IEX_PAYMENTS_N4 NONUNIQUE APPS_TS_TX_IDX IPAYMENT_STATUS
Columns
Name Datatype Length Mandatory Comments
PAYMENT_ID NUMBER
Y Primary key.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
PROGRAM_ID NUMBER

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
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PAYMENT_METHOD_ID NUMBER

ID(FKey) to the payment method
PAYMENT_METHOD VARCHAR2 (30) Y Payment method used on this payment
IPAYMENT_TRANS_ID VARCHAR2 (100)
Transaction ID from iPayment
IPAYMENT_STATUS NUMBER

Status from iPayment
PAY_SVR_CONFIRMATION VARCHAR2 (100)
Confirmation number from iPayment
CAMPAIGN_SCHED_ID NUMBER

What campaign did this payment get created under
RESOURCE_ID NUMBER

What agent received this payment
PAYEE_ID VARCHAR2 (100)
Payee ID of the owner of this product. ID given by cybercash
TANGIBLE_ID VARCHAR2 (100)
FKey to IBY_tangibles
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

IEX.IEX_PAYMENTS does not reference any database object

IEX.IEX_PAYMENTS is referenced by following:

IEX
VIEW - IEX_PAYMENTS#

[top of page]

Table: IEX_PAY_OKL_XREF

Description: Table stores all OKL consolidated invoices or contracts paid in IEX
Primary Key: IEX_PAY_OKL_XREF_PK
  1. PAY_OKL_XREF_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_PAY_OKL_XREF_U1 UNIQUE APPS_TS_TX_IDX PAY_OKL_XREF_ID
Columns
Name Datatype Length Mandatory Comments
PAY_OKL_XREF_ID NUMBER
Y Primary Key
OKL_PAYMENT_ID NUMBER

Foreign Key to OKL payments
CNSLD_INVOICE_ID NUMBER

Consolidated Invoice ID on OKL
CONTRACT_ID NUMBER

Contract ID on OKL
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
PAYMENT_ID NUMBER

Payment ID on IEX schema
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

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

[top of page]

IEX.IEX_PAY_OKL_XREF does not reference any database object

IEX.IEX_PAY_OKL_XREF is referenced by following:

IEX
VIEW - IEX_PAY_OKL_XREF#

[top of page]

Table: IEX_PAY_RECEIPT_XREF

Description: Stores information on what receipts were generated by what payments.
Comments

Stores information on what receipts were generated by what payments.

Indexes
Index Type Tablespace Column
IEX_PAY_RECEIPT_XREF_U1 UNIQUE APPS_TS_TX_IDX PAY_RECEIPT_XREF_ID
IEX_PAY_RECEIPT_XREF_N1 NONUNIQUE APPS_TS_TX_IDX CASH_RECEIPT_ID
IEX_PAY_RECEIPT_XREF_N2 NONUNIQUE APPS_TS_TX_IDX PAYMENT_ID
Columns
Name Datatype Length Mandatory Comments
PAY_RECEIPT_XREF_ID NUMBER
Y Primary key.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
PAYMENT_ID NUMBER

FKey to iex_payments
CASH_RECEIPT_ID NUMBER

FKey to ar_cash_receipts_all
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use

[top of page]

IEX.IEX_PAY_RECEIPT_XREF does not reference any database object

IEX.IEX_PAY_RECEIPT_XREF is referenced by following:

IEX
VIEW - IEX_PAY_RECEIPT_XREF#

[top of page]

Table: IEX_PRD_APPL_XREF

Description: This table stores promise application information.
Comments

This table stores promise application information.

Indexes
Index Type Tablespace Column
IEX_PRD_APPL_XREF_U1 UNIQUE APPS_TS_TX_IDX PRD_APPL_XREF_ID
IEX_PRD_APPL_XREF_N1 NONUNIQUE APPS_TS_TX_IDX PROMISE_DETAIL_ID
IEX_PRD_APPL_XREF_N2 NONUNIQUE APPS_TS_TX_IDX RECEIVABLE_APPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
PRD_APPL_XREF_ID NUMBER
Y Primary Key
PROMISE_DETAIL_ID NUMBER
Y Foreign Key to iex_promise_details
RECEIVABLE_APPLICATION_ID NUMBER

Foreign key to ar_receivable_applications
AMOUNT_APPLIED NUMBER
Y AMount applied to the promise on this record
APPLY_DATE DATE
Y Date the money application happened
REVERSED_FLAG VARCHAR2 (1)
Indicates if the application was reversed
REVERSED_DATE DATE

Date of the application reversal
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y 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).
ADJUSTMENT_ID NUMBER

Foreign key to ar_adjustments

[top of page]

IEX.IEX_PRD_APPL_XREF does not reference any database object

IEX.IEX_PRD_APPL_XREF is referenced by following:

IEX
VIEW - IEX_PRD_APPL_XREF#

[top of page]

Table: IEX_PRD_OKL_XREF

Description: This table stores cross reference information between promises and Consolidated invoices.
Primary Key: IEX_PRD_OKL_XREF_PK
  1. PRD_OKL_XREF_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_PRD_OKL_XREF_U1 UNIQUE APPS_TS_TX_IDX PRD_OKL_XREF_ID
Columns
Name Datatype Length Mandatory Comments
PRD_OKL_XREF_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

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

Foreign key to the lcontract.(OKL)
CNSLD_INVOICE_ID NUMBER

CONTRACT_ID NUMBER

STREAM_ID NUMBER

[top of page]

IEX.IEX_PRD_OKL_XREF does not reference any database object

IEX.IEX_PRD_OKL_XREF is referenced by following:

IEX
VIEW - IEX_PRD_OKL_XREF#

[top of page]

Table: IEX_PRD_RECEIPT_XREF

Description: Stores information on what promises are paid by what receipts.
Comments

Stores information on what promises are paid by what receipts.

Indexes
Index Type Tablespace Column
IEX_PRD_RECEIPT_XREF_U1 UNIQUE APPS_TS_TX_IDX PRD_RECEIPT_XREF_ID
Columns
Name Datatype Length Mandatory Comments
PRD_RECEIPT_XREF_ID NUMBER
Y Primary key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
PROMISE_DETAIL_ID NUMBER

FKey to iex_promise_details
CASH_RECEIPT_ID NUMBER

FKey to ar_cash_receipts_all
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use

[top of page]

IEX.IEX_PRD_RECEIPT_XREF does not reference any database object

IEX.IEX_PRD_RECEIPT_XREF is referenced by following:

IEX
VIEW - IEX_PRD_RECEIPT_XREF#

[top of page]

Table: IEX_PROMISE_DETAILS

Description: Holds detail information about each promise to pay.
Primary Key: OCO_38184336
  1. PROMISE_DETAIL_ID
Comments

Holds detail information about each promise to pay.

Indexes
Index Type Tablespace Column
IEX_PROMISE_DETAILS_U1 UNIQUE APPS_TS_TX_IDX PROMISE_DETAIL_ID
IEX_PROMISE_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX PROMISE_DATE
IEX_PROMISE_DETAILS_N2 NONUNIQUE APPS_TS_TX_IDX BROKEN_ON_DATE
IEX_PROMISE_DETAILS_N3 NONUNIQUE APPS_TS_TX_IDX DELINQUENCY_ID
IEX_PROMISE_DETAILS_N4 NONUNIQUE APPS_TS_TX_IDX CUST_ACCOUNT_ID
STATUS
AMOUNT_DUE_REMAINING
IEX_PROMISE_DETAILS_N5 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
IEX_PROMISE_DETAILS_N6 NONUNIQUE APPS_TS_TX_IDX ORG_ID
Columns
Name Datatype Length Mandatory Comments
PROMISE_DETAIL_ID NUMBER
Y Primary key
OBJECT_VERSION_NUMBER NUMBER
Y Standard Column
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
PROGRAM_ID NUMBER

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
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROMISE_DATE DATE

When will the promise be paid
PROMISE_AMOUNT NUMBER

How much was promised
PROMISE_PAYMENT_METHOD VARCHAR2 (30)
What will this promise be paid with
STATUS VARCHAR2 (30)
Status of promise
ACCOUNT VARCHAR2 (240)
Free text field
PROMISE_ITEM_NUMBER VARCHAR2 (240)
Line item number
CURRENCY_CODE VARCHAR2 (240)
What currency will be used
CALLBACK_CREATED_YN VARCHAR2 (1)
Should we callback about this?
CALLBACK_DATE DATE

When will we callback
CAMPAIGN_SCHED_ID NUMBER

What marketing campaign are we working on
DELINQUENCY_ID NUMBER

FKey to iex_delinquencies_all
RESOURCE_ID NUMBER

What agent received this promise.FKey to jtf
PROMISE_MADE_BY NUMBER

Foreign Key to HZ_Parties to show who (Contact/person) made the promise.
CUST_ACCOUNT_ID NUMBER

FKey to hz_cust_accounts
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CNSLD_INVOICE_ID NUMBER

Consolidated invoice ID. Foreign key.
CONTRACT_ID NUMBER

Contract ID. Foreign key.
BROKEN_ON_DATE DATE

Date promise will be broken.
APPROVAL_REJECTION_DATE DATE

If approval is required, date of approval.
UWQ_STATUS VARCHAR2 (240)
Status of this delinquency on UWQ. Active/Pending/Complete
UWQ_ACTIVE_DATE DATE

Date this delinquency will change into the Active bucket on UWQ.
UWQ_COMPLETE_DATE DATE

Date this delinquency moved into the COMPLETE bucket on UWQ.
AMOUNT_DUE_REMAINING NUMBER

Amount remaing to pay for the promise.
STATE VARCHAR2 (30)
State of the promise - BROKEN - NOT BROKEN
ORG_ID NUMBER

Organization Identifier

[top of page]

IEX.IEX_PROMISE_DETAILS does not reference any database object

IEX.IEX_PROMISE_DETAILS is referenced by following:

IEX
VIEW - IEX_PROMISE_DETAILS#

[top of page]

Table: IEX_QUERY_STRINGS

Description:
Primary Key: IEX_QUERY_STRINGS_PK
  1. QUERY_STRING_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
TRAILER_CONST VARCHAR2 (240)
Trailer constant string in URL
URL_SEPARATOR VARCHAR2 (240)
URL separator constant string in URL
CREATION_DATE DATE

Standard who column - date when this row was created.
QUERY_STRING_ID NUMBER (15) Y PK of IEX_QUERY_STRINGS table
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SWITCH_SEPARATOR VARCHAR2 (240)
Switch separator constant string in URL
HEADER_CONST VARCHAR2 (240)
Header constant string in URL
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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).
ENABLED_FLAG VARCHAR2 (1)
Is this enabled or not
SECURITY_GROUP_ID NUMBER

Hosting Standard Column
SEARCH_ID NUMBER (15)
Identifier of web search associated with this cgi query string
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

IEX.IEX_QUERY_STRINGS does not reference any database object

IEX.IEX_QUERY_STRINGS is referenced by following:

IEX
VIEW - IEX_QUERY_STRINGS#

[top of page]

Table: IEX_QUERY_TEMP_XREF

Description: cross reference table for xdo tempalte and collections sql query
Primary Key: IQTX_PK
  1. QUERY_TEMP_ID
Comments

cross reference table for xdo tempalte and collections sql query

Indexes
Index Type Tablespace Column
IEX_QUERY_TEMP_XREF_U2 UNIQUE APPS_TS_TX_IDX QUERY_ID
TEMPLATE_ID
IEX_QUERY_TEMP_XREF_U1 NONUNIQUE APPS_TS_TX_IDX QUERY_TEMP_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_TEMP_ID NUMBER (10) Y query template cross reference id
QUERY_ID NUMBER (10) Y fk of iex_xml_queries
TEMPLATE_ID NUMBER (10) Y fk of xdo_templates_vl
CREATED_BY NUMBER

record created by
CREATION_DATE DATE

record creation date
LAST_UPDATE_DATE DATE

record last update date
LAST_UPDATED_BY NUMBER

record last updated by
LAST_UPDATE_LOGIN NUMBER

record last update login
OBJECT_VERSION_NUMBER NUMBER

record object version number

[top of page]

IEX.IEX_QUERY_TEMP_XREF does not reference any database object

IEX.IEX_QUERY_TEMP_XREF is referenced by following:

IEX
VIEW - IEX_QUERY_TEMP_XREF#

[top of page]

Table: IEX_QUESTIONNAIRE_ITEMS

Description: Setup table for questionnaire administration
Primary Key: IEX_QUESTIONNAIRE_ITEMS_PK
  1. QUESTIONNAIRE_ITEM_ID
Comments

Setup table for questionnaire administration

Indexes
Index Type Tablespace Column
IEX_QUESTIONNAIRE_ITEMS_U1 UNIQUE APPS_TS_TX_IDX QUESTIONNAIRE_ITEM_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
QUESTIONNAIRE_ITEM_ID NUMBER
Y Primary Key
RECEIVABLE_ENABLED VARCHAR2 (1)
Does you organization collect delinquent receivables?
LOAN_ENABLED VARCHAR2 (1)
Does you organization collect loans?
LEASING_ENABLED VARCHAR2 (1)
Does you organization collect lease contracts?
CLAIM_ENABLED VARCHAR2 (1)
Do you need visibility to claims and deductions?
BUSINESS_LEVEL VARCHAR2 (30)
At what level does your organization do business with customers?
DISPLAY_PREF_ENABLED VARCHAR2 (1)
Do you want to review the display settings?
CORRESPONDENCE_ENABLED VARCHAR2 (1)
Do you send correspondence to your customers?
PAYMENT_ENABLED VARCHAR2 (1)
Do collections agents take payment from customers?
CC_ENABLED VARCHAR2 (1)
Do you accept crecit card payment?
EFT_ENABLED VARCHAR2 (1)
Do you accept bank EFT payment?
ADJUSTMENT_ENABLED VARCHAR2 (1)
Do you allow adjustment?
DISPUTE_ENABLED VARCHAR2 (1)
Do you allow dispute?
REVERSAL_ENABLED VARCHAR2 (1)
Do you allow payment reversal?
PROMISE_ENABLED VARCHAR2 (1)
Do you take the promises to pay from customers?
LATER_STAGE_DELINS VARCHAR2 (1)
Which later stage delinquencies does your organization manage?
BANKRUPTCY_ENABLED VARCHAR2 (1)
Does your organization manage bankruptcies?
REPOSESSION_ENABLED VARCHAR2 (1)
Does your organization manage reposession?
LITIGATION_ENABLED VARCHAR2 (1)
Does your organization manage litigation?
WRITEOFF_ENABLED VARCHAR2 (1)
Does your organization manage writeoff?
OTHER_DELIN_ENABLED VARCHAR2 (1)
Does your organization manage other delinquencies?
METRICS_ENABLED VARCHAR2 (1)
Oracle collections includes a number of seeded metrics calculations from which you can select. Do you want to review these metrics?
COLLECTIONS_METHODS VARCHAR2 (30)
Which collections method does your organization use?(Dunning/Strategies)
COLLECT_SEGMENTS_ENABLED VARCHAR2 (1)
Do you collect from different types, or segments, of customers?
CUSTOMER_SCORING_ENABLED VARCHAR2 (1)
Do you consider the degree of delinquency or the value of your customers when you collect?
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created 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).
USING_CUSTOMER_LEVEL VARCHAR2 (1)
Does collections level for organization use customer level?
USING_ACCOUNT_LEVEL VARCHAR2 (1)
Does collections level for organization use account level?
USING_BILLTO_LEVEL VARCHAR2 (1)
Does collections level for organization use bill-to level?
USING_DELINQUENCY_LEVEL VARCHAR2 (1)
Does collections level for organization use delinquency level?
DEFINE_PARTY_RUNNING_LEVEL VARCHAR2 (1)
Does the Organization wants to override Collection at Party Level ?
DEFINE_OU_RUNNING_LEVEL VARCHAR2 (1)
Does the organization wants to define Collection levels for Operating Units ?
PREDEL_STRATEGY_ENABLED VARCHAR2 (1)
Do you allow predelinquent strategy?
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_QUESTIONNAIRE_ITEMS does not reference any database object

IEX.IEX_QUESTIONNAIRE_ITEMS is referenced by following:

IEX
VIEW - IEX_QUESTIONNAIRE_ITEMS#

[top of page]

Table: IEX_REPOSSESSIONS

Description: Details for Repossession
Primary Key: IRN_PK
  1. REPOSSESSION_ID
Comments

Details for Repossession

Indexes
Index Type Tablespace Column
IEX_REPOSSESSIONS_U1 UNIQUE APPS_TS_TX_IDX REPOSSESSION_ID
IEX_REPOSSESSIONS_N1 NONUNIQUE APPS_TS_TX_IDX DELINQUENCY_ID
PARTY_ID
Columns
Name Datatype Length Mandatory Comments
REPOSSESSION_ID NUMBER
Y Repossession Identifier
DELINQUENCY_ID NUMBER

Delinquency ID for a repossession.
PARTY_ID NUMBER

Party ID for a repossession
CUST_ACCOUNT_ID NUMBER (15)
Customer Account ID for a repossession.
UNPAID_REASON_CODE VARCHAR2 (30)
Unpaid Reason Code for a repossession.
REMARKET_FLAG VARCHAR2 (1)
Remarket Flag (Y/N)
REPOSSESSION_DATE DATE

Repossession Date.
ASSET_ID NUMBER

Asset ID for a repossession.
ASSET_VALUE NUMBER

Asset value for a repossession.
ASSET_NUMBER NUMBER
Y Asset number for a repossession
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
CREDIT_HOLD_REQUEST_FLAG VARCHAR2 (1)
Have we requested credit hold?
CREDIT_HOLD_APPROVED_FLAG VARCHAR2 (1)
Was credit hold approved?
SERVICE_HOLD_REQUEST_FLAG VARCHAR2 (1)
Have we requested service hold?
SERVICE_HOLD_APPROVED_FLAG VARCHAR2 (1)
Was service hold approved?
SUGGESTION_APPROVED_FLAG VARCHAR2 (1)
Flag (Y/N) for the Approved status of Suggestion
REASON_CODE VARCHAR2 (30)
Reason for repossession. Lookup.
DISPOSITION_CODE VARCHAR2 (30)
Repossession disposition. Lookup.
REPLEVIN_ATTORNEY NUMBER

Party_id of the attorney.
REPLEVIN_COURT_DATE DATE

If replevin required. Court date.
REPLEVIN_JUDGEMENT_DATE DATE

Judgement date for replevin.
REPLEVIN_PAYMNT_EXTN_YN VARCHAR2 (1)
Replevin resulted in payment extension.
CUSTOMER_SITE_USE_ID NUMBER

Customer Site Use ID
ORG_ID NUMBER

Org ID
CONTRACT_ID NUMBER

Contract ID
CONTRACT_NUMBER VARCHAR2 (250)
Contract Number

[top of page]

IEX.IEX_REPOSSESSIONS does not reference any database object

IEX.IEX_REPOSSESSIONS is referenced by following:

IEX
VIEW - IEX_REPOSSESSIONS#

[top of page]

Table: IEX_REPOS_OBJECTS

Description: Stores information of assets that are undergoing repossession.
Primary Key: IEX_REP_PK
  1. REPOS_OBJECT_ID
Comments

Stores information of assets that are undergoing repossession. These assets are on a contract which in turn is on a delinquency.

Indexes
Index Type Tablespace Column
IEX_REPOS_OBJECTS_N1 NONUNIQUE APPS_TS_TX_IDX ASSET_ID
IEX_REPOS_OBJECTS_U1 NONUNIQUE APPS_TS_TX_IDX REPOSSESSION_ID
ASSET_ID
Columns
Name Datatype Length Mandatory Comments
REPOS_OBJECT_ID NUMBER
Y Primary key
REPOSSESSION_ID NUMBER
Y FK to IEX_REPOSSESSIONS
ASSET_ID NUMBER (15) Y Asset identifier
RNA_ID NUMBER
Y Repossession agent identifier. FK to PO_VENDORS
RNA_SITE_ID NUMBER

Repossession agent site identifier. FK to PO_VENDOR_SITES_ALL
ART_ID NUMBER

Asset return request identifier. FK to OKL_ASSET_RETURNS_B
ACTIVE_YN VARCHAR2 (1)
If the record has been deleted
OBJECT_VERSION_NUMBER NUMBER (9) Y Column used for locking records during updates
ORG_ID NUMBER

Operating unit identifier
REQUEST_ID NUMBER (15)
Concurrent Program column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program column
PROGRAM_ID NUMBER (15)
Concurrent Program column
PROGRAM_UPDATE_DATE DATE

Concurrent Program column
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield structure definition column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SECURITY_GROUP_ID NUMBER (15)
Used in hosted environments

[top of page]

IEX.IEX_REPOS_OBJECTS does not reference any database object

IEX.IEX_REPOS_OBJECTS is referenced by following:

IEX
VIEW - IEX_REPOS_OBJECTS#

[top of page]

Table: IEX_SCORES

Description: Stores all the score definitions.
Primary Key: IEX_SCORES_PK
  1. SCORE_ID
Comments

Stores all the score definitions.

Indexes
Index Type Tablespace Column
IEX_SCORES_U1 UNIQUE APPS_TS_SEED SCORE_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SCORE_ID NUMBER
Y Primary key
SCORE_NAME VARCHAR2 (256)
Name of the score engine
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
SCORE_DESCRIPTION VARCHAR2 (150)
Long description
ENABLED_FLAG VARCHAR2 (1)
Can we use it?
VALID_FROM_DT DATE

Low end of valid period
VALID_TO_DT DATE

High end of valid period
CAMPAIGN_SCHED_ID NUMBER

What marketing campaign should this be used with
JTF_OBJECT_CODE VARCHAR2 (25)
Code of the object scored on JTF_OBJECTS table.
CONCURRENT_PROG_ID NUMBER

LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
CONCURRENT_PROG_NAME VARCHAR2 (30)
Concurrent program name that generated the score.
STATUS_DETERMINATION VARCHAR2 (1)
This indicates if the scoring engine is to be used for status determination only. Used by Oracle Loans.
WEIGHT_REQUIRED VARCHAR2 (3)
Indicate if weights are required in the scoring engine.
SCORE_RANGE_LOW VARCHAR2 (1000)
Minimum value generated by this scoring engine.
SCORE_RANGE_HIGH VARCHAR2 (1000)
Maximum value generated by this scoring engine.
OUT_OF_RANGE_RULE VARCHAR2 (20)
Rule that indicates what we should do if the value returned by the engine is outside the valid range. We can replace the value with the first value in the range or with the last value in the range.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_SCORES does not reference any database object

IEX.IEX_SCORES is referenced by following:

IEX
VIEW - IEX_SCORES#

[top of page]

Table: IEX_SCORE_COMPONENTS

Description: Stores details about what items make a score.
Primary Key: IEX_SCORE_COMPONENTS_PK
  1. SCORE_COMPONENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEX_SCORE_COMPONENTS.SCORE_COMP_TYPE_ID %
Comments

Stores details about what items make a score.

Indexes
Index Type Tablespace Column
IEX_SCORE_COMPONENTS_U1 UNIQUE APPS_TS_SEED SCORE_COMPONENT_ID
ZD_EDITION_NAME
IEX_SCORE_COMPONENTS_N1 NONUNIQUE APPS_TS_SEED SCORE_ID
Columns
Name Datatype Length Mandatory Comments
SCORE_COMPONENT_ID NUMBER
Y Primary key
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
SCORE_COMP_WEIGHT NUMBER (3)
What is the weight of this componet on the whole score engine.
SCORE_ID NUMBER

What score engine is this part of
ENABLED_FLAG VARCHAR2 (10)
Can we use it?
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
SCORE_COMP_TYPE_ID NUMBER
Y FKey to score component types
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_SCORE_COMPONENTS does not reference any database object

IEX.IEX_SCORE_COMPONENTS is referenced by following:

IEX
VIEW - IEX_SCORE_COMPONENTS#

[top of page]

Table: IEX_SCORE_COMP_DET

Description: Stores range and value details for components
Primary Key: IEX_SCORE_COMP_DET_FK
  1. SCORE_COMP_DET_ID
Comments

Stores range and value details for components

Indexes
Index Type Tablespace Column
IEX_SCORE_COMP_DET_U1 UNIQUE APPS_TS_SEED SCORE_COMP_DET_ID
ZD_EDITION_NAME
IEX_SCORE_COMP_DET_N1 NONUNIQUE APPS_TS_SEED SCORE_COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
SCORE_COMP_DET_ID NUMBER
Y Primary key
OBJECT_VERSION_NUMBER NUMBER
Y Standard column
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
PROGRAM_ID NUMBER

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
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
VALUE NUMBER

What is this component's value
RANGE_LOW NUMBER

Low number of the range to which we are assigning values
RANGE_HIGH NUMBER

High number of the range to which we are assigning values
SCORE_COMPONENT_ID NUMBER

FKey to iex_score_components
NEW_VALUE VARCHAR2 (2000)
VARCHAR2 column so we can return strings from the scoring engine.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_SCORE_COMP_DET does not reference any database object

IEX.IEX_SCORE_COMP_DET is referenced by following:

IEX
VIEW - IEX_SCORE_COMP_DET#

[top of page]

Table: IEX_SCORE_COMP_PARAMS

Description: Stores Parameters to Score components.
Primary Key: IEX_SCORE_COMP_PARAMS_PK
  1. SCORE_COMP_PARAM_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_SCORE_COMP_PARAMS_U1 UNIQUE APPS_TS_SEED SCORE_COMP_PARAM_ID
ZD_EDITION_NAME
IEX_SCORE_COMP_PARAMS_N1 NONUNIQUE APPS_TS_SEED SCORE_COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
SCORE_COMP_PARAM_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

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

CODE VARCHAR2 (40)
VALUE VARCHAR2 (240)
DESCRIPTION VARCHAR2 (240)
ACTIVE_FLAG VARCHAR2 (1)
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_SCORE_COMP_PARAMS does not reference any database object

IEX.IEX_SCORE_COMP_PARAMS is referenced by following:

IEX
VIEW - IEX_SCORE_COMP_PARAMS#

[top of page]

Table: IEX_SCORE_COMP_TYPES_B

Description: Stores configuration data on score components.
Primary Key: IEX_SCORE_COMP_TYPES_B_PK
  1. SCORE_COMP_TYPE_ID
Comments

Stores configuration data on score components.

Indexes
Index Type Tablespace Column
IEX_SCORE_COMP_TYPES_B_U1 UNIQUE APPS_TS_SEED SCORE_COMP_TYPE_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SCORE_COMP_TYPE_ID NUMBER
Y Primary key
OBJECT_VERSION_NUMBER NUMBER
Y Standard column
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
PROGRAM_ID NUMBER

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
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SCORE_COMP_VALUE VARCHAR2 (2000)
Select stmnt of function name
ACTIVE_FLAG VARCHAR2 (10)
Can we use it?
JTF_OBJECT_CODE VARCHAR2 (25)
Code of the object scored on JTF_OBJECTS table.
FUNCTION_FLAG VARCHAR2 (1)
Is this a function or not?
METRIC_FLAG VARCHAR2 (1)
Is this a metric component type or not?
DISPLAY_ORDER NUMBER

Display order in metric's grids only for the metric components
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_SCORE_COMP_TYPES_B does not reference any database object

IEX.IEX_SCORE_COMP_TYPES_B is referenced by following:

IEX
VIEW - IEX_SCORE_COMP_TYPES_B#

[top of page]

Table: IEX_SCORE_COMP_TYPES_TL

Description: Stores configuration data on score components.
Primary Key: IEX_SCORE_COMP_TYPES_TL_PK
  1. SCORE_COMP_TYPE_ID
  2. LANGUAGE
Comments

Stores configuration data on score components.

Indexes
Index Type Tablespace Column
IEX_SCORE_COMP_TYPES_TL_U1 UNIQUE APPS_TS_SEED SCORE_COMP_TYPE_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SCORE_COMP_TYPE_ID NUMBER
Y Primary key
OBJECT_VERSION_NUMBER NUMBER
Y Standard column
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
PROGRAM_ID NUMBER

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
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
SCORE_COMP_NAME VARCHAR2 (45)
Translated name of the component type
DESCRIPTION VARCHAR2 (80)
Translated description
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_SCORE_COMP_TYPES_TL does not reference any database object

IEX.IEX_SCORE_COMP_TYPES_TL is referenced by following:

IEX
VIEW - IEX_SCORE_COMP_TYPES_TL#

[top of page]

Table: IEX_SCORE_HISTORIES

Description: Stores historical data about collection scores.
Primary Key: IEX_SCORE_HISTORIES_PK
  1. SCORE_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEX_SCORE_HISTORIES.DEL_DELINQUENCY_ID IEX_DELINQUENCIES_ALL
Comments

Stores historical data about collection scores.

Indexes
Index Type Tablespace Column
IEX_SCORE_HISTORIES_U1 UNIQUE APPS_TS_TX_IDX SCORE_HISTORY_ID
IEX_SCORE_HISTORIES_N1 NONUNIQUE APPS_TS_TX_IDX SCORE_ID
IEX_SCORE_HISTORIES_N2 NONUNIQUE APPS_TS_TX_IDX SCORE_OBJECT_CODE
SCORE_OBJECT_ID
CREATION_DATE
IEX_SCORE_HISTORIES_N3 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
SCORE_HISTORY_ID NUMBER
Y Primary key
SCORE_OBJECT_ID NUMBER (25)
ID of the object mentioned on SCORE_OBJECT_CODE column.
SCORE_OBJECT_CODE VARCHAR2 (25)
Code of the object scored on JTF_OBJECTS table.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
PROGRAM_ID NUMBER

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
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SCORE_VALUE NUMBER

Score value for this history entry
SCORE_ID NUMBER

Score engine used to create this value
PARTY_ID NUMBER

Party ID of the customer used FKey to HZ_PARTIES
ICO_ID NUMBER

Case ID
DEL_DELINQUENCY_ID NUMBER

Delinquency ID
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_UPDATE_DATE DATE

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

Organization identifier

[top of page]

IEX.IEX_SCORE_HISTORIES does not reference any database object

IEX.IEX_SCORE_HISTORIES is referenced by following:

IEX
VIEW - IEX_SCORE_HISTORIES#

[top of page]

Table: IEX_STRATEGIES

Description:
Comments
Indexes
Index Type Tablespace Column
IEX_STRATEGIES_U1 UNIQUE APPS_TS_TX_IDX STRATEGY_ID
IEX_STRATEGIES_N1 NONUNIQUE APPS_TS_TX_IDX DELINQUENCY_ID
IEX_STRATEGIES_N2 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
STATUS_CODE
IEX_STRATEGIES_N3 NONUNIQUE APPS_TS_TX_IDX OBJECT_ID
OBJECT_TYPE
IEX_STRATEGIES_N4 NONUNIQUE APPS_TS_TX_IDX JTF_OBJECT_TYPE
JTF_OBJECT_ID
STATUS_CODE
IEX_STRATEGIES_N5 NONUNIQUE APPS_TS_TX_IDX ORG_ID
IEX_STRATEGIES_N6 NONUNIQUE APPS_TS_TX_IDX CUST_ACCOUNT_ID
IEX_STRATEGIES_N8 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_SITE_USE_ID
STATUS_CODE
Columns
Name Datatype Length Mandatory Comments
STRATEGY_ID NUMBER (15) Y
STATUS_CODE VARCHAR2 (30)
STRATEGY_TEMPLATE_ID NUMBER (15)
DELINQUENCY_ID NUMBER

OBJECT_TYPE VARCHAR2 (30)
OBJECT_ID NUMBER

CUST_ACCOUNT_ID NUMBER (15)
PARTY_ID NUMBER (15)
Obsoleted
SCORE_VALUE NUMBER

NEXT_WORK_ITEM_ID NUMBER (15)
USER_WORK_ITEM_YN VARCHAR2 (2)
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
OBJECT_VERSION_NUMBER NUMBER
Y 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
Y 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

CHECKLIST_YN VARCHAR2 (6)
STRATEGY_LEVEL NUMBER

strategy level for customer, account, site, delinquency - 10, 20, 30, 40 respectively
JTF_OBJECT_TYPE VARCHAR2 (30)
JTF_OBJECT_ID NUMBER (15)
CUSTOMER_SITE_USE_ID NUMBER

ORG_ID NUMBER

HOLD_START_DATE DATE

HOLD_DAYS NUMBER

RELEASE_DATE DATE

[top of page]

IEX.IEX_STRATEGIES does not reference any database object

IEX.IEX_STRATEGIES is referenced by following:

IEX
VIEW - IEX_STRATEGIES#

[top of page]

Table: IEX_STRATEGY_TEMPLATES_B

Description:
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_STRATEGY_TEMPLATES_B_U1 UNIQUE APPS_TS_SEED STRATEGY_TEMP_ID
ZD_EDITION_NAME
IEX_STRATEGY_TEMPLATES_B_N1 NONUNIQUE APPS_TS_SEED STRATEGY_RANK
IEX_STRATEGY_TEMPLATES_B_N2 NONUNIQUE APPS_TS_SEED CATEGORY_TYPE
CHECK_LIST_YN
ENABLED_FLAG
Columns
Name Datatype Length Mandatory Comments
STRATEGY_TEMP_ID NUMBER (25) Y
STRATEGY_RANK VARCHAR2 (10)
ENABLED_FLAG VARCHAR2 (15)
Can we use it?
CATEGORY_TYPE VARCHAR2 (60)
CHANGE_STRATEGY_YN VARCHAR2 (4)
CHECK_LIST_YN VARCHAR2 (3)
CHECK_LIST_TEMP_ID NUMBER (15)
VALID_FROM_DT DATE

Low end of valid period
VALID_TO_DT DATE

High end of valid period
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
CREATED_BY NUMBER (10)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
STRATEGY_TEMP_GROUP_ID NUMBER (15)
OBJECT_FILTER_ID NUMBER (25)
STRATEGY_LEVEL NUMBER

GROUP_SUBNAME VARCHAR2 (60)
Group subname
STRATEGY_ORDER_ID NUMBER (15)
SCORE_TOLERANCE NUMBER

ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_STRATEGY_TEMPLATES_B does not reference any database object

IEX.IEX_STRATEGY_TEMPLATES_B is referenced by following:

IEX
VIEW - IEX_STRATEGY_TEMPLATES_B#

[top of page]

Table: IEX_STRATEGY_TEMPLATES_TL

Description:
Primary Key: ISTL_PK1
  1. LANGUAGE
  2. STRATEGY_TEMP_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_STRATEGY_TEMPLATES_TL_U1 UNIQUE APPS_TS_SEED STRATEGY_TEMP_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
STRATEGY_TEMP_ID NUMBER
Y Primary key
STRATEGY_NAME VARCHAR2 (240) Y Stores actual note text. Typically will hold the entire note, or up to 2000 characters if the note is very long.
LANGUAGE VARCHAR2 (240) Y Language.
SOURCE_LANG VARCHAR2 (240) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_STRATEGY_TEMPLATES_TL does not reference any database object

IEX.IEX_STRATEGY_TEMPLATES_TL is referenced by following:

IEX
VIEW - IEX_STRATEGY_TEMPLATES_TL#

[top of page]

Table: IEX_STRATEGY_TEMPLATE_GROUPS

Description:
Primary Key: ISP_PK
  1. GROUP_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_STRATEGY_TEMP_GROUPS_U1 UNIQUE APPS_TS_SEED GROUP_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
STRATEGY_GROUP_ID NUMBER (15)
STRATEGY_GROUP_NAME VARCHAR2 (200)
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
STRATEGY_TEMP_ID NUMBER (25)
STRATEGY_ORDER_ID NUMBER (15)
GROUP_ID NUMBER (15) Y
GROUP_NAME VARCHAR2 (200)
STRATEGY_RANK VARCHAR2 (10)
ENABLED_FLAG VARCHAR2 (15)
Can we use it?
CATEGORY_TYPE VARCHAR2 (60)
CHANGE_STRATEGY_YN VARCHAR2 (4)
CHECK_LIST_YN VARCHAR2 (3)
CHECK_LIST_TEMP_ID NUMBER (15)
VALID_FROM_DT DATE

Low end of valid period
VALID_TO_DT DATE

High end of valid period
OBJECT_FILTER_ID NUMBER (25)
SCORING_ENGINE_ID NUMBER (25)
Scoring filter
STRATEGY_LEVEL NUMBER

SCORE_TOLERANCE NUMBER

ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_STRATEGY_TEMPLATE_GROUPS does not reference any database object

IEX.IEX_STRATEGY_TEMPLATE_GROUPS is referenced by following:

IEX
VIEW - IEX_STRATEGY_TEMPLATE_GROUPS#

[top of page]

Table: IEX_STRATEGY_TYPES

Description: OBSOLETED. Obsoleted
Comments
***** Warning: Oracle Internal Use Only *****

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

Columns
Name Datatype Length Mandatory Comments
STRATEGY_TYPE_ID NUMBER
Y
STRATEGY_TYPE_NAME VARCHAR2 (100)
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
CREATED_BY NUMBER (10)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

[top of page]

IEX.IEX_STRATEGY_TYPES does not reference any database object

IEX.IEX_STRATEGY_TYPES is referenced by following:

IEX
VIEW - IEX_STRATEGY_TYPES#

[top of page]

Table: IEX_STRATEGY_USER_ITEMS

Description: Custom work item templates added to a particular strategy IEX_STRATEGY
Primary Key: ISUI_PK
  1. STRATEGY_USER_ITEM_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_STRATEGY_USER_ITEMS_U1 UNIQUE APPS_TS_TX_IDX STRATEGY_USER_ITEM_ID
IEX_STRATEGY_USER_ITEMS_N1 NONUNIQUE APPS_TS_TX_IDX STRATEGY_TEMPLATE_ID
WORK_ITEM_ORDER
IEX_STRATGY_USER_ITEMS_N3 NONUNIQUE APPS_TS_TX_IDX STRATEGY_ID
Columns
Name Datatype Length Mandatory Comments
STRATEGY_USER_ITEM_ID NUMBER (25) Y
STRATEGY_ID NUMBER (25) Y
WORK_ITEM_TEMP_ID NUMBER (25) Y
WORK_ITEM_ORDER NUMBER (15)
STRATEGY_TEMPLATE_ID NUMBER (25) Y
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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).
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
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).
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_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
OPERATION VARCHAR2 (25)
PRE_EXECUTION_WAIT NUMBER

PRE_EXECUTION_TIME_UOM VARCHAR2 (240)
POST_EXECUTION_WAIT NUMBER

EXECUTION_TIME_UOM VARCHAR2 (240)
XDO_TEMP_ID NUMBER

OPTIONAL_YN VARCHAR2 (5)
OPTIONAL_WAIT_TIME NUMBER

OPTIONAL_WAIT_TIME_UOM VARCHAR2 (60)
RESOURCE_ID NUMBER

NOTIFY_YN VARCHAR2 (3)
ESCALATE_YN VARCHAR2 (6)
ESCALATE_WAIT_TIME NUMBER

ESCALATE_WAIT_TIME_UOM VARCHAR2 (60)
CUSTOM_WORKFLOW_TYPE VARCHAR2 (240)

[top of page]

IEX.IEX_STRATEGY_USER_ITEMS does not reference any database object

IEX.IEX_STRATEGY_USER_ITEMS is referenced by following:

IEX
VIEW - IEX_STRATEGY_USER_ITEMS#

[top of page]

Table: IEX_STRATEGY_WORK_ITEMS

Description: Each work item associated with strategy IEX_STRATEGIES
Primary Key: ISWI_PK
  1. WORK_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEX_STRATEGY_WORK_ITEMS.RESOURCE_ID JTF_RS_RESOURCE_EXTNS
Comments
Indexes
Index Type Tablespace Column
IEX_STRATEGY_WORK_ITEMS_U1 UNIQUE APPS_TS_TX_IDX WORK_ITEM_ID
IEX_STRATEGY_WORK_ITEMS_N1 NONUNIQUE APPS_TS_TX_IDX STRATEGY_TEMP_ID
WORK_ITEM_ORDER
IEX_STRATEGY_WORK_ITEMS_N3 NONUNIQUE APPS_TS_TX_IDX STRATEGY_ID
IEX_STRATEGY_WORK_ITEMS_N4 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
STATUS_CODE
SYS_NC00026$
IEX_STRATEGY_WORK_ITEMS_N6 NONUNIQUE APPS_TS_TX_IDX WORK_ITEM_TEMPLATE_ID
Columns
Name Datatype Length Mandatory Comments
WORK_ITEM_ID NUMBER (25) Y
STRATEGY_ID NUMBER (25) Y
WORK_ITEM_TEMPLATE_ID NUMBER (25) Y
RESOURCE_ID NUMBER

STATUS_CODE VARCHAR2 (30)
EXECUTE_START DATE

EXECUTE_END DATE

CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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).
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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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).
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
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_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
SCHEDULE_START DATE

SCHEDULE_END DATE

STRATEGY_TEMP_ID NUMBER (25) Y
WORK_ITEM_ORDER NUMBER (15)
UWQ_STATUS VARCHAR2 (240)
UWQ_ACTIVE_DATE DATE

UWQ_COMPLETE_DATE DATE

ESCALATED_YN VARCHAR2 (1)
PRE_EXECUTION_WAIT NUMBER

PRE_EXECUTION_TIME_UOM VARCHAR2 (240)
EXECUTION_TIME_UOM VARCHAR2 (240)
POST_EXECUTION_WAIT NUMBER

XDO_TEMP_ID NUMBER

OPTIONAL_YN VARCHAR2 (5)
OPTIONAL_WAIT_TIME NUMBER

OPTIONAL_WAIT_TIME_UOM VARCHAR2 (60)
NOTIFY_YN VARCHAR2 (3)
ESCALATE_YN VARCHAR2 (6)
ESCALATE_WAIT_TIME NUMBER

ESCALATE_WAIT_TIME_UOM VARCHAR2 (60)
CUSTOM_WORKFLOW_TYPE VARCHAR2 (240)

[top of page]

IEX.IEX_STRATEGY_WORK_ITEMS does not reference any database object

IEX.IEX_STRATEGY_WORK_ITEMS is referenced by following:

IEX
VIEW - IEX_STRATEGY_WORK_ITEMS#

[top of page]

Table: IEX_STRATEGY_WORK_SKILLS

Description: Skill set associateds with each work item Template defined in IEX_STRY_TEMP_WORK_ITEMS_B
Primary Key: ISWS_PK
  1. WORK_SKILL_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_STRATEGY_WORK_SKILLS_U1 UNIQUE APPS_TS_TX_IDX WORK_SKILL_ID
IEX_STRATEGY_WORK_SKILLS_N1 NONUNIQUE APPS_TS_TX_IDX WORK_ITEM_TEMP_ID
Columns
Name Datatype Length Mandatory Comments
WORK_SKILL_ID NUMBER (25) Y
WORK_ITEM_TEMP_ID NUMBER (25)
COMPETENCE_ID NUMBER (25)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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).
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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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).
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
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_UPDATE_DATE DATE

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

[top of page]

IEX.IEX_STRATEGY_WORK_SKILLS does not reference any database object

IEX.IEX_STRATEGY_WORK_SKILLS is referenced by following:

IEX
VIEW - IEX_STRATEGY_WORK_SKILLS#

[top of page]

Table: IEX_STRATEGY_WORK_TEMP_XREF

Description:
Primary Key: PR1
  1. WORK_TEMP_XREF_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_STRATEGY_WORK_TEMP_XREF_U1 UNIQUE APPS_TS_SEED WORK_TEMP_XREF_ID
ZD_EDITION_NAME
IEX_STRATEGY_WORK_TEMP_XREF_N1 NONUNIQUE APPS_TS_SEED STRATEGY_TEMP_ID
Columns
Name Datatype Length Mandatory Comments
WORK_TEMP_XREF_ID NUMBER (25) Y
STRATEGY_TEMP_ID NUMBER
Y
WORK_ITEM_TEMP_ID NUMBER (25) Y
WORK_ITEM_ORDER NUMBER (15)
REQUIRED_YN VARCHAR2 (240)
CREATED_BY NUMBER (10)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

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

ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_STRATEGY_WORK_TEMP_XREF does not reference any database object

IEX.IEX_STRATEGY_WORK_TEMP_XREF is referenced by following:

IEX
VIEW - IEX_STRATEGY_WORK_TEMP_XREF#

[top of page]

Table: IEX_STRY_TEMP_WORK_ITEMS_B

Description:
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_STRY_TEMP_WORK_ITEMS_B_U1 UNIQUE APPS_TS_SEED WORK_ITEM_TEMP_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
WORK_ITEM_TEMP_ID NUMBER (25) Y
COMPETENCE_ID NUMBER (25)
WORK_TYPE VARCHAR2 (30)
Work Type Currently Auto/Manual
CATEGORY_TYPE VARCHAR2 (30)
(SEND LETTER,CALL,VISIT) CURRENT CATEGORY types
PRIORITY_TYPE VARCHAR2 (30)
OPTIONAL_YN VARCHAR2 (5)
OPTION_WAIT_TIME NUMBER (15)
OPTION_WAIT_TIME_UOM VARCHAR2 (60)
PRE_EXECUTION_WAIT NUMBER (15)
POST_EXECUTION_WAIT NUMBER (15)
EXECUTION_TIME_UOM VARCHAR2 (60)
CLOSURE_TIME_LIMIT NUMBER

CLOSURE_TIME_UOM VARCHAR2 (60)
WORKFLOW_ITEM_TYPE VARCHAR2 (60)
SAME_RESOURCE_YN VARCHAR2 (6)
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

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

Subscriber id, for CRM Online Services use
FULFIL_TEMP_ID NUMBER (25)
ESCALATE_YN VARCHAR2 (6)
NOTIFY_YN VARCHAR2 (3)
SCHEDULE_WAIT NUMBER

SCHEDULE_UOM VARCHAR2 (60)
ENABLED_FLAG VARCHAR2 (15)
XDO_TEMPLATE_ID NUMBER (25)
TEMP_RESOURCE_ID NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
INCLUDE_CURRENT VARCHAR2 (1)
Include Current
INCLUDE_DISPUTED_ITEMS VARCHAR2 (1)
Include disputed Items
INCLUDE_UNUSED_PAYMENTS_FLAG VARCHAR2 (1)
Include unused payments flag
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_STRY_TEMP_WORK_ITEMS_B does not reference any database object

IEX.IEX_STRY_TEMP_WORK_ITEMS_B is referenced by following:

IEX
VIEW - IEX_STRY_TEMP_WORK_ITEMS_B#

[top of page]

Table: IEX_STRY_TEMP_WORK_ITEMS_TL

Description:
Primary Key: ISTWITL_PK1
  1. LANGUAGE
  2. WORK_ITEM_TEMP_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_STRY_TEMP_WORK_ITEMS_TL_U1 UNIQUE APPS_TS_SEED WORK_ITEM_TEMP_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
WORK_ITEM_TEMP_ID NUMBER (25) Y Primary key
NAME VARCHAR2 (240) Y Stores actual note text. Typically will hold the entire note, or up to 2000 characters if the note is very long.
DESCRIPTION VARCHAR2 (255)
LANGUAGE VARCHAR2 (240) Y Language.
SOURCE_LANG VARCHAR2 (240) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_STRY_TEMP_WORK_ITEMS_TL does not reference any database object

IEX.IEX_STRY_TEMP_WORK_ITEMS_TL is referenced by following:

IEX
VIEW - IEX_STRY_TEMP_WORK_ITEMS_TL#

[top of page]

Table: IEX_STRY_WORK_TYPES

Description: OBSOLETED. Obsoleted
Comments
***** Warning: Oracle Internal Use Only *****

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

Columns
Name Datatype Length Mandatory Comments
WORK_TYPE_ID NUMBER
Y

[top of page]

IEX.IEX_STRY_WORK_TYPES does not reference any database object

IEX.IEX_STRY_WORK_TYPES is referenced by following:

IEX
VIEW - IEX_STRY_WORK_TYPES#

[top of page]

Table: IEX_SWITCH_DATA

Description: Metadata for all data on a CGI switch
Comments

Metadata for all data on a CGI switch

Columns
Name Datatype Length Mandatory Comments
SWITCH_DATA_ID NUMBER (15) Y Identifier of switch data
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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ENABLED_FLAG VARCHAR2 (1)
Is this enabled or not
SECURITY_GROUP_ID NUMBER

Hosting Standard Column
SORT_ORDER NUMBER (15)
Order on which the data shows on the switch
FIRST_NAME_YN VARCHAR2 (1)
This is used to include or exclude first name switch data
LAST_NAME_YN VARCHAR2 (1)
This is used to include or exclude last name switch data
ADDRESS_YN VARCHAR2 (1)
This is used to include or exclude address switch data
CITY_YN VARCHAR2 (1)
This is used to include or exclude city switch data
STATE_YN VARCHAR2 (1)
This is used to include or exclude state switch data
COUNTRY_YN VARCHAR2 (1)
This is used to include or exclude country switch data
ZIP_YN VARCHAR2 (1)
This is used to include or exclude zip switch data
CGI_SWITCH_ID NUMBER (15)
Identifier of cgi switch associated with this switch data
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

IEX.IEX_SWITCH_DATA does not reference any database object

IEX.IEX_SWITCH_DATA is referenced by following:

IEX
VIEW - IEX_SWITCH_DATA#

[top of page]

Table: IEX_WEB_ASSISTS

Description: Stores all available web directory assitance sites.
Primary Key: IEX_WEB_ASSISTS_PK
  1. WEB_ASSIST_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE

Standard who column - date when this row was created.
PROXY_PORT VARCHAR2 (240)
Name of the host for the web proxy
PROXY_HOST VARCHAR2 (240)
Port number for the web proxy
WEB_ASSIST_ID NUMBER (15) Y Identifier of Web Assistance
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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).
ENABLED_FLAG VARCHAR2 (1)
Is this enabled or not
ASSIST_ID NUMBER (15)
Assistance Identifier
SECURITY_GROUP_ID NUMBER

Hosting Standard Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

IEX.IEX_WEB_ASSISTS does not reference any database object

IEX.IEX_WEB_ASSISTS is referenced by following:

IEX
VIEW - IEX_WEB_ASSISTS#

[top of page]

Table: IEX_WEB_SEARCHES

Description: All available web searches
Primary Key: IEX_WEB_SEARCHES_PK
  1. SEARCH_ID
Comments
***** Warning: Oracle Internal Use Only *****

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

Columns
Name Datatype Length Mandatory Comments
CGI_SERVER VARCHAR2 (240)
Cgi server of web search
MAX_NBR_PAGES NUMBER

Maximum number of pages for web search
NEXT_PAGE_IDENT VARCHAR2 (240)
Next page Identifier of web search
CREATION_DATE DATE

Standard who column - date when this row was created.
SEARCH_ID NUMBER (15) Y Web Search Identifier
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SEARCH_URL VARCHAR2 (240)
Web Search URL
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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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).
SECURITY_GROUP_ID NUMBER

Hosting Standard Column
ENABLED_FLAG VARCHAR2 (1)
Is this enabled or not
WEB_ASSIST_ID NUMBER (15)
Identifier of web assistance associated with this web search
DIRECTORY_ASSIST_FLAG VARCHAR2 (3)
Mark to differentiate directory assistance sites
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

IEX.IEX_WEB_SEARCHES does not reference any database object

IEX.IEX_WEB_SEARCHES is referenced by following:

IEX
VIEW - IEX_WEB_SEARCHES#

[top of page]

Table: IEX_WRITEOFFS

Description: This entity holds information on writeoffs.
Primary Key: IEX_WRITEOFFS_PK
  1. WRITEOFF_ID
Comments

This entity holds information on writeoffs.

Indexes
Index Type Tablespace Column
IEX_WRITEOFFS_U1 UNIQUE APPS_TS_TX_IDX WRITEOFF_ID
IEX_WRITEOFFS_N1 NONUNIQUE APPS_TS_TX_IDX WRITEOFF_TYPE
IEX_WRITEOFFS_N2 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
IEX_WRITEOFFS_N3 NONUNIQUE APPS_TS_TX_IDX CAS_ID
IEX_WRITEOFFS_N4 NONUNIQUE APPS_TS_TX_IDX APPROVER_ID
IEX_WRITEOFFS_N5 NONUNIQUE APPS_TS_TX_IDX OBJECT_CODE
OBJECT_ID
IEX_WRITEOFFS_N6 NONUNIQUE APPS_TS_TX_IDX CUST_ACCOUNT_ID
IEX_WRITEOFFS_N7 NONUNIQUE APPS_TS_TX_IDX DELINQUENCY_ID
Columns
Name Datatype Length Mandatory Comments
WRITEOFF_ID NUMBER
Y Case Writeoff Identifier
PARTY_ID NUMBER
Y Foreign Key to HZ_PARTIES table
DELINQUENCY_ID NUMBER (15)
Foreign key to iex_delinquencies_b
OBJECT_ID NUMBER

Object Id for the writeoff. Foreign key to iex_Case_objects
OBJECT_CODE VARCHAR2 (240)
Foreign Key to iex_case_objects
ACTIVE_FLAG VARCHAR2 (240) Y Active flag
OBJECT_VERSION_NUMBER NUMBER (9) Y Standard HTML front end column
CAS_ID NUMBER

foreign key to iex_cases_b
WRITEOFF_TYPE VARCHAR2 (240) Y writeoff type
WRITEOFF_REASON VARCHAR2 (240) Y reason for writeoff
WRITEOFF_AMOUNT NUMBER

writeoff amount
WRITEOFF_CURRENCY_CODE VARCHAR2 (240)
Writeoff Currency Code
WRITEOFF_DATE DATE

writeoff date
WRITEOFF_REQUEST_DATE DATE

Writeoff Request Date
WRITEOFF_PROCESS VARCHAR2 (240)
writeoff process
WRITEOFF_SCORE VARCHAR2 (240)
Obsolete.
BAD_DEBT_REASON VARCHAR2 (240)
Reason for writeoff
LEASING_CODE VARCHAR2 (30)
leasing code
REPOSSES_SCH_DATE DATE

repossession schedule date
REPOSSES_COMP_DATE DATE

repossession completed date
CREDIT_HOLD_YN VARCHAR2 (240)
Credit hold
APPROVER_ID VARCHAR2 (240)
approver of the writeoffs
EXTERNAL_AGENT_ID VARCHAR2 (240)
External Agent Id
PROCEDURE_CODE VARCHAR2 (30)
procedure for writeoffs
CHECKLIST_CODE VARCHAR2 (30)
checklist code
CUST_ACCOUNT_ID NUMBER

account of the writeoff
DISPOSITION_CODE VARCHAR2 (30)
disposition code
SECURITY_GROUP_ID NUMBER

Used in hosted environments
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREDIT_HOLD_REQUEST_FLAG VARCHAR2 (1)
Did we request credit hold?
CREDIT_HOLD_APPROVED_FLAG VARCHAR2 (1)
Was hold approved?
SERVICE_HOLD_REQUEST_FLAG VARCHAR2 (1)
Did we request service hold?
SERVICE_HOLD_APPROVED_FLAG VARCHAR2 (1)
Was hold approved?
SUGGESTION_APPROVED_FLAG VARCHAR2 (1)
Flag (Y/N) for the Approved status of Suggestion
DISPOSITION_DATE DATE

Write off disposion set on this date.
CUSTOMER_SITE_USE_ID NUMBER

Customer Site Use ID
ORG_ID NUMBER

Org ID
CONTRACT_ID NUMBER

Contract ID
CONTRACT_NUMBER VARCHAR2 (250)
Contract Number

[top of page]

IEX.IEX_WRITEOFFS does not reference any database object

IEX.IEX_WRITEOFFS is referenced by following:

IEX
VIEW - IEX_WRITEOFFS#

[top of page]

Table: IEX_WRITEOFF_CONTRACTS

Description:
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_WRITEOFF_CONTRACTS_U1 UNIQUE APPS_TS_TX_IDX WRITEOFF_CONTRACT_ID
Columns
Name Datatype Length Mandatory Comments
WRITEOFF_CONTRACT_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

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

Foreign key to the lcontract.(OKL)
OBJECT_CODE VARCHAR2 (240) Y JTF_OBJECT code for the object assigne to the party.
OBJECT_ID NUMBER
Y JTF_OBJECT ID of the object assigned to the party.
DISPOSITION_CODE VARCHAR2 (30)
Code of the lookup with the description.
DISP_REASON_CODE VARCHAR2 (30)
Code of the lookup with the description.
ACTIVE_YN VARCHAR2 (1)
If the record has been deleted.
DELINQUENCY_ID NUMBER

Foreign key to IEX_DELINQUENCIES_ALL

[top of page]

IEX.IEX_WRITEOFF_CONTRACTS does not reference any database object

IEX.IEX_WRITEOFF_CONTRACTS is referenced by following:

IEX
VIEW - IEX_WRITEOFF_CONTRACTS#

[top of page]

Table: IEX_WRITEOFF_INVOICES

Description:
Comments
***** Warning: Oracle Internal Use Only *****

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

Indexes
Index Type Tablespace Column
IEX_WRITEOFF_INVOICES_U1 UNIQUE APPS_TS_TX_IDX WRITEOFF_INVOICE_ID
Columns
Name Datatype Length Mandatory Comments
WRITEOFF_INVOICE_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_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).
OBJECT_VERSION_NUMBER NUMBER
Y Standard HTML front end column
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_UPDATE_DATE DATE

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

Foreign key to the leasing invoice.(OKL)
LEASE_INV_LINE_ID NUMBER

foreign key to the lease invoice line.(OKL)
OBJECT_CODE VARCHAR2 (240) Y JTF_OBJECT code for the object assigne to the party.
OBJECT_ID NUMBER
Y JTF_OBJECT ID of the object assigned to the party.
DISPOSITION_CODE VARCHAR2 (240)
Code of the lookup with the description.
DISP_REASON_CODE VARCHAR2 (240)
Code of the lookup with the description.
ACTIVE_YN VARCHAR2 (240)
If the record has been deleted.
DELINQUENCY_ID NUMBER

Foreign key to IEX_DELINQUENCIES_ALL

[top of page]

IEX.IEX_WRITEOFF_INVOICES does not reference any database object

IEX.IEX_WRITEOFF_INVOICES is referenced by following:

IEX
VIEW - IEX_WRITEOFF_INVOICES#

[top of page]

Table: IEX_WRITEOFF_OBJECTS

Description: This entity holds information on writeoff objects..Writeoff Could occur at 3 different levels. This is again OKL specific. Contracts with a delinquent case could be written off. All Consolidated invoices within a contract can be written off
Primary Key: IEX_WRITEOFF_OBJECTS_PK1
  1. WRITEOFF_OBJECT_ID
Comments

This entity holds information on writeoff objects..Writeoff Could occur at 3 different levels. This is again OKL specific. Contracts with a delinquent case could be written off. All Consolidated invoices within a contract can be written off and atthe lowest level, an invoice within this consolidated could be written off.

Indexes
Index Type Tablespace Column
IEX_WRITEOFF_OBJECTS_U1 UNIQUE APPS_TS_TX_IDX WRITEOFF_OBJECT_ID
IEX_WRITEOFF_OBJECTS_N1 NONUNIQUE APPS_TS_TX_IDX WRITEOFF_ID
IEX_WRITEOFF_OBJECTS_N2 NONUNIQUE APPS_TS_TX_IDX CONTRACT_ID
IEX_WRITEOFF_OBJECTS_N3 NONUNIQUE APPS_TS_TX_IDX CONS_INVOICE_ID
IEX_WRITEOFF_OBJECTS_N4 NONUNIQUE APPS_TS_TX_IDX CONS_INVOICE_LINE_ID
Columns
Name Datatype Length Mandatory Comments
WRITEOFF_OBJECT_ID NUMBER
Y Primary Key Column
WRITEOFF_ID NUMBER
Y Foreign key to table iex_writeoffs
OBJECT_VERSION_NUMBER NUMBER (9) Y Column used for locking records during updates.
CONTRACT_ID NUMBER

Foreign key to iex_case_objects- object_id. This is contract_id from okc_k_headers_b
CONS_INVOICE_ID NUMBER

Foreign key to okl_cnsld_ar_hdrs_b
CONS_INVOICE_LINE_ID NUMBER

Foreign key to okl_cnsld_ar_lines_b
TRANSACTION_ID NUMBER
Y Foreign key to ar_payment_schedules.This is the payment shcedule against which the writeoffis to be done
ADJUSTMENT_AMOUNT NUMBER
Y Amount to be adjusted.
ADJUSTMENT_REASON_CODE VARCHAR2 (30) Y adjustment reason code for the adjustment
RECEVIABLES_ADJUSTMENT_ID NUMBER

Foreign key to table ar_adjustments_All. If the adjustment is created successfully, this will contain the adjustment ID.
REQUEST_ID NUMBER (15)
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 (15)
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).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
WRITEOFF_TYPE_ID NUMBER

Write off Type - CONSOLIDATED_INVOICE,CONTRACT,AR_INVOICE
WRITEOFF_TYPE VARCHAR2 (50)
Write off Type - CONSOLIDATED_INVOICE,CONTRACT,AR_INVOICE
WRITEOFF_STATUS VARCHAR2 (15)
Approved,Rejected, Waiting for Approval
CUSTOMER_TRX_ID NUMBER

Invoice ID
CUSTOMER_TRX_LINE_ID NUMBER

Invoice line ID

[top of page]

IEX.IEX_WRITEOFF_OBJECTS does not reference any database object

IEX.IEX_WRITEOFF_OBJECTS is referenced by following:

IEX
VIEW - IEX_WRITEOFF_OBJECTS#

[top of page]

Table: IEX_XML_QUERIES

Description: This table holds the query for xml publisher template.
Primary Key: IXQ_PK
  1. QUERY_ID
Comments

This table holds the query for xml publisher template.

Indexes
Index Type Tablespace Column
SYS_IL0000402254C00015$$ UNIQUE APPS_TS_TX_DATA
IEX_XML_QUERIES_U1 NONUNIQUE APPS_TS_TX_IDX QUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER (10) Y Query id for xdo template
STATEMENT VARCHAR2 (4000)
sql statement for xdo template
DESCRIPTION VARCHAR2 (4000)
query description
START_DATE DATE

valid query start date
END_DATE DATE

valid query end date
ENABLED_FLAG VARCHAR2 (10)
is this query enable
OBJECT_TYPE VARCHAR2 (20)
object type of this query - where is from
QUERY_LEVEL VARCHAR2 (20)
Query Level Customer/Account/Bill_to/Delinquent
CREATED_BY NUMBER

record creation by
CREATION_DATE DATE

record creation date
LAST_UPDATE_DATE DATE

record last update date
LAST_UPDATED_BY NUMBER

record last updated by
LAST_UPDATE_LOGIN NUMBER

record last update login from
OBJECT_VERSION_NUMBER NUMBER

object version number
ADDITIONAL_QUERY CLOB (4000)
Additional sql statement for xdo template
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEX.IEX_XML_QUERIES does not reference any database object

IEX.IEX_XML_QUERIES is referenced by following:

IEX
VIEW - IEX_XML_QUERIES#

[top of page]

Table: IEX_XML_REQUEST_HISTORIES

Description: xdo requested history for Collections
Comments

Collections'xdo request history

Indexes
Index Type Tablespace Column
SYS_IL0000402263C00004$$ UNIQUE APPS_TS_TX_DATA
SYS_IL0000402263C00005$$ UNIQUE APPS_TS_TX_DATA
SYS_IL0000402263C00022$$ UNIQUE APPS_TS_TX_DATA
SYS_IL0000402263C00038$$ UNIQUE APPS_TS_TX_DATA
SYS_IL0000402263C00040$$ UNIQUE APPS_TS_TX_DATA
SYS_IL0000402263C00041$$ UNIQUE APPS_TS_TX_DATA
IEX_XML_REQUEST_HISTORIES_N1 NONUNIQUE APPS_TS_TX_IDX CREATION_DATE
IEX_XML_REQUEST_HISTORIES_N2 NONUNIQUE APPS_TS_TX_IDX STATUS
WORKER_ID
IEX_XML_REQUEST_HISTORIES_N3 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
IEX_XML_REQUEST_HISTORIES_U1 NONUNIQUE APPS_TS_TX_IDX XML_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
XML_REQUEST_ID NUMBER (10) Y request id from xdo when generated
QUERY_TEMP_ID NUMBER (10) Y sent template id
STATUS VARCHAR2 (40) Y status of delivery
DOCUMENT BLOB (4000)
sent document
XMLDATA CLOB (4000)
xml data for the template
METHOD VARCHAR2 (10)
delivery method - email/fax/printer
DESTINATION VARCHAR2 (2000)
deliver destination email/phone/printer name
OBJECT_TYPE VARCHAR2 (100)
delivery object type
OBJECT_ID NUMBER (15)
delivery object id
VIEW_BY VARCHAR2 (20)
level when delivered (customer/account/site/delinquecy)
RESOURCE_ID NUMBER

collector resource id
PARTY_ID NUMBER (15)
delivered party id
CUST_ACCOUNT_ID NUMBER (15)
delivered account id
CUST_SITE_USE_ID NUMBER (15)
delivered customer site use id
DELINQUENCY_ID NUMBER

delivered delinquency id
CREATED_BY NUMBER

record created by
CREATION_DATE DATE

record created date
LAST_UPDATE_DATE DATE

record last update date
LAST_UPDATED_BY NUMBER

record last updated by
LAST_UPDATE_LOGIN NUMBER

record last update login by
OBJECT_VERSION_NUMBER NUMBER

record object version number
HTML_DOCUMENT BLOB (4000)
sent HTML document
SUBJECT VARCHAR2 (4000)
Subject of the Dunning letter email
REQUEST_ID NUMBER

Concurrent program request id that processed this letter
WORKER_ID NUMBER

Child request uses this Worker Id to identify the requests that needs to
CONFIRMATION_MODE VARCHAR2 (10)
Preview Action(possible values Confirmed/Rejected)
CONC_REQUEST_ID NUMBER

It stores the iex: send dunning concurrent program's request id
LANGUAGE VARCHAR2 (10)
Template output will be generated using this language
TERRITORY VARCHAR2 (10)
Template output will be generated using this territory
PRINTER_URI VARCHAR2 (240)
URI for printer
JOB_ID NUMBER

Job ID
SJOB_ID VARCHAR2 (240)
SJob ID
JOB_URI VARCHAR2 (240)
Job URI
FAILURE_REASON VARCHAR2 (240)
Reason for failure
ORG_ID NUMBER

Organization Identifier
DOCUMENT_TYPE VARCHAR2 (240)
Type of email dunning letter(Inline/PDF attachment/RTF attachment/XLS attachment)
ADDT_QUERY_TEMP_ID NUMBER

sent template id
ADDT_XMLDATA CLOB (4000)
xml data for the additional template
ADDT_STATUS VARCHAR2 (75)
status of delivery
ADDT_HTML_DOCUMENT BLOB (4000)
sent document
ADDT_DOCUMENT BLOB (4000)
sent document

[top of page]

IEX.IEX_XML_REQUEST_HISTORIES does not reference any database object

IEX.IEX_XML_REQUEST_HISTORIES is referenced by following:

IEX
VIEW - IEX_XML_REQUEST_HISTORIES#

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract