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

TABLE: ZX.ZX_SIM_TRX_DISTS

Object Details
Object Name: ZX_SIM_TRX_DISTS
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_SIM_TRX_DISTS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_SIM_TRX_DISTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
ColumnTRX_LINE_ID
ColumnTRX_LINE_DIST_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier of the item distribution
ENTITY_CODE VARCHAR2 (30) Yes Entity code of this item distribution
EVENT_CLASS_CODE VARCHAR2 (30) Yes Event class code of this item distribution
TRX_ID NUMBER

Transaction identifier of this item distribution
HDR_TRX_USER_KEY1 VARCHAR2 (150)
First component of the user composite key to uniquely identify the transaction of this item distribution
HDR_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the user composite key to uniquely identify the transaction of this item distribution
HDR_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the user composite key to uniquely identify the transaction of this item distribution
HDR_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the user composite key to uniquely identify the transaction of this item distribution
HDR_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the user composite key to uniquely identify the transaction of this item distribution
HDR_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the user composite key to uniquely identify the transaction of this item distribution
TRX_LINE_ID NUMBER

Transaction line identifier
LINE_TRX_USER_KEY1 VARCHAR2 (150)
First component of the line user composite key for uniquely identifying the transaction line of this item distribution
LINE_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the line user composite key for uniquely identifying the transaction line of this item distribution
LINE_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the line user composite key for uniquely identifying the transaction line of this item distribution
LINE_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the line user composite key for uniquely identifying the transaction line of this item distribution
LINE_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the line user composite key for uniquely identifying the transaction line of this item distribution
LINE_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the line user composite key for uniquely identifying the transaction line of this item distribution
TRX_LEVEL_TYPE VARCHAR2 (30) Yes Column to record the level at which the transaction line identifier is stored for this item distribution. Possible values are LINE, SHIPMENT and FREIGHT.
TRX_LINE_DIST_ID NUMBER

Item distribution identifier
DIST_TRX_USER_KEY1 VARCHAR2 (150)
First component of the user composite key for uniquely identifying this item distribution
DIST_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the user composite key for uniquely identifying this item distribution
DIST_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the user composite key for uniquely identifying this item distribution
DIST_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the user composite key for uniquely identifying this item distribution
DIST_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the user composite key for uniquely identifying this item distribution
DIST_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the user composite key for uniquely identifying this item distribution
DIST_LEVEL_ACTION VARCHAR2 (30) Yes Column to store action at the item distribution level
TRX_LINE_DIST_DATE DATE
Yes Item distribution date
ITEM_DIST_NUMBER NUMBER

Item distribution number
DIST_INTENDED_USE VARCHAR2 (240)
Intended use code of the item distribution. This identifies the purpose for which the product is used.
TAX_INCLUSION_FLAG VARCHAR2 (1)
Y or N indicates if all taxes are included in the distribution amount
TAX_CODE VARCHAR2 (30)
Tax classification code
APPLIED_FROM_TAX_DIST_ID NUMBER

Applied from document tax distribution identifier
ADJUSTED_DOC_TAX_DIST_ID NUMBER

Adjusted document tax distribution identifier
TASK_ID NUMBER

Identifier for the project task used to build accounting flexfield for project-related distribution line
AWARD_ID NUMBER

Reserved for use by Oracle Grants Management
PROJECT_ID NUMBER

Identifier for project used to build accounting flexfield for project-related distribution line
EXPENDITURE_TYPE VARCHAR2 (30)
Project expenditure type used to build accounting flexfield for project-related distribution line
EXPENDITURE_ORGANIZATION_ID NUMBER

Identifier for project organization used to build accounting flexfield for project-related distribution line
EXPENDITURE_ITEM_DATE DATE

Date for project expenditure item used to build accounting flexfield for project-related distribution line
TRX_LINE_DIST_AMT NUMBER
Yes Item distribution amount
TRX_LINE_DIST_QTY NUMBER

Quantity that pertains to this item distribution
TRX_LINE_QUANTITY NUMBER
Yes Transaction line quantity
ACCOUNT_CCID NUMBER

