1. Tables and Views for Financials
  2. IBY_FNDCPT_ACKNOWLEDGMENT_V

IBY_FNDCPT_ACKNOWLEDGMENT_V

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: VIEW

Columns

Name

BATCHID

TRANSACTION_EXTENSION_ID

TRANSACTION_TYPE

STATUS

MEANING

Query

SQL_Statement

select t.batchid, op.trxn_extension_id transaction_extension_id, t.reqtype transaction_type, t.status, l.meaning

from iby_trxn_summaries_all t,

fnd_lookups l,

iby_fndcpt_tx_operations op

where t.transactionid = op.transactionid

and reqtype IN ('ORAPMTCAPTURE', 'ORAPMTRETURN')

and l.lookup_type = 'IBY_TRANSACTION_STATUS'

and l.lookup_code = t.status