[Home] [Help] [Dependency Information]
Object Name: | AR_STATEMENT_CYCLE_INTERVALS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_STATEMENT_CYCLE_INTERVALS |
Subobject Name: | |
Status: | VALID |
The AR_STATEMENT_CYCLE_INTERVALS table stores information about your statement cycle intervals. Oracle Receivables uses these intervals as list of values choices in the Statement Cycles window. Valid intervals include weekly, monthly, and quarterly intervals.
.
The primary key for this table is INTERVAL_NAME.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERVAL_NAME | VARCHAR2 | (30) | Yes | Name of the interval |
LOW_DAY | NUMBER | Yes | First date when the interval is active | |
HIGH_DAY | NUMBER | Yes | Last date when the interval is active | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT INTERVAL_NAME
, LOW_DAY
, HIGH_DAY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM AR.AR_STATEMENT_CYCLE_INTERVALS;
AR.AR_STATEMENT_CYCLE_INTERVALS does not reference any database object
AR.AR_STATEMENT_CYCLE_INTERVALS is referenced by following:
|
|
|