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

VIEW: APPS.CSC_PROF_CHECK_RESULTS_V

Object Details
Object Name: CSC_PROF_CHECK_RESULTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSC.CSC_PROF_CHECK_RESULTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View of CSC_PROF_CHECK_RESULTS. This view will give us information on the result and grade of the Check Variables when the Profile Engine is run.


[View Source]

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
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 Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
Query Text

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


SELECT CHECK_RESULTS_ID
,      CHECK_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      VALUE
,      CURRENCY_CODE
,      GRADE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.CSC_PROF_CHECK_RESULTS_V;

Dependencies

[top of page]

APPS.CSC_PROF_CHECK_RESULTS_V references the following:

SchemaAPPS
SynonymCSC_PROF_CHECK_RESULTS

APPS.CSC_PROF_CHECK_RESULTS_V is not referenced by any database object