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

TABLE: FUN.FUN_TRX_LINES

Object Details
Object Name: FUN_TRX_LINES
Object Type: TABLE
Owner: FUN
FND Design Data: TableFUN.FUN_TRX_LINES
Subobject Name:
Status: VALID

FUN_TRX_LINES stores some line level information for an intercompany transaction.Each row in FUN_TRX_HEADERS currently maps to 1 row in FUN_TRX_LINES.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FUN_TRX_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
FUN_TRX_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER (15) Yes System Generated primary key.
TRX_ID NUMBER (15) Yes Transaction identifier.
LINE_NUMBER NUMBER (15) Yes Line number.
LINE_TYPE_FLAG VARCHAR2 (1) Yes "L" for Line, "T" for Tax. Currently all the lines in this table have a line type of "L"
INIT_AMOUNT_CR NUMBER

Credit amount for initiator.
INIT_AMOUNT_DR NUMBER

Debit amount for initiator.
RECI_AMOUNT_CR NUMBER

Credit amount for recipient.
RECI_AMOUNT_DR NUMBER

Debit amount for recipient.
DESCRIPTION VARCHAR2 (250)
Description.
CREATED_BY NUMBER (15) Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
LAST_UPDATE_LOGIN NUMBER

Standard Who column.
Query Text

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


SELECT LINE_ID
,      TRX_ID
,      LINE_NUMBER
,      LINE_TYPE_FLAG
,      INIT_AMOUNT_CR
,      INIT_AMOUNT_DR
,      RECI_AMOUNT_CR
,      RECI_AMOUNT_DR
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FUN.FUN_TRX_LINES;

Dependencies

[top of page]

FUN.FUN_TRX_LINES does not reference any database object

FUN.FUN_TRX_LINES is referenced by following:

SchemaFUN
ViewFUN_TRX_LINES#