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]

TABLE: FV.FV_SF1219_REPORT_TEMPLATE

Object Details

Object Name:	FV_SF1219_REPORT_TEMPLATE
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_SF1219_REPORT_TEMPLATE
Subobject Name:
Status:	VALID

FV_SF1219_REPORT_TEMPLATE is a seed table that stores all the standard report lines that appear on the FMS Form 1219/1220 report. It acts as a template for the report structure.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	VARCHAR2	(5)	Yes	Report line identifier
LINE_DESC	VARCHAR2	(50)	Yes	Description that appears on FMS Form 1219/1220 report for report line
LINE_TYPE	VARCHAR2	(1)	Yes	Indicates type of reported line. Report line, Total line, Opening Balance line, or Description line.
MULTIPLIER	NUMBER		Yes	Stores sign on which amount is reported. Valid values are +1 and -1.

Query Text

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


SELECT LINE_ID
,      LINE_DESC
,      LINE_TYPE
,      MULTIPLIER
FROM FV.FV_SF1219_REPORT_TEMPLATE;

Dependencies

[top of page]

FV.FV_SF1219_REPORT_TEMPLATE does not reference any database object

FV.FV_SF1219_REPORT_TEMPLATE is referenced by following:

APPS: FV_SF1219_REPORT_TEMPLATE