[Home] [Help] [Dependency Information]
Object Name: | ICX_CART_DISTRIBUTIONS |
---|---|
Object Type: | TABLE |
Owner: | ICX |
FND Design Data: | ICX.ICX_CART_DISTRIBUTIONS |
Subobject Name: | |
Status: | VALID |
ICX_CART_DISTRIBUTIONS can store information about the accounting
distributions associated with the requisition. This information can
then be applied as a default to all requisition lines. In order to
use this table, custom code must be written.
.
One record is automatically added to this table each time a new
requisition is created.
.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ICX_CART_DISTRIBUTIONS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
CART_ID
DISTRIBUTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CART_ID | NUMBER | Yes | Requisition header 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_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 | |
ORG_ID | NUMBER | Organization unique identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CART_ID
, DISTRIBUTION_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, 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
, ORG_ID
FROM ICX.ICX_CART_DISTRIBUTIONS;
ICX.ICX_CART_DISTRIBUTIONS does not reference any database object
ICX.ICX_CART_DISTRIBUTIONS is referenced by following:
|
|
|