[Home] [Help] [Dependency Information]
Object Name: | OKL_ACCRUAL_GNRTNS_ALL |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_ACCRUAL_GNRTNS_ALL |
Subobject Name: | |
Status: | VALID |
The accrual rules are used by the accrual concurrent program to determine the accrual status of each contract. The rules include names representing data values evaluated by the accrual program. For example: Limit Days (the number of days a customer invoice has been outstanding since the due date), Number of Bills Unpaid (the number of outstanding invoices or unpaid invoices for a contract) and their comparison to literals. Each row in the table is strung together to create a logical expression. The sequence number orders the rows.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_ACCRUAL_GNRTNS_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_ACCRUAL_GNRTNS_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LINE_NUMBER
VERSION ORG_ID |
OKL_ACCRUAL_GNRTNS_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACRO_CODE |
OKL_ACCRUAL_GNRTNS_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ARLO_CODE |
OKL_ACCRUAL_GNRTNS_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ARO_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
LINE_NUMBER | NUMBER | (5) | Yes | Line number |
VERSION | VARCHAR2 | (24) | Yes | Version |
ARO_CODE | VARCHAR2 | (30) | Yes | The unique code for an accrual rule operand. Example: Limit Days, Number of Bills Unpaid. Foreign key to FND_LOOKUP_VALUES |
ARLO_CODE | VARCHAR2 | (30) | The unique code for an accrual rule logical operator. Example: AND, OR. Foreign key to FND_LOOKUP_VALUES | |
ACRO_CODE | VARCHAR2 | (30) | Yes | The unique code for an accrual rule relational operator. Example: >, >=, <. <=, <>. Foreign key to FND_LOOKUP_VALUES |
RIGHT_OPERAND_LITERAL | VARCHAR2 | (90) | Yes | Denotes the value to be compared with an accrual rule operand value. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
LEFT_PARENTHESES | VARCHAR2 | (3) | Left parentheses for the accrual rule to be specified by the user. Example: ( | |
RIGHT_PARENTHESES | VARCHAR2 | (3) | Right parentheses for the accrual rule to be specified by the user. Example: ) | |
FROM_DATE | DATE | Yes | From date | |
TO_DATE | DATE | To date | ||
ORG_ID | NUMBER | (15) | Operating unit identifier | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, LINE_NUMBER
, VERSION
, ARO_CODE
, ARLO_CODE
, ACRO_CODE
, RIGHT_OPERAND_LITERAL
, OBJECT_VERSION_NUMBER
, LEFT_PARENTHESES
, RIGHT_PARENTHESES
, FROM_DATE
, TO_DATE
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_ACCRUAL_GNRTNS_ALL;
OKL.OKL_ACCRUAL_GNRTNS_ALL does not reference any database object
OKL.OKL_ACCRUAL_GNRTNS_ALL is referenced by following:
|
|
|