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

TABLE: AR.AR_PMTS_INTERFACE_HEADER_GT

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

Temporary Table Details

AR.AR_PMTS_INTERFACE_HEADER_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
Indexes
Index Type Uniqueness Tablespace Column
AR_PMTS_INTERFACE_HEADER_N1 NORMAL NONUNIQUE Tablespace ColumnTRANSMISSION_RECORD_ID
ColumnCUSTOMER_TRX_ID
Columns
Name Datatype Length Mandatory Comments
TRANSMISSION_REQUEST_ID NUMBER (15)
TRANSMISSION_RECORD_ID NUMBER (15)
INVOICE_NUMBER VARCHAR2 (50)
AMOUNT_APPLIED_FROM NUMBER

AMOUNT_APPLIED NUMBER

TRANS_TO_RECEIPT_RATE NUMBER

INVOICE_CURRENCY_CODE VARCHAR2 (15)
RECORD_STATUS VARCHAR2 (30)
CUSTOMER_TRX_ID NUMBER (20)
CURRENCY_CODE VARCHAR2 (15)
PRECISION NUMBER (15)
INV_PRECISION NUMBER (15)
DEFAULT_BY VARCHAR2 (15)
Query Text

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


SELECT TRANSMISSION_REQUEST_ID
,      TRANSMISSION_RECORD_ID
,      INVOICE_NUMBER
,      AMOUNT_APPLIED_FROM
,      AMOUNT_APPLIED
,      TRANS_TO_RECEIPT_RATE
,      INVOICE_CURRENCY_CODE
,      RECORD_STATUS
,      CUSTOMER_TRX_ID
,      CURRENCY_CODE
,      PRECISION
,      INV_PRECISION
,      DEFAULT_BY
FROM AR.AR_PMTS_INTERFACE_HEADER_GT;

Dependencies

[top of page]

AR.AR_PMTS_INTERFACE_HEADER_GT does not reference any database object

AR.AR_PMTS_INTERFACE_HEADER_GT is referenced by following:

SchemaAPPS
SynonymAR_PMTS_INTERFACE_HEADER_GT