AP_PAYMENT_INSTR_EXTRACT_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name
CPIBA_CLEARING_CCID CPIBA_AP_ASSET_CCID CPIBA_GAIN_CCID CPIBA_LOSS_CCID CPI_PAYMENT_INSTRUMENT_ALIAS CPIBA_PMT_INSTR_BU_ASSIGN_ID CPI_PAYMENT_INSTRUMENT_ID

Query

SQL_Statement

SELECT nvl(CPIBA.clearing_ccid,NVL(CPIBA.asset_ccid, NVL(CPI.clearing_ccid,CPI.asset_ccid))) CPIBA_clearing_ccid ,nvl(CPIBA.asset_ccid, CPI.asset_ccid) CPIBA_ap_asset_ccid ,cpiba.exchange_gain_ccid CPIBA_gain_ccid ,cpiba.exchange_loss_ccid CPIBA_loss_ccid ,cpi.payment_instrument_alias CPI_payment_instrument_alias ,cpiba.pmt_instr_bu_assignment_id CPIBA_pmt_instr_bu_assign_id ,cpi.payment_instrument_id CPI_payment_instrument_id FROM CE_PMT_INSTR_BU_ASSIGNMENTS CPIBA,CE_PAYMENT_INSTRUMENTS CPI WHERE CPIBA.payment_instrument_id = CPI.payment_instrument_id