DBA Data[Home] [Help] [Dependency Information]

TABLE: AP.AP_MRC_AE_LINES_ALL

Object Details
Object Name: AP_MRC_AE_LINES_ALL
Object Type: TABLE
Owner: AP
Subobject Name:
Status: VALID

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: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
AE_LINE_ID NUMBER (15) Yes
AE_HEADER_ID NUMBER (15) Yes
AE_LINE_NUMBER NUMBER (15)
AE_LINE_TYPE_CODE VARCHAR2 (30) Yes
CODE_COMBINATION_ID NUMBER (15) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

ENTERED_DR NUMBER

ENTERED_CR NUMBER

ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

SOURCE_TABLE VARCHAR2 (30) Yes
SOURCE_ID NUMBER (15) Yes
ACCOUNT_OVERLAY_SOURCE_ID NUMBER (15)
GL_SL_LINK_ID NUMBER (15)
DESCRIPTION VARCHAR2 (240)
ACCOUNTING_ERROR_CODE VARCHAR2 (30)
GL_TRANSFER_ERROR_CODE VARCHAR2 (30)
THIRD_PARTY_ID NUMBER (15)
THIRD_PARTY_SUB_ID NUMBER (15)
STAT_AMOUNT NUMBER

SUBLEDGER_DOC_SEQUENCE_ID NUMBER (15)
SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER (15)
ORG_ID NUMBER (15)
CREATION_DATE DATE
Yes
USSGL_TRANSACTION_CODE VARCHAR2 (30)
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_UPDATE_DATE DATE

PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
REQUEST_ID NUMBER (15)
REFERENCE1 VARCHAR2 (240)
REFERENCE2 VARCHAR2 (240)
REFERENCE3 VARCHAR2 (240)
REFERENCE4 VARCHAR2 (240)
REFERENCE5 VARCHAR2 (240)
REFERENCE6 VARCHAR2 (240)
REFERENCE7 VARCHAR2 (240)
REFERENCE8 VARCHAR2 (240)
REFERENCE9 VARCHAR2 (240)
REFERENCE10 VARCHAR2 (240)
APPLIED_FROM_TRX_HDR_TABLE VARCHAR2 (30)
APPLIED_FROM_TRX_HDR_ID NUMBER (15)
APPLIED_TO_TRX_HDR_TABLE VARCHAR2 (30)
APPLIED_TO_TRX_HDR_ID NUMBER (15)
TAX_CODE_ID NUMBER (15)
TAXABLE_ENTERED_DR NUMBER

TAXABLE_ENTERED_CR NUMBER

TAXABLE_ACCOUNTED_DR NUMBER

TAXABLE_ACCOUNTED_CR NUMBER

TAX_LINK_ID NUMBER (15)
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:

SchemaAPPS
SynonymAP_MRC_AE_LINES_ALL