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

TABLE: FV.FV_SF132_APP_REAPP_SCH

Object Details
Object Name: FV_SF132_APP_REAPP_SCH
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_SF132_APP_REAPP_SCH
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:
Indexes
Index Type Uniqueness Tablespace Column
FV_SF132_APP_REAPP_SCH_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_ID
ColumnSET_OF_BOOKS_ID
ColumnTREASURY_SYMBOL
ColumnFISCAL_YEAR
ColumnREAPPORTIONMENT_NUMBER
Columns
Name Datatype Length Mandatory Comments
FISCAL_YEAR VARCHAR2 (4) Yes Fiscal Year
AGENCY VARCHAR2 (40) Yes Agency to submit the report
BUREAU VARCHAR2 (40)
Bureau
APPROPRIATION VARCHAR2 (50) Yes Appropriation
TREASURY_SYMBOL VARCHAR2 (35) Yes Treasury symbol for which the report is being submitted
REAPPORTIONMENT_NUMBER NUMBER (15) Yes Reapportionment Number
TEXT_1A VARCHAR2 (40)
User Enterable text
AMOUNT_1A NUMBER

Amount on Latest SF -132
REQUEST_1A NUMBER

Agency Request amount
OMB_1A NUMBER

Action by OMB amount
AMOUNT_1B NUMBER

Amount on Latest SF -132
REQUEST_1B NUMBER

Agency Request amount
OMB_1B NUMBER

Action by OMB amount
TEXT_1C VARCHAR2 (40)
User Enterable text
AMOUNT_1C NUMBER

Amount on Latest SF -132
REQUEST_1C NUMBER

Agency Request amount
OMB_1C NUMBER

Action by OMB amount
AMOUNT_1D NUMBER

Amount on Latest SF -132
REQUEST_1D NUMBER

Agency Request amount
OMB_1D NUMBER

Action by OMB amount
TEXT_1E VARCHAR2 (40)
User Enterable text
AMOUNT_1E NUMBER

Amount on Latest SF -132
REQUEST_1E NUMBER

Agency Request amount
OMB_1E NUMBER

Action by OMB amount
AMOUNT_2A NUMBER

Amount on Latest SF -132
REQUEST_2A NUMBER

Agency Request amount
OMB_2A NUMBER

Action by OMB amount
AMOUNT_2B NUMBER

Amount on Latest SF -132
REQUEST_2B NUMBER

Agency Request amount
OMB_2B NUMBER

Action by OMB amount
AMOUNT_2C NUMBER

Amount on Latest SF -132
REQUEST_2C NUMBER

Agency Request amount
OMB_2C NUMBER

Action by OMB amount
AMOUNT_3A1 NUMBER

Amount on Latest SF -132
REQUEST_3A1 NUMBER

Agency Request amount
OMB_3A1 NUMBER

Action by OMB amount
AMOUNT_3A2 NUMBER

Amount on Latest SF -132
REQUEST_3A2 NUMBER

Agency Request amount
OMB_3A2 NUMBER

Action by OMB amount
AMOUNT_3B1 NUMBER

Amount on Latest SF -132
REQUEST_3B1 NUMBER

Agency Request amount
OMB_3B1 NUMBER

Action by OMB amount
AMOUNT_3B2 NUMBER

Amount on Latest SF -132
REQUEST_3B2 NUMBER

Agency Request amount
OMB_3B2 NUMBER

Action by OMB amount
AMOUNT_3C1 NUMBER

Amount on Latest SF -132
REQUEST_3C1 NUMBER

Agency Request amount
OMB_3C1 NUMBER

Action by OMB amount
AMOUNT_3D1 NUMBER

Amount on Latest SF -132
REQUEST_3D1 NUMBER

Agency Request amount
OMB_3D1 NUMBER

Action by OMB amount
AMOUNT_3D2 NUMBER

Amount on Latest SF -132
REQUEST_3D2 NUMBER

Agency Request amount
OMB_3D2 NUMBER

Action by OMB amount
AMOUNT_4A NUMBER

