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

TABLE: AR.AR_RR_CRH_GT

Object Details
Object Name: AR_RR_CRH_GT
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_RR_CRH_GT
Subobject Name:
Status: VALID

Temporary Table Details

AR.AR_RR_CRH_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: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
CASH_RECEIPT_HISTORY_ID NUMBER (15) Yes
CASH_RECEIPT_ID NUMBER (15) Yes
STATUS VARCHAR2 (30) Yes
TRX_DATE DATE
Yes
AMOUNT NUMBER
Yes
FIRST_POSTED_RECORD_FLAG VARCHAR2 (1) Yes
POSTABLE_FLAG VARCHAR2 (1) Yes
FACTOR_FLAG VARCHAR2 (1) Yes
GL_DATE DATE
Yes
CURRENT_RECORD_FLAG VARCHAR2 (1)
BATCH_ID NUMBER (15)
ACCOUNT_CODE_COMBINATION_ID NUMBER (15)
REVERSAL_GL_DATE DATE

REVERSAL_CASH_RECEIPT_HIST_ID NUMBER (15)
FACTOR_DISCOUNT_AMOUNT NUMBER

BANK_CHARGE_ACCOUNT_CCID NUMBER (15)
POSTING_CONTROL_ID NUMBER (15) Yes
REVERSAL_POSTING_CONTROL_ID NUMBER (15)
GL_POSTED_DATE DATE

REVERSAL_GL_POSTED_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
ACCTD_AMOUNT NUMBER
Yes
ACCTD_FACTOR_DISCOUNT_AMOUNT NUMBER

CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
EXCHANGE_DATE DATE

EXCHANGE_RATE NUMBER

EXCHANGE_RATE_TYPE VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Yes
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
LAST_UPDATED_BY NUMBER (15) Yes
PRV_STAT_CASH_RECEIPT_HIST_ID NUMBER (15)
CREATED_FROM VARCHAR2 (30) Yes
REVERSAL_CREATED_FROM VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ORG_ID NUMBER (15)
EVENT_ID NUMBER (15)
CC_ERROR_CODE VARCHAR2 (80)
CC_ERROR_TEXT VARCHAR2 (255)
CC_INSTRTYPE VARCHAR2 (100)
Query Text

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


SELECT CASH_RECEIPT_HISTORY_ID
,      CASH_RECEIPT_ID
,      STATUS
,      TRX_DATE
,      AMOUNT
,      FIRST_POSTED_RECORD_FLAG
,      POSTABLE_FLAG
,      FACTOR_FLAG
,      GL_DATE
,      CURRENT_RECORD_FLAG
,      BATCH_ID
,      ACCOUNT_CODE_COMBINATION_ID
,      REVERSAL_GL_DATE
,      REVERSAL_CASH_RECEIPT_HIST_ID
,      FACTOR_DISCOUNT_AMOUNT
,      BANK_CHARGE_ACCOUNT_CCID
,      POSTING_CONTROL_ID
,      REVERSAL_POSTING_CONTROL_ID
,      GL_POSTED_DATE
,      REVERSAL_GL_POSTED_DATE
,      LAST_UPDATE_LOGIN
,      ACCTD_AMOUNT
,      ACCTD_FACTOR_DISCOUNT_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      LAST_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LAST_UPDATED_BY
,      PRV_STAT_CASH_RECEIPT_HIST_ID
,      CREATED_FROM
,      REVERSAL_CREATED_FROM
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      ORG_ID
,      EVENT_ID
,      CC_ERROR_CODE
,      CC_ERROR_TEXT
,      CC_INSTRTYPE
FROM AR.AR_RR_CRH_GT;

Dependencies

[top of page]

AR.AR_RR_CRH_GT does not reference any database object

AR.AR_RR_CRH_GT is referenced by following:

SchemaAPPS
SynonymAR_RR_CRH_GT