[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_DOCS_PAYABLE_VAL_GT1

Object Details

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

Temporary Table Details

IBY.IBY_DOCS_PAYABLE_VAL_GT1 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

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_DOCS_PAYABLE_VAL_GT1_U1	NORMAL	NONUNIQUE		DOCUMENT_ID

Columns

Query Text

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

SELECT CALLING_APP_ID
,      CALLING_APP_DOC_ID1
,      CALLING_APP_DOC_ID2
,      CALLING_APP_DOC_ID3
,      CALLING_APP_DOC_ID4
,      CALLING_APP_DOC_ID5
,      PAY_PROC_TRXN_TYPE_CD
,      DOCUMENT_ID
,      DOCUMENT_AMOUNT
,      DOCUMENT_PAY_CURRENCY
,      EXCLUSIVE_PAYMENT_FLAG
,      DELIVERY_CHANNEL_CODE
,      DELIVERY_CHN_FORMAT_VAL
,      UNIQUE_REMIT_ID_CODE
,      PAYMENT_REASON_COMMENTS
,      SETTLEMENT_PRIORITY
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      URI_CHECK_DIGIT
,      EXTERNAL_BANK_ACCOUNT_ID
,      INT_BANK_NUM
,      INT_BANK_NAME
,      INT_BANK_NAME_ALT
,      INT_BANK_BRANCH_NUM
,      INT_BANK_BRANCH_NAME
,      INT_BANK_BRANCH_NAME_ALT
,      INT_BANK_ACC_NUM
,      INT_BANK_ACC_NAME
,      INT_BANK_ACC_NAME_ALT
,      INT_BANK_ACC_TYPE
,      INT_BANK_ACC_IBAN
,      INT_BANK_ACC_CURR
,      INT_BANK_ASSIGNED_ID1
,      INT_BANK_ASSIGNED_ID2
,      INT_EFT_USER_NUMBER
,      INT_BANK_ACC_CHK_DGTS
,      INT_EFT_REQ_IDENTIFIER
,      INT_BANK_ACC_SHORT_NAME
,      INT_BANK_ACC_HOLDER_NAME
,      INT_BANK_ACC_HOLDER_NAME_ALT
,      PAYER_LE_NAME
,      PAYER_LE_COUNTRY
,      PAYER_PHONE
,      PAYER_REGISTRATION_NUMBER
,      PAYER_TAX_REGISTRATION_NUMBER
,      EXT_BANK_NUM
,      EXT_BANK_NAME
,      EXT_BANK_NAME_ALT
,      EXT_BANK_BRANCH_NUM
,      EXT_BANK_BRANCH_NAME
,      EXT_BANK_BRANCH_NAME_ALT
,      EXT_BANK_COUNTRY
,      EXT_BANK_BRANCH_ADDR1
,      EXT_BANK_BRANCH_COUNTRY
,      EXT_BANK_ACC_NUM
,      EXT_BANK_ACC_NAME
,      EXT_BANK_ACC_NAME_ALT
,      EXT_BANK_ACC_TYPE
,      EXT_BANK_ACC_IBAN
,      EXT_BANK_ACC_CHK_DGTS
,      EXT_BANK_ACC_SHORT_NAME
,      EXT_BANK_ACC_HOLDER_NAME
,      EXT_BANK_ACC_HOLDER_NAME_ALT
,      EXT_BANK_ACC_BIC
,      PAYEE_PARTY_NAME
,      PAYEE_PARTY_ADDR1
,      PAYEE_PARTY_ADDR2
,      PAYEE_PARTY_ADDR3
,      PAYEE_PARTY_CITY
,      PAYEE_PARTY_STATE
,      PAYEE_PARTY_PROVINCE
,      PAYEE_PARTY_COUNTY
,      PAYEE_PARTY_POSTAL
,      PAYEE_PARTY_COUNTRY
,      BANK_CHARGE_BEARER
,      PAYMENT_REASON_CODE
,      PAYMENT_METHOD_CD
,      PAYEE_PAYMENT_FORMAT_CD
,      PAYEE_PARTY_SITE_NAME
,      INT_BANK_BRANCH_TYPE
,      EXT_BANK_BRANCH_TYPE
FROM IBY.IBY_DOCS_PAYABLE_VAL_GT1;

Dependencies

[top of page]

IBY.IBY_DOCS_PAYABLE_VAL_GT1 does not reference any database object

IBY.IBY_DOCS_PAYABLE_VAL_GT1 is referenced by following:

APPS

IBY_DOCS_PAYABLE_VAL_GT

IBY_DOCS_PAYABLE_VAL_GT1