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_TRXN_EXTENSIONS_V

Object Details

Object Name:	IBY_TRXN_EXTENSIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IBY.IBY_TRXN_EXTENSIONS_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	Mandatory	Comments
ROW_ID	ROWID	(10)
TRXN_EXTENSION_ID	NUMBER	(15)	Yes
PAYMENT_CHANNEL_CODE	VARCHAR2	(30)	Yes
PAYMENT_CHANNEL_NAME	VARCHAR2	(100)	Yes
INSTR_ASSIGNMENT_ID	NUMBER	(15)
INSTRUMENT_TYPE	VARCHAR2	(30)
INSTRUMENT_ID	NUMBER	(15)
CURRENCY_CODE	VARCHAR2	(15)
CARD_NUMBER	VARCHAR2	(30)
CARD_NUMBER_HASH1	VARCHAR2	(64)
CARD_NUMBER_HASH2	VARCHAR2	(64)
CARD_EXPIRYDATE	DATE			Obsoleted as part of PA-DSS uptake.
MASKED_CARD_EXPIRYDATE	CHAR	(5)		Return 'XX/XX' when the record is encrypted, else return the expiry date in 'mm/yy' format.
CARD_EXPIRED_FLAG	VARCHAR2	(1)
CARD_ISSUER_CODE	VARCHAR2	(30)
CARD_ISSUER_NAME	VARCHAR2	(100)
PURCHASECARD_SUBTYPE	VARCHAR2	(30)
CARD_HOLDER_NAME	VARCHAR2	(80)
MASKED_CARD_HOLDER_NAME	VARCHAR2	(4000)
ACCOUNT_NUMBER	VARCHAR2	(100)
BANK_NUMBER	VARCHAR2	(30)
INSTRUMENT_SECURITY_CODE	VARCHAR2	(5)
VOICE_AUTHORIZATION_FLAG	VARCHAR2	(1)
VOICE_AUTHORIZATION_DATE	DATE
VOICE_AUTHORIZATION_CODE	VARCHAR2	(100)
ORIGIN_APPLICATION_ID	NUMBER		Yes
ORDER_ID	VARCHAR2	(75)
PO_NUMBER	VARCHAR2	(100)
PO_LINE_NUMBER	VARCHAR2	(100)
TRXN_REF_NUMBER1	VARCHAR2	(20)
TRXN_REF_NUMBER2	VARCHAR2	(20)
PAYMENT_SYSTEM_ORDER_NUMBER	VARCHAR2	(80)
ADDITIONAL_INFO	VARCHAR2	(255)
AUTHORIZED_FLAG	VARCHAR2	(1)
AUTHORIZATION_STATUS	VARCHAR2	(12)
SETTLED_FLAG	VARCHAR2	(1)
SETTLEMENT_STATUS	VARCHAR2	(18)
RETURNED_FLAG	VARCHAR2	(1)
RETURN_STATUS	VARCHAR2	(14)
BANK_NAME	VARCHAR2	(360)
BANK_BRANCH_NAME	VARCHAR2	(360)

Query Text

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


SELECT ROW_ID
,      TRXN_EXTENSION_ID
,      PAYMENT_CHANNEL_CODE
,      PAYMENT_CHANNEL_NAME
,      INSTR_ASSIGNMENT_ID
,      INSTRUMENT_TYPE
,      INSTRUMENT_ID
,      CURRENCY_CODE
,      CARD_NUMBER
,      CARD_NUMBER_HASH1
,      CARD_NUMBER_HASH2
,      CARD_EXPIRYDATE
,      MASKED_CARD_EXPIRYDATE
,      CARD_EXPIRED_FLAG
,      CARD_ISSUER_CODE
,      CARD_ISSUER_NAME
,      PURCHASECARD_SUBTYPE
,      CARD_HOLDER_NAME
,      MASKED_CARD_HOLDER_NAME
,      ACCOUNT_NUMBER
,      BANK_NUMBER
,      INSTRUMENT_SECURITY_CODE
,      VOICE_AUTHORIZATION_FLAG
,      VOICE_AUTHORIZATION_DATE
,      VOICE_AUTHORIZATION_CODE
,      ORIGIN_APPLICATION_ID
,      ORDER_ID
,      PO_NUMBER
,      PO_LINE_NUMBER
,      TRXN_REF_NUMBER1
,      TRXN_REF_NUMBER2
,      PAYMENT_SYSTEM_ORDER_NUMBER
,      ADDITIONAL_INFO
,      AUTHORIZED_FLAG
,      AUTHORIZATION_STATUS
,      SETTLED_FLAG
,      SETTLEMENT_STATUS
,      RETURNED_FLAG
,      RETURN_STATUS
,      BANK_NAME
,      BANK_BRANCH_NAME
FROM APPS.IBY_TRXN_EXTENSIONS_V;

