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_MANUAL_LINES

Object Details

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

FV_SF1219_MANUAL_LINES is used to store the report lines assigned by the users using the FMS Form 1219/1220 Transaction Correction form. These are the report lines on the 1219/1220 report, where the transactions are reported. These transactions are classified as MANUAL transactions, which require user intervention to assign the appropriate report lines on which they are reported.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_SF1219_MANUAL_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID TEMP_RECORD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEMP_RECORD_ID	NUMBER	(8)	Yes	Unique record identifier
LINE_ID	VARCHAR2	(3)	Yes	Report line identifier
LINE_DISP	VARCHAR2	(4)	Yes	Line identifier displayed with period for querying purposes
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created 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.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
COLUMN_NO	NUMBER	(1)		Column on which transaction is reported on 1220 report

Query Text

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


SELECT TEMP_RECORD_ID
,      LINE_ID
,      LINE_DISP
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      COLUMN_NO
FROM FV.FV_SF1219_MANUAL_LINES;

Dependencies

[top of page]

FV.FV_SF1219_MANUAL_LINES does not reference any database object

FV.FV_SF1219_MANUAL_LINES is referenced by following:

APPS: FV_SF1219_MANUAL_LINES