Amount on Latest SF -132
REQUEST_4A NUMBER

Agency Request amount
OMB_4A NUMBER

Action by OMB amount
AMOUNT_4B NUMBER

Amount on Latest SF -132
REQUEST_4B NUMBER

Agency Request amount
OMB_4B NUMBER

Action by OMB amount
TEXT_5 VARCHAR2 (40)
User Enterable text
AMOUNT_5 NUMBER

Amount on Latest SF -132
REQUEST_5 NUMBER

Agency Request amount
OMB_5 NUMBER

Action by OMB amount
AMOUNT_6A NUMBER

Amount on Latest SF -132
REQUEST_6A NUMBER

Agency Request amount
OMB_6A NUMBER

Action by OMB amount
AMOUNT_6B NUMBER

Amount on Latest SF -132
REQUEST_6B NUMBER

Agency Request amount
OMB_6B NUMBER

Action by OMB amount
AMOUNT_6C NUMBER

Amount on Latest SF -132
REQUEST_6C NUMBER

Agency Request amount
OMB_6C NUMBER

Action by OMB amount
AMOUNT_6D NUMBER

Amount on Latest SF -132
REQUEST_6D NUMBER

Agency Request amount
OMB_6D NUMBER

Action by OMB amount
TEXT_6E VARCHAR2 (40)
User Enterable text
AMOUNT_6E NUMBER

Amount on Latest SF -132
REQUEST_6E NUMBER

Agency Request amount
OMB_6E NUMBER

Action by OMB amount
AMOUNT_6F NUMBER

Amount on Latest SF -132
REQUEST_6F NUMBER

Agency Request amount
OMB_6F NUMBER

Action by OMB amount
AMOUNT_7 NUMBER

Amount on Latest SF -132
REQUEST_7 NUMBER

Agency Request amount
OMB_7 NUMBER

Action by OMB amount
TEXT_8A VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8A1 NUMBER

Amount on Latest SF -132
AMOUNT_8A1 NUMBER

Amount on Latest SF -132
REQUEST_8A1 NUMBER

Agency Request amount
OMB_8A1 NUMBER

Action by OMB amount
OBL_AMOUNT_8A2 NUMBER

Amount on Latest SF -132
AMOUNT_8A2 NUMBER

Amount on Latest SF -132
REQUEST_8A2 NUMBER

Agency Request amount
OMB_8A2 NUMBER

Action by OMB amount
OBL_AMOUNT_8A3 NUMBER

Amount on Latest SF -132
AMOUNT_8A3 NUMBER

Amount on Latest SF -132
REQUEST_8A3 NUMBER

Agency Request amount
OMB_8A3 NUMBER

Action by OMB amount
OBL_AMOUNT_8A4 NUMBER

Amount on Latest SF -132
AMOUNT_8A4 NUMBER

Amount on Latest SF -132
REQUEST_8A4 NUMBER

Agency Request amount
OMB_8A4 NUMBER

Action by OMB amount
TEXT_8B VARCHAR2 (40)
User Enterable text
TEXT_8B1 VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8B1 NUMBER

Amount on Latest SF -132
AMOUNT_8B1 NUMBER

Amount on Latest SF -132
REQUEST_8B1 NUMBER

Agency Request amount
OMB_8B1 NUMBER

Action by OMB amount
TEXT_8B2 VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8B2 NUMBER

Amount on Latest SF -132
AMOUNT_8B2 NUMBER

Amount on Latest SF -132
REQUEST_8B2 NUMBER

Agency Request amount
OMB_8B2 NUMBER

Action by OMB amount
TEXT_8B3 VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8B3 NUMBER

Amount on Latest SF -132
AMOUNT_8B3 NUMBER

Amount on Latest SF -132
REQUEST_8B3 NUMBER

Agency Request amount
OMB_8B3 NUMBER

Action by OMB amount
TEXT_8B4 VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8B4 NUMBER

Amount on Latest SF -132
AMOUNT_8B4 NUMBER

Amount on Latest SF -132
REQUEST_8B4 NUMBER

