View: AP_PAYMENT_HISTORY_MRC_V

View Text

SELECT MC.PAYMENT_HISTORY_ID
, CHECK_ID
, ACCOUNTING_DATE
, TRANSACTION_TYPE
, POSTED_FLAG
, MATCHED_FLAG
, ACCOUNTING_EVENT_ID
, ORG_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, REQUEST_ID
, REV_PMT_HIST_ID
, TRX_BANK_AMOUNT
, ERRORS_BANK_AMOUNT
, CHARGES_BANK_AMOUNT
, TRX_PMT_AMOUNT
, ERRORS_PMT_AMOUNT
, CHARGES_PMT_AMOUNT
, MC.TRX_BASE_AMOUNT
, MC.ERRORS_BASE_AMOUNT
, MC.CHARGES_BASE_AMOUNT
, BANK_CURRENCY_CODE
, MC.BANK_TO_BASE_XRATE_TYPE
, MC.BANK_TO_BASE_XRATE_DATE
, MC.BANK_TO_BASE_XRATE
, PMT_CURRENCY_CODE
, MC.PMT_TO_BASE_XRATE_TYPE
, MC.PMT_TO_BASE_XRATE_DATE
, MC.PMT_TO_BASE_XRATE
, MRC_PMT_TO_BASE_XRATE_TYPE
, MRC_PMT_TO_BASE_XRATE_DATE
, MRC_PMT_TO_BASE_XRATE
, MRC_BANK_TO_BASE_XRATE_TYPE
, MRC_BANK_TO_BASE_XRATE_DATE
, MRC_BANK_TO_BASE_XRATE
, MRC_TRX_BASE_AMOUNT
, MRC_ERRORS_BASE_AMOUNT
, MRC_CHARGES_BASE_AMOUNT
FROM AP_PAYMENT_HISTORY_ALL B
, AP_MC_PAYMENT_HISTORY MC
WHERE B.PAYMENT_HISTORY_ID = MC.PAYMENT_HISTORY_ID
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)
AND NVL(B.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns