[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_HOOK_PAYMENTS_T

Object Details

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

Temporary Table Details

IBY.IBY_HOOK_PAYMENTS_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_PAYMENTS_T_N1	NORMAL	NONUNIQUE		PAYMENT_ID

Columns

Query Text

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

SELECT CALLING_APP_ID
,      CALL_APP_PAY_SERVICE_REQ_CODE
,      PAYMENT_SERVICE_REQUEST_ID
,      PAYMENT_ID
,      PAYMENT_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      DONT_PAY_FLAG
,      DONT_PAY_REASON_CODE
,      DONT_PAY_DESCRIPTION
,      INTERNAL_BANK_ACCOUNT_ID
,      EXT_PAYEE_ID
,      PAYEE_PARTY_ID
,      PARTY_SITE_ID
,      SUPPLIER_SITE_ID
,      ORG_ID
,      ORG_TYPE
,      EXTERNAL_BANK_ACCOUNT_ID
,      DISCOUNT_AMOUNT_TAKEN
,      PAYMENT_DATE
,      BANK_CHARGE_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM IBY.IBY_HOOK_PAYMENTS_T;

Dependencies

[top of page]

IBY.IBY_HOOK_PAYMENTS_T does not reference any database object

IBY.IBY_HOOK_PAYMENTS_T is referenced by following:

APPS

IBY_HOOK_PAYMENTS_T