VIEW: ZX.ZX_SIM_TRX_DISTS#

Source

View Text - Preformatted

select APPLICATION_ID APPLICATION_ID, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, TRX_ID TRX_ID, HDR_TRX_USER_KEY1 HDR_TRX_USER_KEY1, HDR_TRX_USER_KEY2 HDR_TRX_USER_KEY2, HDR_TRX_USER_KEY3 HDR_TRX_USER_KEY3, HDR_TRX_USER_KEY4 HDR_TRX_USER_KEY4, HDR_TRX_USER_KEY5 HDR_TRX_USER_KEY5, HDR_TRX_USER_KEY6 HDR_TRX_USER_KEY6, TRX_LINE_ID TRX_LINE_ID, LINE_TRX_USER_KEY1 LINE_TRX_USER_KEY1, LINE_TRX_USER_KEY2 LINE_TRX_USER_KEY2, LINE_TRX_USER_KEY3 LINE_TRX_USER_KEY3, LINE_TRX_USER_KEY4 LINE_TRX_USER_KEY4, LINE_TRX_USER_KEY5 LINE_TRX_USER_KEY5, LINE_TRX_USER_KEY6 LINE_TRX_USER_KEY6, TRX_LEVEL_TYPE TRX_LEVEL_TYPE, TRX_LINE_DIST_ID TRX_LINE_DIST_ID, DIST_TRX_USER_KEY1 DIST_TRX_USER_KEY1, DIST_TRX_USER_KEY2 DIST_TRX_USER_KEY2, DIST_TRX_USER_KEY3 DIST_TRX_USER_KEY3, DIST_TRX_USER_KEY4 DIST_TRX_USER_KEY4, DIST_TRX_USER_KEY5 DIST_TRX_USER_KEY5, DIST_TRX_USER_KEY6 DIST_TRX_USER_KEY6, DIST_LEVEL_ACTION DIST_LEVEL_ACTION, TRX_LINE_DIST_DATE TRX_LINE_DIST_DATE, ITEM_DIST_NUMBER ITEM_DIST_NUMBER, DIST_INTENDED_USE DIST_INTENDED_USE, TAX_INCLUSION_FLAG TAX_INCLUSION_FLAG, TAX_CODE TAX_CODE, APPLIED_FROM_TAX_DIST_ID APPLIED_FROM_TAX_DIST_ID, ADJUSTED_DOC_TAX_DIST_ID ADJUSTED_DOC_TAX_DIST_ID, TASK_ID TASK_ID, AWARD_ID AWARD_ID, PROJECT_ID PROJECT_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, TRX_LINE_DIST_AMT TRX_LINE_DIST_AMT, TRX_LINE_DIST_QTY TRX_LINE_DIST_QTY, TRX_LINE_QUANTITY TRX_LINE_QUANTITY, ACCOUNT_CCID ACCOUNT_CCID, ACCOUNT_STRING ACCOUNT_STRING, REF_DOC_APPLICATION_ID REF_DOC_APPLICATION_ID, REF_DOC_ENTITY_CODE REF_DOC_ENTITY_CODE, REF_DOC_EVENT_CLASS_CODE REF_DOC_EVENT_CLASS_CODE, REF_DOC_TRX_ID REF_DOC_TRX_ID, REF_DOC_HDR_TRX_USER_KEY1 REF_DOC_HDR_TRX_USER_KEY1, REF_DOC_HDR_TRX_USER_KEY2 REF_DOC_HDR_TRX_USER_KEY2, REF_DOC_HDR_TRX_USER_KEY3 REF_DOC_HDR_TRX_USER_KEY3, REF_DOC_HDR_TRX_USER_KEY4 REF_DOC_HDR_TRX_USER_KEY4, REF_DOC_HDR_TRX_USER_KEY5 REF_DOC_HDR_TRX_USER_KEY5, REF_DOC_HDR_TRX_USER_KEY6 REF_DOC_HDR_TRX_USER_KEY6, REF_DOC_LINE_ID REF_DOC_LINE_ID, REF_DOC_LIN_TRX_USER_KEY1 REF_DOC_LIN_TRX_USER_KEY1, REF_DOC_LIN_TRX_USER_KEY2 REF_DOC_LIN_TRX_USER_KEY2, REF_DOC_LIN_TRX_USER_KEY3 REF_DOC_LIN_TRX_USER_KEY3, REF_DOC_LIN_TRX_USER_KEY4 REF_DOC_LIN_TRX_USER_KEY4, REF_DOC_LIN_TRX_USER_KEY5 REF_DOC_LIN_TRX_USER_KEY5, REF_DOC_LIN_TRX_USER_KEY6 REF_DOC_LIN_TRX_USER_KEY6, REF_DOC_DIST_ID REF_DOC_DIST_ID, REF_DOC_DIST_TRX_USER_KEY1 REF_DOC_DIST_TRX_USER_KEY1, REF_DOC_DIST_TRX_USER_KEY2 REF_DOC_DIST_TRX_USER_KEY2, REF_DOC_DIST_TRX_USER_KEY3 REF_DOC_DIST_TRX_USER_KEY3, REF_DOC_DIST_TRX_USER_KEY4 REF_DOC_DIST_TRX_USER_KEY4, REF_DOC_DIST_TRX_USER_KEY5 REF_DOC_DIST_TRX_USER_KEY5, REF_DOC_DIST_TRX_USER_KEY6 REF_DOC_DIST_TRX_USER_KEY6, REF_DOC_CURR_CONV_RATE REF_DOC_CURR_CONV_RATE, NUMERIC1 NUMERIC1, NUMERIC2 NUMERIC2, NUMERIC3 NUMERIC3, NUMERIC4 NUMERIC4, NUMERIC5 NUMERIC5, CHAR1 CHAR1, CHAR2 CHAR2, CHAR3 CHAR3, CHAR4 CHAR4, CHAR5 CHAR5, DATE1 DATE1, DATE2 DATE2, DATE3 DATE3, DATE4 DATE4, DATE5 DATE5, TRX_LINE_DIST_TAX_AMT TRX_LINE_DIST_TAX_AMT, HISTORICAL_FLAG HISTORICAL_FLAG, APPLIED_FROM_APPLICATION_ID APPLIED_FROM_APPLICATION_ID, APPLIED_FROM_EVENT_CLASS_CODE APPLIED_FROM_EVENT_CLASS_CODE, APPLIED_FROM_ENTITY_CODE APPLIED_FROM_ENTITY_CODE, APPLIED_FROM_TRX_ID APPLIED_FROM_TRX_ID, APP_FROM_HDR_TRX_USER_KEY1 APP_FROM_HDR_TRX_USER_KEY1, APP_FROM_HDR_TRX_USER_KEY2 APP_FROM_HDR_TRX_USER_KEY2, APP_FROM_HDR_TRX_USER_KEY3 APP_FROM_HDR_TRX_USER_KEY3, APP_FROM_HDR_TRX_USER_KEY4 APP_FROM_HDR_TRX_USER_KEY4, APP_FROM_HDR_TRX_USER_KEY5 APP_FROM_HDR_TRX_USER_KEY5, APP_FROM_HDR_TRX_USER_KEY6 APP_FROM_HDR_TRX_USER_KEY6, APPLIED_FROM_LINE_ID APPLIED_FROM_LINE_ID, APP_FROM_LIN_TRX_USER_KEY1 APP_FROM_LIN_TRX_USER_KEY1, APP_FROM_LIN_TRX_USER_KEY2 APP_FROM_LIN_TRX_USER_KEY2, APP_FROM_LIN_TRX_USER_KEY3 APP_FROM_LIN_TRX_USER_KEY3, APP_FROM_LIN_TRX_USER_KEY4 APP_FROM_LIN_TRX_USER_KEY4, APP_FROM_LIN_TRX_USER_KEY5 APP_FROM_LIN_TRX_USER_KEY5, APP_FROM_LIN_TRX_USER_KEY6 APP_FROM_LIN_TRX_USER_KEY6, APPLIED_FROM_DIST_ID APPLIED_FROM_DIST_ID, APP_FROM_DST_TRX_USER_KEY1 APP_FROM_DST_TRX_USER_KEY1, APP_FROM_DST_TRX_USER_KEY2 APP_FROM_DST_TRX_USER_KEY2, APP_FROM_DST_TRX_USER_KEY3 APP_FROM_DST_TRX_USER_KEY3, APP_FROM_DST_TRX_USER_KEY4 APP_FROM_DST_TRX_USER_KEY4, APP_FROM_DST_TRX_USER_KEY5 APP_FROM_DST_TRX_USER_KEY5, APP_FROM_DST_TRX_USER_KEY6 APP_FROM_DST_TRX_USER_KEY6, ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_APPLICATION_ID, ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE, ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE, ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID, ADJ_DOC_HDR_TRX_USER_KEY1 ADJ_DOC_HDR_TRX_USER_KEY1, ADJ_DOC_HDR_TRX_USER_KEY2 ADJ_DOC_HDR_TRX_USER_KEY2, ADJ_DOC_HDR_TRX_USER_KEY3 ADJ_DOC_HDR_TRX_USER_KEY3, ADJ_DOC_HDR_TRX_USER_KEY4 ADJ_DOC_HDR_TRX_USER_KEY4, ADJ_DOC_HDR_TRX_USER_KEY5 ADJ_DOC_HDR_TRX_USER_KEY5, ADJ_DOC_HDR_TRX_USER_KEY6 ADJ_DOC_HDR_TRX_USER_KEY6, ADJUSTED_DOC_LINE_ID ADJUSTED_DOC_LINE_ID, ADJ_DOC_LIN_TRX_USER_KEY1 ADJ_DOC_LIN_TRX_USER_KEY1, ADJ_DOC_LIN_TRX_USER_KEY2 ADJ_DOC_LIN_TRX_USER_KEY2, ADJ_DOC_LIN_TRX_USER_KEY3 ADJ_DOC_LIN_TRX_USER_KEY3, ADJ_DOC_LIN_TRX_USER_KEY4 ADJ_DOC_LIN_TRX_USER_KEY4, ADJ_DOC_LIN_TRX_USER_KEY5 ADJ_DOC_LIN_TRX_USER_KEY5, ADJ_DOC_LIN_TRX_USER_KEY6 ADJ_DOC_LIN_TRX_USER_KEY6, ADJUSTED_DOC_DIST_ID ADJUSTED_DOC_DIST_ID, ADJ_DOC_DST_TRX_USER_KEY1 ADJ_DOC_DST_TRX_USER_KEY1, ADJ_DOC_DST_TRX_USER_KEY2 ADJ_DOC_DST_TRX_USER_KEY2, ADJ_DOC_DST_TRX_USER_KEY3 ADJ_DOC_DST_TRX_USER_KEY3, ADJ_DOC_DST_TRX_USER_KEY4 ADJ_DOC_DST_TRX_USER_KEY4, ADJ_DOC_DST_TRX_USER_KEY5 ADJ_DOC_DST_TRX_USER_KEY5, ADJ_DOC_DST_TRX_USER_KEY6 ADJ_DOC_DST_TRX_USER_KEY6, APPLIED_TO_DOC_CURR_CONV_RATE APPLIED_TO_DOC_CURR_CONV_RATE, TAX_VARIANCE_CALC_FLAG TAX_VARIANCE_CALC_FLAG, REF_DOC_TRX_LINE_DIST_QTY REF_DOC_TRX_LINE_DIST_QTY, PRICE_DIFF PRICE_DIFF, UNIT_PRICE UNIT_PRICE, CURRENCY_EXCHANGE_RATE CURRENCY_EXCHANGE_RATE, REF_DOC_TRX_LEVEL_TYPE REF_DOC_TRX_LEVEL_TYPE, APPLIED_FROM_TRX_LEVEL_TYPE APPLIED_FROM_TRX_LEVEL_TYPE, ADJUSTED_DOC_TRX_LEVEL_TYPE ADJUSTED_DOC_TRX_LEVEL_TYPE, OVERRIDING_RECOVERY_RATE OVERRIDING_RECOVERY_RATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "ZX"."ZX_SIM_TRX_DISTS"

