PSC_BNP_CASH_ACCT_EVENT_V

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
TRANSACTION_ID AGENCY_ID RECONCILE_ID TRANSACTION_DATE TRANSACTION_TYPE TRANSACTION_AMOUNT CURRENCY_CODE CUR_CONVERSION_DATE CUR_CONVERSION_RATE CUR_CONVERSION_TYPE ACCOUNTING_DATE EVENT_ID ACCTG_EVENT_STATUS DRAWER_ID

Query

SQL_Statement

SELECT A.TRANSACTION_ID , A.AGENCY_ID , A.RECONCILE_ID , to_date(to_char(from_tz(A.CREATION_DATE,'UTC') at time zone C.TZNAME, 'YYYY-MM-DD'),'YYYY-MM-DD') AS TRANSACTION_DATE , A.TRANSACTION_TYPE , A.TRANSACTION_AMOUNT , A.CURRENCY_CODE , CAST (NULL AS DATE) AS CUR_CONVERSION_DATE , CAST (NULL AS NUMBER) AS CUR_CONVERSION_RATE , CAST (NULL AS VARCHAR2(30)) AS CUR_CONVERSION_TYPE , A.ACCOUNTING_DATE , A.EVENT_ID , A.ACCTG_EVENT_STATUS , S.DRAWER_ID FROM PSC_BNP_CASH_RECON_ACCTG A, PSC_BNP_CSH_DRW_RECON_SUM S, psc_com_agency_b C WHERE A.RECONCILE_ID = S.RECONCILE_ID AND C.AGENCY_ID = A.AGENCY_ID