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]

VIEW: APPS.IBY_FNDCPT_PAYER_ALL_INSTRS_V

Object Details

Object Name:	IBY_FNDCPT_PAYER_ALL_INSTRS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IBY.IBY_FNDCPT_PAYER_ALL_INSTRS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
PARTY_ID	NUMBER	(15)
INSTRUMENT_TYPE	VARCHAR2	(11)
INSTRUMENT_ID	NUMBER	(15)
CURRENCY_CODE	VARCHAR2	(15)
CARD_NUMBER	VARCHAR2	(30)
CC_NUMBER_HASH1	VARCHAR2	(64)
CC_NUMBER_HASH2	VARCHAR2	(64)
CARD_EXPIRYDATE	VARCHAR2	(9)	Obsoleted as part of PA-DSS uptake.
MASKED_CARD_EXPIRYDATE	VARCHAR2	(5)
CARD_EXPIRED_FLAG	VARCHAR2	(1)
CARD_ISSUER_CODE	VARCHAR2	(30)
CARD_ISSUER_NAME	VARCHAR2	(100)
PURCHASECARD_SUBTYPE	VARCHAR2	(30)
CARD_HOLDER_NAME	VARCHAR2	(80)
CARD_BILLING_ADDRESS_ID	NUMBER
CARD_FI_NAME	VARCHAR2	(80)
CARD_SINGLE_USE_FLAG	VARCHAR2	(1)
ACCOUNT_NUMBER	VARCHAR2	(100)
BANK_ACCT_NUM_HASH1	VARCHAR2	(64)
BANK_ACCT_NUM_HASH2	VARCHAR2	(64)
BANK_NAME	VARCHAR2	(360)
BANK_NUMBER	VARCHAR2	(30)
BRANCH_NAME	VARCHAR2	(360)
BRANCH_NUMBER	VARCHAR2	(30)
BIC_NUMBER	VARCHAR2	(0)
DESCRIPTION	VARCHAR2	(240)
ENCRYPTED	VARCHAR2	(1)
CARD_EXPIRATION_STATUS	VARCHAR2	(80)

Query Text

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


SELECT PARTY_ID
,      INSTRUMENT_TYPE
,      INSTRUMENT_ID
,      CURRENCY_CODE
,      CARD_NUMBER
,      CC_NUMBER_HASH1
,      CC_NUMBER_HASH2
,      CARD_EXPIRYDATE
,      MASKED_CARD_EXPIRYDATE
,      CARD_EXPIRED_FLAG
,      CARD_ISSUER_CODE
,      CARD_ISSUER_NAME
,      PURCHASECARD_SUBTYPE
,      CARD_HOLDER_NAME
,      CARD_BILLING_ADDRESS_ID
,      CARD_FI_NAME
,      CARD_SINGLE_USE_FLAG
,      ACCOUNT_NUMBER
,      BANK_ACCT_NUM_HASH1
,      BANK_ACCT_NUM_HASH2
,      BANK_NAME
,      BANK_NUMBER
,      BRANCH_NAME
,      BRANCH_NUMBER
,      BIC_NUMBER
,      DESCRIPTION
,      ENCRYPTED
,      CARD_EXPIRATION_STATUS
FROM APPS.IBY_FNDCPT_PAYER_ALL_INSTRS_V;

Dependencies

[top of page]

APPS.IBY_FNDCPT_PAYER_ALL_INSTRS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; IBY_ACCOUNT_OWNERS; IBY_CREDITCARD; IBY_CREDITCARD_ISSUERS_VL; IBY_EXT_BANK_ACCOUNTS_V

APPS.IBY_FNDCPT_PAYER_ALL_INSTRS_V is referenced by following:

APPS: AP_CARD_VALIDATE_PKG - show dependent code; AP_EXPENSE_FEED_DISTS_OPEN_V; AP_EXPENSE_FEED_DISTS_V; AP_EXPENSE_FEED_LINES_V; OE_PAYMENT_TRXN_UTIL - show dependent code