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

TABLE: AR.AR_CASH_RECOS_PS_GT

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

GT Table for Recommendations UI (BETA)

Temporary Table Details

AR.AR_CASH_RECOS_PS_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
RECOMMENDATION_ID NUMBER

Recommendation Identifier
REMIT_REFERENCE_ID NUMBER

Remittance Reference Identifier
RESOLVED_MATCHING_NUMBER VARCHAR2 (30)
Resolved Matching Number
MATCH_RESOLVED_USING VARCHAR2 (30)
Match Resolved Category
MATCH_SCORE_VALUE NUMBER

Match Score Value
PAYMENT_SCHEDULE_ID NUMBER

Payment Schedule Identifier
CUSTOMER_TRX_ID NUMBER

Customer Transaction Identifier
AMOUNT_DUE_ORIGINAL NUMBER

Original Amount Due
AMOUNT_DUE_REMAINING NUMBER

Remaining Amount Due
TRX_NUMBER VARCHAR2 (30)
Transaction Number
TRX_DATE DATE

Transaction Date
CLASS VARCHAR2 (30)
Payment Class
INVOICE_CURRENCY_CODE VARCHAR2 (30)
Invoice Currency Code
AUTOMATCH_NAME VARCHAR2 (30)
Automatch Name
CUSTOMER_ID NUMBER

Customer Identifier
PARTY_NAME VARCHAR2 (360)
Party Name
Query Text

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


SELECT RECOMMENDATION_ID
,      REMIT_REFERENCE_ID
,      RESOLVED_MATCHING_NUMBER
,      MATCH_RESOLVED_USING
,      MATCH_SCORE_VALUE
,      PAYMENT_SCHEDULE_ID
,      CUSTOMER_TRX_ID
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      TRX_NUMBER
,      TRX_DATE
,      CLASS
,      INVOICE_CURRENCY_CODE
,      AUTOMATCH_NAME
,      CUSTOMER_ID
,      PARTY_NAME
FROM AR.AR_CASH_RECOS_PS_GT;

Dependencies

[top of page]

AR.AR_CASH_RECOS_PS_GT does not reference any database object

AR.AR_CASH_RECOS_PS_GT is referenced by following:

SchemaAPPS
SynonymAR_CASH_RECOS_PS_GT