Agency Request amount
OMB_8B4 NUMBER

Action by OMB amount
TEXT_8B5 VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8B5 NUMBER

Amount on Latest SF -132
AMOUNT_8B5 NUMBER

Amount on Latest SF -132
REQUEST_8B5 NUMBER

Agency Request amount
OMB_8B5 NUMBER

Action by OMB amount
TEXT_8B6 VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8B6 NUMBER

Amount on Latest SF -132
AMOUNT_8B6 NUMBER

Amount on Latest SF -132
REQUEST_8B6 NUMBER

Agency Request amount
OMB_8B6 NUMBER

Action by OMB amount
TEXT_8B7 VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8B7 NUMBER

Amount on Latest SF -132
AMOUNT_8B7 NUMBER

Amount on Latest SF -132
REQUEST_8B7 NUMBER

Agency Request amount
OMB_8B7 NUMBER

Action by OMB amount
TEXT_8B8 VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8B8 NUMBER

Amount on Latest SF -132
AMOUNT_8B8 NUMBER

Amount on Latest SF -132
REQUEST_8B8 NUMBER

Agency Request amount
OMB_8B8 NUMBER

Action by OMB amount
TEXT_8B9 VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8B9 NUMBER

Amount on Latest SF -132
AMOUNT_8B9 NUMBER

Amount on Latest SF -132
REQUEST_8B9 NUMBER

Agency Request amount
OMB_8B9 NUMBER

Action by OMB amount
TEXT_8B10 VARCHAR2 (40)
User Enterable text
OBL_AMOUNT_8B10 NUMBER

Amount on Latest SF -132
AMOUNT_8B10 NUMBER

Amount on Latest SF -132
REQUEST_8B10 NUMBER

Agency Request amount
OMB_8B10 NUMBER

Action by OMB amount
AMOUNT_9 NUMBER

Amount on Latest SF -132
REQUEST_9 NUMBER

Agency Request amount
OMB_9 NUMBER

Action by OMB amount
AMOUNT_10 NUMBER

Amount on Latest SF -132
REQUEST_10 NUMBER

Agency Request amount
OMB_10 NUMBER

Action by OMB amount
AMOUNT_11 NUMBER

Amount on Latest SF -132
REQUEST_11 NUMBER

Agency Request amount
OMB_11 NUMBER

Action by OMB amount
AMOUNT_12 NUMBER

Amount on Latest SF -132
REQUEST_12 NUMBER

Agency Request amount
OMB_12 NUMBER

