[Home] [Help]
[Dependency Information]
Object Name: | PA_RULES |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
PA_RULES stores implementation-defined formulas for
deriving accounting flexfield segment values using
AutoAccounting.
.
.
Tablespace: | ![]() |
---|---|
PCT Free: | 3 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_RULES_U1 | NORMAL | UNIQUE |
![]() |
![]() |
PA_RULES_U2 | NORMAL | UNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | (15) | Yes | The system-generated number that uniquely identifies the rule |
RULE_NAME | VARCHAR2 | (60) | Yes | The implementation-defined name that uniquely identifies the rule |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
RULE_TYPE | VARCHAR2 | (1) | Yes | The method by which the segment value is derived from the intermediate value |
KEY_SOURCE | VARCHAR2 | (1) | Yes | The source of the intermediate value |
DESCRIPTION | VARCHAR2 | (250) | Description of the rule | |
USER_UPDATABLE_FLAG | VARCHAR2 | (1) | Flag that indicates whether the rule can be updated by a user. All rules used by Oracle Projects are user entered and user updateable. This flag is always set to 'Y' | |
CONSTANT_VALUE | VARCHAR2 | (250) | The value of the constant intermediate value source | |
KEY_PARAMETER_ID | NUMBER | (15) | The identifier of the parameter from which the intermediate value is derived for the rule that derives the intermediate value from a parameter | |
SEGMENT_VALUE_LOOKUP_SET_ID | NUMBER | (15) | The identifier of the segment value lookup set from which the segment value is derived from the intermediate value | |
SELECT_QUALIFIERS_AMT | NUMBER | (1) | The number of AutoAccounting qualifiers that can be selected. This value is not currently used by AutoAccounting | |
SELECT_MULTIPLE_ROWS_FLAG | VARCHAR2 | (1) | Flag that indicates whether returning multiple rows with a SQL statement rule is acceptable for the rule. Multiple rows from a SQL statement are not currently supported by AutoAccounting | |
SELECT_STATEMENT | LONG | (0) | The SQL statement that selects the intermediate value for a rule defined to use SQL statements |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, RULE_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RULE_TYPE
, KEY_SOURCE
, DESCRIPTION
, USER_UPDATABLE_FLAG
, CONSTANT_VALUE
, KEY_PARAMETER_ID
, SEGMENT_VALUE_LOOKUP_SET_ID
, SELECT_QUALIFIERS_AMT
, SELECT_MULTIPLE_ROWS_FLAG
, SELECT_STATEMENT
FROM PA.PA_RULES;
PA.PA_RULES does not reference any database object
PA.PA_RULES is referenced by following:
|
|
|