Account identifier associated with the item distribution line
ACCOUNT_STRING VARCHAR2 (2000)
Account string associated with the item distribution line
REF_DOC_APPLICATION_ID NUMBER

Reference document application identifier
REF_DOC_ENTITY_CODE VARCHAR2 (30)
Reference document entity code
REF_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Reference document event class code
REF_DOC_TRX_ID NUMBER

Reference document transaction identifier
REF_DOC_HDR_TRX_USER_KEY1 VARCHAR2 (150)
First component of the header level user composite key for uniquely identifying the reference document
REF_DOC_HDR_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the header level user composite key for uniquely identifying the reference document
REF_DOC_HDR_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the header level user composite key for uniquely identifying the reference document
REF_DOC_HDR_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the header level user composite key for uniquely identifying the reference document
REF_DOC_HDR_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the header level user composite key for uniquely identifying the reference document
REF_DOC_HDR_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the header level user composite key for uniquely identifying the reference document
REF_DOC_LINE_ID NUMBER

Transaction line identifier for the reference document
REF_DOC_LIN_TRX_USER_KEY1 VARCHAR2 (150)
First component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LIN_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LIN_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LIN_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LIN_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LIN_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_DIST_ID NUMBER

Item distribution identifier for the reference document
REF_DOC_DIST_TRX_USER_KEY1 VARCHAR2 (150)
First component of the user composite key for uniquely identifying the reference document distribution
REF_DOC_DIST_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the user composite key for uniquely identifying the reference document distribution
REF_DOC_DIST_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the user composite key for uniquely identifying the reference document distribution
REF_DOC_DIST_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the user composite key for uniquely identifying the reference document distribution
REF_DOC_DIST_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the user composite key for uniquely identifying the reference document distribution
REF_DOC_DIST_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the user composite key for uniquely identifying the reference document distribution
REF_DOC_CURR_CONV_RATE NUMBER

Reference document exchange rate
NUMERIC1 NUMBER

Not currently used
NUMERIC2 NUMBER

Not currently used
NUMERIC3 NUMBER

Not currently used
NUMERIC4 NUMBER

Not currently used
NUMERIC5 NUMBER

Not currently used
CHAR1 VARCHAR2 (150)
Not currently used
CHAR2 VARCHAR2 (150)
Not currently used
CHAR3 VARCHAR2 (150)
Not currently used
CHAR4 VARCHAR2 (150)
Not currently used
CHAR5 VARCHAR2 (150)
Not currently used
DATE1 DATE

Not currently used
DATE2 DATE

Not currently used
DATE3 DATE

Not currently used
DATE4 DATE

Not currently used
DATE5 DATE

Not currently used
TRX_LINE_DIST_TAX_AMT NUMBER

Transaction line distribution tax amount
HISTORICAL_FLAG VARCHAR2 (1)
Y or N indicates whether this distribution line is for a transaction migrated from prior releases
APPLIED_FROM_APPLICATION_ID NUMBER

Applied from document application identifier
APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 (30)
Applied from document event clas code
APPLIED_FROM_ENTITY_CODE VARCHAR2 (30)
Applied from document entity code
APPLIED_FROM_TRX_ID NUMBER

Applied from document transaction identifier
APP_FROM_HDR_TRX_USER_KEY1 VARCHAR2 (150)
First component of the header level user composite key for uniquely identifying the applied from document
APP_FROM_HDR_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the header level user composite key for uniquely identifying the applied from document
APP_FROM_HDR_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the header level user composite key for uniquely identifying the applied from document
APP_FROM_HDR_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the header level user composite key for uniquely identifying the applied from document
APP_FROM_HDR_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the header level user composite key for uniquely identifying the applied from document
APP_FROM_HDR_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the header level user composite key for uniquely identifying the applied from document
APPLIED_FROM_LINE_ID NUMBER

Transaction line identifier for the applied from document
APP_FROM_LIN_TRX_USER_KEY1 VARCHAR2 (150)
First component of the line level user composite key for uniquely identifying the applied from document line
APP_FROM_LIN_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the line level user composite key for uniquely identifying the applied from document line
APP_FROM_LIN_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the line level user composite key for uniquely identifying the applied from document line
APP_FROM_LIN_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the line level user composite key for uniquely identifying the applied from document line
APP_FROM_LIN_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the line level user composite key for uniquely identifying the applied from document line
APP_FROM_LIN_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the line level user composite key for uniquely identifying the applied from document line
APPLIED_FROM_DIST_ID NUMBER

