VIEW: ICX.ICX_CART_LINE_DISTRIBUTIONS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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