PSC_BNP_OVERPAYMENT_V

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
TRANSACTION_ID LINE_KEY AGENCY_ID TRANSACTION_DATE TRANSACTION_AMOUNT CURRENCY_CODE PAYMENT_METHOD_CODE PAYMENT_REFERENCE_ID EVENT_ID ONACCOUNT_SOURCE ONACCOUNT_REASON_CODE ACCOUNTING_DATE ACCTG_EVENT_STATUS

Query

SQL_Statement

SELECT HDR.PAYMENT_HISTORY_KEY TRANSACTION_ID, OVR.ONACCOUNT_HISTORY_KEY LINE_KEY, OVR.AGENCY_ID, OVR.ONACCOUNT_DATE TRANSACTION_DATE, OVR.ONACCOUNT_AMOUNT TRANSACTION_AMOUNT, OVR.ONACCOUNT_CURRENCY CURRENCY_CODE, OVR.PAYMENT_METHOD_CODE, OVR.PAYMENT_REFERENCE_ID, OVR.EVENT_ID, OVR.ONACCOUNT_SOURCE, OVR.ONACCOUNT_REASON_CODE, OVR.ACCOUNTING_DATE, OVR.ACCTG_EVENT_STATUS FROM PSC_BNP_PAYMENT_ONACCOUNT OVR, PSC_BNP_PAYMENT_HIST_HDR HDR WHERE OVR.ACCTG_EVENT_STATUS IN ('ORA_NONE', 'ORA_ERROR') AND OVR.TRUST_ACCOUNT_NUMBER IS NULL AND OVR.PAYMENT_REFERENCE_ID = HDR.PAYMENT_REFERENCE_ID