[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_HOOK_DOCS_IN_PMT_T

Object Details

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

Temporary Table Details

IBY.IBY_HOOK_DOCS_IN_PMT_T 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_HOOK_DOCS_IN_PMT_T_N1	NORMAL	NONUNIQUE		DOCUMENT_PAYABLE_ID DONT_PAY_FLAG

Columns

Query Text

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

SELECT PAYMENT_ID
,      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
,      DOCUMENT_AMOUNT
,      DOCUMENT_CURRENCY_CODE
,      AMOUNT_WITHHELD
,      DONT_PAY_FLAG
,      DONT_PAY_REASON_CODE
,      DONT_PAY_DESCRIPTION
,      PAY_PROC_TRXN_TYPE_CODE
,      INTERNAL_BANK_ACCOUNT_ID
,      EXT_PAYEE_ID
,      PAYEE_PARTY_ID
,      PARTY_SITE_ID
,      SUPPLIER_SITE_ID
,      ORG_ID
,      ORG_TYPE
,      EXTERNAL_BANK_ACCOUNT_ID
,      PAYMENT_CURR_DISCOUNT_TAKEN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM IBY.IBY_HOOK_DOCS_IN_PMT_T;

Dependencies

[top of page]

IBY.IBY_HOOK_DOCS_IN_PMT_T does not reference any database object

IBY.IBY_HOOK_DOCS_IN_PMT_T is referenced by following:

APPS

IBY_HOOK_DOCS_IN_PMT_T