[Home] [Help] [Dependency Information]
Object Name: | JAI_RGM_TERMS# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TERM_ID | NUMBER | Yes | ||
TERM_NAME | VARCHAR2 | (50) | Yes | |
START_PERIOD | VARCHAR2 | (20) | ||
START_FREQUENCY_DAY | VARCHAR2 | (10) | ||
START_DAY_OF_MONTH | NUMBER | (9) | ||
NUMBER_OF_INSTALMENTS | NUMBER | (9) | ||
INSTALMENT_FREQUENCY | NUMBER | (9) | ||
INSTALMENT_PERIOD | VARCHAR2 | (20) | ||
FREQUENCY_DAY | VARCHAR2 | (10) | ||
DAY_OF_MONTH | NUMBER | (9) | ||
DEFAULT_TERM_FLAG | VARCHAR2 | (1) | ||
TERM_IN_USE_FLAG | VARCHAR2 | (1) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | (9) |
Cut, paste (and edit) the following text to query this object:
SELECT TERM_ID
, TERM_NAME
, START_PERIOD
, START_FREQUENCY_DAY
, START_DAY_OF_MONTH
, NUMBER_OF_INSTALMENTS
, INSTALMENT_FREQUENCY
, INSTALMENT_PERIOD
, FREQUENCY_DAY
, DAY_OF_MONTH
, DEFAULT_TERM_FLAG
, TERM_IN_USE_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, OBJECT_VERSION_NUMBER
FROM JA.JAI_RGM_TERMS#;
|
|
|