[Home] [Help] [Dependency Information]
Object Name: | XLA_CONDITIONS_T |
---|---|
Object Type: | TABLE |
Owner: | XLA |
FND Design Data: | XLA.XLA_CONDITIONS_T |
Subobject Name: | |
Status: | VALID |
Interface table to load the conditions associated to the ADR rule details into SLA.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONDITION_ID | NUMBER | (15) | Yes | This is the identifier of the condition. |
APPLICATION_ID | NUMBER | (15) | Yes | This is the application id. |
AMB_CONTEXT_CODE | VARCHAR2 | (30) | Yes | This is the context code associated to the account derivation rule. |
SEGMENT_RULE_DETAIL_ID | NUMBER | (15) | Yes | This is the identifier of the detail. |
USER_SEQUENCE | NUMBER | (15) | Yes | This is the user sequence of the condition. |
BRACKET_LEFT_CODE | VARCHAR2 | (1) | This is the left bracket of the condition. | |
BRACKET_RIGHT_CODE | VARCHAR2 | (1) | This is the right bracket of the condition. | |
VALUE_TYPE_CODE | VARCHAR2 | (1) | Yes | This is the type of the value of the condition. |
SOURCE_APPLICATION_ID | NUMBER | (15) | This is the application id of the source. | |
SOURCE_TYPE_CODE | VARCHAR2 | (1) | This is the type code of the source. | |
SOURCE_CODE | VARCHAR2 | (30) | This is the code of the source. | |
FLEXFIELD_SEGMENT_CODE | VARCHAR2 | (30) | This is the code of the flexfield segment. | |
VALUE_FLEXFIELD_SEGMENT_CODE | VARCHAR2 | (30) | This is the code of the flexfield segment used as a value. | |
VALUE_SOURCE_APPLICATION_ID | NUMBER | (15) | This is the application id of the source used as a value. | |
VALUE_SOURCE_TYPE_CODE | VARCHAR2 | (1) | This is the type code of the source used as a value. | |
VALUE_SOURCE_CODE | VARCHAR2 | (30) | This is the code of the source used as a value. | |
VALUE_CONSTANT | VARCHAR2 | (240) | This is the constant used as a value. | |
LINE_OPERATOR_CODE | VARCHAR2 | (1) | This is the code of the line operator. | |
LOGICAL_OPERATOR_CODE | VARCHAR2 | (1) | This is the code of the logical operator. | |
INDEPENDENT_VALUE_CONSTANT | VARCHAR2 | (30) | This is the constant used as independent value. | |
ERROR_VALUE | NUMBER | (15) | Yes | This indicates the error status of the row after processed by the ADR interface program. |
Cut, paste (and edit) the following text to query this object:
SELECT CONDITION_ID
, APPLICATION_ID
, AMB_CONTEXT_CODE
, SEGMENT_RULE_DETAIL_ID
, USER_SEQUENCE
, BRACKET_LEFT_CODE
, BRACKET_RIGHT_CODE
, VALUE_TYPE_CODE
, SOURCE_APPLICATION_ID
, SOURCE_TYPE_CODE
, SOURCE_CODE
, FLEXFIELD_SEGMENT_CODE
, VALUE_FLEXFIELD_SEGMENT_CODE
, VALUE_SOURCE_APPLICATION_ID
, VALUE_SOURCE_TYPE_CODE
, VALUE_SOURCE_CODE
, VALUE_CONSTANT
, LINE_OPERATOR_CODE
, LOGICAL_OPERATOR_CODE
, INDEPENDENT_VALUE_CONSTANT
, ERROR_VALUE
FROM XLA.XLA_CONDITIONS_T;
XLA.XLA_CONDITIONS_T does not reference any database object
XLA.XLA_CONDITIONS_T is referenced by following:
|
|
|