[Home] [Help] [Dependency Information]

TABLE: AP.AP_PERIOD_CLOSE_EXCPS_GT

Object Details

Object Name:	AP_PERIOD_CLOSE_EXCPS_GT
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_PERIOD_CLOSE_EXCPS_GT
Subobject Name:
Status:	VALID

Temporary Table Details

AP.AP_PERIOD_CLOSE_EXCPS_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_PERIOD_CLOSE_EXCPS_GT_N1	NORMAL	NONUNIQUE		SOURCE_TYPE SOURCE_TABLE_NAME
AP_PERIOD_CLOSE_EXCPS_GT_N2	NORMAL	NONUNIQUE		ACCOUNTING_EVENT_ID
AP_PERIOD_CLOSE_EXCPS_GT_N3	NORMAL	NONUNIQUE		INVOICE_DISTRIBUTION_ID SOURCE_TABLE_NAME SOURCE_TYPE
AP_PERIOD_CLOSE_EXCPS_GT_N4	NORMAL	NONUNIQUE		INVOICE_ID INVOICE_LINE_NUMBER

Columns

Query Text

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

SELECT INVOICE_ID
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_LINE_NUMBER
,      ACCOUNTING_DATE
,      ORG_ID
,      INVOICE_NUM
,      INVOICE_CURRENCY_CODE
,      VENDOR_ID
,      PARTY_ID
,      DOC_SEQUENCE_VALUE
,      VOUCHER_NUM
,      INVOICE_DATE
,      INVOICE_AMOUNT
,      CANCELLED_DATE
,      MATCH_STATUS_FLAG
,      PAYMENT_HISTORY_ID
,      INVOICE_PAYMENT_ID
,      ACCOUNTING_EVENT_ID
,      CHECK_ID
,      PAYMENT_AMOUNT
,      RECON_ACCOUNTING_FLAG
,      TRANSACTION_TYPE
,      LEGAL_ENTITY_ID
,      PO_DISTRIBUTION_ID
,      DETAIL_TAX_DIST_ID
,      AMOUNT
,      CHECK_NUMBER
,      CHECK_AMOUNT
,      CHECK_DATE
,      EXCHANGE_RATE
,      VENDOR_NAME
,      BANK_ACCOUNT_NAME
,      CURRENCY_CODE
,      STATUS_LOOKUP_CODE
,      SOURCE_TYPE
,      SOURCE_TABLE_NAME
,      PROCESS_STATUS_FLAG
,      EVENT_TYPE_CODE
,      ENTITY_CODE
FROM AP.AP_PERIOD_CLOSE_EXCPS_GT;

Dependencies

[top of page]

AP.AP_PERIOD_CLOSE_EXCPS_GT does not reference any database object

AP.AP_PERIOD_CLOSE_EXCPS_GT is referenced by following:

APPS

AP_PERIOD_CLOSE_EXCPS_GT