[Home] [Help] [Dependency Information]
Object Name: | FA_PROJ_PARAM_RUN |
---|---|
Object Type: | TABLE |
Owner: | FA |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_PROJ_PARAM_RUN_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_DATA |
REQUEST_ID
BOOK_TYPE_CODE1 PERIOD_NAME |
FA_PROJ_PARAM_RUN_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_DATA |
REQUEST_ID
BOOK_TYPE_CODE2 PERIOD_NAME |
FA_PROJ_PARAM_RUN_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_DATA |
REQUEST_ID
BOOK_TYPE_CODE3 PERIOD_NAME |
FA_PROJ_PARAM_RUN_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_DATA |
REQUEST_ID
BOOK_TYPE_CODE4 PERIOD_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | |
BOOK_TYPE_CODE1 | VARCHAR2 | (30) | ||
BOOK_TYPE_CODE2 | VARCHAR2 | (30) | ||
BOOK_TYPE_CODE3 | VARCHAR2 | (30) | ||
BOOK_TYPE_CODE4 | VARCHAR2 | (30) | ||
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
PERIOD_COUNT | NUMBER | (4) | Yes | |
FISCAL_YEAR | NUMBER | (4) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, BOOK_TYPE_CODE1
, BOOK_TYPE_CODE2
, BOOK_TYPE_CODE3
, BOOK_TYPE_CODE4
, PERIOD_NAME
, PERIOD_COUNT
, FISCAL_YEAR
, CURRENCY_CODE
, SET_OF_BOOKS_ID
FROM FA.FA_PROJ_PARAM_RUN;
FA.FA_PROJ_PARAM_RUN does not reference any database object
FA.FA_PROJ_PARAM_RUN is referenced by following:
|
|
|