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

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

TABLE: CSC.CSC_PROF_CHECK_RESULTS

Object Details

Object Name:	CSC_PROF_CHECK_RESULTS
Object Type:	TABLE
Owner:	CSC
FND Design Data:	CSC.CSC_PROF_CHECK_RESULTS
Subobject Name:
Status:	VALID

CSC_PROF_BLOCK_RESULTS stores the value of the profile checks per party and account

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSC_PROF_CHECK_RESULTS_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PARTY_ID
CSC_PROF_CHECK_RESULTS_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CHECK_ID PARTY_ID CUST_ACCOUNT_ID
CSC_PROF_CHECK_RESULTS_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CUST_ACCOUNT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHECK_RESULTS_ID	NUMBER		Yes	Unique identifier of the record
CHECK_ID	NUMBER		Yes	References CHECK_ID in CSC_PROF_CHECKS_B
PARTY_ID	NUMBER		Yes	References PARTY_ID in HZ_PARTIES
CUST_ACCOUNT_ID	NUMBER			References CUST_ACCOUNT_ID in HZ_CUST_ACCOUNTS_ALL
CUST_ACCOUNT_ORG_ID	NUMBER
VALUE	VARCHAR2	(240)		The result of the profile check
CURRENCY_CODE	VARCHAR2	(15)		The currency code of the value
GRADE	VARCHAR2	(9)		The grade of the the value
CREATED_BY	NUMBER		Yes	Standard Who colum
CREATION_DATE	DATE		Yes	Standard Who colum
LAST_UPDATED_BY	NUMBER		Yes	Standard Who colum
LAST_UPDATE_DATE	DATE		Yes	Standard Who colum
LAST_UPDATE_LOGIN	NUMBER			Standard Who colum
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
RATING_CODE	VARCHAR2	(240)		Specifies the ratings available for a check variable, eg Low
COLOR_CODE	VARCHAR2	(240)		The color of the rating
RESULTS_THRESHOLD_FLAG	VARCHAR2	(3)		A flag, checking the value and calculating if the Check should appear on the Profile Window

Query Text

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


SELECT CHECK_RESULTS_ID
,      CHECK_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      CUST_ACCOUNT_ORG_ID
,      VALUE
,      CURRENCY_CODE
,      GRADE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      RATING_CODE
,      COLOR_CODE
,      RESULTS_THRESHOLD_FLAG
FROM CSC.CSC_PROF_CHECK_RESULTS;

Dependencies

[top of page]

CSC.CSC_PROF_CHECK_RESULTS does not reference any database object

CSC.CSC_PROF_CHECK_RESULTS is referenced by following:

APPS: CSC_PROF_CHECK_RESULTS