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: FUN.FUN_DIST_LINES

Object Details

Object Name:	FUN_DIST_LINES
Object Type:	TABLE
Owner:	FUN
FND Design Data:	FUN.FUN_DIST_LINES
Subobject Name:
Status:	VALID

FUN_DIST_LINES stores the distributions for the Intercompany transactions. Both recipient and initiator distributions are stored in this table. Party_type_flag = I and dist_type_flag = L indicates an Initiator distribution line. Party_type_flag = I and dist_type_flag = R indicates an Initiator receivables account distribution line. Party_type_flag = R and dist_type_flag = L indicates a Recipient distribution line. Party_type_flag = R and dist_type_flag = P indicates a Recipient payables account distribution line.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FUN_DIST_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DIST_ID
FUN_DIST_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_ID
FUN_DIST_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_ID
FUN_DIST_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DIST_ID	NUMBER	(15)	Yes	System generated primary key
LINE_ID	NUMBER	(15)	Yes	Line identifier
DIST_NUMBER	NUMBER		Yes	Distribution number
PARTY_ID	NUMBER	(15)	Yes	Party Identifier. Stores the recipient party identifier if party_type_flag = R else stores the initiator party identifier.
PARTY_TYPE_FLAG	VARCHAR2	(1)	Yes	Party type flag. Valid values are I, R
DIST_TYPE_FLAG	VARCHAR2	(1)	Yes	Distribution type flag. Valid values are R, P, L
BATCH_DIST_ID	NUMBER	(15)		Batch distribution Identifier if the distribution was created using the automatic proration method.
AMOUNT_CR	NUMBER			Credit amount
AMOUNT_DR	NUMBER			Debit amount
CCID	NUMBER	(15)		Code combination identifier
DESCRIPTION	VARCHAR2	(250)		Description
AUTO_GENERATE_FLAG	VARCHAR2	(1)	Yes	Indicates whether this distribution line was manually entered or not.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield context
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	(15)		Standard Who column.
TRX_ID	NUMBER			Transaction Identifier.

Query Text

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


SELECT DIST_ID
,      LINE_ID
,      DIST_NUMBER
,      PARTY_ID
,      PARTY_TYPE_FLAG
,      DIST_TYPE_FLAG
,      BATCH_DIST_ID
,      AMOUNT_CR
,      AMOUNT_DR
,      CCID
,      DESCRIPTION
,      AUTO_GENERATE_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRX_ID
FROM FUN.FUN_DIST_LINES;

Dependencies

[top of page]

FUN.FUN_DIST_LINES does not reference any database object

FUN.FUN_DIST_LINES is referenced by following:

FUN: FUN_DIST_LINES#