[Home] [Help] [Dependency Information]
Object Name: | CSC_CONDITION_LINE_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_CONDITION_LINE_DETAILS_V |
Subobject Name: | |
Status: | VALID |
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.
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. |
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;
APPS.CSC_CONDITION_LINE_DETAILS_V is not referenced by any database object
|
|
|