[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_DOCS_PAYABLE_GT

Object Details

Object Name:	IBY_DOCS_PAYABLE_GT
Object Type:	TABLE
Owner:	IBY
FND Design Data:	IBY.IBY_DOCS_PAYABLE_GT
Subobject Name:
Status:	VALID

Temporary Table Details

IBY.IBY_DOCS_PAYABLE_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

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_DOCS_PAYABLE_GT_N1	NORMAL	NONUNIQUE		DOCUMENT_PAYABLE_ID

Columns

Query Text

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

SELECT DOCUMENT_PAYABLE_ID
,      CALLING_APP_ID
,      CALLING_APP_DOC_UNIQUE_REF1
,      CALLING_APP_DOC_UNIQUE_REF2
,      CALLING_APP_DOC_UNIQUE_REF3
,      CALLING_APP_DOC_UNIQUE_REF4
,      CALLING_APP_DOC_UNIQUE_REF5
,      CALLING_APP_DOC_REF_NUMBER
,      PAY_PROC_TRXN_TYPE_CODE
,      PAYMENT_METHOD_CODE
,      PAYMENT_FORMAT_CODE
,      PAYMENT_AMOUNT
,      EXCLUSIVE_PAYMENT_FLAG
,      PAYMENT_PROFILE_ID
,      PAYMENT_FUNCTION
,      PROCESS_TYPE
,      DOCUMENT_DATE
,      DOCUMENT_TYPE
,      DOCUMENT_DESCRIPTION
,      DOCUMENT_AMOUNT
,      DOCUMENT_CURRENCY_TAX_AMOUNT
,      DOCUMENT_CURR_CHARGE_AMOUNT
,      PAYMENT_CURR_DISCOUNT_TAKEN
,      PAYMENT_DUE_DATE
,      PAYMENT_GROUPING_NUMBER
,      INTERNAL_BANK_ACCOUNT_ID
,      EXTERNAL_BANK_ACCOUNT_ID
,      PAYEE_PARTY_ID
,      PAYEE_PARTY_SITE_ID
,      SUPPLIER_SITE_ID
,      REMIT_TO_LOCATION_ID
,      LEGAL_ENTITY_ID
,      ORG_ID
,      ORG_TYPE
,      DOCUMENT_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
,      BANK_CHARGE_BEARER
,      BANK_CHARGE_AMOUNT
,      PAYMENT_CURR_BANK_CHARGES
,      PAYMENT_DATE
,      ANTICIPATED_VALUE_DATE
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      SETTLEMENT_PRIORITY
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      BANK_ASSIGNED_REF_CODE
,      DELIVERY_CHANNEL_CODE
,      INTEREST_RATE
,      PO_NUMBER
,      AMOUNT_WITHHELD
,      DISCOUNT_DATE
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      ALLOW_REMOVING_DOCUMENT_FLAG
,      DOC_CATEGORY_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM IBY.IBY_DOCS_PAYABLE_GT;

Dependencies

[top of page]

IBY.IBY_DOCS_PAYABLE_GT does not reference any database object

IBY.IBY_DOCS_PAYABLE_GT is referenced by following:

APPS

IBY_DOCS_PAYABLE_GT