PSC_BNP_FEE_REFUND_HDR_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
RFNDH_REFUND_HISTORY_KEY RFNDH_AGENCY_ID RFNDH_REFUND_REFERENCE_ID RFNDH_REFUND_METHOD_CODE RFNDH_REFUND_TYPE RFNDH_REFUND_DATE RFNDH_REFUND_AMOUNT RFNDH_REFUND_CURRENCY CUR_CONVERSION_DATE CUR_CONVERSION_RATE CUR_CONVERSION_TYPE RFNDH_REFUND_REASON_CODE RFNDH_REFUND_TRANSACTION_ID RFNDH_PAYMENT_METHOD_CODE RFNDH_PAYMENT_REFERENCE_ID RFNDH_ACCOUNT_TYPE RFNDH_ACCOUNT_PURPOSE EVENT_ID LEDGER_ID

Query

SQL_Statement

select A.REFUND_HISTORY_KEY RFNDH_REFUND_HISTORY_KEY ,A.AGENCY_ID RFNDH_AGENCY_ID ,A.REFUND_REFERENCE_ID RFNDH_REFUND_REFERENCE_ID ,A.REFUND_METHOD_CODE RFNDH_REFUND_METHOD_CODE ,A.REFUND_TYPE RFNDH_REFUND_TYPE ,to_date(to_char(from_tz(A.CREATION_DATE,'UTC') at time zone C.TZNAME, 'YYYY-MM-DD'),'YYYY-MM-DD') RFNDH_REFUND_DATE ,A.REFUND_AMOUNT RFNDH_REFUND_AMOUNT ,A.REFUND_CURRENCY RFNDH_REFUND_CURRENCY ,CAST (NULL AS DATE) CUR_CONVERSION_DATE ,CAST (NULL AS NUMBER) CUR_CONVERSION_RATE ,CAST (NULL AS VARCHAR2(30)) CUR_CONVERSION_TYPE ,A.REFUND_REASON_CODE RFNDH_REFUND_REASON_CODE ,A.REFUND_TRANSACTION_ID RFNDH_REFUND_TRANSACTION_ID ,A.PAYMENT_METHOD_CODE RFNDH_PAYMENT_METHOD_CODE ,A.PAYMENT_REFERENCE_ID RFNDH_PAYMENT_REFERENCE_ID ,A.ACCOUNT_TYPE RFNDH_ACCOUNT_TYPE ,A.ACCOUNT_PURPOSE RFNDH_ACCOUNT_PURPOSE ,A.EVENT_ID EVENT_ID ,C.LEDGER_ID LEDGER_ID from psc_bnp_refund_hist_hdr A, psc_com_agency_b C where C.AGENCY_ID = A.AGENCY_ID