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

TABLE: ICX.ICX_CART_LINE_DISTRIBUTIONS

Object Details
Object Name: ICX_CART_LINE_DISTRIBUTIONS
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_CART_LINE_DISTRIBUTIONS
Subobject Name:
Status: VALID


ICX_CART_LINE_DISTRIBUTIONS stores information about the accounting
distributions associated with each requisition line. Each requisition
line must have at least one accounting distribution. You need one
row for each requisition distribution you create.
.
DISTRIBUTION_ID is the unique identifier for the distribution. Each
distribution also contains the CART_LINE_ID from
ICX_SHOPPING_CART_LINES table, as well as CART_ID from
ICX_SHOPPING_CARTS table. The percent allocation to each amount is
stored in the ALLOCATION_VALUE field.
.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_CART_LINE_DISTRIBUTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCART_LINE_ID
ColumnDISTRIBUTION_ID
Columns
Name Datatype Length Mandatory Comments
CART_LINE_ID NUMBER
Yes Requisiton line unique identifier
DISTRIBUTION_ID NUMBER
Yes Requisition distribution unique identifier
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
CHARGE_ACCOUNT_ID NUMBER

GL charge account unique identifier
CHARGE_ACCOUNT_SEGMENT1 VARCHAR2 (240)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT2 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT3 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT4 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT5 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT6 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT7 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT8 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT9 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT10 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT11 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT12 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT13 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT14 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT15 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT16 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT17 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT18 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT19 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT20 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT21 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT22 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT23 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT24 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT25 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT26 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT27 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT28 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT29 VARCHAR2 (25)
Key flexfield segment
CHARGE_ACCOUNT_SEGMENT30 VARCHAR2 (25)
Key flexfield segment
DIST_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
DISTRIBUTION_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ACCRUAL_ACCOUNT_ID NUMBER

GL accrual account unique identifier
VARIANCE_ACCOUNT_ID NUMBER

GL variance account unique identifier
BUDGET_ACCOUNT_ID NUMBER

GL budget account unique identifier
ORG_ID NUMBER

Organization unique identifier
CART_ID NUMBER
Yes Requisition header unique identifier
ALLOCATION_TYPE VARCHAR2 (30)
Specifies the method of allocation across distributions. Can be PERCENT.
ALLOCATION_VALUE NUMBER

Allocation split value
ALLOCATION_QUANTITY NUMBER

For future use
CHARGE_ACCOUNT_NUM VARCHAR2 (2000)
Concatenated charge account segment
DISTRIBUTION_NUM NUMBER

Distribution number
Query Text

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


SELECT CART_LINE_ID
,      DISTRIBUTION_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CHARGE_ACCOUNT_ID
,      CHARGE_ACCOUNT_SEGMENT1
,      CHARGE_ACCOUNT_SEGMENT2
,      CHARGE_ACCOUNT_SEGMENT3
,      CHARGE_ACCOUNT_SEGMENT4
,      CHARGE_ACCOUNT_SEGMENT5
,      CHARGE_ACCOUNT_SEGMENT6
,      CHARGE_ACCOUNT_SEGMENT7
,      CHARGE_ACCOUNT_SEGMENT8
,      CHARGE_ACCOUNT_SEGMENT9
,      CHARGE_ACCOUNT_SEGMENT10
,      CHARGE_ACCOUNT_SEGMENT11
,      CHARGE_ACCOUNT_SEGMENT12
,      CHARGE_ACCOUNT_SEGMENT13
,      CHARGE_ACCOUNT_SEGMENT14
,      CHARGE_ACCOUNT_SEGMENT15
,      CHARGE_ACCOUNT_SEGMENT16
,      CHARGE_ACCOUNT_SEGMENT17
,      CHARGE_ACCOUNT_SEGMENT18
,      CHARGE_ACCOUNT_SEGMENT19
,      CHARGE_ACCOUNT_SEGMENT20
,      CHARGE_ACCOUNT_SEGMENT21
,      CHARGE_ACCOUNT_SEGMENT22
,      CHARGE_ACCOUNT_SEGMENT23
,      CHARGE_ACCOUNT_SEGMENT24
,      CHARGE_ACCOUNT_SEGMENT25
,      CHARGE_ACCOUNT_SEGMENT26
,      CHARGE_ACCOUNT_SEGMENT27
,      CHARGE_ACCOUNT_SEGMENT28
,      CHARGE_ACCOUNT_SEGMENT29
,      CHARGE_ACCOUNT_SEGMENT30
,      DIST_ATTRIBUTE_CATEGORY
,      DISTRIBUTION_ATTRIBUTE1
,      DISTRIBUTION_ATTRIBUTE2
,      DISTRIBUTION_ATTRIBUTE3
,      DISTRIBUTION_ATTRIBUTE4
,      DISTRIBUTION_ATTRIBUTE5
,      DISTRIBUTION_ATTRIBUTE6
,      DISTRIBUTION_ATTRIBUTE7
,      DISTRIBUTION_ATTRIBUTE8
,      DISTRIBUTION_ATTRIBUTE9
,      DISTRIBUTION_ATTRIBUTE10
,      DISTRIBUTION_ATTRIBUTE11
,      DISTRIBUTION_ATTRIBUTE12
,      DISTRIBUTION_ATTRIBUTE13
,      DISTRIBUTION_ATTRIBUTE14
,      DISTRIBUTION_ATTRIBUTE15
,      ACCRUAL_ACCOUNT_ID
,      VARIANCE_ACCOUNT_ID
,      BUDGET_ACCOUNT_ID
,      ORG_ID
,      CART_ID
,      ALLOCATION_TYPE
,      ALLOCATION_VALUE
,      ALLOCATION_QUANTITY
,      CHARGE_ACCOUNT_NUM
,      DISTRIBUTION_NUM
FROM ICX.ICX_CART_LINE_DISTRIBUTIONS;

Dependencies

[top of page]

ICX.ICX_CART_LINE_DISTRIBUTIONS does not reference any database object

ICX.ICX_CART_LINE_DISTRIBUTIONS is referenced by following:

SchemaAPPS
SynonymICX_CART_LINE_DISTRIBUTIONS