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

VIEW: APPS.CSC_CONDITION_OUTCOMES_V

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

View Type

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


Registration of a PL/SQL process or a workflow with the application for use as an OUTCOME, CONTRACT PROCESS, QA PROCESS, or FUNCTION in a CONDITION LINE.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key column.
PDF_TYPE VARCHAR2 (30) Yes Process definition type.
SFWT_FLAG VARCHAR2 (3) Yes Indicates a value was changed in another language. Not fully implemented in 11i
DESCRIPTION VARCHAR2 (1995)
User entered free format text description.
SHORT_DESCRIPTION VARCHAR2 (600)
User entered free format text description.
COMMENTS VARCHAR2 (1995)
User entered comment.
USAGE VARCHAR2 (60) Yes Process usage.
NAME VARCHAR2 (150) Yes Process definition name.
EXECUTABLE_NAME VARCHAR2 (150)
Descriptive Process definition type.
WF_NAME VARCHAR2 (150)
Workflow name.
WF_PROCESS_NAME VARCHAR2 (150)
Workflow process name.
PROCEDURE_NAME VARCHAR2 (90)
PLSQL process procedure name.
PACKAGE_NAME VARCHAR2 (90)
PLSQL process package name.
PROCESS_DEFINITION_TYPE VARCHAR2 (30)
Descriptive Process definition type.
BEGIN_DATE DATE
Yes Begin Date
END_DATE DATE

End Date
Query Text

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


SELECT ID
,      PDF_TYPE
,      SFWT_FLAG
,      DESCRIPTION
,      SHORT_DESCRIPTION
,      COMMENTS
,      USAGE
,      NAME
,      EXECUTABLE_NAME
,      WF_NAME
,      WF_PROCESS_NAME
,      PROCEDURE_NAME
,      PACKAGE_NAME
,      PROCESS_DEFINITION_TYPE
,      BEGIN_DATE
,      END_DATE
FROM APPS.CSC_CONDITION_OUTCOMES_V;

Dependencies

[top of page]

APPS.CSC_CONDITION_OUTCOMES_V references the following:

SchemaAPPS
ViewOKC_PROCESS_DEFS_V

APPS.CSC_CONDITION_OUTCOMES_V is not referenced by any database object