[Home] [Help] [Dependency Information]

TABLE: APPS.IBY_PYO_INVOICE_GT

Object Details

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

Temporary Table Details

APPS.IBY_PYO_INVOICE_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_PYO_INVOICE_GT_N1	NORMAL	NONUNIQUE		PAYMENT_INSTRUCTION_ID PAYMENT_ID VENDOR_ID VENDOR_SITE_ID

Columns

Query Text

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

SELECT PAYMENT_ID
,      PAYMENT_INSTRUCTION_ID
,      PAY_SELECTED_CHECK_ID
,      VENDOR_NUM
,      CUSTOMER_NUM
,      INVOICE_NUM
,      INVOICE_DATE
,      INVOICE_DESCRIPTION
,      PROPOSED_PAYMENT_AMOUNT
,      INVOICE_AMOUNT
,      DISCOUNT_AMOUNT
,      PRINT_SELECTED_CHECK_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INV_GLOBAL_ATTRIBUTE_CATEGORY
,      INV_GLOBAL_ATTRIBUTE1
,      INV_GLOBAL_ATTRIBUTE2
,      INV_GLOBAL_ATTRIBUTE3
,      INV_GLOBAL_ATTRIBUTE4
,      INV_GLOBAL_ATTRIBUTE5
,      INV_GLOBAL_ATTRIBUTE6
,      INV_GLOBAL_ATTRIBUTE7
,      INV_GLOBAL_ATTRIBUTE8
,      INV_GLOBAL_ATTRIBUTE9
,      INV_GLOBAL_ATTRIBUTE10
,      INV_GLOBAL_ATTRIBUTE11
,      INV_GLOBAL_ATTRIBUTE12
,      INV_GLOBAL_ATTRIBUTE13
,      INV_GLOBAL_ATTRIBUTE14
,      INV_GLOBAL_ATTRIBUTE15
,      INV_GLOBAL_ATTRIBUTE16
,      INV_GLOBAL_ATTRIBUTE17
,      INV_GLOBAL_ATTRIBUTE18
,      INV_GLOBAL_ATTRIBUTE19
,      INV_GLOBAL_ATTRIBUTE20
,      BANK_CHARGE_BEARER
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      DELIVERY_CHANNEL_CODE
,      SETTLEMENT_PRIORITY
,      EXTERNAL_BANK_ACCOUNT_ID
,      PAYMENT_METHOD_CODE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      PAYMENT_MEAN
,      PAYMENT_CHANNEL
,      COUNTRY
,      PAYMENT_PROCESS_REQUEST_NAME
,      BANK_ACCOUNT_ID
,      VENDOR_BANK_ACCOUNT_ID
,      PAYMENT_REFERENCE_NUMBER
,      CHECK_NUMBER
,      AMOUNT_WITHHELD
,      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_SEQUENCE_ID
,      DOCUMENT_SEQUENCE_VALUE
,      DOCUMENT_CATEGORY_CODE
FROM APPS.IBY_PYO_INVOICE_GT;

Dependencies

[top of page]

APPS.IBY_PYO_INVOICE_GT does not reference any database object

APPS.IBY_PYO_INVOICE_GT is referenced by following:

APPS

ECE_AP_PAYMENT - show dependent code

ECE_PYO_INVOICE_V

IBY_PYO_TRANSACTION - show dependent code