Item distribution identifier for the applied from document
APP_FROM_DST_TRX_USER_KEY1 VARCHAR2 (150)
First component of the user composite key for uniquely identifying the applied from document distribution
APP_FROM_DST_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the user composite key for uniquely identifying the applied from document distribution
APP_FROM_DST_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the user composite key for uniquely identifying the applied from document distribution
APP_FROM_DST_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the user composite key for uniquely identifying the applied from document distribution
APP_FROM_DST_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the user composite key for uniquely identifying the applied from document distribution
APP_FROM_DST_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the user composite key for uniquely identifying the applied from document distribution
ADJUSTED_DOC_APPLICATION_ID NUMBER

Adjusted document application identifier
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Adjusted document event clas code
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
Adjusted document entity code
ADJUSTED_DOC_TRX_ID NUMBER

Adjusted document transaction identifier
ADJ_DOC_HDR_TRX_USER_KEY1 VARCHAR2 (150)
First component of the header level user composite key for uniquely identifying the adjusted document
ADJ_DOC_HDR_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the header level user composite key for uniquely identifying the adjusted document
ADJ_DOC_HDR_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the header level user composite key for uniquely identifying the adjusted document
ADJ_DOC_HDR_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the header level user composite key for uniquely identifying the adjusted document
ADJ_DOC_HDR_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the header level user composite key for uniquely identifying the adjusted document
ADJ_DOC_HDR_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the header level user composite key for uniquely identifying the adjusted document
ADJUSTED_DOC_LINE_ID NUMBER

Transaction line identifier for the adjusted document
ADJ_DOC_LIN_TRX_USER_KEY1 VARCHAR2 (150)
First component of the line level user composite key for uniquely identifying the adjusted document line
ADJ_DOC_LIN_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the line level user composite key for uniquely identifying the adjusted document line
ADJ_DOC_LIN_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the line level user composite key for uniquely identifying the adjusted document line
ADJ_DOC_LIN_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the line level user composite key for uniquely identifying the adjusted document line
ADJ_DOC_LIN_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the line level user composite key for uniquely identifying the adjusted document line
ADJ_DOC_LIN_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the line level user composite key for uniquely identifying the adjusted document line
ADJUSTED_DOC_DIST_ID NUMBER

Item distribution identifier for the adjusted document
ADJ_DOC_DST_TRX_USER_KEY1 VARCHAR2 (150)
First component of the user composite key for uniquely identifying the adjusted document distribution
ADJ_DOC_DST_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the user composite key for uniquely identifying the adjusted document distribution
ADJ_DOC_DST_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the user composite key for uniquely identifying the adjusted document distribution
ADJ_DOC_DST_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the user composite key for uniquely identifying the adjusted document distribution
ADJ_DOC_DST_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the user composite key for uniquely identifying the adjusted document distribution
ADJ_DOC_DST_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the user composite key for uniquely identifying the adjusted document distribution
APPLIED_TO_DOC_CURR_CONV_RATE NUMBER

Applied to document exchange rate
TAX_VARIANCE_CALC_FLAG VARCHAR2 (1)
Y or N indicates whether tax variance needs to be calculated
REF_DOC_TRX_LINE_DIST_QTY NUMBER

Reference document transaction line distribution quantity
PRICE_DIFF NUMBER

Price variance. This is applicable only for price correction invoices of Oracle Payables.
UNIT_PRICE NUMBER

Unit price
CURRENCY_EXCHANGE_RATE NUMBER

Exchange Rate
REF_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the reference document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
APPLIED_FROM_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the applied from document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
ADJUSTED_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the adjusted document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
OVERRIDING_RECOVERY_RATE NUMBER

User defined recovery rate that will override the system determined recovery rate
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

ZX.ZX_SIM_TRX_DISTS does not reference any database object

ZX.ZX_SIM_TRX_DISTS is referenced by following:

SchemaZX
ViewZX_SIM_TRX_DISTS#