[Home] [Help] [Dependency Information]

TABLE: AP.AP_MRC_AE_LINES_ALL

Object Details

Temporary Table Details

AP.AP_MRC_AE_LINES_ALL 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

Columns

Query Text

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

SELECT AE_LINE_ID
,      AE_HEADER_ID
,      AE_LINE_NUMBER
,      AE_LINE_TYPE_CODE
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      SOURCE_TABLE
,      SOURCE_ID
,      ACCOUNT_OVERLAY_SOURCE_ID
,      GL_SL_LINK_ID
,      DESCRIPTION
,      ACCOUNTING_ERROR_CODE
,      GL_TRANSFER_ERROR_CODE
,      THIRD_PARTY_ID
,      THIRD_PARTY_SUB_ID
,      STAT_AMOUNT
,      SUBLEDGER_DOC_SEQUENCE_ID
,      SUBLEDGER_DOC_SEQUENCE_VALUE
,      ORG_ID
,      CREATION_DATE
,      USSGL_TRANSACTION_CODE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      APPLIED_FROM_TRX_HDR_TABLE
,      APPLIED_FROM_TRX_HDR_ID
,      APPLIED_TO_TRX_HDR_TABLE
,      APPLIED_TO_TRX_HDR_ID
,      TAX_CODE_ID
,      TAXABLE_ENTERED_DR
,      TAXABLE_ENTERED_CR
,      TAXABLE_ACCOUNTED_DR
,      TAXABLE_ACCOUNTED_CR
,      TAX_LINK_ID
FROM AP.AP_MRC_AE_LINES_ALL;

Dependencies

[top of page]

AP.AP_MRC_AE_LINES_ALL does not reference any database object

AP.AP_MRC_AE_LINES_ALL is referenced by following:

APPS

AP_MRC_AE_LINES_ALL