[Home] [Help] [Dependency Information]
Object Name: | CSC_CONDITION_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_CONDITION_HEADERS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Defines a Condition to be evaluated upon the occurrence of an Action.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONDITION_HEADER_ID | NUMBER | Yes | Primary key column of OKC_CONDITION_HEADERS_B. | |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Indicates a value was changed in another language. Not fully implemented in 11i |
ACTION_ID | NUMBER | Yes | Primary key column of OKC_ACTIONS_B | |
OBJECT_ID | NUMBER | Surrogate key used for primary unique identifiers. | ||
DESCRIPTION | VARCHAR2 | (1995) | User entered free format text description. | |
SHORT_DESCRIPTION | VARCHAR2 | (600) | User entered free format text description. | |
COMMENTS | VARCHAR2 | (1995) | User entered free format text comment. | |
ONE_TIME_YN | VARCHAR2 | (3) | Yes | Yes/No field. |
CONDITION_NAME | VARCHAR2 | (150) | Yes | Condition name. |
CONDITION_VALID_YN | VARCHAR2 | (3) | Yes | Yes/No field. |
BEFORE_AFTER | VARCHAR2 | (3) | Before/After field. | |
TEMPLATE_YN | VARCHAR2 | (3) | Yes | Yes/No field to denote if a template was used. |
DATE_ACTIVE | DATE | Yes | Date condition became active. | |
DATE_INACTIVE | DATE | Date condition became inactive. | ||
CONDITION_HEADER_TYPE | VARCHAR2 | (30) | Yes | Condition type |
ACTION_NAME | VARCHAR2 | (150) | Yes | Action name. |
ACTION_DESCRIPTION | VARCHAR2 | (1995) | User entered free format text description for an Action. | |
ACTION_TYPE | VARCHAR2 | (30) | Yes | Action type |
COUNTER_ACTION_YN | VARCHAR2 | (3) | Yes | Yes/No field. |
ACTION_ENABLED | VARCHAR2 | (3) | Yes | Yes/No field. |
Cut, paste (and edit) the following text to query this object:
SELECT CONDITION_HEADER_ID
, SFWT_FLAG
, ACTION_ID
, OBJECT_ID
, DESCRIPTION
, SHORT_DESCRIPTION
, COMMENTS
, ONE_TIME_YN
, CONDITION_NAME
, CONDITION_VALID_YN
, BEFORE_AFTER
, TEMPLATE_YN
, DATE_ACTIVE
, DATE_INACTIVE
, CONDITION_HEADER_TYPE
, ACTION_NAME
, ACTION_DESCRIPTION
, ACTION_TYPE
, COUNTER_ACTION_YN
, ACTION_ENABLED
FROM APPS.CSC_CONDITION_HEADERS_V;
APPS.CSC_CONDITION_HEADERS_V is not referenced by any database object
|
|
|