DBA Data[Home] [Help] [Dependency Information]

TABLE: FA.FA_SORP_UPG_CAGF_HIST

Object Details
Object Name: FA_SORP_UPG_CAGF_HIST
Object Type: TABLE
Owner: FA
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BOOK_TYPE_CODE VARCHAR2 (15)
Book name
ASSET_ID NUMBER

Asset identification number
ASSET_NUMBER VARCHAR2 (50)
Asset Number
ASSET_DESCRIPTION VARCHAR2 (200)
Asset Description
DATE_PLACED_IN_SERVICE DATE

Date Placed In Service
CATEGORY_NAME VARCHAR2 (250)
Category Name
CURRENT_COST NUMBER

Current Cost
DEPRICIATION_RESERVE NUMBER

Depriciation Reserve
REVALUATION_RESERVE NUMBER

Revaluation Reserve
IMPAIRMENT_RESERVE NUMBER

Impairment Reserve
CAPITAL_ADJUSTMENT_ACCT_AMOUNT NUMBER

Capital Adjustment Balance
GENERAL_FUND_ACCT_AMOUNT NUMBER

General Fund Balance
REQUEST_ID NUMBER

Concurent Porgram Request Id
REPORT_MODE VARCHAR2 (10)
Report Mode
PERIOD_NAME VARCHAR2 (25)
Period Name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BOOK_TYPE_CODE
,      ASSET_ID
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      DATE_PLACED_IN_SERVICE
,      CATEGORY_NAME
,      CURRENT_COST
,      DEPRICIATION_RESERVE
,      REVALUATION_RESERVE
,      IMPAIRMENT_RESERVE
,      CAPITAL_ADJUSTMENT_ACCT_AMOUNT
,      GENERAL_FUND_ACCT_AMOUNT
,      REQUEST_ID
,      REPORT_MODE
,      PERIOD_NAME
FROM FA.FA_SORP_UPG_CAGF_HIST;

Dependencies

[top of page]

FA.FA_SORP_UPG_CAGF_HIST does not reference any database object

FA.FA_SORP_UPG_CAGF_HIST is referenced by following:

SchemaFA
ViewFA_SORP_UPG_CAGF_HIST#