RB_DIST_MATCH_V (SQL View)	Index Back
Matching SQL view This is view of the Cache table for Matching SQL.

RB_DIST_MATCH_V

(SQL View)

Matching SQL view

This is view of the Cache table for Matching SQL.

SELECT DISTINCT A.RUN_CNTL_ID FROM PS_RB_MATCHING_SQL A , PS_RB_IMPT_RUNSPEC B , PSPRCSRQST D WHERE A.RUN_CNTL_ID = B.RUN_CNTL_ID AND B.RUN_CNTL_ID = D.RUNCNTLID AND D.RUNSTATUS NOT IN ('4', '5', '6', '7') AND B.RB_KEEP_STAGES = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID