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

TABLE: FV.FV_SF133_DEFINITIONS_COLS_TEMP

Object Details
Object Name: FV_SF133_DEFINITIONS_COLS_TEMP
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FV_SF133_DEFINITIONS_COLS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSF133_FUND_VALUE
ColumnSF133_LINE_ID
ColumnSF133_COLUMN_NUMBER
Columns
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
Query Text

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;

Dependencies

[top of page]

FV.FV_SF133_DEFINITIONS_COLS_TEMP does not reference any database object

FV.FV_SF133_DEFINITIONS_COLS_TEMP is referenced by following:

SchemaFV
ViewFV_SF133_DEFINITIONS_COLS_TEM#