[Home] [Help] [Dependency Information]
Object Name: | FV_SF133_DEFINITIONS_COLS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_SF133_DEFINITIONS_COLS_TEMP |
Subobject Name: | |
Status: | VALID |
FV_SF133_DEFINITIONS_ COLS_TEMP is a temporary table populated with summary data calculated by the SF 133 Report on Budget Execution process
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FV_SF133_DEFINITIONS_COLS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SF133_FUND_VALUE
SF133_LINE_ID SF133_COLUMN_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SF133_FUND_VALUE | VARCHAR2 | (25) | Yes | Actual value representing a fund |
SF133_LINE_ID | NUMBER | (15) | Yes | Unique number that identifies parent report line for SF 133 Report on Budget Execution for a Set of Books |
SF133_COLUMN_NUMBER | NUMBER | (15) | Yes | Identifies a column on SF 133 Report on Budget Execution |
SF133_COLUMN_AMOUNT | NUMBER | Yes | Dollar amount calculated by SF 133 Report on Budget Execution process that is to be printed in associated line and column of report | |
SF133_AMOUNT_NOT_SHOWN | NUMBER | Yes | True value of amount before sign changes | |
SF133_COLUMN_2_AMOUNT | NUMBER | Dollar amount calculated by SF 133 Report on Budget Execution process for one year prior to passed period year that is to be printed in associated line and column of report | ||
SF133_AMT_2_NOT_SHOWN | NUMBER | True value of SF133_COLUMN_2_AMOUNT before sign changes | ||
SF133_COLUMN_3_AMOUNT | NUMBER | Dollar amount calculated by SF 133 Report on Budget Execution process for two years prior to passed period year that is to be printed in associated line and column of report | ||
SF133_AMT_3_NOT_SHOWN | NUMBER | True value of SF133_COLUMN_3_AMOUNT before sign changes | ||
SF133_COLUMN_4_AMOUNT | NUMBER | Dollar amount calculated by SF 133 Report on Budget Execution process for three years prior to passed period year that is to be printed in associated line and column of report | ||
SF133_AMT_4_NOT_SHOWN | NUMBER | True value of SF133_COLUMN_4_AMOUNT before sign changes | ||
SF133_COLUMN_5_AMOUNT | NUMBER | Dollar amount calculated by SF 133 Report on Budget Execution process for four years prior to passed period year that is to be printed in associated line and column of report | ||
SF133_AMT_5_NOT_SHOWN | NUMBER | True value of SF133_COLUMN_5_AMOUNT before sign changes | ||
SF133_COLUMN_6_AMOUNT | NUMBER | Dollar amount calculated by SF 133 Report on Budget Execution process for five years prior to passed period year that is to be printed in associated line and column of report | ||
SF133_AMT_6_NOT_SHOWN | NUMBER | True value of SF133_COLUMN_6_AMOUNT before sign changes | ||
SF133_COLUMN_TOTAL_AMT | NUMBER | Total Dollar amount calculated by SF 133 Report on Budget Execution process for all the six years that is to be printed in associated line and column of report | ||
SF133_AMT_TOTAL_NOT_SHOWN | NUMBER | True value of SF133_COLUMN_TOTAL_AMOUNT before sign changes | ||
TREASURY_SYMBOL_ID | NUMBER | (15) | references treasury_symbol_id of the table FV_TREASURY_SYMBOLS |
Cut, paste (and edit) the following text to query this object:
SELECT SF133_FUND_VALUE
, SF133_LINE_ID
, SF133_COLUMN_NUMBER
, SF133_COLUMN_AMOUNT
, SF133_AMOUNT_NOT_SHOWN
, SF133_COLUMN_2_AMOUNT
, SF133_AMT_2_NOT_SHOWN
, SF133_COLUMN_3_AMOUNT
, SF133_AMT_3_NOT_SHOWN
, SF133_COLUMN_4_AMOUNT
, SF133_AMT_4_NOT_SHOWN
, SF133_COLUMN_5_AMOUNT
, SF133_AMT_5_NOT_SHOWN
, SF133_COLUMN_6_AMOUNT
, SF133_AMT_6_NOT_SHOWN
, SF133_COLUMN_TOTAL_AMT
, SF133_AMT_TOTAL_NOT_SHOWN
, TREASURY_SYMBOL_ID
FROM FV.FV_SF133_DEFINITIONS_COLS_TEMP;
FV.FV_SF133_DEFINITIONS_COLS_TEMP does not reference any database object
FV.FV_SF133_DEFINITIONS_COLS_TEMP is referenced by following:
|
|
|