[Home] [Help] [Dependency Information]
Object Name: | ZX_DISTRIBUTION_LINES_GT |
---|---|
Object Type: | TABLE |
Owner: | ZX |
Subobject Name: | |
Status: | VALID |
ZX.ZX_DISTRIBUTION_LINES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Yes | ||
ENTITY_CODE | VARCHAR2 | (30) | Yes | |
EVENT_CLASS_CODE | VARCHAR2 | (30) | Yes | |
EVENT_TYPE_CODE | VARCHAR2 | (30) | Yes | |
TRX_ID | NUMBER | |||
HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
TRX_LINE_ID | NUMBER | |||
LINE_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
LINE_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
LINE_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
LINE_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
LINE_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
LINE_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
TRX_LEVEL_TYPE | VARCHAR2 | (30) | Yes | |
TRX_LINE_DIST_ID | NUMBER | |||
DIST_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
DIST_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
DIST_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
DIST_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
DIST_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
DIST_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
DIST_LEVEL_ACTION | VARCHAR2 | (30) | Yes | |
TRX_LINE_DIST_DATE | DATE | Yes | ||
ITEM_DIST_NUMBER | NUMBER | |||
DIST_INTENDED_USE | VARCHAR2 | (30) | Yes | |
TAX_INCLUSION_FLG | VARCHAR2 | (1) | ||
TAX_CODE | VARCHAR2 | (30) | ||
APPLIED_FROM_TAX_DIST_ID | NUMBER | |||
ADJUSTED_DOC_TAX_DIST_ID | NUMBER | |||
TASK_ID | NUMBER | |||
AWARD_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
EXPENDITURE_ITEM_DATE | DATE | |||
TRX_LINE_DIST_AMT | NUMBER | Yes | ||
TRX_LINE_DIST_QUANTITY | NUMBER | |||
TRX_LINE_QUANTITY | NUMBER | Yes | ||
ACCOUNT_CCID | NUMBER | |||
ACCOUNT_STRING | VARCHAR2 | (2000) | ||
REF_DOC_APPLICATION_ID | NUMBER | |||
REF_DOC_ENTITY_CODE | VARCHAR2 | (30) | ||
REF_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
REF_DOC_TRX_ID | NUMBER | |||
REF_DOC_HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
REF_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
REF_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
REF_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
REF_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
REF_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
REF_DOC_LINE_ID | NUMBER | |||
REF_DOC_LIN_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
REF_DOC_LIN_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
REF_DOC_LIN_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
REF_DOC_LIN_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
REF_DOC_LIN_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
REF_DOC_LIN_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
REF_DOC_DIST_ID | NUMBER | |||
REF_DOC_DIST_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
REF_DOC_DIST_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
REF_DOC_DIST_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
REF_DOC_DIST_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
REF_DOC_DIST_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
REF_DOC_DIST_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
REF_DOC_CURR_CONV_RATE | NUMBER | |||
NUMERIC1 | NUMBER | |||
NUMERIC2 | NUMBER | |||
NUMERIC3 | NUMBER | |||
NUMERIC4 | NUMBER | |||
NUMERIC5 | NUMBER | |||
CHAR1 | VARCHAR2 | (150) | ||
CHAR2 | VARCHAR2 | (150) | ||
CHAR3 | VARCHAR2 | (150) | ||
CHAR4 | VARCHAR2 | (150) | ||
CHAR5 | VARCHAR2 | (150) | ||
DATE1 | DATE | |||
DATE2 | DATE | |||
DATE3 | DATE | |||
DATE4 | DATE | |||
DATE5 | DATE | |||
TRX_LINE_DIST_TAX_AMT | NUMBER | |||
HISTORICAL_FLG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, ENTITY_CODE
, EVENT_CLASS_CODE
, EVENT_TYPE_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_FLG
, 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_QUANTITY
, 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_FLG
FROM ZX.ZX_DISTRIBUTION_LINES_GT;
ZX.ZX_DISTRIBUTION_LINES_GT does not reference any database object
ZX.ZX_DISTRIBUTION_LINES_GT is referenced by following:
|
|
|