6 queries found for "Match Event"

Get all from Match Event

select * 
from CI_MATCH_EVT

uploaded by Nuno Rodrigues

Get specific Match Event

select * 
from CI_MATCH_EVT
where 
MATCH_EVT_ID = 'XXXX'

uploaded by Nuno Rodrigues

Retrieve Match Events for Adjustment

SELECT DISTINCT ME.MATCH_EVT_ID,
                ME.MEVT_STATUS_FLG,
                ME.ARCHIVE_SW
FROM   CI_FT FT,
       CI_MATCH_EVT ME
WHERE  FT.SIBLING_ID = 'INSERT_ADJUSTMENT_ID'
       AND ( FT.FT_TYPE_FLG = 'AD'
              OR FT.FT_TYPE_FLG = 'AX' )
       AND ME.MATCH_EVT_ID = FT.MATCH_EVT_ID

uploaded by Nuno Rodrigues

Retrieve Match Events for Bill

SELECT DISTINCT ME.MATCH_EVT_ID,
                ME.MEVT_STATUS_FLG,
                ME.ARCHIVE_SW
FROM   CI_BSEG BS,
       CI_FT FT,
       CI_MATCH_EVT ME
WHERE  FT.SIBLING_ID = BS.BSEG_ID
       AND BS.BILL_ID = 'INSERT_BILL_ID'
       AND ( FT.FT_TYPE_FLG = 'BS'
              OR FT.FT_TYPE_FLG = 'BX' )
       AND ME.MATCH_EVT_ID = FT.MATCH_EVT_ID

uploaded by Nuno Rodrigues

Retrieve Match Events for Bill Segment

SELECT DISTINCT ME.MATCH_EVT_ID,
                ME.MEVT_STATUS_FLG,
                ME.ARCHIVE_SW
FROM   CI_FT FT,
       CI_MATCH_EVT ME
WHERE  FT.SIBLING_ID = 'INSERT_BILL_SEGMENT_ID'
       AND ( FT.FT_TYPE_FLG = 'BS'
              OR FT.FT_TYPE_FLG = 'BX' )
       AND ME.MATCH_EVT_ID = FT.MATCH_EVT_ID

uploaded by Nuno Rodrigues

Retrieve Match Events for Payment Event

SELECT DISTINCT ME.MATCH_EVT_ID,
                ME.MEVT_STATUS_FLG,
                ME.ARCHIVE_SW
FROM   CI_PAY P,
       CI_FT FT,
       CI_MATCH_EVT ME
WHERE  FT.PARENT_ID = P.PAY_ID
       AND P.PAY_EVENT_ID = 'INSERT_PAY_EVENT_ID'
       AND ( FT.FT_TYPE_FLG = 'PS'
              OR FT.FT_TYPE_FLG = 'PX' )
       AND FT.MATCH_EVT_ID = ME.MATCH_EVT_ID

uploaded by Nuno Rodrigues