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

VIEW: ICX.ICX_CART_DISTRIBUTIONS#

Object Details
Object Name: ICX_CART_DISTRIBUTIONS#
Object Type: VIEW
Owner: ICX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CART_ID NUMBER
Yes
DISTRIBUTION_ID NUMBER
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
CHARGE_ACCOUNT_SEGMENT1 VARCHAR2 (240)
CHARGE_ACCOUNT_SEGMENT2 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT3 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT4 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT5 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT6 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT7 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT8 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT9 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT10 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT11 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT12 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT13 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT14 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT15 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT16 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT17 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT18 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT19 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT20 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT21 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT22 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT23 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT24 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT25 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT26 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT27 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT28 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT29 VARCHAR2 (25)
CHARGE_ACCOUNT_SEGMENT30 VARCHAR2 (25)
ORG_ID NUMBER

Query Text

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#;

Dependencies

[top of page]

ICX.ICX_CART_DISTRIBUTIONS# references the following:

SchemaICX
TableICX_CART_DISTRIBUTIONS
ICX.ICX_CART_DISTRIBUTIONS# is referenced by following:

SchemaAPPS
SynonymICX_CART_DISTRIBUTIONS