eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: FV.FV_SF132_APP_REAPP_SCH#

Object Details

Object Name:	FV_SF132_APP_REAPP_SCH#
Object Type:	VIEW
Owner:	FV
Subobject Name:
Status:	VALID

[View Source]

Columns

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

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# references the following:

FV: FV_SF132_APP_REAPP_SCH

FV.FV_SF132_APP_REAPP_SCH# is referenced by following:

APPS: FV_SF132_APP_REAPP_SCH