eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [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

Name	Datatype	Length	Mandatory
PAYMENT_ID	NUMBER	(15)	Yes
DOCUMENT_PAYABLE_ID	NUMBER	(15)	Yes
CALLING_APP_ID	NUMBER	(15)	Yes
CALLING_APP_DOC_UNIQUE_REF1	NUMBER	(15)	Yes
CALLING_APP_DOC_UNIQUE_REF2	NUMBER	(15)
CALLING_APP_DOC_UNIQUE_REF3	NUMBER	(15)
CALLING_APP_DOC_UNIQUE_REF4	NUMBER	(15)
CALLING_APP_DOC_UNIQUE_REF5	NUMBER	(15)
DOCUMENT_AMOUNT	NUMBER		Yes
DOCUMENT_CURRENCY_CODE	VARCHAR2	(10)	Yes
AMOUNT_WITHHELD	NUMBER
DONT_PAY_FLAG	VARCHAR2	(1)
DONT_PAY_REASON_CODE	VARCHAR2	(30)
DONT_PAY_DESCRIPTION	VARCHAR2	(255)
PAY_PROC_TRXN_TYPE_CODE	VARCHAR2	(100)	Yes
INTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)	Yes
EXT_PAYEE_ID	NUMBER	(15)	Yes
PAYEE_PARTY_ID	NUMBER	(15)
PARTY_SITE_ID	NUMBER	(15)
SUPPLIER_SITE_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
ORG_TYPE	VARCHAR2	(30)
EXTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)
PAYMENT_CURR_DISCOUNT_TAKEN	NUMBER
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes

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