[Home] [Help] [Dependency Information]
Object Name: | AP_OPEN_ITEMS_REVAL_GT |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_OPEN_ITEMS_REVAL_GT |
Subobject Name: | |
Status: | VALID |
AP.AP_OPEN_ITEMS_REVAL_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 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_OPEN_ITEMS_REVAL_GT_N1 | NORMAL | NONUNIQUE | TXN_NUMBER | |
AP_OPEN_ITEMS_REVAL_GT_N2 | NORMAL | NONUNIQUE |
VENDOR_ID
VENDOR_SITE_ID | |
AP_OPEN_ITEMS_REVAL_GT_N3 | NORMAL | NONUNIQUE |
PARTY_ID
PARTY_SITE_ID | |
AP_OPEN_ITEMS_REVAL_GT_N4 | NORMAL | NONUNIQUE |
TXN_ID
CODE_COMBINATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BALANCING_SEGMENT | VARCHAR2 | (25) | ||
ACCOUNT_SEGMENT | VARCHAR2 | (25) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Yes | |
ACCOUNT | VARCHAR2 | (311) | ||
VENDOR_ID | NUMBER | (15) | ||
PARTY_NAME | VARCHAR2 | (360) | ||
VENDOR_NUMBER | VARCHAR2 | (30) | ||
VENDOR_SITE_ID | NUMBER | (15) | ||
VENDOR_SITE_CODE | VARCHAR2 | (15) | ||
PARTY_ID | NUMBER | (15) | ||
PARTY_SITE_ID | NUMBER | (15) | ||
TXN_ID | NUMBER | (15) | Yes | |
TXN_NUMBER | VARCHAR2 | (50) | Yes | |
TXN_TYPE_LOOKUP_CODE | VARCHAR2 | (80) | Yes | |
TXN_DATE | DATE | |||
TXN_AMOUNT | NUMBER | |||
TXN_BASE_AMOUNT | NUMBER | |||
TXN_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
TXN_CURR_MIN_ACCT_UNIT | NUMBER | |||
TXN_CURR_PRECISION | NUMBER | (1) | ||
TXN_BASE_EXCHANGE_RATE | NUMBER | |||
PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
PAYMENT_CROSS_RATE | NUMBER | |||
PAYMENT_CURR_PRECISION | NUMBER | (1) | ||
PMT_CURR_MIN_ACCT_UNIT | NUMBER | |||
PAYMENT_STATUS_FLAG | VARCHAR2 | (1) | ||
ENTERED_AMOUNT | NUMBER | |||
ACCOUNTED_AMOUNT | NUMBER | |||
DUE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT BALANCING_SEGMENT
, ACCOUNT_SEGMENT
, CODE_COMBINATION_ID
, ACCOUNT
, VENDOR_ID
, PARTY_NAME
, VENDOR_NUMBER
, VENDOR_SITE_ID
, VENDOR_SITE_CODE
, PARTY_ID
, PARTY_SITE_ID
, TXN_ID
, TXN_NUMBER
, TXN_TYPE_LOOKUP_CODE
, TXN_DATE
, TXN_AMOUNT
, TXN_BASE_AMOUNT
, TXN_CURRENCY_CODE
, TXN_CURR_MIN_ACCT_UNIT
, TXN_CURR_PRECISION
, TXN_BASE_EXCHANGE_RATE
, PAYMENT_CURRENCY_CODE
, PAYMENT_CROSS_RATE
, PAYMENT_CURR_PRECISION
, PMT_CURR_MIN_ACCT_UNIT
, PAYMENT_STATUS_FLAG
, ENTERED_AMOUNT
, ACCOUNTED_AMOUNT
, DUE_DATE
FROM AP.AP_OPEN_ITEMS_REVAL_GT;
AP.AP_OPEN_ITEMS_REVAL_GT does not reference any database object
AP.AP_OPEN_ITEMS_REVAL_GT is referenced by following:
|
|
|