[Home] [Help] [Dependency Information]

TABLE: AR.AR_XLA_LINES_EXTRACT

Object Details

Object Name:	AR_XLA_LINES_EXTRACT
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_XLA_LINES_EXTRACT
Subobject Name:
Status:	VALID

Temporary Table Details

AR.AR_XLA_LINES_EXTRACT 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
AR_XLA_LINES_EXTRACT_N1	NORMAL	NONUNIQUE		EVENT_ID LINE_NUMBER LEVEL_FLAG EVENT_CLASS_CODE FROM_TO_FLAG
AR_XLA_LINES_EXTRACT_N2	NORMAL	NONUNIQUE		LINE_ID
AR_XLA_LINES_EXTRACT_N3	NORMAL	NONUNIQUE		EVENT_ID LINE_NUMBER MFAR_ADDITIONAL_ENTRY LEVEL_FLAG POSTING_ENTITY FROM_TO_FLAG CUSTOMER_TRX_ID

Columns

Query Text

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

SELECT EVENT_ID
,      LINE_NUMBER
,      LANGUAGE
,      LEDGER_ID
,      SOURCE_ID
,      SOURCE_TABLE
,      LINE_ID
,      TAX_CODE_ID
,      LOCATION_SEGMENT_ID
,      BASE_CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      ACCTD_AMOUNT
,      TAXABLE_ACCTD_AMOUNT
,      ORG_ID
,      HEADER_TABLE_ID
,      POSTING_ENTITY
,      CASH_RECEIPT_ID
,      CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      CUST_TRX_LINE_GL_DIST_ID
,      CUST_TRX_LINE_SALESREP_ID
,      INVENTORY_ITEM_ID
,      SALES_TAX_ID
,      SO_ORGANIZATION_ID
,      TAX_EXEMPTION_ID
,      UOM_CODE
,      WAREHOUSE_ID
,      AGREEMENT_ID
,      CUSTOMER_BANK_ACCT_ID
,      DRAWEE_BANK_ACCOUNT_ID
,      REMITTANCE_BANK_ACCT_ID
,      DISTRIBUTION_SET_ID
,      PAYMENT_SCHEDULE_ID
,      RECEIPT_METHOD_ID
,      RECEIVABLES_TRX_ID
,      ED_ADJ_RECEIVABLES_TRX_ID
,      UNED_RECEIVABLES_TRX_ID
,      SET_OF_BOOKS_ID
,      SALESREP_ID
,      BILL_SITE_USE_ID
,      DRAWEE_SITE_USE_ID
,      PAYING_SITE_USE_ID
,      SOLD_SITE_USE_ID
,      SHIP_SITE_USE_ID
,      RECEIPT_CUSTOMER_SITE_USE_ID
,      BILL_CUST_ROLE_ID
,      DRAWEE_CUST_ROLE_ID
,      SHIP_CUST_ROLE_ID
,      SOLD_CUST_ROLE_ID
,      BILL_CUSTOMER_ID
,      DRAWEE_CUSTOMER_ID
,      PAYING_CUSTOMER_ID
,      SOLD_CUSTOMER_ID
,      SHIP_CUSTOMER_ID
,      REMIT_ADDRESS_ID
,      RECEIPT_BATCH_ID
,      RECEIVABLE_APPLICATION_ID
,      CUSTOMER_BANK_BRANCH_ID
,      ISSUER_BANK_BRANCH_ID
,      BATCH_SOURCE_ID
,      BATCH_ID
,      TERM_ID
,      SELECT_FLAG
,      LEVEL_FLAG
,      FROM_TO_FLAG
,      CRH_STATUS
,      CRH_PRV_STATUS
,      AMOUNT
,      FROM_AMOUNT
,      FROM_ACCTD_AMOUNT
,      PREV_FUND_SEG_REPLACE
,      APP_CRH_STATUS
,      PAIRED_CCID
,      PAIRE_DIST_ID
,      REF_DIST_CCID
,      REF_MF_DIST_FLAG
,      ORIGIN_EXTRACT_TABLE
,      EVENT_TYPE_CODE
,      EVENT_CLASS_CODE
,      ENTITY_CODE
,      REVERSAL_CODE
,      BUSINESS_FLOW_CODE
,      TAX_LINE_ID
,      ADDITIONAL_CHAR1
,      ADDITIONAL_CHAR2
,      ADDITIONAL_CHAR3
,      ADDITIONAL_CHAR4
,      ADDITIONAL_CHAR5
,      ADDITIONAL_ID1
,      ADDITIONAL_ID2
,      ADDITIONAL_ID3
,      ADDITIONAL_ID4
,      ADDITIONAL_ID5
,      XLA_ENTITY_ID
,      REF_CTLGD_CCID
,      DIST_CCID
,      FROM_EXCHANGE_RATE
,      FROM_EXCHANGE_RATE_TYPE
,      FROM_EXCHANGE_DATE
,      FROM_CURRENCY_CODE
,      TO_CURRENCY_CODE
,      MFAR_ADDITIONAL_ENTRY
,      THIRD_PARTY_ID
,      THIRD_PARTY_SITE_ID
,      THIRD_PARTY_TYPE
,      SOURCE_TYPE
,      CM_APP_TO_TRX_LINE_ID
,      BAL_SEG_VALUE
FROM AR.AR_XLA_LINES_EXTRACT;

Dependencies

[top of page]

AR.AR_XLA_LINES_EXTRACT does not reference any database object

AR.AR_XLA_LINES_EXTRACT is referenced by following:

APPS

AR_XLA_LINES_EXTRACT