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: TableFUN.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FUN_DIST_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDIST_ID
FUN_DIST_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
FUN_DIST_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_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:

SchemaAPPS
SynonymFUN_DIST_LINES