[Home] [Help] [Dependency Information]
Object Name: | AR_XLA_LINES_EXTRACT |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_XLA_LINES_EXTRACT |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | ||
LINE_NUMBER | NUMBER | (15) | ||
LANGUAGE | VARCHAR2 | (20) | ||
LEDGER_ID | NUMBER | (15) | ||
SOURCE_ID | NUMBER | (15) | ||
SOURCE_TABLE | VARCHAR2 | (10) | ||
LINE_ID | NUMBER | (15) | ||
TAX_CODE_ID | NUMBER | (15) | ||
LOCATION_SEGMENT_ID | NUMBER | (15) | ||
BASE_CURRENCY_CODE | VARCHAR2 | (15) | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
EXCHANGE_RATE | NUMBER | |||
EXCHANGE_DATE | DATE | |||
ACCTD_AMOUNT | NUMBER | |||
TAXABLE_ACCTD_AMOUNT | NUMBER | |||
ORG_ID | NUMBER | (15) | ||
HEADER_TABLE_ID | NUMBER | (15) | ||
POSTING_ENTITY | VARCHAR2 | (20) | ||
CASH_RECEIPT_ID | NUMBER | (15) | ||
CUSTOMER_TRX_ID | NUMBER | (15) | ||
CUSTOMER_TRX_LINE_ID | NUMBER | (15) | ||
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | ||
CUST_TRX_LINE_SALESREP_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | ||
SALES_TAX_ID | NUMBER | (15) | ||
SO_ORGANIZATION_ID | NUMBER | (15) | ||
TAX_EXEMPTION_ID | NUMBER | (15) | ||
UOM_CODE | VARCHAR2 | (3) | ||
WAREHOUSE_ID | NUMBER | (15) | ||
AGREEMENT_ID | NUMBER | (15) | ||
CUSTOMER_BANK_ACCT_ID | NUMBER | (15) | ||
DRAWEE_BANK_ACCOUNT_ID | NUMBER | (15) | ||
REMITTANCE_BANK_ACCT_ID | NUMBER | (15) | ||
DISTRIBUTION_SET_ID | NUMBER | (15) | ||
PAYMENT_SCHEDULE_ID | NUMBER | (15) | ||
RECEIPT_METHOD_ID | NUMBER | (15) | ||
RECEIVABLES_TRX_ID | NUMBER | (15) | ||
ED_ADJ_RECEIVABLES_TRX_ID | NUMBER | (15) | ||
UNED_RECEIVABLES_TRX_ID | NUMBER | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
SALESREP_ID | NUMBER | (15) | ||
BILL_SITE_USE_ID | NUMBER | (15) | ||
DRAWEE_SITE_USE_ID | NUMBER | (15) | ||
PAYING_SITE_USE_ID | NUMBER | (15) | ||
SOLD_SITE_USE_ID | NUMBER | (15) | ||
SHIP_SITE_USE_ID | NUMBER | (15) | ||
RECEIPT_CUSTOMER_SITE_USE_ID | NUMBER | (15) | ||
BILL_CUST_ROLE_ID | NUMBER | (15) | ||
DRAWEE_CUST_ROLE_ID | NUMBER | (15) | ||
SHIP_CUST_ROLE_ID | NUMBER | (15) | ||
SOLD_CUST_ROLE_ID | NUMBER | (15) | ||
BILL_CUSTOMER_ID | NUMBER | (15) | ||
DRAWEE_CUSTOMER_ID | NUMBER | (15) | ||
PAYING_CUSTOMER_ID | NUMBER | (15) | ||
SOLD_CUSTOMER_ID | NUMBER | (15) | ||
SHIP_CUSTOMER_ID | NUMBER | (15) | ||
REMIT_ADDRESS_ID | NUMBER | (15) | ||
RECEIPT_BATCH_ID | NUMBER | (15) | ||
RECEIVABLE_APPLICATION_ID | NUMBER | (15) | ||
CUSTOMER_BANK_BRANCH_ID | NUMBER | (15) | ||
ISSUER_BANK_BRANCH_ID | NUMBER | (15) | ||
BATCH_SOURCE_ID | NUMBER | (15) | ||
BATCH_ID | NUMBER | (15) | ||
TERM_ID | NUMBER | (15) | ||
SELECT_FLAG | VARCHAR2 | (1) | ||
LEVEL_FLAG | VARCHAR2 | (1) | ||
FROM_TO_FLAG | VARCHAR2 | (1) | ||
CRH_STATUS | VARCHAR2 | (30) | ||
CRH_PRV_STATUS | VARCHAR2 | (30) | ||
AMOUNT | NUMBER | |||
FROM_AMOUNT | NUMBER | |||
FROM_ACCTD_AMOUNT | NUMBER | |||
PREV_FUND_SEG_REPLACE | VARCHAR2 | (1) | ||
APP_CRH_STATUS | VARCHAR2 | (30) | ||
PAIRED_CCID | NUMBER | |||
PAIRE_DIST_ID | NUMBER | |||
REF_DIST_CCID | NUMBER | |||
REF_MF_DIST_FLAG | VARCHAR2 | (15) | ||
ORIGIN_EXTRACT_TABLE | VARCHAR2 | (30) | ||
EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
ENTITY_CODE | VARCHAR2 | (30) | ||
REVERSAL_CODE | VARCHAR2 | (30) | ||
BUSINESS_FLOW_CODE | VARCHAR2 | (30) | ||
TAX_LINE_ID | NUMBER | (15) | ||
ADDITIONAL_CHAR1 | VARCHAR2 | (30) | ||
ADDITIONAL_CHAR2 | VARCHAR2 | (30) | ||
ADDITIONAL_CHAR3 | VARCHAR2 | (30) | ||
ADDITIONAL_CHAR4 | VARCHAR2 | (30) | ||
ADDITIONAL_CHAR5 | VARCHAR2 | (30) | ||
ADDITIONAL_ID1 | NUMBER | |||
ADDITIONAL_ID2 | NUMBER | |||
ADDITIONAL_ID3 | NUMBER | |||
ADDITIONAL_ID4 | NUMBER | |||
ADDITIONAL_ID5 | NUMBER | |||
XLA_ENTITY_ID | NUMBER | (15) | ||
REF_CTLGD_CCID | NUMBER | (15) | ||
DIST_CCID | NUMBER | (15) | ||
FROM_EXCHANGE_RATE | NUMBER | |||
FROM_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
FROM_EXCHANGE_DATE | DATE | |||
FROM_CURRENCY_CODE | VARCHAR2 | (30) | ||
TO_CURRENCY_CODE | VARCHAR2 | (30) | ||
MFAR_ADDITIONAL_ENTRY | VARCHAR2 | (30) | ||
THIRD_PARTY_ID | NUMBER | (15) | ||
THIRD_PARTY_SITE_ID | NUMBER | (15) | ||
THIRD_PARTY_TYPE | VARCHAR2 | (30) | ||
SOURCE_TYPE | VARCHAR2 | (30) | ||
CM_APP_TO_TRX_LINE_ID | NUMBER | (15) | ||
BAL_SEG_VALUE | VARCHAR2 | (25) |
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;
AR.AR_XLA_LINES_EXTRACT does not reference any database object
AR.AR_XLA_LINES_EXTRACT is referenced by following:
|
|
|