DBA Data[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: TableIBY.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: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
IBY_PYO_INVOICE_GT_N1 NORMAL NONUNIQUE Tablespace ColumnPAYMENT_INSTRUCTION_ID
ColumnPAYMENT_ID
ColumnVENDOR_ID
ColumnVENDOR_SITE_ID
Columns
Name Datatype Length Mandatory Comments
PAYMENT_ID NUMBER (15)
PAYMENT_INSTRUCTION_ID NUMBER (15)
PAY_SELECTED_CHECK_ID VARCHAR2 (100)
VENDOR_NUM VARCHAR2 (30)
CUSTOMER_NUM VARCHAR2 (100)
INVOICE_NUM VARCHAR2 (100) Yes
INVOICE_DATE DATE
Yes
INVOICE_DESCRIPTION VARCHAR2 (255)
PROPOSED_PAYMENT_AMOUNT NUMBER
Yes
INVOICE_AMOUNT NUMBER
Yes
DISCOUNT_AMOUNT VARCHAR2 (100)
PRINT_SELECTED_CHECK_ID VARCHAR2 (100)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE1 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE2 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE3 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE4 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE5 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE6 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE7 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE8 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE9 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE10 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE11 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE12 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE13 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE14 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE15 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE16 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE17 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE18 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE19 VARCHAR2 (240)
INV_GLOBAL_ATTRIBUTE20 VARCHAR2 (240)
BANK_CHARGE_BEARER VARCHAR2 (30)
PAYMENT_REASON_CODE VARCHAR2 (30)
PAYMENT_REASON_COMMENTS VARCHAR2 (240)
REMITTANCE_MESSAGE1 VARCHAR2 (150)
REMITTANCE_MESSAGE2 VARCHAR2 (150)
REMITTANCE_MESSAGE3 VARCHAR2 (150)
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 (30)
URI_CHECK_DIGIT VARCHAR2 (2)
DELIVERY_CHANNEL_CODE VARCHAR2 (30)
SETTLEMENT_PRIORITY VARCHAR2 (30)
EXTERNAL_BANK_ACCOUNT_ID NUMBER (15)
PAYMENT_METHOD_CODE VARCHAR2 (30) Yes
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER (15)
PAYMENT_MEAN VARCHAR2 (150)
PAYMENT_CHANNEL VARCHAR2 (150)
COUNTRY VARCHAR2 (60)
PAYMENT_PROCESS_REQUEST_NAME VARCHAR2 (255)
BANK_ACCOUNT_ID NUMBER (15)
VENDOR_BANK_ACCOUNT_ID NUMBER (15)
PAYMENT_REFERENCE_NUMBER NUMBER (15)
CHECK_NUMBER NUMBER (15)
AMOUNT_WITHHELD NUMBER

CALLING_APP_ID NUMBER (15)
CALLING_APP_DOC_UNIQUE_REF1 VARCHAR2 (100)
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)
DOCUMENT_SEQUENCE_ID NUMBER

DOCUMENT_SEQUENCE_VALUE NUMBER

DOCUMENT_CATEGORY_CODE VARCHAR2 (30)
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:

SchemaAPPS
Package BodyECE_AP_PAYMENT - show dependent code
ViewECE_PYO_INVOICE_V
Package BodyIBY_PYO_TRANSACTION - show dependent code