Dependencies

[top of page]

APPS.IBY_TRXN_EXTENSIONS_V references the following:

APPS: FND_APPLICATION; HZ_ORGANIZATION_PROFILES; HZ_PARTIES; IBY_CREDITCARD; IBY_CREDITCARD_ISSUERS_B; IBY_CREDITCARD_ISSUERS_TL; IBY_EXT_BANK_ACCOUNTS; IBY_FNDCPT_PMT_CHNNLS_B; IBY_FNDCPT_PMT_CHNNLS_TL; IBY_FNDCPT_TRXN_PUB - show dependent code; IBY_FNDCPT_TX_EXTENSIONS; IBY_FNDCPT_TX_OPERATIONS; IBY_PMT_INSTR_USES_ALL; IBY_TRXN_SUMMARIES_ALL

APPS.IBY_TRXN_EXTENSIONS_V is referenced by following:

APPS: ARBR_DOCS_RECEIVABLES_V; ARFV_CASH_RECEIPTS; ARFV_CREDITS; ARFV_CREDIT_MEMO_ARS; ARFV_DEBITS; ARFV_INVOICE_ARS; ARFV_ON_ACCOUNT_CREDIT_MEMOS; ARP_CORRECT_CC_ERRORS - show dependent code; ARP_PROCESS_RCTS - show dependent code; ARP_PROCESS_RCTS - show dependent code; ARP_PROGRAM_GENERATE_BR - show dependent code; ARP_TRX_DEFAULTS_3 - show dependent code; ARP_TRX_DEFAULTS_3 - show dependent code; AR_AUTOMATIC_RECEIPTS_FORMAT_V; AR_AUTOREC_API - show dependent code; AR_AUTOREM_API - show dependent code; AR_BILLS_CREATION_PUB - show dependent code; AR_BILLS_CREATION_PUB - show dependent code; AR_BILLS_MAINTAIN_PUB - show dependent code; AR_BOE_REMIT_RECEIPTS_CBR_V; AR_BOE_REMIT_RECEIPTS_CBUNR_V; AR_BOE_REMIT_RECEIPTS_NONCBR_V; AR_BOE_REMIT_RECEIPTS_V; AR_BR_ASSIGNMENTS_V; AR_BR_MAIN_REMIT_BATCH_V; AR_CC_ERRORS_V; AR_CORRECT_GL_LINES_V; AR_CUSTOMER_BILLS_TRX_V; AR_DOCS_RECEIVABLES_V; AR_INVOICE_UTILS - show dependent code; AR_PURGE - show dependent code; AR_REMITTED_RECEIPTS_FORMAT_V; ASO_COPY_QUOTE_PVT - show dependent code; ASO_OA_PAYMENTS_HDR_V; ASO_OA_PAYMENTS_LINE_V; ASO_PAYMENTS_V; ASO_PAYMENT_INT - show dependent code; IBE_QUOTE_CHECKOUT_PVT - show dependent code; IBE_QUOTE_MISC_PVT - show dependent code; IBY_FNDCPT_TRXN_PUB - show dependent code; OE_PAYMENT_TRXN_UTIL - show dependent code; OE_VERIFY_PAYMENT_PUB - show dependent code; OKS_ATTR_DEFAULTS_PVT - show dependent code; OKS_CUSTOMER_ACCEPTANCE_PVT - show dependent code; OKS_EXTWARPRGM_PVT - show dependent code; OKS_RENCPY_PVT - show dependent code; OKS_UTIL_PUB - show dependent code; PV_ORDER_MGMT_PVT - show dependent code