Action by OMB amount
STATUS VARCHAR2 (240)
Status of the Report
EXPLANATION VARCHAR2 (2000)
User Enterable text for the notes at the end of the report
SET_OF_BOOKS_ID NUMBER (15)
Set of books Identifier
ORG_ID NUMBER (15)
Organization identifier
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT FISCAL_YEAR
,      AGENCY
,      BUREAU
,      APPROPRIATION
,      TREASURY_SYMBOL
,      REAPPORTIONMENT_NUMBER
,      TEXT_1A
,      AMOUNT_1A
,      REQUEST_1A
,      OMB_1A
,      AMOUNT_1B
,      REQUEST_1B
,      OMB_1B
,      TEXT_1C
,      AMOUNT_1C
,      REQUEST_1C
,      OMB_1C
,      AMOUNT_1D
,      REQUEST_1D
,      OMB_1D
,      TEXT_1E
,      AMOUNT_1E
,      REQUEST_1E
,      OMB_1E
,      AMOUNT_2A
,      REQUEST_2A
,      OMB_2A
,      AMOUNT_2B
,      REQUEST_2B
,      OMB_2B
,      AMOUNT_2C
,      REQUEST_2C
,      OMB_2C
,      AMOUNT_3A1
,      REQUEST_3A1
,      OMB_3A1
,      AMOUNT_3A2
,      REQUEST_3A2
,      OMB_3A2
,      AMOUNT_3B1
,      REQUEST_3B1
,      OMB_3B1
,      AMOUNT_3B2
,      REQUEST_3B2
,      OMB_3B2
,      AMOUNT_3C1
,      REQUEST_3C1
,      OMB_3C1
,      AMOUNT_3D1
,      REQUEST_3D1
,      OMB_3D1
,      AMOUNT_3D2
,      REQUEST_3D2
,      OMB_3D2
,      AMOUNT_4A
,      REQUEST_4A
,      OMB_4A
,      AMOUNT_4B
,      REQUEST_4B
,      OMB_4B
,      TEXT_5
,      AMOUNT_5
,      REQUEST_5
,      OMB_5
,      AMOUNT_6A
,      REQUEST_6A
,      OMB_6A
,      AMOUNT_6B
,      REQUEST_6B
,      OMB_6B
,      AMOUNT_6C
,      REQUEST_6C
,      OMB_6C
,      AMOUNT_6D
,      REQUEST_6D
,      OMB_6D
,      TEXT_6E
,      AMOUNT_6E
,      REQUEST_6E
,      OMB_6E
,      AMOUNT_6F
,      REQUEST_6F
,      OMB_6F
,      AMOUNT_7
,      REQUEST_7
,      OMB_7
,      TEXT_8A
,      OBL_AMOUNT_8A1
,      AMOUNT_8A1
,      REQUEST_8A1
,      OMB_8A1
,      OBL_AMOUNT_8A2
,      AMOUNT_8A2
,      REQUEST_8A2
,      OMB_8A2
,      OBL_AMOUNT_8A3
,      AMOUNT_8A3
,      REQUEST_8A3
,      OMB_8A3
,      OBL_AMOUNT_8A4
,      AMOUNT_8A4
,      REQUEST_8A4
,      OMB_8A4
,      TEXT_8B
,      TEXT_8B1
,      OBL_AMOUNT_8B1
,      AMOUNT_8B1
,      REQUEST_8B1
,      OMB_8B1
,      TEXT_8B2
,      OBL_AMOUNT_8B2
,      AMOUNT_8B2
,      REQUEST_8B2
,      OMB_8B2
,      TEXT_8B3
,      OBL_AMOUNT_8B3
,      AMOUNT_8B3
,      REQUEST_8B3
,      OMB_8B3
,      TEXT_8B4
,      OBL_AMOUNT_8B4
,      AMOUNT_8B4
,      REQUEST_8B4
,      OMB_8B4
,      TEXT_8B5
,      OBL_AMOUNT_8B5
,      AMOUNT_8B5
,      REQUEST_8B5
,      OMB_8B5
,      TEXT_8B6
,      OBL_AMOUNT_8B6
,      AMOUNT_8B6
,      REQUEST_8B6
,      OMB_8B6
,      TEXT_8B7
,      OBL_AMOUNT_8B7
,      AMOUNT_8B7
,      REQUEST_8B7
,      OMB_8B7
,      TEXT_8B8
,      OBL_AMOUNT_8B8
,      AMOUNT_8B8
,      REQUEST_8B8
,      OMB_8B8
,      TEXT_8B9
,      OBL_AMOUNT_8B9
,      AMOUNT_8B9
,      REQUEST_8B9
,      OMB_8B9
,      TEXT_8B10
,      OBL_AMOUNT_8B10
,      AMOUNT_8B10
,      REQUEST_8B10
,      OMB_8B10
,      AMOUNT_9
,      REQUEST_9
,      OMB_9
,      AMOUNT_10
,      REQUEST_10
,      OMB_10
,      AMOUNT_11
,      REQUEST_11
,      OMB_11
,      AMOUNT_12
,      REQUEST_12
,      OMB_12
,      STATUS
,      EXPLANATION
,      SET_OF_BOOKS_ID
,      ORG_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
FROM FV.FV_SF132_APP_REAPP_SCH;

Dependencies

[top of page]

FV.FV_SF132_APP_REAPP_SCH does not reference any database object

FV.FV_SF132_APP_REAPP_SCH is referenced by following:

SchemaAPPS
SynonymFV_SF132_APP_REAPP_SCH