[Home] [Help] [Dependency Information]
Object Name: | RA_CUSTOMER_TRX_LINES_GT |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.RA_CUSTOMER_TRX_LINES_GT |
Subobject Name: | |
Status: | VALID |
AR.RA_CUSTOMER_TRX_LINES_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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RA_CUSTOMER_TRX_LINES_GT_N1 | NORMAL | NONUNIQUE |
CUSTOMER_TRX_ID
CUSTOMER_TRX_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCTD_AMOUNT_DUE_ORIGINAL | NUMBER | |||
ACCTD_AMOUNT_DUE_REMAINING | NUMBER | |||
AMOUNT_DUE_ORIGINAL | NUMBER | |||
AMOUNT_DUE_REMAINING | NUMBER | |||
CHRG_ACCTD_AMOUNT_REMAINING | NUMBER | |||
CHRG_AMOUNT_REMAINING | NUMBER | |||
CUSTOMER_TRX_ID | NUMBER | |||
CUSTOMER_TRX_LINE_ID | NUMBER | |||
DESCRIPTION | VARCHAR2 | (240) | ||
FRT_ADJ_ACCTD_REMAINING | NUMBER | |||
FRT_ADJ_REMAINING | NUMBER | |||
FRT_ED_ACCTD_AMOUNT | NUMBER | |||
FRT_ED_AMOUNT | NUMBER | |||
FRT_UNED_ACCTD_AMOUNT | NUMBER | |||
FRT_UNED_AMOUNT | NUMBER | |||
GROUP_ID | VARCHAR2 | (1000) | ||
INVENTORY_ITEM_ID | NUMBER | |||
LINE_TYPE | VARCHAR2 | (20) | ||
LINK_TO_CUST_TRX_LINE_ID | NUMBER | |||
REASON_CODE | VARCHAR2 | (30) | ||
SET_OF_BOOKS_ID | NUMBER | |||
SOURCE_DATA_KEY1 | VARCHAR2 | (150) | ||
SOURCE_DATA_KEY2 | VARCHAR2 | (150) | ||
SOURCE_DATA_KEY3 | VARCHAR2 | (150) | ||
SOURCE_DATA_KEY4 | VARCHAR2 | (150) | ||
SOURCE_DATA_KEY5 | VARCHAR2 | (150) | ||
BR_LINE_ORIG_AMT | NUMBER | |||
BR_TAX_ORIG_AMT | NUMBER | |||
BR_FRT_ORIG_AMT | NUMBER | |||
BR_CHRG_ORIG_AMT | NUMBER | |||
BR_LINE_REM_AMT | NUMBER | |||
BR_TAX_REM_AMT | NUMBER | |||
BR_FRT_REM_AMT | NUMBER | |||
BR_CHRG_REM_AMT | NUMBER | |||
BR_LINE_ORIG_ACCTD_AMT | NUMBER | |||
BR_TAX_ORIG_ACCTD_AMT | NUMBER | |||
BR_FRT_ORIG_ACCTD_AMT | NUMBER | |||
BR_CHRG_ORIG_ACCTD_AMT | NUMBER | |||
BR_LINE_REM_ACCTD_AMT | NUMBER | |||
BR_TAX_REM_ACCTD_AMT | NUMBER | |||
BR_FRT_REM_ACCTD_AMT | NUMBER | |||
BR_CHRG_REM_ACCTD_AMT | NUMBER | |||
BR_REF_CUSTOMER_TRX_ID | NUMBER | |||
BR_ADJUSTMENT_ID | NUMBER | |||
LINE_ORIGIN | VARCHAR2 | (30) | ||
CM_AMT_DUE_ORIG | NUMBER | |||
CM_AMT_DUE_REM | NUMBER | |||
CM_ACCTD_AMT_DUE_ORIG | NUMBER | |||
CM_ACCTD_AMT_DUE_REM | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACCTD_AMOUNT_DUE_ORIGINAL
, ACCTD_AMOUNT_DUE_REMAINING
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, CHRG_ACCTD_AMOUNT_REMAINING
, CHRG_AMOUNT_REMAINING
, CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID
, DESCRIPTION
, FRT_ADJ_ACCTD_REMAINING
, FRT_ADJ_REMAINING
, FRT_ED_ACCTD_AMOUNT
, FRT_ED_AMOUNT
, FRT_UNED_ACCTD_AMOUNT
, FRT_UNED_AMOUNT
, GROUP_ID
, INVENTORY_ITEM_ID
, LINE_TYPE
, LINK_TO_CUST_TRX_LINE_ID
, REASON_CODE
, SET_OF_BOOKS_ID
, SOURCE_DATA_KEY1
, SOURCE_DATA_KEY2
, SOURCE_DATA_KEY3
, SOURCE_DATA_KEY4
, SOURCE_DATA_KEY5
, BR_LINE_ORIG_AMT
, BR_TAX_ORIG_AMT
, BR_FRT_ORIG_AMT
, BR_CHRG_ORIG_AMT
, BR_LINE_REM_AMT
, BR_TAX_REM_AMT
, BR_FRT_REM_AMT
, BR_CHRG_REM_AMT
, BR_LINE_ORIG_ACCTD_AMT
, BR_TAX_ORIG_ACCTD_AMT
, BR_FRT_ORIG_ACCTD_AMT
, BR_CHRG_ORIG_ACCTD_AMT
, BR_LINE_REM_ACCTD_AMT
, BR_TAX_REM_ACCTD_AMT
, BR_FRT_REM_ACCTD_AMT
, BR_CHRG_REM_ACCTD_AMT
, BR_REF_CUSTOMER_TRX_ID
, BR_ADJUSTMENT_ID
, LINE_ORIGIN
, CM_AMT_DUE_ORIG
, CM_AMT_DUE_REM
, CM_ACCTD_AMT_DUE_ORIG
, CM_ACCTD_AMT_DUE_REM
FROM AR.RA_CUSTOMER_TRX_LINES_GT;
AR.RA_CUSTOMER_TRX_LINES_GT does not reference any database object
AR.RA_CUSTOMER_TRX_LINES_GT is referenced by following:
|
|
|