PSC_BNP_FEE_REFUND_LIN_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name

RFNDL_REFUND_HISTORY_KEY RFNDL_REFUND_RECORD_KEY RFNDL_REFUND_REFERENCE_ID RFNDL_AGENCY_ID RFNDL_REFUND_TYPE RFNDL_REFUND_DATE RFNDL_ITEM_NAME RFNDL_ITEM_LINE RFNDL_ITEM_DESCRIPTION RFNDL_ITEM_PAYMENT_AMOUNT RFNDL_ITEM_PAYMENT_CURR RFNDL_ITEM_REFUND_AMOUNT RFNDL_ITEM_REFUND_CURRENCY RFNDL_CLASSIFICATION RFNDL_RECORD_ID RFNDL_RECORD_TYPE_ID RFNDL_REFUND_TRANSACTION_ID RFNDL_PAYMENT_METHOD_CODE RFNDL_PAYMENT_REFERENCE_ID EVENT_ID LINE_NUMBER LEDGER_ID

Query

SQL_Statement

select A.REFUND_HISTORY_KEY RFNDL_REFUND_HISTORY_KEY ,B.REFUND_RECORD_KEY RFNDL_REFUND_RECORD_KEY ,A.REFUND_REFERENCE_ID RFNDL_REFUND_REFERENCE_ID ,A.AGENCY_ID RFNDL_AGENCY_ID ,A.REFUND_TYPE RFNDL_REFUND_TYPE ,A.REFUND_DATE RFNDL_REFUND_DATE ,B.ITEM_NAME RFNDL_ITEM_NAME ,B.ITEM_LINE RFNDL_ITEM_LINE ,B.ITEM_DESCRIPTION RFNDL_ITEM_DESCRIPTION ,B.ITEM_PAYMENT_AMOUNT RFNDL_ITEM_PAYMENT_AMOUNT ,B.ITEM_PAYMENT_CURRENCY RFNDL_ITEM_PAYMENT_CURR ,B.ITEM_REFUND_AMOUNT RFNDL_ITEM_REFUND_AMOUNT ,B.ITEM_REFUND_CURRENCY RFNDL_ITEM_REFUND_CURRENCY ,CONCAT('ORA_', B.CLASSIFICATION) RFNDL_CLASSIFICATION ,B.RECORD_ID RFNDL_RECORD_ID ,B.RECORD_TYPE_ID RFNDL_RECORD_TYPE_ID ,A.REFUND_TRANSACTION_ID RFNDL_REFUND_TRANSACTION_ID ,A.PAYMENT_METHOD_CODE RFNDL_PAYMENT_METHOD_CODE ,A.PAYMENT_REFERENCE_ID RFNDL_PAYMENT_REFERENCE_ID ,A.EVENT_ID EVENT_ID ,ROW_NUMBER() OVER (PARTITION BY B.REFUND_HISTORY_KEY ORDER BY B.REFUND_RECORD_KEY) LINE_NUMBER ,C.LEDGER_ID LEDGER_ID from psc_bnp_refund_hist_hdr A, psc_bnp_refund_hist_lin B, psc_com_agency_b C where B.REFUND_HISTORY_KEY = A.REFUND_HISTORY_KEY and C.AGENCY_ID = A.AGENCY_ID