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_LATE_CHARGE_DOC_GT

Object Details

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

Temporary Table Details

AR.AR_LATE_CHARGE_DOC_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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
INTEREST_HEADER_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(30)
HEADER_TYPE	VARCHAR2	(30)
CUST_TRX_TYPE_ID	NUMBER
CUSTOMER_ID	NUMBER
CUSTOMER_SITE_USE_ID	NUMBER
LATE_CHARGE_TERM_ID	NUMBER
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
EXCHANGE_RATE	NUMBER
ORG_ID	NUMBER
LEGAL_ENTITY_ID	NUMBER
LATE_CHARGE_CALCULATION_TRX	VARCHAR2	(30)
INTEREST_LINE_ID	NUMBER
DAYS_OF_INTEREST	NUMBER
DAYS_OVERDUE_LATE	NUMBER
DAILY_INTEREST_CHARGE	NUMBER
PAYMENT_SCHEDULE_ID	NUMBER
INTEREST_CHARGED	NUMBER
TYPE	VARCHAR2	(30)
SALESREP_REQUIRED_FLAG	VARCHAR2	(30)
SALESREP_ID	NUMBER
SALESREP_NUMBER	VARCHAR2	(30)
GL_ID_REC	NUMBER
EXECUTION_STATUS	VARCHAR2	(30)
HDR_ERR_MSG	VARCHAR2	(2000)
LINE_ERR_MSG	VARCHAR2	(2000)
INTEREST_BATCH_ID	NUMBER
ORIGINAL_TRX_ID	NUMBER
RECEIVABLES_TRX_ID	NUMBER
RECEIVABLES_TRX_NAME	VARCHAR2	(50)
ORIGINAL_TRX_CLASS	VARCHAR2	(30)
DUE_DATE	DATE
OUTSTANDING_AMOUNT	NUMBER
PAYMENT_DATE	DATE
LAST_CHARGE_DATE	DATE
INTEREST_RATE	NUMBER
GL_ID_REV	NUMBER
WORKER_NUM	NUMBER

Query Text

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


SELECT INTEREST_HEADER_ID
,      CURRENCY_CODE
,      HEADER_TYPE
,      CUST_TRX_TYPE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      LATE_CHARGE_TERM_ID
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      ORG_ID
,      LEGAL_ENTITY_ID
,      LATE_CHARGE_CALCULATION_TRX
,      INTEREST_LINE_ID
,      DAYS_OF_INTEREST
,      DAYS_OVERDUE_LATE
,      DAILY_INTEREST_CHARGE
,      PAYMENT_SCHEDULE_ID
,      INTEREST_CHARGED
,      TYPE
,      SALESREP_REQUIRED_FLAG
,      SALESREP_ID
,      SALESREP_NUMBER
,      GL_ID_REC
,      EXECUTION_STATUS
,      HDR_ERR_MSG
,      LINE_ERR_MSG
,      INTEREST_BATCH_ID
,      ORIGINAL_TRX_ID
,      RECEIVABLES_TRX_ID
,      RECEIVABLES_TRX_NAME
,      ORIGINAL_TRX_CLASS
,      DUE_DATE
,      OUTSTANDING_AMOUNT
,      PAYMENT_DATE
,      LAST_CHARGE_DATE
,      INTEREST_RATE
,      GL_ID_REV
,      WORKER_NUM
FROM AR.AR_LATE_CHARGE_DOC_GT;

Dependencies

[top of page]

AR.AR_LATE_CHARGE_DOC_GT does not reference any database object

AR.AR_LATE_CHARGE_DOC_GT is referenced by following:

APPS: AR_LATE_CHARGE_DOC_GT