VIEW: APPS.FV_TREASURY_EXTRACT_HEADER_V

Source

View Text - Preformatted

SELECT FTC.EVENT_ID EVENT_ID ,FTC.TREASURY_CONFIRMATION_ID ,FTC.ORG_ID ,FTC.PAYMENT_INSTRUCTION_ID FROM fv_treasury_confirmations_all FTC, xla_events_gt XE WHERE XE.event_id = FTC.event_id UNION SELECT FVC.EVENT_ID EVENT_ID ,FTC.TREASURY_CONFIRMATION_ID ,FVC.ORG_ID ,FVC.PAYMENT_INSTRUCTION_ID FROM fv_voided_checks FVC, fv_treasury_confirmations_all FTC, xla_events_gt XE WHERE XE.event_id = FVC.event_id AND FTC.treasury_confirmation_id = (SELECT max(FTC1.treasury_confirmation_id) FROM fv_treasury_confirmations_all FTC1 WHERE FTC1.payment_instruction_id = FVC.payment_instruction_id GROUP BY FTC1.payment_instruction_id) AND FTC.confirmation_status_flag <> 'B'

View Text - HTML Formatted

SELECT FTC.EVENT_ID EVENT_ID
, FTC.TREASURY_CONFIRMATION_ID
, FTC.ORG_ID
, FTC.PAYMENT_INSTRUCTION_ID
FROM FV_TREASURY_CONFIRMATIONS_ALL FTC
, XLA_EVENTS_GT XE
WHERE XE.EVENT_ID = FTC.EVENT_ID UNION SELECT FVC.EVENT_ID EVENT_ID
, FTC.TREASURY_CONFIRMATION_ID
, FVC.ORG_ID
, FVC.PAYMENT_INSTRUCTION_ID
FROM FV_VOIDED_CHECKS FVC
, FV_TREASURY_CONFIRMATIONS_ALL FTC
, XLA_EVENTS_GT XE
WHERE XE.EVENT_ID = FVC.EVENT_ID
AND FTC.TREASURY_CONFIRMATION_ID = (SELECT MAX(FTC1.TREASURY_CONFIRMATION_ID)
FROM FV_TREASURY_CONFIRMATIONS_ALL FTC1
WHERE FTC1.PAYMENT_INSTRUCTION_ID = FVC.PAYMENT_INSTRUCTION_ID GROUP BY FTC1.PAYMENT_INSTRUCTION_ID)
AND FTC.CONFIRMATION_STATUS_FLAG <> 'B'