[Home] [Help] [Dependency Information]
Object Name: | FA_SORP_UPG_CAT# |
---|---|
Object Type: | VIEW |
Owner: | FA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOOK_TYPE_CODE | VARCHAR2 | (15) | ||
CATEGORY_ID | NUMBER | |||
REVAL_AMORTIZATION_ACCT | VARCHAR2 | (25) | ||
REVAL_AMORT_ACCOUNT_CCID | NUMBER | |||
IMPAIR_EXPENSE_ACCT | VARCHAR2 | (25) | ||
IMPAIR_EXPENSE_ACCOUNT_CCID | NUMBER | |||
IMPAIR_RESERVE_ACCT | VARCHAR2 | (25) | ||
IMPAIR_RESERVE_ACCOUNT_CCID | NUMBER | |||
CAPITAL_ADJ_ACCT | VARCHAR2 | (25) | ||
CAPITAL_ADJ_ACCOUNT_CCID | NUMBER | |||
GENERAL_FUND_ACCT | VARCHAR2 | (25) | ||
GENERAL_FUND_ACCOUNT_CCID | NUMBER | |||
VALIDATION_FLAG | VARCHAR2 | (1) | ||
CATEGORY_FLEX | VARCHAR2 | (500) | ||
RUN_MODE | VARCHAR2 | (10) | ||
RUN_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_TYPE_CODE
, CATEGORY_ID
, REVAL_AMORTIZATION_ACCT
, REVAL_AMORT_ACCOUNT_CCID
, IMPAIR_EXPENSE_ACCT
, IMPAIR_EXPENSE_ACCOUNT_CCID
, IMPAIR_RESERVE_ACCT
, IMPAIR_RESERVE_ACCOUNT_CCID
, CAPITAL_ADJ_ACCT
, CAPITAL_ADJ_ACCOUNT_CCID
, GENERAL_FUND_ACCT
, GENERAL_FUND_ACCOUNT_CCID
, VALIDATION_FLAG
, CATEGORY_FLEX
, RUN_MODE
, RUN_DATE
FROM FA.FA_SORP_UPG_CAT#;
|
|
|