eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AR.AR_CM_TO_GT

Object Details

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

Temporary Table Details

AR.AR_CM_TO_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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CM_TO_U1	NORMAL	UNIQUE		LINE_ID

Columns

Name	Datatype	Length
ENTITY_ID	NUMBER	(15)
RECEIVABLE_APPLICATION_ID	NUMBER	(15)
LINE_ID	NUMBER	(15)
AMOUNT	NUMBER
ACCTD_AMOUNT	NUMBER
FROM_AMOUNT	NUMBER
FROM_ACCTD_AMOUNT	NUMBER
THIRD_PARTY_ID	NUMBER	(15)
THIRD_PARTY_SITE_ID	NUMBER	(15)
THIRD_PARTY_TYPE	VARCHAR2	(30)
CURRENCY_CODE	VARCHAR2	(30)
EXCHANGE_RATE	NUMBER
EXCHANGE_TYPE	VARCHAR2	(30)
EXCHANGE_DATE	DATE
REF_CUSTOMER_TRX_LINE_ID	NUMBER	(15)
REF_CUST_TRX_LINE_GL_DIST_ID	NUMBER	(15)
CODE_COMBINATION_ID	NUMBER	(15)
REF_DIST_CCID	NUMBER	(15)
ACTIVITY_BUCKET	VARCHAR2	(30)
SOURCE_TYPE	VARCHAR2	(30)
SOURCE_TABLE	VARCHAR2	(30)
RA_POST_INDICATOR	VARCHAR2	(30)
SOURCE_DISTRIBUTION_TYPE	VARCHAR2	(30)
CUSTOMER_TRX_ID	NUMBER	(15)
INVENTORY_ITEM_ID	NUMBER	(15)
SALES_TAX_ID	NUMBER	(15)
TAX_LINE_ID	NUMBER	(15)
BILL_TO_CUSTOMER_ID	NUMBER	(15)
BILL_TO_SITE_USE_ID	NUMBER	(15)
SOLD_TO_CUSTOMER_ID	NUMBER	(15)
SOLD_TO_SITE_USE_ID	NUMBER	(15)
SHIP_TO_CUSTOMER_ID	NUMBER	(15)
SHIP_TO_SITE_USE_ID	NUMBER	(15)
ADDITIONAL_NUMBER_ID1	NUMBER
ADDITIONAL_NUMBER_ID2	NUMBER
ADDITIONAL_NUMBER_ID3	NUMBER
ADDITIONAL_NUMBER_ID4	NUMBER
ADDITIONAL_NUMBER_ID5	NUMBER
ADDITIONAL_CHAR_ID1	VARCHAR2	(200)
ADDITIONAL_CHAR_ID2	VARCHAR2	(200)
ADDITIONAL_CHAR_ID3	VARCHAR2	(200)
ADDITIONAL_CHAR_ID4	VARCHAR2	(200)
ADDITIONAL_CHAR_ID5	VARCHAR2	(200)

Query Text

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


SELECT ENTITY_ID
,      RECEIVABLE_APPLICATION_ID
,      LINE_ID
,      AMOUNT
,      ACCTD_AMOUNT
,      FROM_AMOUNT
,      FROM_ACCTD_AMOUNT
,      THIRD_PARTY_ID
,      THIRD_PARTY_SITE_ID
,      THIRD_PARTY_TYPE
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_TYPE
,      EXCHANGE_DATE
,      REF_CUSTOMER_TRX_LINE_ID
,      REF_CUST_TRX_LINE_GL_DIST_ID
,      CODE_COMBINATION_ID
,      REF_DIST_CCID
,      ACTIVITY_BUCKET
,      SOURCE_TYPE
,      SOURCE_TABLE
,      RA_POST_INDICATOR
,      SOURCE_DISTRIBUTION_TYPE
,      CUSTOMER_TRX_ID
,      INVENTORY_ITEM_ID
,      SALES_TAX_ID
,      TAX_LINE_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      SOLD_TO_CUSTOMER_ID
,      SOLD_TO_SITE_USE_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_SITE_USE_ID
,      ADDITIONAL_NUMBER_ID1
,      ADDITIONAL_NUMBER_ID2
,      ADDITIONAL_NUMBER_ID3
,      ADDITIONAL_NUMBER_ID4
,      ADDITIONAL_NUMBER_ID5
,      ADDITIONAL_CHAR_ID1
,      ADDITIONAL_CHAR_ID2
,      ADDITIONAL_CHAR_ID3
,      ADDITIONAL_CHAR_ID4
,      ADDITIONAL_CHAR_ID5
FROM AR.AR_CM_TO_GT;

Dependencies

[top of page]

AR.AR_CM_TO_GT does not reference any database object

AR.AR_CM_TO_GT is referenced by following:

APPS: AR_CM_TO_GT