eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: ICX.ICX_CART_DISTRIBUTIONS#

Source

View Text - Preformatted


select CART_ID CART_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_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, ORG_ID ORG_ID from "ICX"."ICX_CART_DISTRIBUTIONS"

View Text - HTML Formatted

SELECT CART_ID CART_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_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
, ORG_ID ORG_ID
FROM "ICX"."ICX_CART_DISTRIBUTIONS"