[Home] [Help] [Dependency Information]

TABLE: AR.AR_IREC_PAYMENT_GT_ALL

Object Details

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

Temporary Table Details

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

Query Text

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

SELECT CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      ACCOUNT_NUMBER
,      CUSTOMER_TRX_ID
,      TRX_NUMBER
,      TRX_DATE
,      TRX_CLASS
,      DUE_DATE
,      PAYMENT_SCHEDULE_ID
,      STATUS
,      PAYMENT_TERMS
,      NUMBER_OF_INSTALLMENTS
,      TERMS_SEQUENCE_NUMBER
,      LINE_AMOUNT
,      TAX_AMOUNT
,      FREIGHT_AMOUNT
,      FINANCE_CHARGES
,      CURRENCY_CODE
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      PAYMENT_AMT
,      SERVICE_CHARGE
,      DISCOUNT_AMOUNT
,      RECEIPT_DATE
,      RECEIPT_NUMBER
,      PO_NUMBER
,      SO_NUMBER
,      PRINTING_OPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INTERFACE_HEADER_CONTEXT
,      INTERFACE_HEADER_ATTRIBUTE1
,      INTERFACE_HEADER_ATTRIBUTE2
,      INTERFACE_HEADER_ATTRIBUTE3
,      INTERFACE_HEADER_ATTRIBUTE4
,      INTERFACE_HEADER_ATTRIBUTE5
,      INTERFACE_HEADER_ATTRIBUTE6
,      INTERFACE_HEADER_ATTRIBUTE7
,      INTERFACE_HEADER_ATTRIBUTE8
,      INTERFACE_HEADER_ATTRIBUTE9
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      APPLICATION_AMOUNT
,      CASH_RECEIPT_ID
,      ORIGINAL_DISCOUNT_AMT
,      ORG_ID
,      PAY_FOR_CUSTOMER_ID
,      PAY_FOR_CUSTOMER_SITE_ID
,      DISPUTE_AMT
FROM AR.AR_IREC_PAYMENT_GT_ALL;

Dependencies

[top of page]

AR.AR_IREC_PAYMENT_GT_ALL does not reference any database object

AR.AR_IREC_PAYMENT_GT_ALL is referenced by following:

APPS

AR_IREC_PAYMENT_GT_ALL

AR_IREC_PAYMENT_LIST_GT