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_CGAC_CRT_TAS_TEMP#

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ORIGINAL_TREASURY_SYMBOL	VARCHAR2	(35)
DISTRIBUTION_DTL_ID	NUMBER	(15)
ORIGINAL_TREASURY_SYMBOL_ID	NUMBER	(15)
DISTRIBUTION_ID	NUMBER	(15)
FUND_VALUE	VARCHAR2	(25)
TREASURY_SYMBOL	VARCHAR2	(35)
SET_OF_BOOKS_ID	NUMBER	(15)
TREASURY_SYMBOL_ID	NUMBER	(15)
ORIGINAL_FUND_VALUE	VARCHAR2	(25)
ORIGINAL_FUND_PARAMETER_ID	NUMBER	(15)
FUND_PARAMETER_ID	NUMBER	(15)
DEFAULT_SEGMENT	VARCHAR2	(2000)
DESCRIPTION	VARCHAR2	(15)
AID	VARCHAR2	(3)
MAIN	VARCHAR2	(4)
SP	VARCHAR2	(2)
ATA	VARCHAR2	(3)
BPOA	NUMBER	(15)
EPOA	NUMBER	(15)
SUB	VARCHAR2	(3)
AUTO_TAS	VARCHAR2	(1)
AUTO_BETC	VARCHAR2	(1)
AUTO_FUND	VARCHAR2	(1)
AUTO_DIST	VARCHAR2	(240)
NEW_BPOA	NUMBER	(15)
NEW_EPOA	NUMBER	(15)
ERROR_MESSAGE	VARCHAR2	(100)

Query Text

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


SELECT ORIGINAL_TREASURY_SYMBOL
,      DISTRIBUTION_DTL_ID
,      ORIGINAL_TREASURY_SYMBOL_ID
,      DISTRIBUTION_ID
,      FUND_VALUE
,      TREASURY_SYMBOL
,      SET_OF_BOOKS_ID
,      TREASURY_SYMBOL_ID
,      ORIGINAL_FUND_VALUE
,      ORIGINAL_FUND_PARAMETER_ID
,      FUND_PARAMETER_ID
,      DEFAULT_SEGMENT
,      DESCRIPTION
,      AID
,      MAIN
,      SP
,      ATA
,      BPOA
,      EPOA
,      SUB
,      AUTO_TAS
,      AUTO_BETC
,      AUTO_FUND
,      AUTO_DIST
,      NEW_BPOA
,      NEW_EPOA
,      ERROR_MESSAGE
FROM FV.FV_CGAC_CRT_TAS_TEMP#;

Dependencies

[top of page]

FV.FV_CGAC_CRT_TAS_TEMP# references the following:

FV: FV_CGAC_CRT_TAS_TEMP

FV.FV_CGAC_CRT_TAS_TEMP# is referenced by following:

APPS: FV_CGAC_CRT_TAS_TEMP