RBQ_BORELREC_VW

(SQL View)
 Index Back

Records with two BO fields.

Prompt Record for displaying Records with BO_ID_1 and BO_ID_2 fields.

SELECT A.RECNAME FROM PSRECDEFN A , PSRECFIELDALL B , PSRECFIELDALL C WHERE A.RECNAME = B.RECNAME AND A.RECNAME = C.RECNAME AND B.FIELDNAME = 'BO_ID_1' AND C.FIELDNAME = 'BO_ID_2' AND A.RECTYPE IN (0 , 1 , 5 , 6)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).