eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IEX_STRATEGIES_BALI_V

Object Details

Object Name:	IEX_STRATEGIES_BALI_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

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

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
STRATEGY_ID	NUMBER	(15)
STRATEGY_TEMPLATE_ID	NUMBER	(15)
STRATEGY_NAME	VARCHAR2	(240)	Stores actual note text. Typically will hold the entire note, or up to 2000 characters if the note is very long.
CATEGORY_TYPE_MEANING	VARCHAR2	(80)	QuickCode meaning
CATEGORY	VARCHAR2	(60)
RANK	VARCHAR2	(10)
STATUS	VARCHAR2	(30)
STATUS_MEANING	VARCHAR2	(80)	QuickCode meaning
VALID_FROM	DATE		Low end of valid period
VALID_TO	DATE		High end of valid period
STRATEGY_SCORE	NUMBER
RESCORE_YN	VARCHAR2	(2)
DELINQUENCY_ID	NUMBER
ACCOUNT_NUMBER	VARCHAR2	(30)	Account Number
OVERDUE_AMT	NUMBER
CUST_ACCOUNT_ID	NUMBER	(15)
PARTY_ID	NUMBER	(15)
OBJECT_TYPE	VARCHAR2	(30)
OBJECT_ID	NUMBER
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
TRX_ID	NUMBER
TRX_NUMBER	VARCHAR2	(20)
CASE_ID	NUMBER
CASE_NUMBER	NUMBER
JTF_OBJECT_TYPE	VARCHAR2	(30)
JTF_OBJECT_NAME	VARCHAR2	(30)
JTF_OBJECT_ID	NUMBER	(15)
STRATEGY_LEVEL	NUMBER
STRATEGY_LEVEL_CODE	VARCHAR2	(11)
SCORE	NUMBER
CUSTOMER_SITE_USE_ID	NUMBER
LOCATION	VARCHAR2	(40)
ADDRESS	VARCHAR2	(307)
PARTY_NAME	VARCHAR2	(360)
ORG_ID	NUMBER
OPERATING_UNIT	VARCHAR2	(240)
ARCHIVED_CODE	CHAR	(1)
ARCHIVED	VARCHAR2	(4000)
HOLD_START_DATE	DATE
RELEASE_DATE	DATE

Query Text

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


SELECT STRATEGY_ID
,      STRATEGY_TEMPLATE_ID
,      STRATEGY_NAME
,      CATEGORY_TYPE_MEANING
,      CATEGORY
,      RANK
,      STATUS
,      STATUS_MEANING
,      VALID_FROM
,      VALID_TO
,      STRATEGY_SCORE
,      RESCORE_YN
,      DELINQUENCY_ID
,      ACCOUNT_NUMBER
,      OVERDUE_AMT
,      CUST_ACCOUNT_ID
,      PARTY_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      TRX_ID
,      TRX_NUMBER
,      CASE_ID
,      CASE_NUMBER
,      JTF_OBJECT_TYPE
,      JTF_OBJECT_NAME
,      JTF_OBJECT_ID
,      STRATEGY_LEVEL
,      STRATEGY_LEVEL_CODE
,      SCORE
,      CUSTOMER_SITE_USE_ID
,      LOCATION
,      ADDRESS
,      PARTY_NAME
,      ORG_ID
,      OPERATING_UNIT
,      ARCHIVED_CODE
,      ARCHIVED
,      HOLD_START_DATE
,      RELEASE_DATE
FROM APPS.IEX_STRATEGIES_BALI_V;