[Home] [Help] [Dependency Information]

TABLE: AP.AP_OPEN_ITEMS_REVAL_GT

Object Details

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

Temporary Table Details

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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

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

Columns

Query Text

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;

Dependencies

[top of page]

AP.AP_OPEN_ITEMS_REVAL_GT does not reference any database object

AP.AP_OPEN_ITEMS_REVAL_GT is referenced by following:

APPS

AP_OPEN_ITEMS_REVAL_GT