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: APPS.IBY_DOCS_IN_PMT_GT

Object Details

Object Name:	IBY_DOCS_IN_PMT_GT
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.IBY_DOCS_IN_PMT_GT
Subobject Name:
Status:	VALID

Temporary Table Details

APPS.IBY_DOCS_IN_PMT_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$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00907179

DOCUMENT_PAYABLE_ID

Indexes

Index	Type	Uniqueness	Column
SYS_C00907179	NORMAL	UNIQUE	DOCUMENT_PAYABLE_ID
IBY_DOCS_IN_PMT_GT_N1	NORMAL	NONUNIQUE	PAYMENT_ID
IBY_DOCS_IN_PMT_GT_N2	NORMAL	NONUNIQUE	PAYMENT_ID DOCUMENT_STATUS PAYMENT_GROUPING_NUMBER
IBY_DOCS_IN_PMT_GT_N3	NORMAL	NONUNIQUE	PAYMENT_ID DONT_PAY_FLAG
IBY_DOCS_IN_PMT_GT_N4	NORMAL	NONUNIQUE	PAYMENT_ID DISCOUNT_DATE
IBY_DOCS_IN_PMT_GT_N5	NORMAL	NONUNIQUE	PAYMENT_ID PAYMENT_DUE_DATE

Columns

Name	Datatype	Length	Mandatory
PAYMENT_ID	NUMBER	(15)
DOCUMENT_PAYABLE_ID	NUMBER	(15)	Yes
CALLING_APP_ID	NUMBER	(15)	Yes
CALLING_APP_DOC_UNIQUE_REF1	VARCHAR2	(100)	Yes
CALLING_APP_DOC_UNIQUE_REF2	VARCHAR2	(100)
CALLING_APP_DOC_UNIQUE_REF3	VARCHAR2	(100)
CALLING_APP_DOC_UNIQUE_REF4	VARCHAR2	(100)
CALLING_APP_DOC_UNIQUE_REF5	VARCHAR2	(100)
PAY_PROC_TRXN_TYPE_CODE	VARCHAR2	(100)	Yes
DOCUMENT_AMOUNT	NUMBER		Yes
DOCUMENT_CURRENCY_CODE	VARCHAR2	(10)	Yes
PAYMENT_GROUPING_NUMBER	NUMBER	(15)
DOCUMENT_STATUS	VARCHAR2	(30)	Yes
AMOUNT_WITHHELD	NUMBER
PAYMENT_DUE_DATE	DATE
DISCOUNT_DATE	DATE
INTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)
EXT_PAYEE_ID	NUMBER	(15)	Yes
PAYEE_PARTY_ID	NUMBER	(15)	Yes
PARTY_SITE_ID	NUMBER	(15)
SUPPLIER_SITE_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)	Yes
ORG_TYPE	VARCHAR2	(30)	Yes
EXTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)
PAYMENT_CURR_DISCOUNT_TAKEN	NUMBER
DELIVERY_CHANNEL_CODE	VARCHAR2	(30)
UNIQUE_REMITTANCE_IDENTIFIER	VARCHAR2	(30)
URI_CHECK_DIGIT	VARCHAR2	(2)
CREATED_BY	NUMBER	(15)
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
DONT_PAY_FLAG	VARCHAR2	(1)
DONT_PAY_REASON_CODE	VARCHAR2	(30)
DONT_PAY_DESCRIPTION	VARCHAR2	(255)

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
,      PAY_PROC_TRXN_TYPE_CODE
,      DOCUMENT_AMOUNT
,      DOCUMENT_CURRENCY_CODE
,      PAYMENT_GROUPING_NUMBER
,      DOCUMENT_STATUS
,      AMOUNT_WITHHELD
,      PAYMENT_DUE_DATE
,      DISCOUNT_DATE
,      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
,      DELIVERY_CHANNEL_CODE
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      DONT_PAY_FLAG
,      DONT_PAY_REASON_CODE
,      DONT_PAY_DESCRIPTION
FROM APPS.IBY_DOCS_IN_PMT_GT;

Dependencies

[top of page]

APPS.IBY_DOCS_IN_PMT_GT does not reference any database object

APPS.IBY_DOCS_IN_PMT_GT is referenced by following:

APPS: IBY_PAYGROUP_PUB - show dependent code