View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, TRX_ID TRX_ID
, HDR_TRX_USER_KEY1 HDR_TRX_USER_KEY1
, HDR_TRX_USER_KEY2 HDR_TRX_USER_KEY2
, HDR_TRX_USER_KEY3 HDR_TRX_USER_KEY3
, HDR_TRX_USER_KEY4 HDR_TRX_USER_KEY4
, HDR_TRX_USER_KEY5 HDR_TRX_USER_KEY5
, HDR_TRX_USER_KEY6 HDR_TRX_USER_KEY6
, TRX_LINE_ID TRX_LINE_ID
, LINE_TRX_USER_KEY1 LINE_TRX_USER_KEY1
, LINE_TRX_USER_KEY2 LINE_TRX_USER_KEY2
, LINE_TRX_USER_KEY3 LINE_TRX_USER_KEY3
, LINE_TRX_USER_KEY4 LINE_TRX_USER_KEY4
, LINE_TRX_USER_KEY5 LINE_TRX_USER_KEY5
, LINE_TRX_USER_KEY6 LINE_TRX_USER_KEY6
, TRX_LEVEL_TYPE TRX_LEVEL_TYPE
, TRX_LINE_DIST_ID TRX_LINE_DIST_ID
, DIST_TRX_USER_KEY1 DIST_TRX_USER_KEY1
, DIST_TRX_USER_KEY2 DIST_TRX_USER_KEY2
, DIST_TRX_USER_KEY3 DIST_TRX_USER_KEY3
, DIST_TRX_USER_KEY4 DIST_TRX_USER_KEY4
, DIST_TRX_USER_KEY5 DIST_TRX_USER_KEY5
, DIST_TRX_USER_KEY6 DIST_TRX_USER_KEY6
, DIST_LEVEL_ACTION DIST_LEVEL_ACTION
, TRX_LINE_DIST_DATE TRX_LINE_DIST_DATE
, ITEM_DIST_NUMBER ITEM_DIST_NUMBER
, DIST_INTENDED_USE DIST_INTENDED_USE
, TAX_INCLUSION_FLAG TAX_INCLUSION_FLAG
, TAX_CODE TAX_CODE
, APPLIED_FROM_TAX_DIST_ID APPLIED_FROM_TAX_DIST_ID
, ADJUSTED_DOC_TAX_DIST_ID ADJUSTED_DOC_TAX_DIST_ID
, TASK_ID TASK_ID
, AWARD_ID AWARD_ID
, PROJECT_ID PROJECT_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, TRX_LINE_DIST_AMT TRX_LINE_DIST_AMT
, TRX_LINE_DIST_QTY TRX_LINE_DIST_QTY
, TRX_LINE_QUANTITY TRX_LINE_QUANTITY
, ACCOUNT_CCID ACCOUNT_CCID
, ACCOUNT_STRING ACCOUNT_STRING
, REF_DOC_APPLICATION_ID REF_DOC_APPLICATION_ID
, REF_DOC_ENTITY_CODE REF_DOC_ENTITY_CODE
, REF_DOC_EVENT_CLASS_CODE REF_DOC_EVENT_CLASS_CODE
, REF_DOC_TRX_ID REF_DOC_TRX_ID
, REF_DOC_HDR_TRX_USER_KEY1 REF_DOC_HDR_TRX_USER_KEY1
, REF_DOC_HDR_TRX_USER_KEY2 REF_DOC_HDR_TRX_USER_KEY2
, REF_DOC_HDR_TRX_USER_KEY3 REF_DOC_HDR_TRX_USER_KEY3
, REF_DOC_HDR_TRX_USER_KEY4 REF_DOC_HDR_TRX_USER_KEY4
, REF_DOC_HDR_TRX_USER_KEY5 REF_DOC_HDR_TRX_USER_KEY5
, REF_DOC_HDR_TRX_USER_KEY6 REF_DOC_HDR_TRX_USER_KEY6
, REF_DOC_LINE_ID REF_DOC_LINE_ID
, REF_DOC_LIN_TRX_USER_KEY1 REF_DOC_LIN_TRX_USER_KEY1
, REF_DOC_LIN_TRX_USER_KEY2 REF_DOC_LIN_TRX_USER_KEY2
, REF_DOC_LIN_TRX_USER_KEY3 REF_DOC_LIN_TRX_USER_KEY3
, REF_DOC_LIN_TRX_USER_KEY4 REF_DOC_LIN_TRX_USER_KEY4
, REF_DOC_LIN_TRX_USER_KEY5 REF_DOC_LIN_TRX_USER_KEY5
, REF_DOC_LIN_TRX_USER_KEY6 REF_DOC_LIN_TRX_USER_KEY6
, REF_DOC_DIST_ID REF_DOC_DIST_ID
, REF_DOC_DIST_TRX_USER_KEY1 REF_DOC_DIST_TRX_USER_KEY1
, REF_DOC_DIST_TRX_USER_KEY2 REF_DOC_DIST_TRX_USER_KEY2
, REF_DOC_DIST_TRX_USER_KEY3 REF_DOC_DIST_TRX_USER_KEY3
, REF_DOC_DIST_TRX_USER_KEY4 REF_DOC_DIST_TRX_USER_KEY4
, REF_DOC_DIST_TRX_USER_KEY5 REF_DOC_DIST_TRX_USER_KEY5
, REF_DOC_DIST_TRX_USER_KEY6 REF_DOC_DIST_TRX_USER_KEY6
, REF_DOC_CURR_CONV_RATE REF_DOC_CURR_CONV_RATE
, NUMERIC1 NUMERIC1
, NUMERIC2 NUMERIC2
, NUMERIC3 NUMERIC3
, NUMERIC4 NUMERIC4
, NUMERIC5 NUMERIC5
, CHAR1 CHAR1
, CHAR2 CHAR2
, CHAR3 CHAR3
, CHAR4 CHAR4
, CHAR5 CHAR5
, DATE1 DATE1
, DATE2 DATE2
, DATE3 DATE3
, DATE4 DATE4
, DATE5 DATE5
, TRX_LINE_DIST_TAX_AMT TRX_LINE_DIST_TAX_AMT
, HISTORICAL_FLAG HISTORICAL_FLAG
, APPLIED_FROM_APPLICATION_ID APPLIED_FROM_APPLICATION_ID
, APPLIED_FROM_EVENT_CLASS_CODE APPLIED_FROM_EVENT_CLASS_CODE
, APPLIED_FROM_ENTITY_CODE APPLIED_FROM_ENTITY_CODE
, APPLIED_FROM_TRX_ID APPLIED_FROM_TRX_ID
, APP_FROM_HDR_TRX_USER_KEY1 APP_FROM_HDR_TRX_USER_KEY1
, APP_FROM_HDR_TRX_USER_KEY2 APP_FROM_HDR_TRX_USER_KEY2
, APP_FROM_HDR_TRX_USER_KEY3 APP_FROM_HDR_TRX_USER_KEY3
, APP_FROM_HDR_TRX_USER_KEY4 APP_FROM_HDR_TRX_USER_KEY4
, APP_FROM_HDR_TRX_USER_KEY5 APP_FROM_HDR_TRX_USER_KEY5
, APP_FROM_HDR_TRX_USER_KEY6 APP_FROM_HDR_TRX_USER_KEY6
, APPLIED_FROM_LINE_ID APPLIED_FROM_LINE_ID
, APP_FROM_LIN_TRX_USER_KEY1 APP_FROM_LIN_TRX_USER_KEY1
, APP_FROM_LIN_TRX_USER_KEY2 APP_FROM_LIN_TRX_USER_KEY2
, APP_FROM_LIN_TRX_USER_KEY3 APP_FROM_LIN_TRX_USER_KEY3
, APP_FROM_LIN_TRX_USER_KEY4 APP_FROM_LIN_TRX_USER_KEY4
, APP_FROM_LIN_TRX_USER_KEY5 APP_FROM_LIN_TRX_USER_KEY5
, APP_FROM_LIN_TRX_USER_KEY6 APP_FROM_LIN_TRX_USER_KEY6
, APPLIED_FROM_DIST_ID APPLIED_FROM_DIST_ID
, APP_FROM_DST_TRX_USER_KEY1 APP_FROM_DST_TRX_USER_KEY1
, APP_FROM_DST_TRX_USER_KEY2 APP_FROM_DST_TRX_USER_KEY2
, APP_FROM_DST_TRX_USER_KEY3 APP_FROM_DST_TRX_USER_KEY3
, APP_FROM_DST_TRX_USER_KEY4 APP_FROM_DST_TRX_USER_KEY4
, APP_FROM_DST_TRX_USER_KEY5 APP_FROM_DST_TRX_USER_KEY5
, APP_FROM_DST_TRX_USER_KEY6 APP_FROM_DST_TRX_USER_KEY6
, ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_APPLICATION_ID
, ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE
, ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE
, ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID
, ADJ_DOC_HDR_TRX_USER_KEY1 ADJ_DOC_HDR_TRX_USER_KEY1
, ADJ_DOC_HDR_TRX_USER_KEY2 ADJ_DOC_HDR_TRX_USER_KEY2
, ADJ_DOC_HDR_TRX_USER_KEY3 ADJ_DOC_HDR_TRX_USER_KEY3
, ADJ_DOC_HDR_TRX_USER_KEY4 ADJ_DOC_HDR_TRX_USER_KEY4
, ADJ_DOC_HDR_TRX_USER_KEY5 ADJ_DOC_HDR_TRX_USER_KEY5
, ADJ_DOC_HDR_TRX_USER_KEY6 ADJ_DOC_HDR_TRX_USER_KEY6
, ADJUSTED_DOC_LINE_ID ADJUSTED_DOC_LINE_ID
, ADJ_DOC_LIN_TRX_USER_KEY1 ADJ_DOC_LIN_TRX_USER_KEY1
, ADJ_DOC_LIN_TRX_USER_KEY2 ADJ_DOC_LIN_TRX_USER_KEY2
, ADJ_DOC_LIN_TRX_USER_KEY3 ADJ_DOC_LIN_TRX_USER_KEY3
, ADJ_DOC_LIN_TRX_USER_KEY4 ADJ_DOC_LIN_TRX_USER_KEY4
, ADJ_DOC_LIN_TRX_USER_KEY5 ADJ_DOC_LIN_TRX_USER_KEY5
, ADJ_DOC_LIN_TRX_USER_KEY6 ADJ_DOC_LIN_TRX_USER_KEY6
, ADJUSTED_DOC_DIST_ID ADJUSTED_DOC_DIST_ID
, ADJ_DOC_DST_TRX_USER_KEY1 ADJ_DOC_DST_TRX_USER_KEY1
, ADJ_DOC_DST_TRX_USER_KEY2 ADJ_DOC_DST_TRX_USER_KEY2
, ADJ_DOC_DST_TRX_USER_KEY3 ADJ_DOC_DST_TRX_USER_KEY3
, ADJ_DOC_DST_TRX_USER_KEY4 ADJ_DOC_DST_TRX_USER_KEY4
, ADJ_DOC_DST_TRX_USER_KEY5 ADJ_DOC_DST_TRX_USER_KEY5
, ADJ_DOC_DST_TRX_USER_KEY6 ADJ_DOC_DST_TRX_USER_KEY6
, APPLIED_TO_DOC_CURR_CONV_RATE APPLIED_TO_DOC_CURR_CONV_RATE
, TAX_VARIANCE_CALC_FLAG TAX_VARIANCE_CALC_FLAG
, REF_DOC_TRX_LINE_DIST_QTY REF_DOC_TRX_LINE_DIST_QTY
, PRICE_DIFF PRICE_DIFF
, UNIT_PRICE UNIT_PRICE
, CURRENCY_EXCHANGE_RATE CURRENCY_EXCHANGE_RATE
, REF_DOC_TRX_LEVEL_TYPE REF_DOC_TRX_LEVEL_TYPE
, APPLIED_FROM_TRX_LEVEL_TYPE APPLIED_FROM_TRX_LEVEL_TYPE
, ADJUSTED_DOC_TRX_LEVEL_TYPE ADJUSTED_DOC_TRX_LEVEL_TYPE
, OVERRIDING_RECOVERY_RATE OVERRIDING_RECOVERY_RATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "ZX"."ZX_SIM_TRX_DISTS"