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

VIEW: APPS.CSC_CONDITION_LINE_DETAILS_V

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

View Type

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


Each Condition Line expresses a Boolean condition. Multiple Condition Lines may be and'd or or'd together and nested using parenthesis.


[View Source]

Columns
Name Datatype Length Mandatory Comments
AAE_ID NUMBER

Primary key of OKC_ACTION_ATTRIBUTES_B.
CONDITION_TYPE VARCHAR2 (10)
type of Condition Expression, Function, Counter.
CNL_TYPE VARCHAR2 (10) Yes Surrogate key used for primary unique identifiers.
DESCRIPTION VARCHAR2 (1995)
User entered free format text description.
PDF_ID NUMBER

Primary key of OKC_PROCESS_DEFS_B.
CNH_ID NUMBER
Yes Primary Key of OKC_CONDITION_HEADERS_B
SORTSEQ NUMBER (10) Yes Serial Numbers.
LEFT_PARENTHESIS VARCHAR2 (90)
Left parenthesis.
LEFT_VALUE VARCHAR2 (4000)
Surrogate key used for primary unique identifiers.
RELATIONAL_OPERATOR VARCHAR2 (36)
Relational operator.
RIGHT_OPERAND VARCHAR2 (4000)
Right operand.
RIGHT_PARENTHESIS VARCHAR2 (90)
Right parenthesis.
LOGICAL_OPERATOR VARCHAR2 (9)
Logical operator.
Query Text

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


SELECT AAE_ID
,      CONDITION_TYPE
,      CNL_TYPE
,      DESCRIPTION
,      PDF_ID
,      CNH_ID
,      SORTSEQ
,      LEFT_PARENTHESIS
,      LEFT_VALUE
,      RELATIONAL_OPERATOR
,      RIGHT_OPERAND
,      RIGHT_PARENTHESIS
,      LOGICAL_OPERATOR
FROM APPS.CSC_CONDITION_LINE_DETAILS_V;

Dependencies

[top of page]

APPS.CSC_CONDITION_LINE_DETAILS_V references the following:

SchemaAPPS
PL/SQL PackageCSC_CORE_UTILS_PVT - show dependent code
ViewOKC_ACTION_ATTRIBUTES_V
ViewOKC_CONDITION_LINES_V
ViewOKC_PROCESS_DEFS_V

APPS.CSC_CONDITION_LINE_DETAILS_V is not referenced by any database object